Notifications
Announcements
No record found.
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?
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
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.
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 456 Super User 2025 Season 2
Martin Dráb 429 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
