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



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?
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54501
Location: Sydney, Australia
Points: 295558

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?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
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