Skip to main content
Microsoft Dynamics GP forum
Answered

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

editSubscribe (0) ShareShare
ReportReport
Posted on by 75,730

I am back to getting this message when configuring Web Services. 'Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180''  I am using this installation media.

 MDGPFALL2020_DVD_ENUS

I see this previous reply but I thought this issue was correct using GP 18.3

https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/207499/web-services-config-wizard-fails-cannot-insert-the-value-null-into-column-data180/1045077#1045077

If I need to run the scripts in this KB which ones do I run against the DYNAMICS database and which ones against the company database?

  • Suggested answer
    RE: Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180' MDGPFALL2020_DVD_ENUS

    My thoughts are that is is due to the changes we made to Web Services around TLS 1.0/1.1, and the use of the Active Directory security store.

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

    For future reference for those who run into this the answer was to download the latest MDGPFALL2020_DVD_ENUS.There is something different in this media version that corrects the issue.

  • Suggested answer
    RE: Web Services Config Wizard fails: Cannot insert the value NULL into column 'DATA180' MDGPFALL2020_DVD_ENUS

    As I also have the support case you opened, I won't re-hash all the information other than to say that yes, usually when we see this type of message, Web Services is seeing information in the GP databases to indicate a prior install is present, but not enough to offer the option to upgrade, thus it throws the error.

    We usually have to run the scripts, one against the GP system database and the other against all GP company databases, to remove Web Services objects and then re-run the Web Services Configuration Wizard to complete the install of Web Services.

    Thank you

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans