DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message

Joined: 22 Oct 2015
Posts: 1

Points: 14

Post Posted: Mon Feb 25, 2019 3:55 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Unix
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?

Premium Poster

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54582
Location: Sydney, Australia
Points: 295988

Post Posted: Wed Feb 27, 2019 4:16 pm Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours