{"id":6464,"date":"2021-12-20T14:53:51","date_gmt":"2021-12-20T14:53:51","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/salesforce\/?p=6464"},"modified":"2022-05-09T12:57:32","modified_gmt":"2022-05-09T12:57:32","slug":"how-to-resolve-the-error-s0000-providexodbc-drivercolumn-not-found-udf-salesforce-encountered-while-accessing-sdata-over-the-web-for-sage-100-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/salesforce\/2021\/12\/20\/how-to-resolve-the-error-s0000-providexodbc-drivercolumn-not-found-udf-salesforce-encountered-while-accessing-sdata-over-the-web-for-sage-100-erp\/","title":{"rendered":"How to resolve the ERROR [S0000] [ProvideX][ODBC Driver]Column not found: UDF_SALESFORCE encountered while accessing SData over the Web for Sage 100 ERP"},"content":{"rendered":"\n

Due to various unpredictable reasons, we often encounter numerous errors while browsing the web. Some are known, and some are not, since not everyone has wisdom about the errors encountered on the screen. So in this blog, we focus on understanding the basic troubleshooting steps to perform if ERROR [S0000] occurs while accessing the SData URL over the web. Refer the below image for ERROR [S0000] [ProvideX][ODBC Driver]Column not found: UDF_SALESFORCE.<\/strong><\/p>\n\n\n\n

\"ERROR-S0000\"<\/a><\/center>\n
ERROR-S0000<\/i><\/center><\/font>\n\n\n\n

As you all know, for accessing SData over the web User need to enter their Sage 100 Login credentials. So to resolve the above-encountered error, one needs to ask the \u201cAdministrator<\/strong>\u201d or any user with appropriate rights.<\/p>\n\n\n\n

\"Sage<\/a><\/center>\n
Sage 100 Logon<\/i><\/center><\/font>\n\n\n\n

Solution\/Resolution<\/em><\/u><\/strong><\/h4>\n\n\n\n

The User needs to log in to the Sage 100 ERP application to identify the problem with the User used for accessing SData over the web. Now go to the “Custom Office” module”  as shown below.<\/p>\n\n\n\n

\"Custom-Office\"<\/a><\/center>\n
Custom-Office<\/i><\/center><\/font>\n\n\n\n

Clicking the “User-Defined Field and Table Maintenance<\/strong>” sub-module will pop a screen where we need to Double Click on the module in which you are getting an error, then click on the Edit Fields<\/strong> Option. Refer to the below image:<\/p>\n\n\n\n

\"User-Defiend-Field-Maintenance\"<\/a><\/center>\n
User-Defiend-Field-Maintenance<\/i><\/center><\/font>\n\n\n\n

After that, you will get the User Defined Fields Screen, then Click on Add Icon as shown below.<\/p>\n\n\n\n

\"User-Defined-Field\"<\/a><\/center>\n
User-Defined-Field<\/i><\/center><\/font>\n\n\n\n

Fill in all the info required, then click on the OK <\/strong>button. After that, one screen will pop up, as shown below image.<\/p>\n\n\n\n

\"Add-Custom-fields\"<\/a><\/center>\n
Add-Custom-fields<\/i><\/center><\/font>\n\n\n\n

Fill in all the info required, then click on the OK <\/strong>button. After that, one screen will pop up, as shown below.<\/p>\n\n\n\n

\"Add-Custom-Fields-Details\"<\/a><\/center>\n
Add-Custom-Fields-Details<\/i><\/center><\/font>\n\n\n\n

Then it will ask for confirmation, as shown in the below image.<\/p>\n\n\n\n

\"Field-Update-Confirmation\"<\/a><\/center>\n
Field-Update-Confirmation<\/i><\/center><\/font>\n\n\n\n

After saving the Fields, the details will appear as shown below. <\/p>\n\n\n\n

\"Add-Fields-List\"<\/a><\/center>\n
Add-Fields-List<\/i><\/center><\/font>\n\n\n\n

Now repeat the steps, open the User-defined screen again, and click on the cross sign over the right-hand side as shown in the image below.<\/p>\n\n\n\n

\"Delete-Field\"<\/a><\/center>\n
Delete-Field<\/i><\/center><\/font>\n\n\n\n

Now click on the Yes <\/strong>button; once you click on that button, the status will convert to Del, as shown in the below image.<\/p>\n\n\n\n

\"User-defined-field-list-after-fields-marked-for-deletion\"<\/a><\/center>\n
User-defined-field-list-after-fields-marked-for-deletion<\/i><\/center><\/font>\n\n\n\n

Now, click on the “OK” button on the bottom of the layout then it will ask for confirmation, as shown in the below image.<\/p>\n\n\n\n

\"Field-Update-Confirmation\"<\/a><\/center>\n
Field-Update-Confirmation<\/i><\/center><\/font>\n\n\n\n

Once you click on the OK button, it will delete the field you have created. After performing the above steps, Restart the IIS<\/strong>.<\/p>\n\n\n\n

Note: –<\/strong> Before performing the above steps, please delete the “MassContract.XSD”<\/strong> file located in the following given path (C:\\sage\\Sage 100 Standard\\MAS90\\SData, assuming the Sage system is installed in C drive).<\/em><\/p><\/blockquote>\n\n\n\n

Conclusion<\/em><\/strong><\/h4>\n\n\n\n

This error is caused due to some missing files related to DNS. When you reset the password and restart IIS, it restores all the default files. Now you can access SData as shown in the below image.<\/p>\n\n\n\n

\"Working<\/a><\/center>\n
Working SData<\/i><\/center><\/font>\n\n\n\n

In conclusion, we hope you can log in & use SData web service again by using the above steps. If you still have concerns, you can write them to us, and we will reach out to you with the solution for the same.<\/p>\n\n\n\n

We hope you may find this blog resourceful and helpful. If you still have concerns and need more help, please contact us at salesforce@greytrix.com<\/a>.<\/p>\n\n\n\n

About Us<\/b><\/br>\n

Greytrix<\/a> \u2013 a globally recognized and one of the oldest Sage Development Partner and a Salesforce Product development partner offers a wide variety of integration products and services to the end users as well as to the Partners and Sage PSG across the globe. We offer Consultation, Configuration, Training and support services in out-of-the-box functionality as well as customizations to incorporate custom business rules and functionalities that require apex code incorporation into the Salesforce platform.

Greytrix has some unique solutions for Cloud CRM such as Salesforce Sage integration<\/a> for Sage X3<\/a>, Sage 100<\/a> and Sage 300 (Sage Accpac)<\/a>. We also offer best-in-class Cloud CRM Salesforce customization and development services<\/a> along with services such as Salesforce Data Migration<\/a>, Integrated App development<\/a>, Custom App development and Technical Support business partners and end users. Salesforce Cloud CRM integration offered by Greytrix works with Lightning web components and supports standard opportunity workflow. Greytrix GUMU™ integration for Sage ERP \u2013 Salesforce is a 5-star rated app listed on Salesforce AppExchange<\/a>.
The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more information on our Salesforce products and services, contact us at salesforce@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n

Related Posts<\/strong><\/p>\n\n\n\n