Fatal SQL error occurred. (2,125) HR_HIRE.DATA.HIRE_REQUEST_BEAN.OnExecute

Fatal SQL error occurred. (2,125) HR_HIRE.DATA.HIRE_REQUEST_BEAN.OnExecute  Name:insert  PCPC:575  Statement:16 Called from:HR_HIRE.BUS.HireRequest.OnExecute  Name:saveHireRequest  Statement:11 Called from:HIRE_REQUEST.HireRequestSubscription.OnExecute
Attempt to call abstract method/property OnError of object class PS_PT:Integration:INotificationHandler. (180,845) 

 

 

 

 

 SOLUTION:
**************
1. Inactivate the Integration Broker domain
PeopleTools>Integration Broker>Service Operations Monitor>Administration>Domain Status
2. Click on Refresh button until all status string should be changed to "INACT" under Dispatcher Status.
3.Now, Activate the Integration Broker domain
4. Click on Refresh button until all status string should be changed to "ACT" under Dispatcher Status.
5. Re-test the issue.

If the issue still persists then change the DB flags option to 8 in psappsrv.cfg & psprcs.cfg files.