Unable to set to Null

[chetankumarh]

Hi ,

I am facing a strange problem. The problem definition is as follows

8 parallel job runs in squence (Unix Server). Each job has a parameter variable and the value is current date ( converted from julian format and convertion logic works fine. All the jobs were running perfectly for the past 7 months.

Source is ASCII format of EBCDIC file, traget is SQL Server 2000 and it is simple data pull and push operation.

From last friday, first 3 job completes the execution, but the 4th job aborts with an error "Returned date format not recognised for field - <Column_Name>. Unable to set to Null." ( But the same variable is used in the first 3 jobs).

The strange thing is that the job copies in Dev and UAT runs perfectly fine with out any problem.

What could be the problem?? any help/ tips will help me a lot.


Thanks and Regards,
Chetan

[ray.wurlod]

Welcome aboard.

What is different between the environments where it works and the environment where it does not work?

("Nothing" is not the correct answer. However the correct answer may lie outside of DataStage. You need to be the detective.)