Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Web Services Config Wi...
Microsoft Dynamics GP (Archived)

Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180'

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

We are trying to get Web Services and ultimately Workflow installed and working but we are seeing issues in the Web Services configuration wizard that are preventing us from getting very far with it.

When running the wizard and selecting a company to configure Web Services for, we see the following error:

 

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'DATA180', table 'DYNAMICS.dbo.eConnect_Out_Setup'; column does not allow nulls. INSERT fails.

The statement has been terminated.

This seems to happen on any company we choose. I ran a SQL Profiler Trace to see the INSERT used and it appears to  specify values to insert into DATA1-DATA40 but there are 140 other DATA columns, none of which appear to allow NULLs.

Any thoughts?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180'

    Well this may have worked for GP 2016 but not for GP 18.2.1060. Just for kicks I tried setting DATA180 to allow NULLS and then the error moved to another column. Has anyone been successful in getting Web Services running with GP 18.2?

  • Suggested answer
    Talon Meyer Profile Picture
    Talon Meyer 91 on at
    RE: Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180'

    Here's what I got from the support team:

    Try running this script against the system and company databases, then run the configuration wizard again.

    7635.GPWS_5F00_Drop_5F00_DYNAMICS_5F00_Database_5F00_Objects.txt 

    If that doesn't work:


    1. Make sure to have a good, recent backup of the DYNAMICS and all GP company databases.
    2. Make a backup of the eConnect_Out_Setup table in the DYNAMICS system database, using this script:

    Select * into DYNAMICS..eConnect_Out_SetupBAK from DYNAMICS..eConnect_Out_Setup
    3. Run this script against the DYNAMICS system database to drop this table:
    Drop Table eConnect_Out_Setup
    4. Run the attached ‘eConnect_Out_Setup_GP2016R2’ script against the DYNAMICS database to re-create this table at the GP 2016 R2 structure.
    5. Run the attached ‘DataInto_eConnect_Out_Setup_GP2016R2’ script against the DYNAMICS system database, to put data back into the newly created eConnect_Out_Setup table.
    6. I’d make a backup of the DYNAMICS database at this point.
    7. Launch the Web Services Configuration Wizard again and attempt to complete the install of Web Services on the DYNAMICS system database and GP company databases.
    (You may or may not need to re-run the scripts I provided previously, but as it doesn’t seem the Wizard got very far, I’m thinking you may not need to)

    DataInto_5F00_eConnect_5F00_Out_5F00_Setup_5F00_GP2016R2.txt

    eConnect_5F00_Out_5F00_Setup_5F00_GP2016.zip

    Thanks to Derek Albaugh

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180'

    I am seeing this in the event viewer.

    System.IO.FileLoadException

    Exception message:

    Could not load file or assembly 'Microsoft.Dynamics.GP.WebServices.Contract, Version=18.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

    Stack Trace:

      at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type)

      at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName)

      at System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)

      at System.Type.GetType(String typeName)

      at Microsoft.Dynamics.GP.NTServiceHost.ResolveServiceType(ServiceElement service)

      at Microsoft.Dynamics.GP.NTServiceHost.OnStart(String[] args)

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180'

    I have resubmitted this question as no one has responded. I see nothing in the event viewer about this.

  • Talon Meyer Profile Picture
    Talon Meyer 91 on at
    RE: Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180'

    Did you find a solution for this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans