Categories
RDP Table not updating
Good day,
A table in our rdp does not update. Data count remains 0 (no data is available) even though data exists for the records in this table in the system.
Can you please advise if this is common?
What happens when some tables dont update after the ETL runs its update process?
Is there a workaround that can be applied if there is no fix?
Thank you
Best Answers
-
"other tables in the RPD contain metadata"
Once more: The RPD is a metadata layer. Objects in the RPD do not "contain metadata".
This is a physical layer example:
The table "COUNTRIES" is a metadata representation of the database table COUNTRIES in the schema SH in one of my ADWs.
This metadata object does not contain anything. It is a metadata construct which allows the Oracle Analytics / OBIEEplatform to construct queries which are then being sent against the database. In my case an ADW. Only the database contains anything. In the RPD it's jsut descriptors.
When you double-click the table in the physical layer of the RPD you can see whether the caching is enabled for that object or not:
In my case above it's active which means that Oracle Analytics / OBIEE creates a cache entry behind the scenes (when the first query hits this object) which then contains whatever the database sent back as a result of the query.
So as Federico said you may need to purge your cache or disable your cache on your environment or disable it for your request.
0 -
Thank you for your guidance.
The cache was set on "Cache never expires", I will disable it to it to see if it helps
0
Answers
-
Hi @Sisanda ,
A table mapped in your metadata repository (RPD) has been updated in the data source, but changes are not reflected in reports built on top of the RPD. Did I understand your issue correctly?
If so, I would double-check the connection details and credentials in the connection pool to be sure that they are correct and still reference the physical table that has been updated.
Then I would purge the BI Server cache. You can do it manually by navigating to Administration > Issue SQL and executing
call SAPurgeAllCache(). The same call can be eventually included in your ETL procedures, so you don't have it do it manually after each update.0 -
Yes, a table has been mapped in our metadata repository, but does not update when the etl extracts data from the data source. I can't build any reports or dashboards using the data because it's not available on the rdp table
0 -
Sisanda,
Federico explicitly mentioned the cache in his response. Is your system set up to use cache? Have you cached an empty or old result set and are always seeing that instead of the newest loaded data?
You will have to explain your issue more precisely because the RPD (not RDP) does not contain or store any data at all. It is pure metadata.
What you call an "rdp table" is just a metadata representation of the table which is in the actual data source.
0 -
Hi Christian,
I'm not certain if our system was setup to use cache, other tables in the RPD contain metadata except for one table I'm reporting. The metadata is not pulling through, we know for a fact that data exists but somehow, it's not pulling through to the RPD level.
Is there a guide I can use to check the system cache settings?
0
