Summary
Changing the Data model connection to point to different database and data not being reflected
Content
Hi all,
We are developing a use case in OAAC. Initially, we had a connection named "Test". In that, we had a database named "A" and made it point to the data model. Later on, we changed to database "B" in the connection "Test" (which has the same set of tables as the database "A") After this, the data in the reports is only referring to the old database "A" instead of pulling the data from the database "B".
For example:
A table named "ABC" has a record count of 81 in the database "A" while the same table has record count of 94 in database "B".
After changing the database, a report is created for the table "ABC" using the connection "Test", the result should have 94 records but it still shows only 81 records.
Steps we tried:
1.Synchronization with the database in the data model.
2. Cleared cache data in the data model level.
3. Disabled cache via the parameter "SET VARIABLE DISABLE_CACHE_HIT=1;"
But in vain. Would be pleased if someone can help me with this.
Thanks.
