SAP IDOC Load job getting hanged

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
BradMiller
Premium Member
Premium Member
Posts: 87
Joined: Mon Feb 18, 2008 3:58 pm
Location: Sacramento, CA

SAP IDOC Load job getting hanged

Post by BradMiller »

I ran a job to load data containing 5200 records from database into DEBMAS05 IDOC using SAP IDOC Load stage & it worked properly and loading into SAP was done in 30 minutes.After that I re-ran the job after 30 minutes and it gets into hanged mode.Looked whether data is writing into IDocLoadData directory or not but its not writing anything out there.Did anyone had the same problem if so how did you fix it.Here is more information (dstage.tid shows Apr02 where as IDocListener.log shows Apr 5th which is the correct date of run.

-rw-r--r-- 1 dsadm dstage 2266 Mar 31 17:51 0A6E18D3007D4BB3EE102315.mms
-rw-rw-r-- 1 dsadm dstage 189 Mar 31 18:15 IDocLoad.config
drwxrwxr-x 5 dsadm dstage 256 Apr 01 11:37 IDocTypes
drwxrwxr-x 5 dsadm dstage 256 Apr 01 11:38 IDocLoadData
-rw-rw-r-- 1 dsadm dstage 9858 Apr 02 16:32 dstage.tid
-rw-rw-r-- 1 dsadm dstage 0 Apr 05 15:38 IDocListener.log

$tail -4 dstage.tid

Fri Apr 2 16:32:09 2010 0A6E18D300724BB67E791FFB CONFIRMED
Fri Apr 2 16:32:09 2010 0A6E18D300724BB67E791FFC CONFIRMED
Fri Apr 2 16:32:10 2010 0A6E18D300724BB67E791FFD CONFIRMED
Fri Apr 2 16:32:10 2010 0A6E18D300724BB67E7A1FFE CREATED
BradMiller
Premium Member
Premium Member
Posts: 87
Joined: Mon Feb 18, 2008 3:58 pm
Location: Sacramento, CA

Post by BradMiller »

I resolved the issue by myself.Usually when you establish the parent,child relationship and pass the primary key values you need to change the datatype to Bigint(19) instead of varchar which is set by default as the limit would be reached in DataStage to 99999 and it doesn't posts any idocs.
Post Reply