1 Reply Latest reply on Dec 2, 2019 2:04 PM by Mike-Matthews-Oracle

    DQM - Error records with error 'ORA-01403: no data found' in HZ_DQM_SYNC_INTERFACE table

    1665798

      Hi All,

       

      We are getting records stuck in the HZ_DQM_SYNC_INTERFACE  table which are being created regularly.

       

      The column STAGED_FLAG = 'E' which I presume means Error.

       

      I have searched on Oracle support but cannot find any previous entries where someone is getting rows stuck in HZ_DQM_SYNC_INTERFACE  with STAGED_FLAG = 'E'.

       

      Can anyone shed any light on why these records would be getting stuck.

       

      We have over 12000 records in here now and I believe it is causing issues with the DQM Serial Sync Index Program getting stuck at Pending.

       

      Any help would be appreciated.

       

      Thanks

      Tim