Raw data is not inserting into the database. RN_QOS_DATA_* tables are empty; retention settings have been removing data. The data_engine probe is configured to partition the tables, but no new partitions have been created.
The data_engine log shows the following:
Nov 28 19:30:39:561 [140687239481088] 0 de: data_engine [QoS] [QoSData] - commitDataHasMax [QoSData] data_engine [QoS] status: -1
OCI_ERROR - ORA-14400: inserted partition key does not map to any partition
OCIEnv: 0x0x7ff44800XXXX OCIAuthInfo: 0x0x7ff44801XXXX OCISvcCtx: 0x0x7ff44804XXXX
- Error: commitDataHasMax [QoSData] data_engine [QoS] status: -1
OCI_ERROR - ORA-14400: inserted partition key does not map to any partition
OCIEnv: 0x0x7ff44800XXXX OCIAuthInfo: 0x0x7ff44801XXXX OCISvcCtx: 0x0x7ff44804XXXX
Release : 20.3+
Oracle database
New partitioning is failing. Data retention settings are removing older data and new data can't be inserted as the partitions will not be created.
Need to allow the data_engine probe to re-partition the tables:
The maintenance activity starts with the following:
Dec 9 21:39:56:159 [11660] 1 de: Admin - start admin routines
Dec 9 21:39:56:164 [11660] 3 de: [Admin] has connected to database
Once the tables are unpartitioned proceed on
Change the value of data_management_partition from "no" to "yes" and then restart the data_engine
Run the "run_admin_now" callback again and check logs. You should also see data in tables.