Oracle Analytics Cloud and Server

Cache polling event - deleting rows from polling table

Received Response
2
Views
1
Comments

Hi please can anybody explain to me? I have a polling table with these records for example

CATALOG_NAMEDATABASE_NAMEOTHER_RESERVEDSCHEME_NAMETABLE_NAMEUPDATE_TSUPDATE_TYPE
nullnullnullnullTABLE18.11.2019 7:50:51,1111111
nullnullnullnullTABLE28.11.2019 7:50:51,2222221
nullnullnullnullTABLE38.11.2019 7:50:51,1111111

The event will add new records

CATALOG_NAMEDATABASE_NAMEOTHER_RESERVEDSCHEME_NAMETABLE_NAMEUPDATE_TSUPDATE_TYPE
nullnullnullnullTABLE18.11.2019 7:50:51,1111111
nullnullnullnullTABLE28.11.2019 7:50:51,2222221
nullnullnullnullTABLE38.11.2019 7:50:52,1111111
nullnullobis1nullTABLE18.11.2019 7:50:511
nullnullobis1nullTABLE28.11.2019 7:50:511
nullnullobis1nullTABLE38.11.2019 7:50:521

And then performs delete and result look like this:

CATALOG_NAMEDATABASE_NAMEOTHER_RESERVEDSCHEME_NAMETABLE_NAMEUPDATE_TSUPDATE_TYPE
nullnullnullnullTABLE18.11.2019 7:50:51,1111111
nullnullnullnullTABLE28.11.2019 7:50:51,2222221
nullnullnullnullTABLE38.11.2019 7:50:52,1111111
nullnullobis1nullTABLE18.11.2019 7:50:511
nullnullobis1nullTABLE28.11.2019 7:50:511

It perfroms delete just to the datetime which is truncated to seconds and only the unique ones. So my question is how can I achieve that the records will be all deleted after cache purging? Oracle documentation says the UPDATE_TS is unique key, but this is though without the seconds decimals.

Answers

  • I will answer to myself :-) The key is this sentence.

    The Oracle BI Server truncates the timestamps to the number of digits that are defined by FRACTIONAL_SECOND_PRECISION.

    So in RPD in physical layer for DB set fractional second precision to value as timestamp so 6 and all works as a charm.