SAP Business One Integration
SAP error validating source XML against schema – Invalid child element
Last Updated: June 21, 2023Symptom At task runtime, the step fails with error: Error validating source XML against schema - The element 'ELEMENT_NAME' has invalid child element ‘ELEMENT_NAME' Cause The error is caused by an invalid schema from the input data source, i.e. the Database Query step will be the input data source. Solution To resolve the error, open...
To generate document, define the numbering series in Administration module – Error code: -5002
Last Updated: July 4, 2022Symptom At task run time, the step fails with the error: Failed to Add SAP B1 Business Object (-5002): To generate this document, first define the numbering series in the Administration module Cause This error occurs when a numbering series that is not supported for the document type is being mapped to the ‘series’ field....
Unable to get schema – You are not connected to a company
Last Updated: July 4, 2022Symptom At step configuration, when you select an operation you get the error: Unable to get object schema. Error occurred. You are not connected to a company Cause Occurs when the user setup under the ‘Authentication’ tab in the tool global configuration, has no license assigned within SAP B1, or the license has expired. Solution...
A task fails with the error: Could not establish trust relationship for the SSL/TLS secure channel
Last Updated: July 4, 2022Symptom A task with a SAP Business One connector step connecting to a SAP HANA database is failing with the error: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel Cause The HANA license server is not accessible over the SSL connection. Solution On the machine where the CommunicatorWS...
After installation of the SAP Business One client tools the SAP Business One Event tool is missing
Last Updated: June 21, 2023Symptom After installation of the SAP Business One client tools, the SAP Business One Event tool is missing meaning you will only see the following two client tools: SAP Business One Connector SAP Business One XML to Recordset Mapper Normally you would expect to see the following three: SAP Business One Connector SAP Business One...
HTTP Error 404.3 – Not Found – Occurs when connecting to a Sap Business One web service
Last Updated: June 21, 2023Symptom When connecting to a Sap Business One the request fails and the following error is received in the event log: HTTP Error 404.3 - Not Found If the Sap B1 web service URL is pasted into a web browser, the “Detailed Error Information” would be similar to the following example: Cause The requested resource...
IIS App pool fails when you make a call onto the SAP Business One Connector web service.
Last Updated: July 4, 2022Symptom The IIS application pool hosting the SAP Business One Connector web service stops when you make a call onto web service. The Windows event viewer log records entries from the IIS-W3SVC-WP event source similar to following: The Module DLL 'C:\path\My64bit.dll' could not be loaded due to a configuration problem. The current configuration only supports...
IIS App pool fails when you make a call onto the SAP Business One Connector web service.
Last Updated: June 21, 2023Symptom The IIS application pool hosting the SAP Business One Connector web service stops when you make a call onto web service. The Windows event viewer log records entries from the IIS-W3SVC-WP event source similar to following: The Module DLL 'C:\path\My64bit.dll' could not be loaded due to a configuration problem. The current configuration only supports...
Posting a Journal entry using the SAP Business One Connector returns error: 10000415 – Enter valid code.
Last Updated: July 4, 2022Symptom When you post a Journal entry using the SAP Business One Connector you may receive the following exception text in the response XML returned from the connector web service. 10000415 - Enter valid code Cause The error occurs when you post a journal entry where the Debit and Credit amounts do not equalise. Resolution...
SAP B1 – Business Partner address fails to update with error “This entry already exists in the following tables (ODBC -2035)”
Last Updated: June 21, 2023Symptom When you update both the Billing and Shipping addresses for a Business Partner, one of the addresses may fail to update. The following error returned is: This entry already exists in the following tables (ODBC -2035) Cause This is caused by attempting to update the same row twice. You can prevent this error by...
