Back to connectors… Back to Sage CRM...

Sage CRM SQL update scripts had some errors (2 replies)

Arline Welty
7 years ago
Arline Welty 7 years ago

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

Support
7 years ago
Support 7 years ago

Arline, let's pick this up today via a GotoMeeting.

Thanks

6 years ago
Support 6 years ago

Closed due to inactivity.

Contact

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

Close

Request Demo

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

Close

Access Downloads

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

Close