Converting database from ASG 2012 -> 2015

[jossemann]

Hi,

I get an error when converting/importing the 2012 database.
Please help.

See attachment

   

[DevOma]

Which step is executed - the error message is in front of the current step...

[jossemann]

Which step is executed - the error message is in front of the current step...

Sorry.

See new attachment

[DevOma]

Ok - there are 2 possible ways how to fix (I hope so) - we had some issues with very large log data

You can check how many log entries do you have on your old sql database

SELECT count(*) FROM vCCErrorLog

If this count is very high (perhaps > 50k) then you should delete some logs before migrating (delete all in UI of error logs or set an automatic deletion in options like last 30 days - automatic deletion will execute when you start the program again) - or you could try to set a very high timeout in your new database environment to prevent an timeout error when executing the migration (edit your environment at startup and check "Set advanced options).

[jossemann]

Ok - there are 2 possible ways how to fix (I hope so) - we had some issues with very large log data

You can check how many log entries do you have on your old sql database

SELECT count(*) FROM vCCErrorLog

If this count is very high (perhaps > 50k) then you should delete some logs before migrating (delete all in UI of error logs or set an automatic deletion in options like last 30 days - automatic deletion will execute when you start the program again) - or you could try to set a very high timeout in your new database environment to prevent an timeout error when executing the migration (edit your environment at startup and check "Set advanced options).

I get this value running the command in the database:
2934351

I have turned on deleting of log files after 30 days.
Does not seem like anything happens. When I try to open logs, from Tools (menu) I get an error message.

Do you have a script that can wipe the logs directly from the database?

[DevOma]

The fast way is to delete all :-)

TRUNCATE TABLE vCCErrorLog

else every row will be deleted one by one and that could take a really long time :-) 30 minutes to 1 hour (or perhaps more) I guess...

DELETE FROM vCCErrorLog WHERE _InsertDate < DATEADD(day, (-30), getutcdate())

[jossemann]

The fast way is to delete all :-)

TRUNCATE TABLE vCCErrorLog

else every row will be deleted one by one and that could take a really long time :-) 30 minutes to 1 hour (or perhaps more) I guess...

DELETE FROM vCCErrorLog WHERE _InsertDate < DATEADD(day, (-30), getutcdate())

That solved the issue.

Thank you!