c3_core_error_en_504

[Former Member]

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

[Former Member]

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

[Former Member]

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?