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