03-28-2010 04:30 PM
I just applied the automated update (Act 2010 SP1) and the database update bombs out. I was a clean install of Act 2010 and have not made any radical customizations. Looks like the script is trying to insert a null value that is not allowed by the database settings. Cannot find any support info about this. Any help is appreciated.
Setting syscolumn metadata for TBL_ACTIVITY.ISINVITATIONSENT ...
Setting syscolumn metadata for ITEMTYPE ON TBL_PRODUCTSERVICE
Msg 515, Level 16, State 2, Server GLACIAL-SA234\ACT7, Line 5
Cannot insert the value NULL into column 'ISDEFINEFIELD', table 'glacial.dbo.TBL_SYSCOLUMN'; column does not allow nulls. INSERT fails.
The statement has been terminated.
PROCESSING ERROR OCCURRED ADDING SYSCOLUMN INFO
Msg 50000, Level 16, State 1, Server GLACIAL-SA234\ACT7, Line 14265
WORK WAS ROLLED BACK - EXITING FROM UPDATE!
FOOTER ENTRY TRANCOUNT = 0
Msg 50000, Level 25, State 1, Server GLACIAL-SA234\ACT7, Line 19
***** Update of database failed! Exiting from update!
Msg 2745, Level 16, State 2, Server GLACIAL-SA234\ACT7, Line 19
Process ID 52 has raised user error 50000, severity 25. SQL Server is terminating this process.
03-28-2010 04:35 PM