Error When Trying To Refresh The Current Report
Contents |
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23, FLBOUG, Clearwater: Oct 28, ASUG Northern California: Nov 2, ASUG Arizona Chapter: Nov 3, ASUG error when trying to refresh the current report in webi All Texas Chapter Meeting: Nov 11. Error when trying to
Wih 444444
refresh the current report Search this topic...|Search WebIntelligence XI...|Search Box Select a search Explain These Choices... --------------------Recent missing sentry parameter Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Building Reports -> WebIntelligence XI Author Message julioqtSenior MemberJoined: 16 Aug 2011Posts: 54 Posted: Mon universe generation failed for resource id Jan 09, 2012 11:08 amPost subject: Error when trying to refresh the current report Hi, I am getting this message when I try to refresh the report: Error when trying to refresh the current report Does anyone has deal with this issue? Thanks, Julio Back to top Mark PForum DevoteeJoined: 03 Feb 2003Posts: 10295Location: Manchester, UK Posted: Mon Jan 09, 2012
Sap Notes
12:29 pmPost subject: Re: Error when trying to refresh the current report What further error details do you get?_________________Current version I'm using: 4.1 SP3 Next available for contract or consultancy work: October 4th 2016 ______________________________________ Note to clients: The bitterness of poor quality remains long after the sweetness of low price is forgotten Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Register or Login to Post Forum Index -> Building Reports -> WebIntelligence XI Page 1 of 1 All times are GMT - 5 Hours Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Jump to:Select a forumBusinessObjects Software------------------------------------General DiscussionBuilding Reports•Legacy Crystal Products•Crystal Reports•Desktop Intelligence•WebIntelligence 1.x/2.x•WebIntelligence Version 6•WebIntelligence XISemantic Layer / Universe DesignerSecurity and User Administration•Supervisor (4.x - 6.x)•CMCServer Administration, Installation, Upgrades•Web Intelligence 1.x/2.x Servers•Web Intelligence 6.x Servers•XI Server DiscussionEnterprise Scheduling and Distribution•Broadcast Agent (BCA)•XI SchedulerData Integrator•DI: Installation, Administration, and Connectivities•DI: Metadata Reports•DI: Designer and Job Design•DI: Performance and Tuning•DI: Realtime and NRDM•DI: Data Quality•DI: Information Steward•DI: SAP-specific ERP/BW•DI: Text Analytics•DI: Rapidmarts and Business ContentOther
environment is still a bit weird for those (like me) originally coming from the SAP BW world. The Lifecycle Manager (LCM) webapp somehow doesn’t feel as robust as the Transport Management System in SAP, but in the end it does the same thing of course. This week a colleague ran into some errors after promoting his new Web Intelligence and Crystal Reports from our BI4 development environment to the production environment. His reports were created on SAP BW BEx query data sources. Update: We finally figured out how to work with Override Settings for OLAP Connections to solve this issue. Check the blog post here. First let's have a look at the Web Intelligence report. After the promotion he was able to open the Web Intelligence report, but when refreshing the data the following errors appeared: http://www.forumtopics.com/busobj/viewtopic.php?t=187834&sid=9c93fbd77fad3326f80d5a2e4d8cc2c6 Errors when trying to refresh the current report. The universe generation using the resource id has failed. (WIS 00000) The solution to this issue is quite easy but you just have to know this somehow I guess: You have to manually reconnect each SAP BW BEx query with the Web Intelligence report. Yes, this just feels odd. We are used to the Transport Management System to take care of these things. Also I think it's a bit strange to standard having http://www.hackingsap.com/blog/errors-after-promoting-bi4-reports-with-bex-query-data-sources-crystal-reports-web-intelligence to edit reports in a production environment, just to make them work. On the other hand, if you only have one BI4 environment on top of multiple SAP BW environments, it might be useful to have the ability to change the data sources of a report to connect to a different system. Anyway, to fix this just follow the next easy steps: 1. Open the report and go to Design mode. Go to the Data Access tab and select the Tools submenu. Here you see the option Change Source. By the way make sure that you are running the Rich Internet Application (JAVA) version since the Web version doesn’t show this option! You can check and change this in the BI Launchpad preferences for Web Intelligence menu (top right). 2. After selecting your query a wizard will appear in which you can specify a new data source. 3. Browse to your BEx query. 4. The next screen shows a proposed object mapping. This should normally show only green lines because the BEx queries should have the same configuration on the several SAP BW environments. 5. After clicking Finish the report will refresh. Don't forget to save the report or you'll have to do this again the next time you want to run the report! When opening the Crystal Reports report in BI Launchpad after promotion something similar happens: The viewer could not process an event. The data source is invalid. Invalid CMS Que
and Safety Management ) A&D (Aerospace & Defense) ABAP About SAP Android Announcement of Legal http://www.stechies.com/error-when-trying-refresh-current-report-occurs-web-intelli/ Change APO (Advanced Planner and Optimizer) Audit Management BASIS BCM (Business https://community.powerbi.com/t5/Integrations-with-Files-and/Power-BI-message-when-trying-to-refresh-the-CRM-data-base/td-p/10200 Communication Management) BI (Business Intelligence) BI Suite - Business Explorer BO (Business Objects) BODS (Business Objects Data Services) BOPF (Business Object Processing Framework) BPC (Business Planning and Consolidation) BPM (Business Process Management) Business ByDesign Business One Business Suite BW (Business Warehousing) CLM (Contract error when Lifecycle Management) Cloud CRM (Customer Relationship Management) CS (Customer Service) Do It Yourself DSiM (Demand Signal Management) E-Recruitment EAM (Enterprise Asset Management) EC (Enterprise Controlling) EP (Enterprise Portal) ERP (Enterprise Resource Planning) Event Management EWM (Extended Warehouse Management) FICO (Financial Accounting & Controling) FIN-FSCM (Financial Supply Chain Management) Fiori FS-BA (Bank Analyzer) FS-CD (Collections error when trying and Disbursements) Governance GTS (Global Trade Services) GUI (Graphical User Interface) GWM (Gateway for Microsoft) HANA HCM (HCM Human Capital Management) HR (Human Resource) Hybris (SAP E-Commerce Software) IdM (Identity Management) IFRS (International Financial Reporting Standards) IM (Investment Management) Integration Server IS (Industry Solutions) IT Management Java KW (Knowledge Warehouse) Landscape Transformation of Replication Server Logistics Information System Lumira MaxDB MDM (Master Data Management) ME (Manufacturing Execution) MM (Materials Management) Mobile MRS (Multi Resource Scheduling) MySAP MySQL NetWeaver OCM (Order Change Management) OM (Organisational Management) Oracle Oracle SQL PE (Product Enhancement) Photoshop PHP PI (Process Integration) PLM (Product Lifecycle Management) PM (Plant Maintenance) PO (Process Orchestration) Point-of-Sale (POS) Data Management (DM) Postalsoft PP (Production Planning) PPM (Portfolio and Project Management) Predictive Analytics Project Manager PS (Project Systems) QA (Quality Assurance) QM (Quality Management) SAP Office SAP User Experience (UX) SCM (Supply Chain Management) SD (Sales and Distribution) SEM (Strategic Enterprise Management Software) SEO (Search Engine Optimization) Shared Service Framework SOD (Segr
Give Feedback Webinars Blog Home Forums Ideas Events User Groups Community Blog Register · Sign In · Help Integrations with Files and Services Go To Forums Desktop Service Integrations with Files and Services Mobile Apps Developer Forums : Integrations with Files and Services : Power BI message when trying to refresh the CRM da... Reply Topic Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page « Message Listing « Previous Topic Next Topic » PurvaSapre Frequent Visitor Posts: 2 Registered: 11-16-2015 Power BI message when trying to refresh the CRM data base [Edited] Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content 11-16-2015 01:31 AM - edited 11-16-2015 01:44 AM Hello,I am getting the following error when trying to refresh the CRM database.Something went wrong.An error occurred while processing the data in the dataset.Column "Lead" in table "Leadset" contains blank values and this is not allowed for columns on the one side of a mnay-to-one relationship or the columns that are used as the primary key of a table.The current operation was cancelled because another operation in the traction failed.Any solution to solve this error? Thanks for your help in advance. Report Inappropriate Content Message 1 of 5 (299 Views) Labels: Need Help Reply 0 Kudos smoupre Occasional Contributor Posts: 2,704 Registered: 07-11-2015 Re: Power BI message when trying to refresh the CRM data base Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content 11-16-2015 05:09 AM Edit your query, select the offending column and choose to remove blank values, or remove the relationship. In Ohio? Check out the Columbus Azure ML and Power BI User Group (CAMLPUG)In lieu of a kudo, consider donating to The Buckeye Ranch Report Inappropriate Content Message 2 of 5 (278 Views) Reply 0 Kudos PurvaSapre Frequent Visitor Posts: 2 Registered: 11-16-2015 Re: Power BI message when trying to refresh the CRM data base Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to a Friend Report Inappropriate Content 11-17-2015 12:59 AM Thanks for your response. Can you please give me some links regarding how to find and remove these blank values? Report Inappropriate Content Message 3 of 5 (263 Views) Reply 0 Kudos Rémi Regular Visitor Posts: 41 Registered: 09-29-2015 Re: