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 3 weeks 2 days ago. Offline
Joined: 06/23/2008
Posts: 565
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

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.