Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT RESTORE PROBLEM

New Member
Posts: 2
Country: United States

ACT RESTORE PROBLEM

Hi Guys,

I came across this one while trying to open an Act 2005 db with act 2009:

 

*** Upgrading database to Schema Version 08.00.0101.0000 at 2008-11-09 19:35:31 ***
Altering table TBL_SYSTABLEKEY
The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.
 
*** Upgrading database to Schema Version 08.00.0107.0000 at 2008-11-09 19:35:31 ***
Altering table CTL_SYNCDBMAP_ROWSCHEMA
  Rebuilding indexes...
Altering table CTL_SYNCDBMAP_ROWDATA
  Rebuilding indexes...
Creating table CTL_SYNCDBMAP_ROWCOMPLETED
   setting metadata...
   setting Keys... 

 

*** Upgrading database to Schema Version 08.00.0110.0000 at 2008-11-09 19:35:31 ***
Altering table TBL_PICKLISTITEM
Msg 547, Level 16, State 1, Server \ACT7, Line 4
The INSERT statement conflicted with the FOREIGN KEY constraint "PICKLISTITEM_PICKLISTID_FK". The conflict occurred in database "INFO4", table "dbo.TBL_PICKLIST", column 'PICKLISTID'.
The statement has been terminated.
PROCESSING ERROR OCCURRED IN BUILD 08.00.0110.0000!
Msg 50000, Level 15, State 1, Server Chronos\ACT7, Line 61
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
 
FOOTER ENTRY TRANCOUNT = 0
Msg 50000, Level 25, State 1, Server Chronos\ACT7, Line 11
***** Update of database failed!  Exiting from update!
Msg 2745, Level 16, State 2, Server Chronos\ACT7, Line 11
Process ID 52 has raised user error 50000, severity 25. SQL Server is terminating this process.

 

 

Do you know how can I fix it ?:smileyvery-happy: 

Thank you,

Dman

Moderator
Posts: 4,395
Country: USA

Re: ACT RESTORE PROBLEM

Try running database maintenance from actdiag.

 

Database Rebuild and Repair Procedures