Originally posted by: TarakN

Hello All,

I am having the concern in my production servers wherein all increment value lookups getting deleted over past 4months and files are failing with error code:12.

These lookup will hit the maps and increment the values for control numbers for ex: 17890 to 17891 during runtime.

Because of hitting and writing the values is it getting deleted, we are using this from 2012 on wards but suddenly from past 4 months we are seeing the issues.

Is there any patch deploy for this we are using WTX 8.3.0.3 version.

Thanks,

Tarak

Originally posted by: paul.brett

Are you using the GETANDSET() function to increment this value?  There are some known issues with GETANDSET() which are fixed in Service Pack 6.  I recommend you upgrade to WTX 8.3.0.6 instead.

Thank-you.

Paul

Follow me on Twitter

Originally posted by: TarakN

Hi Paul,

We are not using GETANDSET() function. We use the below,

Ex: NUMBERTOTEXT(SeqNum) + 1

Thanks,

Tarak

Originally posted by: paul.brett

So, your output card overwrites the input card?  I assume that this map is always executed single-threaded?

I suppose in rare circumstances, during a map crash, the file might get 'lost' somehow.

I'm still leaning toward installation of Service Pack 6, as the best way to avoid this problem from re-occurring.

Thank-you.

Paul

Follow me on Twitter

Originally posted by: TarakN

Hi Paul,

Map executes in multi-thread. Not sure output card overwrites input card.

In which scenarios map can crash and file gets deleted.

Do you mean Service Pack 6 is the fix.

Thanks,

Tarak