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


      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.