>do you have any commands which would be handy to measure the memory consumption.
call a script like the following every 30 mins (using your monitoring tool or a cron job)
PID=`cat /mercator1/.launcherPID`
ps l $PID
(the name of the PID file might be slightly different in 671)
the memory...
I don't think you will be able to get back the database errorcodes.
Doing a LASTERRORCODE() function will return the Mercator error code (e.g. 1002 - No data found), not the SQL errorcode.
The SQL errorcode should appear in the database trace, but parsing this would be slow.
Another option...
You only need to create 8 new segments; most of the segments are either very small (USR, UST, USY) or mostly reuse existing composites (USX, USB).
Can't see it being more than an hour to build.
What do you mean by "file size is normal"?
As soon as Mercator sees the file it will try to run the transformation map. If the file is still being written to, you will get errors.
Either follow Janhes' suggestion and implement a map delay or change the delivery process of the file to do a...
the easiest way to do it is to use DBLOOKUP or DBQUERY - why can't you use them?
the alternative is to have a parent map build the adapter string (so that you can populate the input variables) and override the input of the child map, so the child map gets the results of the DB procedure call...
If both maps are run under the same Event Server, the resource manager should prevent multiple maps from accessing the same object simultaneously.
But if it is a problem, use rollback in your output cards - WTX will then create a temporary filename, write to it, then rename when the map has...
there are limitations in WTX on what versions of SAP it supports - I'm not sure what the limits are though!
try using WTX 8.1 to import the idoc defn file, then export the tree to XML and then import into 6.7.1
Can you just add an extra input card to your functional map?
you might need to do something messy like pass down the previous index value and add one, e.g. something like:
index:HL Segment[LAST]+1
but should all be possible.
What happens if you run a simple map with just one database output card?
can you try removing the UPDATE OFF too?
can you try combining cards 3 and 4 (they both write to the same table)?
I was expecting more information in the trace, so possibly there's a problem with the DB2 adapter or client.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.