DatStage showing DSCAPIOP_OraDB Error

ray.wurlod · Post by **ray.wurlod** » Wed Jan 14, 2009 11:10 pm

"Parameter not resolvable" probably means that you have used parameters for these three properties but, for whatever reason, the values supplied for the parameters (check in the job log) could not resolve into anything that the Oracle connection could use.

enigmatic28 · Post by **enigmatic28** » Wed Jan 14, 2009 11:53 pm

I checked all the logs of the job and did not found the DSCAPIOP_* parameters.

Just last questions before i mark this thread as resolved, can this kind of problem originate if the job was created using 7.5 rather than 7.5x2, and what is the difference using the compiler of 7.5 against 7.5x2?

thank you very much...

throbinson · Post by **throbinson** » Thu Jan 15, 2009 6:19 am

Drop the DSCAPIOP_ part. Are the parameters $ORADB, $OraDBUserID
and $OraDBPswd defined in the job and as Project level env variables in the 7.5.2 project?

enigmatic28 · Post by **enigmatic28** » Thu Jan 22, 2009 4:28 am

Are the parameters $ORADB, $OraDBUserID
and $OraDBPswd defined in the job and as Project level env variables in the 7.5.2 project?

yes they are...

ray.wurlod · Post by **ray.wurlod** » Thu Jan 22, 2009 2:42 pm

"Parameter not resolvable" probably means that you have used parameters for these three properties (ignoring the DSCAPIOP_ part of the name) but, for whatever reason, the values supplied for the parameters (check in the job log) could not resolve into anything that the Oracle connection could use.

LenGreenwood · Post by **LenGreenwood** » Fri Jan 23, 2009 3:48 am

If this is a parallel job and it calls a shared container, it may be a compiler bug. There is an APAR # JR29478 that resolves a very similar error message where "DSCAPIOP_ " appears as part of the param name.