VERIFIED SOLUTION i
X

Resolve Task Processor failed to process the task. DA_ERR_DBERROR db_alert_pending error in Confirm

UPDATED: September 22, 2017


When running the Alerts and Notification Agent with them task Processor the below error appears: 

Task Processor failed to process the task. DA_ERR_DBERROR    db_alert_pending    INSERT INTO alert_pending ( alert_entity_type, alert_entity_key, alert_id, effective_date, alert_login_name, alert_contact_no, alert_to_user_flag ) VALUES ( ?, ?, ?, ?, ?, ?, ? )    SQLSTATE = 23000~r~n[Oracle][ODBC][Ora]ORA-00001: unique constraint (ABC_SBS.SYS_C00232701) violated~n~r~n~r~nNo changes made to database.~r~n~r~nINSERT INTO alert_pending ( alert_entity_type, alert_entity_key, alert_id, effective_date, alert_login_name, alert_contact_no, alert_to_user_flag ) VALUES ( ?, ?, ?, ?, ?, ?, ? ). 

This is happening because there is a record in the Alert_pending and sw_notice_header table which has an alert_refresh still showing 'Y' for work_header_no = '123456789'. The Alert Agent is trying to insert a new record in the Alert_pending table but is not updating the alert_refresh column for that record, this results in the agent trying again and again to insert it into alert_pending table. 


To resolve this issue please contact Confirm Tech Support by calling, raising a case via the portal or emailing software.support@pb.com as you will need to receive some SQL to run against the database.

 

Environment Details

Product Feature: Application Infrastructure


 

Downloads

  • No Downloads