Originally posted by: SystemAdmin

Hello,

with TX 6.7 under win2k, i have a map A that run another map B according to data that are in a table (there is a query every 5 minutes). Sometimes the map B always fail with the error "Not enough memory to run map". The only solution is then to restart the event server.
What can be the problem.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Three things that I would suggest,
1. In the mercator.ini, change the following settings:
;IdleDB=0
;SLimDB=0
;HLimDB=0
;KeepDB=0
;MinDB=0

to
IdleDB=1
;SLimDB=0
;HLimDB=0
KeepDB=0
;MinDB=0

This will create a new connection every time it runs. (Which might be the problem.)
2. If the querys are returning large amounts of data, make sure that the work files in the executable map and the run map are set to file, unique.
3. If these don't fix the issue, contact support, there might be a memory leak that is causing it to crash, if you see the memory in the management console continually increasing, and never dropping, even when no maps are running, it is a possibility.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange