Multiple streams are not running in datastage server

mohandl · Post by **mohandl** » Tue Nov 06, 2007 4:38 am

Multiple streams are not running in datastage server for example if i ran two user defined SQL statemets thru datastage with two streams,i am getting error mesages randomly like

1.Timed out error 2. Abnormal Error 3.Incorrect VOC entry for $DS.GETPID and EACCESS permission deniend

If any body knows solution please let me know

Regards,
Mohan

ray.wurlod · Post by **ray.wurlod** » Tue Nov 06, 2007 6:54 am

What stage types? From the error message it appears that the interlude to the getpid() GCI call has become corrupted. Can you look at that VOC entry in this project and another, to see whether they are different? Timed out can be due to many factors, including database locks; this is difficult to diagnose with so little information about your job design. And the error about permission denied - what stage is generating that? It could be operating system permissions, it could be database authentication, it could be all manner of things. In short, you have not provided enough information to allow us to formulate any kind of cogent diagnosis.

mohandl · Post by **mohandl** » Tue Nov 06, 2007 7:25 am

Thx Ray,for u r quick reponds,

Stage type is ODBC Stage,please tell me What is GCI and VOC where i have to find and where i have to change in Datastage to find the solution.

Regards,
Mohan

chulett · Post by **chulett** » Tue Nov 06, 2007 7:53 am

Need a better idea of exactly what you are doing in your job. One ODBC stage, two output links, each one using User-Defined sql? If you use two separate ODBC stages, do they work fine?