Posted: 14 May 2020 5:10 EDT 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 :-
** 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***
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.