You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Component Interface error message while performing a MSS transaction like terminate an employee

1 reply [Last post]
Guest's picture
Guest

Need reason for the attached error message and provide details as to why the WORKFORCE_SYNC is failing.

SQL error. Stmt#:332 Error Position:0 Return: 8604 - [IBM][CLI Driver][DB2] SQL0913N Unsuccess

Lepa's picture
User offline. Last seen 2 years 2 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Component Interface error message while performing a MSS ...

I would try debugging the component interface from PeopleCode. To accomplish that you need to modify a delivered function. The function is located at FUNCLIB_CI.CI_EXCEPTIONS FieldFormula and is called ciCreateExceptionEntry

Right after the following code

If All(&MsgSetNbr, &MsgNbr) Then
&ExceptionRec.MSG_SEVERITY.Value = ciGetSeverity(&MsgSetNbr, &MsgNbr);
End-If;

add this:

MessageBox(0, "", 0, 0, "Error Message: " | &ExceptionRec.MESSAGE_TEXT.Value);

Now when a CI is called and an error occurs you will get a messagebox on the screen indicating the error. Hopefully this will give you a more meaningful error.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog