[Solved] Out of Memory Error
Posted: Wed Jul 11, 2012 5:50 pm
Hello All,
My Main Customer table has become corrupted (I'm assuming) and the table will not open. When I attempt to open the table I get the following error:
THE DATA CONTENT COULD NOT BE LOADED. out of memory.
When I click the MORE button I receive the following information:
SQL Status: S1000
Error code: 72
out of memory
AND:
The SQL command leading to this error is:
SELECT * FROM "Orders"
("Orders" is the name of the table that will not open.)
I have tried SHUTDOWN COMPACT and get this message:
1: File input/output error: mydb.script.new in statement [SHUTDOWN COMPACT]
And then in my db folder I see I have a mydb.script AND a mydb.script.new file
I have recently moved to a multi-user set up so I'm wondering if there are duplicate records or some other conflict going on.
ANY help would be greatly appreciated. I am dead in the water until I can get this fixed. Even though I have been utilizing my db for quite sometime without major problems, I'm still rather new to the intricacies of db management.
Thank you!
TJM05
My Main Customer table has become corrupted (I'm assuming) and the table will not open. When I attempt to open the table I get the following error:
THE DATA CONTENT COULD NOT BE LOADED. out of memory.
When I click the MORE button I receive the following information:
SQL Status: S1000
Error code: 72
out of memory
AND:
The SQL command leading to this error is:
SELECT * FROM "Orders"
("Orders" is the name of the table that will not open.)
I have tried SHUTDOWN COMPACT and get this message:
1: File input/output error: mydb.script.new in statement [SHUTDOWN COMPACT]
And then in my db folder I see I have a mydb.script AND a mydb.script.new file
I have recently moved to a multi-user set up so I'm wondering if there are duplicate records or some other conflict going on.
ANY help would be greatly appreciated. I am dead in the water until I can get this fixed. Even though I have been utilizing my db for quite sometime without major problems, I'm still rather new to the intricacies of db management.
Thank you!
TJM05