Using BASIC transformer

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
agathaeleanor
Participant
Posts: 76
Joined: Mon Mar 05, 2007 9:26 pm
Location: Malaysia

Using BASIC transformer

Post by agathaeleanor »

Hi All Experts,

I have a ETL job which using BASIC transformer to call a routine.

The job runs successfully for the first time. And subsequently, to run second time, the job seems running forever and up to certain period (20minutes), it will be aborted.

I try to recompile the job again and it runs finished.

All in all, every time after each successful run, I will need to compile the job and thus it has no issue (running 20 minutes to abort state).

For your information, I have set the transformer stage as sequential.

Need your help in tackling this issue.

Thanks in advance.
kkalyanrao@gmail.com
Participant
Posts: 11
Joined: Thu Feb 10, 2011 1:09 am
Location: Kuala Lumpur

Post by kkalyanrao@gmail.com »

Can you post the error message that you get on the second run ?
- Kalyan
agathaeleanor
Participant
Posts: 76
Joined: Mon Mar 05, 2007 9:26 pm
Location: Malaysia

Post by agathaeleanor »

Error message said,

BASIC_Transformer_6,0: dspipe_init(11338): open(/tmp/ade.HPBINFOHUBDEV.JB_KP_EX_LU_DATA_OWNER.#0.BASIC_Transformer_6.Lnk_Basic-Output) - No such file or directory

BASIC_Transformer_6,0: The runLocally() of the operator failed.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Does your operating system have a maximum length of a file name? I think this is a truncated name of a pipe (fifo) file. Try using shorter stage and/or link names, at least for the purpose of testing this theory.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply