on 10-31-2013 5:30 AM
Hi
I migrated a universe and a webi report and dependencies from dev to prod through Promotion Management Tool. The job was successful. But when I opened the report it threw error. When I checked the universe there was an object with tablename..columnname instead of tablename.columnname. So I rollback the job and corrected it in dev server.
But When I try to open any other previuolsy working Webi reports in Prod it threw error "c3_core_error_en_504".
Dashboards also threw error "Request processing failed. (XLS 000009) com.businessobjects.mds.securedconnection.exception.SecuredConnectionException: Unable to retrieve the connection from the CMS. Check if the connection exists in the CMS and if you have rights."
But any user in Admin Group can access the reports and dashboards in Prod without any error.
I already followed what said in
1746212 - Error: "Webi C3_core_error_en_504" while refreshing the Web Intelligence Document in SAP BO BI 4.0
1645566 - A Web Intelligence report Refresh throws c3_core_error_en_504 in BI 4.0
1842353 - Error c3_core_error_en_504 when refreshing webi reports based on ODBC connections, migrated with Upgrade
Management Tool
Version : SAPBO SP4 14.0.4.738
Please help me experts...
Thanks
Sandeep
Hi
The error was due to promoting security while migrating the universe because already the same was in Prod Server ( from earlier migration).
To solve this
Go to CMC>Connections> Select the connection used>User security>Select the user grp(everyone)>Assign Security....give the rights as below
In Access levels>View on demand
Advanced> System>Relational Connection> Data Access, Data Access(Owner right) , Download Connection Locally, Download Connection Locally (owner right), Use connection for stored procedures, Use connection for stored procedures (Owner right) and
Also uncheck the two 'inherit from..' checkboxes on top.
Regards
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sandeep,
I think this has something to do with the Webi and dashboard queries referencing a repository resources which is no longer available in your environment.
Is everything working fine in Dev? If they are working my suggestion is to take a backup of objects throwing problem in Prod into a BIAR file and do a clean promotion from a working environment..
Also just to pin point the problem causing element did you tries creating a dummy report in prod using the problem causing universe and connection?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.