Originally posted by: eyetea

Hi all,

I'm having issue with one of the trading manager maps stampandsortfile.mmc (sortec.mms).

we have an application that generates 2 files. WTX map transforms those files to EDI and places them under PO location c:\<install_dir>\tmgr_v8.2.1\mmgr\ (ABCD_mo.edi & ABCD1_mo.edi)

Issue is one of the files gets processed by trading manager and other gets struck in the folder (This happens at least 2 times in a week). There is only one entry in TMGR.Mapstatus table.

I attached the Error message generated by the stampandsortfile map

But when I touch the second file, it gets processed too.

Database: SQL server 2008
O/S: windows server 2003

Any help would be appreciated.

Thanks in advance.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: jvanboga

Your best bet is to look at the log file for 'snsdbwriter'. It will give you mre information about which of the 4 output cards experienced difficulty.

Card 1 and 4 are 'Sink' while 2 and 3 updated tables; 'mapstatus' and 'ecicstatus' respectively. My guess is that there is an issue of some sort with one of the table updates. Could be as easy as a missing or duplicate key. Might be something requiring a little more research.

Try recompiling the map with the trace on. If the problem will always occur with the same file use '-t'. If it failes randomly you'll probably want to use '-tv'.

Hope that helps.
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: eyetea

Thank you, I'm trying to replicate the same error in another environment with all traces turned on for the snsdbwriter map output cards, will see how that goes.
Appreciate it for spending time on my request.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender