03-09-2011 05:21 PM
Trying to restore a remote new act database. Only 1300 contacts in the main database. The machine is a WIN7 new laptop and the install went fine.
It looks like the Remote is going through the restore process then it says failed. The error message is "could not find stored procedure 'dbo.PRC_UPD_TABLECOLUMN.
03-09-2011 06:41 PM
03-10-2011 08:15 PM
12-06-2011 08:48 AM
My exact error message:
Cannot insert the value NULL into column 'DATATYPEID', table
'name.dbo.TBL_SYSCOLUMN'; column does not allow nulls.
The statement has been terminated
12-07-2011 07:30 AM
You can test the ACT!/SQL installation by attempting to create a new database (File / New Database). Is this successful?
If yes, create a backup of it (File / Backup / Database) and then attempt to restore it using the Restore As option. Is this successful?
If these are successful, attempt to restore the remote database (RDB) file on the server. If it is successful, use the method in the following article to move the remote to workstation: KB Article 19817
12-07-2011 07:47 AM
I tried to restore the remote database on the server and I got the same exact error message as when I tried it on the client. I guess from that we can assume there is a problem with the database itself. Any more suggestions from here?