Abnormal termination of stage in Datastage

Question

I have a DX server job in Datastage v8.1 It has very simple flow DRS stage --> Transformer --> seq file stage In DRS stage I have an oracle sql query (complex join query). I am able to view data through VIEW DATA option in DRS stage but when I execue the job it Aborts saying

Abnormal termination of stage Exxx_Ixyxyxy..X_Transform detected

There no other error or warning message in log.

Is Exxx_Ixyxyxy..X_Transform the name of the transformer stage? If yes have you tested the job without it? — MichaelTiefenbacher, May 23 '17 at 18:29
Hi @MichaelTiefenbacher X_Transform is the transformer stage. Exxx_Ixyxyxy is my job name. — fairplay, May 24 '17 at 08:58

score 0 · Accepted Answer · answered Oct 16 '20 at 20:18

I had the same problem until I cleaned the resources that the job had locked and it works:

From Unix/Linux:

Log into the server using the dsadm user.
cd to the DSEngine directory
Enter . ./dsenv to source the dsenv file
Enter ./bin/uvsh to get into DataStage prompt
At ">" DataStage engine prompt, enter LOGTO project name
Run LIST.READU EVERY to list all the locks
Check active record locks under "Item Id" column for job name or RT_CONFIG# or RT_LOG# (# matches the job description number
Write down the Inode numbers and user numbers associated with these locks.
Enter LOGTO UV

If the LOGTO command is disabled, enter this command

"CHDIR <path_to_the_DSEngine_folder>"

(with <path_to_the_DSEngine_folder>=cat /.dshome under a telnet session on the DataStage server).

The UNLOCK command lives in UV account.

Enter UNLOCK INODE inode# USER user# ALL
You can use Q to get out of DataStage engine

Abnormal termination of stage in Datastage

1 Answers1