SAP Business One Integration
SAP Business One Connector. Add or Update operation causes error: -8006 Resource error Login
Last Updated: June 28, 2022Symptom When you call onto the Add or Update operation within the SAP Business One Connector tool you may receive the following exception text in the response XML returned from the connector web service. -8006 Resource error Login Cause Calling onto an Add or Update operation within the tool causes a call to first be...
System requirements for implementing an Exchange to SAP integration solution
Last Updated: July 28, 2022Introduction An Exchange to SAP integration solution allows for created or modified mailbox objects in Exchange, such as calendar or contact entries, to be automatically created and maintained in SAP. The requirements for implementing this solution into your infrastructure are listed below:- Servers Note: The Exchange/SAP tools do not have to be installed locally to...
The recommended SQL structure to generate multiple child records
Last Updated: June 29, 2022The SAP Business One Integration tool has the ability to produce a structure from a flat database recordset known as ‘Recordset Shaping’. Provided below is an example of the recommended SQL structure to produce a recordset of the correct format. This is necessary to enable mapping of multiple child records to a single header simultaneously....
SAP Business One Integration Tool – Troubleshooting Guide
Last Updated: June 21, 2023GLOBAL CONFIGURATION ERRORS Creating a connection fails with error: An error has occurred while processing connection ‘CONNECTION_NAME’: Failed to Connect to DIAPI Server: SAP B1 Error Response – OBServerDLL.dll version is older than the DI API version (Error Code: -8003) Cause 1: This error occurs when there is a version mismatch between the SBOCommon database...
SAP Business One Integration Tool Pack v. SAP Business One Version
Last Updated: July 28, 2022Summary This following article shows which SAP Business One version is supported by which SAP Business One Integration Tool Pack. Note: The versions described here are taken from the SAP Business One Integration Tool Pack Release Notes, and are correct at the time of release. Supported Versions Matrix SAP Business One Integration Tool Pack Release...
TaskCentre SAP Integration Tool – Instructions and conversion process from old SAP connector tool
Last Updated: July 28, 2022The purpose of this knowledge base article is to apprise the reader of the topics listed below. How to download and install the new SAP Integration tool pack All versions of the SAP Integration tool pack can be found in the partner area of our website via Community -> Partner Area. Note: Access to this...
Using the SAP Business One Integration Tool Pack v3.0+ with SAP Business One Private Cloud and Microsoft SQL Server
Last Updated: August 3, 2022Introduction The SAP Business One Integration Tool Pack provides communication between SAP Business One and BPA Platform. It consists of: SAP Business One (DIAPI) Integration Agent SAP Business One (DIAPI) Integration Tool SAP Business One (SL) Integration Agent (v3.1 onwards) SAP Business One (SL) Integration Tool (v3.1 onwards) SAP Business One Event Agent (optional) SAP...
Using the SAP Business One Integration Tool Pack v3.0+ with SAP Private Cloud and HANA
Last Updated: July 29, 2022Introduction The SAP Business One Integration Tool Pack provides communication between SAP Business One and BPA Platform. It consists of: SAP Business One (DIAPI) Integration Agent SAP Business One (DIAPI) Integration Tool SAP Business One (SL) Integration Agent (v3.1 onwards) SAP Business One (SL) Integration Tool (v3.1 onwards) SAP Business One Event Agent (optional) SAP...
How to Connect to SAP HANA Database Using an OLEDB-ODBC Bridge
Last Updated: September 5, 2022This article provides guidance for using the Call Stored Procedure (OLEDB) tool to connect to a SAP Business One HANA database.
How to add a Purchase Delivery Note Through the SAP Business One Connector
Last Updated: June 21, 2023The following is assumed: You have the installed in TaskCentre, and connected to the SAP Business One server To add a Purchase Delivery Note through the SAP Business One Connector, do the following: Open the SAP Business One Connector task step. Go to the Mapping tab. Open the Purchase Delivery Note (OPDN) object, with an...
A task is failing at run time with the following error: “Could not load file or assembly”
Last Updated: June 29, 2022Symptom A task is failing at runtime and errors similar to the following are being produced: TIAPI: Type Information Error while loading tool assembly for step SAP Business One Connector. See Windows Event Viewer for more details. The Windows application log will display something similar to the following: Could not load file or assembly 'file:///C:\Program...
Running a SAP HANA stored procedure errors with: ‘Unterminated quoted identifier’
Last Updated: July 1, 2022Symptom Running a SAP HANA stored procedure produces the following error: .. [HDBODBC32] Syntax error or access violation; 257 sql syntax error: unterminated quoted identifier.. Cause The error occurs when SAP HANA identifiers are not enclosed in double quote (“) characters. The SAP HANA ODBC layer requires that procedures are identified with double quotes, and...
Unable to query a SAP HANA database: Driver error – 10808 [HODBC32] Feature (SCROLLABLE RESULT) not implemented yet
Last Updated: July 1, 2022Symptom Unable to query a SAP HANA database, the following error occurs: Driver error - 10808 [HODBC32] Feature (SCROLLABLE RESULT) not implemented yet Cause The SAP HANA ODBC layer does not support scrollable cursors. Resolution Go to the global configuration properties for the SAP HANA ODBC connection via: Manage -> Tools -> Input -> Database...
Getting Errors when Updating Documents in the SAP Client
Last Updated: August 3, 2022Symptom After installing the SAP Business One Event Agent to monitor a company database, you are now experiencing errors every time you attempt to update a document in the SAP client. This article describes how to resolve the above problem. Cause The database user assigned to the SAP Business One Event Agent (refer to the...
Failed to load company list from server – Error code: 8007007e
Last Updated: July 4, 2022Symptom Creating a connection fails with the error: Failed to load company list from server. Exception occurred retrieving the COM class factory for component with CLSID: {632F4591-AA62-4219-8FB6-22BCF5F60090} Failed due to the following error: 8007007e The specified module could not be found. Cause The error is specific to SAP Business One Integration Tool version 1.311 which...
OBServerDLL.dll version is older than the DI API version – Error code -8003
Last Updated: July 4, 2022Symptom Creating a connection fails with the error: An error has occurred while processing connection 'CONNECTION_NAME': Failed to Connect to DIAPI Server: SAP B1 Error Response - OBServerDLL.dll version is older than the DI API version (Error Code: -8003) Cause This error occurs when there is a version miss-match between the SBOCommon database and the...
Unable to initialise OBServerDLL.dll – Error code: -105
Last Updated: July 4, 2022Symptom Creating a connection fails with the error: An error has occurred while processing connection : Failed to Connect to DIAPI Server: SAP B1 Response – Unable to initialise OBServerDLL.dll (Error Code: -105) Cause The SAP licence server details setup within the tool are incorrect. Solution Check that both the license server host name and...
Date deviates from permissible range – Error code: -5002 10000047
Last Updated: July 4, 2022Symptom At task run time, the step fails with the error: Failed to Add SAP B1 Business Object (-5002): 10000047 - Date deviates from permissible range Cause This error occurs on A/R Invoice and A/P Invoice documents, and is caused by the due date on the document in a posting period being locked. (By default,...
Error code: 998 – An error occurred whilst processing the operation: Exception from HRESULT: 0xFFFFFB9E
Last Updated: July 4, 2022Symptom At task run time, the step fails with the error: Error code 998. An error occurred whilst processing the operation: Exception from HRESULT: 0xFFFFFB9E Cause The error occurs when the SAP DIAPI component is in an inconsistent state. Subsequent transactions against the same SAP business object while the component is in this state will...
Error whilst processing operation: You are not connected to a company
Last Updated: July 4, 2022Symptom At task run time, the step fails with the error: An error occurred whilst processing the operation: You are not connected to a company Cause The error occurs when the user setup under the ‘Authentication’ tab in the global connection setting, has no license assigned within SAP Business One, or the license has expired....
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...
SAP Business One connection error: Error 5-5 (- access is denied) connecting to the DI API
Last Updated: June 21, 2023Symptom When you create a new connection (or refresh the schemas on an existing connection) you receive the following error: Error 5-5 (- access is denied) connecting to the DI API. Cause The DI API is not updating a set of temporary files correctly. When a connection is created (or schemas refreshed) the TaskCentre tools...
SAP Business One connection error: Error 5-5 (- access is denied) connecting to the DI API
Last Updated: July 4, 2022Symptom When you create a new connection (or refresh the schemas on an existing connection) you receive the following error: Error 5-5 (- access is denied) connecting to the DI API. Cause The DI API is not updating a set of temporary files correctly. When a connection is created (or schemas refreshed) the TaskCentre tools...
SAP Business One connector tool – Error: “Failed to connect or logon to SLD”
Last Updated: June 21, 2023Symptom Within the global configuration of the , when attempting to configure a connection to a SAP B1 database the following error occurs: Failed to connect or logon to SLD Cause When configuring the connection, the use of ‘localhost’ instead of using the host name can cause a connection failure. Solution Within the Server and...
SAP Business One Connector Tool – ‘Unable to contact web service’
Last Updated: July 4, 2022Symptom When creating a new task with a SAP Business One Connector step, as soon as you try to choose the SAP Business One object an error occurs which displays Unable to contact web service As a result of this no objects or fields appear for mapping. Cause Issue occurs after upgrade from 3.0.1 to...
SAP Business One Connector tool – Error: -5002 10000156 Posting date deviates from the defined range.
Last Updated: June 21, 2023Symptom When posting orders within the SAP Business One connector tool the following error message is received: -5002 10000156 Posting Date deviates from the defined range. To complete the operation, define the posting period to match the entered Posting Date. Cause A new posting period has been created but the changes made have not been...
SAP Business One Connector Tool – Error: 10000008 – License does not exist
Last Updated: June 21, 2023Symptom A task using the SAP Business One Connector Tool is failing at runtime and producing the following error in the event logs: 100000008 - License does not exist Cause This error relates to the SAP DI Server Module not being licensed and not the TaskCentre SAP B1 Connector Tool. Solution You can check if...
SAP Business One Connector: Error when updating the ‘Quotation’ object
Last Updated: July 4, 2022Symptom When using the Quotation object to perform an Update operation, an error similar to the following is received: This entry already exists in the following table (ODBC -2035) Cause This is a known issue, specific to the Sales Quotation and Purchase Quotation objects. Solution Remove the files oQuotationsRequest.xslt and oQuotationsResponse.xslt from the folder: c:\inetpub\wwwroot\CommunicatorWS\Schemas\ServiceTranslation...
SAP Business One Event Tool – Error when trying to remove a company database
Last Updated: July 4, 2022Symptom Within the SAP Business One Event Tool configuration, when a database is selected for removal the following error is produced: Cannot open the database "[DATABASE NAME]" requested by the login. The login failed. Login failed for the user '[USERNAME]' Applies To SAP Business One Tools v5.1 SQL Server hosted database Cause The database has...
Sap Business One Event Tool : Error 0x80040154 setting up available objects
Last Updated: July 4, 2022Symptom Within the Sap Business One Event Tool and under the General tab, when you select from the Agent drop-down list you may receive the following error message: Error 0x80040154 setting up available objects You will also find under the Main tab of the tool that the Sap Business One Object and Operation drop-down lists...
SAP Business One installer fails with error: Error: -2147024891 connecting to TaskCentre server
Last Updated: June 21, 2023Symptom When trying to register the SAP B1 Agent with the TaskCentre Server, (from the tools for SAP B1 installer), it fails with the following error: Error: -2147024891 connecting to TaskCentre server Cause The Windows users account being used to run the tools for SAP B1 installer does not have sufficient permissions to the TaskCentre...
SAP connector tool step fails at task runtime with error: System.Exception: Failed to send request to Web Service
Last Updated: July 4, 2022Symptom The SAP connector tool step fails at task runtime and the following error is recorded to the TaskCentre event log: System.Exception: Failed to send request to Web Service at Tool.ToolRuntime.UploadCompressedRequest(String requestId) at Tool.ToolRuntime.SendRequest(XmlDocument requestXmlDoc, Boolean useMultipleTransactions, Boolean useOverrideXML) Cause The web service hasn’t been able to create the temp directory which is used when...
Selecting the SAP Business One ‘Installation Number’ causes the TaskCentre client to crash
Last Updated: July 4, 2022Symptom When configuring a new global connection; within the Connection Configuration window, selecting the SAP Business One Installation Number causes the TaskCentre client to crash. Cause C++ 2013 Redistributable is missing from the machine where the issue occurred. This can be confirmed by checking the ‘Add/Remove’ programs list within Control Panel. Resolution Install C++ 2013...
System.Bad Image Format Exception Could not load file or assembly ‘Codestone.Compression’
Last Updated: August 3, 2022Symptom When you click OK after adding a new connection in the SAP Business One Connector global configuration, you may get the following error message: System.BadImageFormatException Could not load file or assembly 'Codestone.Compression' Cause TaskCentre Tools for The SAP Business One is designed to run in a 32 bit application pool in IIS. It requires...
System.Exception: Tool not licensed. Invalid SAP Business One license count of 0 found
Last Updated: July 4, 2022Symptom At task runtime the DI server returns the following error message in the TaskCentre event log: System.Exception: Tool not licensed. Invalid SAP Business One license count of 0 found. Cause The SAP Business One details in the Connection Configuration are incorrect Applies To TaskCentre Tools for SAP Business One Resolution Ensure the SAP Business...
System.Invalid Operation Exception unrecognized attribute multipleSiteBindingsEnabled
Last Updated: July 4, 2022Symptom When you click ‘OK’ after adding a new connection in the SAP Business One Connector global configuration (or you refresh an existing connection) you may get the following error message: System.InvalidOperationException unrecognized attribute multipleSiteBindingsEnabled Cause The SAP Business One Connector web service does not expect an attribute named ‘multipleSiteBindingsEnabled’ to present resulting in the...
System.IO.DirectoryNotFoundException Could not find a part of the path
Last Updated: July 4, 2022Symptom The SAP Business One Connector tool fails at task runtime and the following error gets recorded in the Windows Event Log: System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\inetpub\wwwroot\CommunicatorWS\Temp\xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.gz' Cause Caused by a missing temp folder under the communicator web service’s publishing directory. Resolution Create a folder called ‘Temp’ under the communicator...
System.Net.WebException: The operation has timed out
Last Updated: July 4, 2022Symptom At task runtime, the SAP Business One Connector returns the following error in the Response Xml: Timeout Error System.Net.WebException: The operation has timed out Cause 1 The SAP DI server service has not started, or the service is running but not responding to requests. Solution 1 Restart the SAP DI server service. Note: After...
System.Runtime.InteropServices.COMException (0x80040154)
Last Updated: July 4, 2022Symptom When you click OK after adding a new connection in the SAP Business One Connector global configuration, you may get the following error message: System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {9DB232DC-50D6-4AAF-BA35-E510E16B2056} failed due to the following error: 80040154. Cause The application pool identity that the connector web service runs...
System.Web.Services.Protocols.SoapException: Retrieving the COM class factory for component with CLSID {F3D77DAE-6C14-B56F-426th-C550BDE8B09D} failed
Last Updated: July 4, 2022Symptom Within the TaskCentre event log the following Response XML is logged from the SAP B1 connector tool: System.Web.Services.Protocols.SoapException: Retrieving the COM class factory for component with CLSID {F3D77DAE-6C14-B56F-426th-C550BDE8B09D} failed due to the following error: 80070005 Access is denied. Cause The account that the Connector Web Service application pool runs under does not have sufficient...
Unable to create a new connection to a SAP Business One database – Error: Load library for observer failed
Last Updated: June 21, 2023Symptom Within the SAP Business One tools global configuration, you are unable to create a new connection to a company database. The following error message is received: Load library for observer failed. Observer file name: C:\Windows\Temp\SM_OBS_DLL\'881317'\ObserverDLL_881371.dll Cause The SM_OBS_DLL cache has become corrupt or inaccessible. Resolution This can be resolved by completing the following: Stop...
Unable to register the SAP Business One event agent with the TaskCentre server – Error: -214702489
Last Updated: July 4, 2022Symptom Modifying the SAP Business One tools from the ‘add/remove’ programs list to install the event agent, fails at the point of registering with the TaskCentre server. The following error message is received: -2147024891 (0x80070005) connecting to TaskCentre server Cause This message is a Windows access denied error message, preventing the install from completing. Resolution...
Unable to Register web Service Encryption for COM Interop
Last Updated: July 4, 2022Symptom During installation of the tools for SAP Business One you may receive the following error: Unable to Register web Service Encryption for COM Interop Note: Setup will still complete but the SAP Business One Event tool will not be available from within TaskCentre. Cause SAP Business One Tools for TaskCentre requires that .NET framework...
When you add lines to a Sales Order or Purchase Order, the SAP Connector updates the existing lines instead of adding new ones
Last Updated: June 21, 2023Symptom The SAP Business One Connector tool is configured to update the Sales Order or Purchase Order object, and the DocEntry is mapped to make it find the correct Order. However, when you add new lines it updates the existing lines instead of adding new ones Cause The default behaviour for the connector tool is...
You receive error:’ -1000 Property is invalid’ when you add data to a User defined Field (UDF)
Last Updated: July 4, 2022Symptom After adding a user defined field (UDF) in SAP Business One you may receive the following error when you add data to the field using the SAP Business One Connector tool: -1000 Property is invalid Cause The SAP Business One Data Integration Server (DI Server ) does not pick up newly added user defined...
SAP Business One Integration Tool Pack — Getting Error XML: “Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.”
Last Updated: August 3, 2022Summary You have the following installed: BPA Platform (formerly “TaskCentre”) v4.7 or above SAP Business One Integration Tool Pack v3.0, including the Integration Agent and the Event Agent Although the Event Agent is installed, it isn’t being used yet so the configuration is either incomplete or not started. SAP Business One using SQL Server (instead...
Why are my SAP Business One UDT, UDF, and UDOs not Triggering my Tasks?
Last Updated: June 21, 2023Summary Your BPA Platform solution makes use of the SAP Business One Integration Tool Pack, specifically, the SAP Business One Event Agent. You’ve added user-defined tables (UDT), user-defined fields (UDF), and/or user-defined objects (UDO) to your SAP Business One installation. You’ve created a task which triggers on the new tables, fields, or objects. Your tasks...
Why is my New Field in my Data Connector’s Object not Available for Linking?
Last Updated: July 4, 2022Summary You’re using a Data Connector tool to connect to an external application. You’ve updated one of the objects in the external application, but it isn’t showing in the tool’s Mapping tab. This affects the following tools: Applications Platform Connector Infor CRM Connector Microsoft Dynamics CRM Connector Microsoft Exchange Tool Pack Rollbase Connector Sage 50...
How to Install a Remote SAP Business One Event Agent
Last Updated: July 29, 2022Introduction The SAP Business One Integration Tool Pack provides communication between SAP Business One and BPA Platform. It consists of: SAP Business One Integration Agent SAP Business One Integration Tool SAP Business One Event Agent (optional) SAP Business One Event Tool For a detailed description of how to use the tool pack, refer to the...
