Categories
Changing the Data model connection to point to different database and data not being reflected
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.
Answers
-
Hi Prakash.
If you edit the data model and click View Data how many records return (if you set the Rows = 200)? 81 or 94?
Can you see the active connections on the database side (A and
? Like querying the V$SESSION table?Cheers.
Fernando
0 -
Hi Prakash.
Sometimes we change the default data source connection of the Data Model but the Data Set may still point to a different one.
Just checking.
Fernando
0 -
Hi Fernando,
Thanks.. how can we get past this issue?
Prakash M
0 -
Hi Prakash.
It is just a hunch.
See the images on my sample data model.
First image is the Data Model Default Data Source
Second image is the Data Set Data Source.
Just check if is the correct one on the data set. May not be the problem but worth checking.
Cheers.
Fernando
0 -
Data Set Connection
0