Table problem?
We are currently running servicedesk 5507 on mysql on a 2003 server.
We've tried to upgrade to 6002 twice, but not succesfull. Java.exe on the server explodes the cpu (100%)
What we found out was that the current table "requestonhold" in 5007 is huge compared to the total database.
Database = 545,5 mb with 7 mnl rows
Requestionhold table= 431 mb with 6,9 mnl rows
(see attachment)
When opening the weblient and view 'requests on hold' there are zero requests.
Could this pe the problem? Do you have a solution for this?
We have run the bin\reinitializeDB.bat -->solved the problem but the database was empty
We have run the bin\run.bat --> no errors on screen
We've tried to upgrade to 6002 twice, but not succesfull. Java.exe on the server explodes the cpu (100%)
What we found out was that the current table "requestonhold" in 5007 is huge compared to the total database.
Database = 545,5 mb with 7 mnl rows
Requestionhold table= 431 mb with 6,9 mnl rows
(see attachment)
When opening the weblient and view 'requests on hold' there are zero requests.
Could this pe the problem? Do you have a solution for this?
We have run the bin\reinitializeDB.bat -->solved the problem but the database was empty
We have run the bin\run.bat --> no errors on screen