Many a times due to various unpredictable reason we encounter numerous errors while browsing over the web some are known and some are not, since not everyone has wisdom about the errors that are encountered on the screen. So in this blog we are focusing 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]PVKIO] Logon failed ERROR [S0000] [ProvideX][ODBC Driver][PVKIO]Logon failed:
As you all know for accessing SData over the web User needs to enter their Sage 100 Login credentials. So in order to resolve the above encountered error one needs ask the “Administrator” or any user with appropriate rights.
Solution/Resolution
User needs to Login to Sage 100 ERP application for identifying the problem with the User used for accessing SData over the web.
After logging to Sage 100 ERP, open “Library Master Module” located under Modules and click on “User Maintenance” sub-module. As shown in the below image:
Clicking “User Maintenance” sub-module, will pop a screen where we need to specify the User Logon Name for accessing SData. Refer the below image:
Once you have enter the required User Logon all the details of the User [the one used for accessing SData] populates on the screen. The screen also has a checkbox at the left bottom of the screen which says “User Account Locked” with the value as “True” or “Checked” which means the following User Logon: SData is locked.
Since the Account is locked, it will not allow the User to login in Sage 100 ERP application. And it will also not allow the User to access to SData over the web. So in order to remove the barrier of not being able to access the SData and logging into Sage 100 ERP application, the Administrator needs to “Un-check” the box of User Account locked for the “SData” for User to continue its Activities.
Conclusion
When the Administrator un-checks the User Account Locked checkbox the user can now access the SData over the web and you can no longer encounter the ERROR [S0000] [ProvideX][ODBC Driver]PVKIO] Logon failed ERROR [S0000] [ProvideX][ODBC Driver][PVKIO]Logon failed. Refer the below image:
In conclusion, by using the above steps you are able to login & are able to use SData web-service again. If you still have concerns, you can write it to us and we will reach out to you with the same.
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.
About Us
Greytrix – 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 for Sage X3, Sage 100 and Sage 300 (Sage Accpac). We also offer best-in-class Cloud CRM Salesforce customization and development services along with services such as Salesforce Data Migration, Integrated App development, 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 – Salesforce is a 5-star rated app listed on Salesforce AppExchange.
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. We will be glad to assist you.
Related Posts
- Bulk Order Promotion from Salesforce – Sage 100 ERP using GUMU™ lightning version
- Bulk Account Promotion from Salesforce to Sage 100 ERP
- Promote Salesforce Account to Sage 100 Customer using GUMU™ lightning version
- GUMU™ Salesforce Tricks & Tips – Synching Additional (Order) Fields from Salesforce to Sage 100 ERP
- GUMU™ Salesforce Tricks & Tips – Synching Additional (Order Details) Fields from Salesforce to Sage 100 ERP