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.
Using BASIC transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Participant
- Posts: 11
- Joined: Thu Feb 10, 2011 1:09 am
- Location: Kuala Lumpur
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.