Error log does not show actual DB error message

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
myDPstage
Participant
Posts: 1
Joined: Thu Oct 22, 2015 1:06 pm

Error log does not show actual DB error message

Post by myDPstage »

The server job fails due to column length issue (target.table.column has length less than source.table.column) but log doesn't show the actual error message, only shows few column values of the row that failed. It happens also with unique constraint error.

Below is the error message while updating the target table:

J_PERSON_TEST..SRC_PS_PERSON_UPD.IDENT4: The value of the row is: PERSON_NBR = 1224 ETHNIC_ID = 0 PER_ID = 6286 PF_ID = 0 PLN_IND = - P_NM = abc FULL_IND = N

The execution order of the job looks something like this: MSEQ1>MSEQ2>SEQ>Server Job

All options under Severity Level in Administrator > Log Views have been checked but still have the same issue, not showing the actual DB error.

Is something needs to be done in the server job/administrator so that the log shows the complete/actual error message?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.

The sequences probably aren't relevant here. Can you please tell us what the actual server job is trying to accomplish, and how?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply