Job which runs successfully is getting aborted in newversion

puli.reddy · Post by **puli.reddy** » Tue Oct 24, 2006 7:48 pm

Hi All,

Job which runs successfully in old version is getting aborted in newversion.
I am getting a funny error. One of the text column generates junk values in new version. I use IF IsNull(Col) = 1 Then "Open" Else Col. It generates proper values in old version. The same job generates junk values in new version. The generated values populated into a hashfile, so that job is getting aborted.

Old Version is 7.0 and new version is 7.5

Can anyone advise on this please!

chulett · Post by **chulett** » Tue Oct 24, 2006 7:55 pm

The 'junk' values being generated is the 'funny error'? Are these junk values the contents of the 'Col' field or something else entirely? You may want to post some examples - what comes in the Col field and the result of the derivation.

I would guess the IsNull check is no longer returning True for those values and just passing on what's in the field. You might want to try changing the derivation to this and see if it helps:

Code: Select all

If Len(Trim(Col)) = 0 Then 'Open' Else Col

That checks for empty strings as well as nulls.

keshav0307 · Post by **keshav0307** » Wed Oct 25, 2006 7:11 am

try this
IF IsNull(Col) Then "Open" Else Col

chulett · Post by **chulett** » Wed Oct 25, 2006 7:13 am

No functional difference from the original derivation.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 25, 2006 7:41 am

Is the source a text file? If so, how is NULL represented in that particular column? You may need to visit the extended properties (Edit Row in the Columns grid) to find out.