Question

5
Replies
43
Views
ABHISHEKY Member since 2015 3 posts
Cognizant Techonology Solutions
Posted: 5 months ago
Last activity: 5 months ago

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***  

Pega Platform 7.2.2 Reporting
Share this page LinkedIn