Unable to set to Null
Posted: Wed Oct 03, 2007 11:12 am
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
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