Hi All,
Sorry for the late response. …working like hell. (like all of us, I think)…
Rob (thanks your remarks!), it was necessary to keep the mentioned data together, because in my case these are invrpt/slsrpt edifact message type, just customer sends them not within one UNH-UNT, but more within an envelope.
Our WM implementations is configured to split and process incomming envelopes per transaction (in case of edifact it menas one UNH-UNT pair). In case of big invrpt or slsrpt file it is not acceptable if we map it to inhouse (comma delimited) text files per each transaction and deliver it this was, because the user can get 100s of files (and 100s of warning mails).
The change to not to split per transaction in the default inbound TPA of the specified Trading Partner is not an option, because it would affect the other message types of the Trading Partner (and all of our mappings are based on transactions-processing instead of envelope processing).
So, the solution I choosed and implemented is a database-based solution; with a few words: process-store-group-deliver
First - while the data is still envelope - I save the header data into a table (e.g. senderID,ICnr,NrOfTransactions,Status). After that, during the processing of each transactions I save the output into another (detail) table with the senderID+ICnr key and also with the transactionNr (sequenced nr within one interchange).
Another service is scheduled to run every X hrs and which first makes a list from header table, then loop over on the list and takes out the detail data forr the specified senderID+ICnr and do the groupping and the delivery to the destination server.
Third service is scheduled once a day (or whatever) to clean up both tables, where the status is ‘DELIVERED’. This case our database tables do not grow that quickly, or let’s say, they are almost empty, only the data of the current day is there.
Any of your remarks are welcome and I hope it will be also helpful to someboday who will meet the same requirements and has the same trouble.
CU All and thanks again all of your posts!
Balazs