Back to connectors… Back to Sage CRM...

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

Arline Welty
10 years ago
Arline Welty 10 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
10 years ago
Support 10 years ago

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

Thanks

9 years ago
Support 9 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