Sage CRM SQL update scripts had some errors (2 replies)
Arline, let's pick this up today via a GotoMeeting.
Thanks
Closed due to inactivity.
Arline, let's pick this up today via a GotoMeeting.
Thanks
Closed due to inactivity.
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Just reading the Sage CRM User Guide, it recommends running the Sage CRM MetaData Update scripts in the IMAN folder: E:\IMan\Config
When I ran the 7.2 scripts on a 7.3 system (I only saw scripts for 7.0 7.1 and 7.2) I got the below in SQL Server Mgt Studio. Is this an issue, or is there a better script I should run?
Msg 515, Level 16, State 2, Line 22
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [Custom_sysParams] Column [Parm_Value] Inserted
(1 row(s) affected)
Msg 515, Level 16, State 2, Line 30
Cannot insert the value NULL into column 'FdSe_FldSecurID', table 'PABCRM.dbo.FieldSecurity'; column does not allow nulls. INSERT fails.
The statement has been terminated.
FieldSecurity Row Inserted
(1 row(s) affected)
Column [Parm_Value] added successfully.
Msg 515, Level 16, State 2, Line 63
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [Custom_sysParams] Column [Parm_Name] Inserted
(1 row(s) affected)
Msg 515, Level 16, State 2, Line 71
Cannot insert the value NULL into column 'FdSe_FldSecurID', table 'PABCRM.dbo.FieldSecurity'; column does not allow nulls. INSERT fails.
The statement has been terminated.
(1 row(s) affected)
(1 row(s) affected)
Table [Custom_Tables] Updated.
(1 row(s) affected)
Table [Custom_Captions] Updated.
(1 row(s) affected)
Table [Custom_SysParams] Updated.
(1 row(s) affected)
Table [Address_Link] Updated.
(1 row(s) affected)
Table [Person_Link] Updated.
(1 row(s) affected)
Table [Custom_Tables] Entity [EmailLink] Updated.
(1 row(s) affected)
Table [Custom_Tables] Entity [PhoneLink] Updated.
Msg 515, Level 16, State 2, Line 148
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [Custom_Captions] Column [Capt_CaptionId] Inserted
Msg 515, Level 16, State 2, Line 156
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [Custom_SysParams] Column [Parm_id] Inserted
Msg 515, Level 16, State 2, Line 164
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [Custom_Tables] Column [Bord_TableID] Inserted
Msg 515, Level 16, State 2, Line 172
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [Custom_Tables] Column [Bord_IdField] Inserted
Msg 515, Level 16, State 2, Line 180
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [EmailLink] Column [elink_linkid] Inserted
Msg 515, Level 16, State 2, Line 188
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [Person_Link] Column [PeLi_PersonLinkId] Inserted
Msg 515, Level 16, State 2, Line 196
Cannot insert the value NULL into column 'ColP_ColPropsId', table 'PABCRM.dbo.Custom_Edits'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Table [Custom_Edits] Entity [PhoneLink] Column [PLink_LinkID] Inserted