DSXchange

As you say you are getting this problem randomly, is there any specific job where you are getting this error?
What is the job design? Are you fetching record from some database or writing to some database?
what will load on Datastage server when you are facing this issue?

what is your job design?
Are you using some row generator or some such type of stage?

Typically orchadmin command cannot be used from client machine but do you mean to say that your requirement is to convert datasets into text files? If this is case, then you can create a job to read dataset using dataset stage and write it to text file using sequential file stage.

Please paste complete error message what you are getting.

1) After how many rows job is getting aborted ?
2) Are you able to view the data in dataset ?
3) Is there any trnasformation logic written inside transformer for any column ?
4) Is the timestamp column you are referrring was getting passed as senull() is the key column in table ?

What is the source for this date data ? is it coming from some database or you reading it from some file ??
what is your target database for loading the data ??

Is this Dataset problem is with this particular Dataset or is this is for all other Datasets too ?
If this is the problem for all the datasets then probably you can check with your storage or unix team about the mount points on which datasets description file is getting created.

Did you check the target table key columns? Is there any issue with DB side or some problem on target table?
Try to use sequential file in target and check whether job is running or not.

Hi All, Some two days back one of my datastage project got deleted and i don't have any idea how it got deleted as no one has issued the command to delete it. One of my colleague was trying to delete some other project through DstageWrapper.sh script and after some 4 hours when one of our job got ab...

Try using "dscc.exe" command. You can find it where your Datastage clients are instlaled, location like "C:\IBM\InformationServer\Clients\Classic"

Do we need to recompile the job after adding the message handler ?

Thanks for the reply. Please find below details as requested. 1) There is no grid server. This is standalone server. 2) In job log only 4 entries are coming for that run - User defined variables, Adding message handler, environment variable adding and last it shows Parallel job initiated and then if...

Hi All, I am facing a strange problem in some of my jobs. Sometimes whenever i trigger my DataStage job it shows as running in the director logs and on OS side too but when you see the detail logs then you will find it is hung. I tried restarting my DataStage services but still same issue is coming ...

After making above settings the data loaded is in gebberish format but when the same data i took into the oracle output stage it is loaded correctly. Only giving improper result in XML output stage.

I changed the below NLS parameter and then my job runs fine. Now need to check whether data loaded is correctly or not.
NLS_CHARACTERSET - AL32UTF8
NLS_LANG - AMERICAN_AMERICA.AL32UTF8