IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  memory allocation error DatastageTX v7.5.1

    Posted 03/16/07 06:01 PM

    Originally posted by: smcasey


    We are getting error "-1001 memory allocation error" using v7.5.1 in Command Server stand-alone WIN w/ 1G RAM. The DBLOOKUP has been coded with VALID function and gives a fail and the errorcode and error message. Have tried burst mode with no luck. The CPU does hit its upper limits but physical memory does not appear to ever max out or even come close. There does not appear to be a lock out in the database; fix EC60894 appears to be included in our build. There are approx 1040 DBLOOKUPS that are requested and only the first 980 get fulfilled. We are using Interface library version 7.5(119) and Database adapter: Oracle8i Version 7.5(119). The number of DBLOOKUPS remain constant (dbl files generated)- seems like with a memory error it would bounce around a bit. The trace file gives "OUTPUT 1 contains invalid objects" but does not list anything invalid. The kicker is that the same map run in WTX8.1 with everything else constant completes sucessfully. Any ideas? Are we missing a patch fix on 7.5.1?
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: memory allocation error DatastageTX v7.5.1

    Posted 03/18/07 11:46 AM

    Originally posted by: SystemAdmin


    Not sure if the problem will be fixed by a newer adapter library because the memory issue may lay elsewhere. Nonetheless, you can contact support and say that you have a map that runs fine in 8.1 but gets certain errors in 7.5.1 and that you think it has to do with the database adapter. You can ask for the latest database adapter for Oracle 8i for V7.5.1.

    Yvonne Ricard
    Resistance is NOT futile.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 3.  Re: memory allocation error DatastageTX v7.5.1

    Posted 03/19/07 02:54 PM

    Originally posted by: SystemAdmin


    We had a similar problem seems there is a hard edit at 1.0 gigs for the mercator maps. Set your audit logs to "OnBurstError" and page size to "512/8", and Retry set to "Off", then input card for burst 100,000 (you might have to play around with that number in the page size and page count,use denominators of 8, depending on your data.) and on the output card append, I was using the audit log as a trigger for letting the event server know when the map was done appending the data successfully (rc!=0), then kicked off a bat file that changed the extension of the appended file for the next process. hope that helps.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender