Question
Capgemini Technological Services
IN
Last activity: 19 May 2020 13:53 EDT
Getting Error when trying to create a report which fetches data from two different table located in different databases.
I have tried few approached to achieve this.
1. Tried to access the tables using class join directly defined in data access tab.
2. Tried including sub report to access the 2nd table which resides in different databases, but didnt worked.
Any quick suggestion will be extremely helpful.
The error I am getting is :-
Error:
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 208 SQLState: S0002 Message: Invalid object name 'dbo.databasetablename'. DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'dbo.databaseTablename'. | SQL Code: 208 | SQL State: S0002
***Edited by Moderator: Pallavi to update platform capability tags***
Capgemini Technological Services
IN
Hello Marc,
We are not allowed to do DB side changes , so could you please suggest any change from Pega Side to achieve it.
Pegasystems Inc.
US
Are the databases on the same server? SQL Server allows joining tables from different databases only as long as the databases are on the same server.
Capgemini Technological Services
IN
We are not allowed to do the changes from DB side is there any solution we can follow using Pega only.
Thanks.
Pegasystems Inc.
US
The error you have encountered is a database context error. Again, it is likely because you are trying to join tables from different databases.
There is no Pega solution for this AFAIK. This has to be addressed on the database side (e.g., mirroring one of the tables to the other database so that you can join the 2 tables in the same DB). If you cannot make any changes to the DBs, I don't think you can solve this.