02-09-2018 04:10 AM
I have backed up an Act! v17 Premium database. Using File>Restore as on a v20 Premium machine get this error
Act.Data.ActDb. ActDbException.Cannot insert the value NULL into column 'ORIGIN_SYNCDBID'
Not seen this before. Any clues?
Tried restoring the database to a different folder.
02-09-2018 04:55 AM
Try to restore on the v17 machine where the backup originates from. Make sure to use RESTORE AS and restore under a different name and in a different place on that machine.
If that fails as well, try "save copy as.." from the live database.
Open the copy and perform a database maintenance. If that goes ok , make a backup of the copy and start from the beginning.
02-09-2018 05:33 AM
Interesting - cannot make a full copy or empty copy of the original database. Errors out both times. (same error).
Performed basic maintenance - same issue.
Could not restore backup on original machine - same error.
02-09-2018 06:08 AM
The error message hints to some problem with synchronisation.
Is the database a "publisher database" and is there a synchronisation in use?
If not ( pls check thoroughly before the next step!), go into the settings and switch the synch OFF.
If there is an active remote database and the a.m. is not feasible: try to create a backup of the remote DB.
Then start procedure from step 1.