1

Topic: Dictionary Upgrade 6P - Out of memory

I am working through the updates to get my installation up to date.  6P is failing with 'Out of Memory'.  I am inclined to edit the sql file to insert COMMIT statements every few thousand lines. Would this be safe, or is there a better way of overcoming the problem?

2

Re: Dictionary Upgrade 6P - Out of memory

Hi
Did you mean 4P. If you change the block size to 1 this will commit after each line. By default this is set to 50 lines so no point altering the SQL. Run with the block set to 1 and then try looking in the log file which is on the same folder as the update file. It may be one SQL statement which is failing and if so this should show in the log file.

Mike Weideli
Littlefield Consultancy - IT Consultants