web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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

I have the same question (0)
  • Talon Meyer Profile Picture
    Talon Meyer 91 on at

    Did you find a solution for this?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    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)

  • Suggested answer
    Talon Meyer Profile Picture
    Talon Meyer 91 on at

    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,850 Moderator on at

    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?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans