Troubleshooting
BPA Platform Licensing Troubleshooting Guide
Last Updated: August 31, 2022Introduction This article aims to assist with scenarios affecting the running of BPA Platform from a licensing perspective. It is worth noting the following: BPA Platform Editions – BPA Platform is usually supplied in standard form which can be identified by the ‘BPA Platform’ logos appearing upon install, login and within the main interface. BPA Platform can also be supplied as a...
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...
Cannot login to BPA Platform. Error: Module cannot be loaded 0x80090005
Last Updated: June 29, 2022Symptom When logging on with the BPA Platform client the following error occurs: Module cannot be loaded 0x80090005 Cause The fault occurs when the registry entries that cache the user’s password , ID1 and ID2 in HKEY_CURRENT_USER\Software\Orbis Software\BPA Platform, become corrupt and cannot be decrypted. Resolution Rename the entries which will cause them to be recreated, this will then...
Error Message: Unable to establish a connection to the Server. Please check the connection details and Server availability
Last Updated: June 29, 2022Symptom When you attempt to login to the BPA Platform client you receive the following error message: Unable to establish a connection to the Server. Please check the connection details and Server availability. Cause Multiple causes; the two most common being: The BPA Platform server service is not running The BPA Platform server service is...
Load Failure: The code expected does not match the one contained in the launcher
Last Updated: June 29, 2022Symptom When you launch the BPA Platform client it fails and the following error is produced: Load Failure: The code expected does not match the one contained in the launcher Cause This error can occur when an OEM uninstall did not remove all of the previous OEM data. This can lead to a mismatch of...
Missing Task Browser Window: Unable to access Task data
Last Updated: June 29, 2022Symptom From within task design the floating ‘task browser’ window has disappeared resulting in no access to the task data. Cause The most likely cause would be a change of desktop resolution. Solution Delete the following registry key to reset the state of the TaskCentre UI: HKEY_CURRENT_USER\Software\Orbis Software\TaskCentre\WindowStates The TaskCentre client must be closed before...
Run External Program step fails at task runtime with error 0x80070522 “A required privilege is not held by the client”
Last Updated: September 2, 2024Symptom When a task that uses impersonation contains a Run External Program step that runs a batch file it may fail at runtime with the following error: 0x80070522 “A required privilege is not held by the client” Cause Occurs where the impersonating account does not have sufficient rights to logon as a batch job. Resolution...
BPA Platform client exhibits delayed response times
Last Updated: June 29, 2022Symptom When you browse tools under the System node you may experience delayed response times. You may also experience delayed task initialisation. Cause The problem is confined to machines where no internet connection is available, and is caused by certificate revocation checking of digitally signed components failing to contact the certificate revocation list server. When...
The BPA Platform event log has to be deleted frequently due to reaching high capacity
Last Updated: August 31, 2022Symptom The BPA Platform event log increases in size very quickly and has to be deleted frequently. Cause One or a number of tool packs installed have extended logging turned on. When this mode is set, it records the inbound and outbound data to the BPA Platform event log, causing it to increase in size at...
An error has occurred while processing: Initialization Error details: Cannot decode the product key
Last Updated: June 29, 2022Symptom When you run the Configurator the following error message is received: An error has occurred while processing: Initialization Error details: Cannot decode the product key Cause Caused by an expired main product key license (You will also find that tasks cannot be run.) Resolution The resolution is to renew the main product key license....
Unable to open the BPA Platform configurator on the client machine: Error “Cannot retrieve the product key”
Last Updated: June 29, 2022Symptom Once the BPA Platform client has been installed onto a workstation, you are unable to open the configurator to complete any required configuration settings. The following error is displayed: An error has occurred while processing:Initialization Error details: Cannot retrieve the product key Note: This message will only be displayed when trying to launch the...
Configuring Impersonation – Allowing BPA Platform to access a remote network location such as a shared folder or printer
Last Updated: June 29, 2022When tasks run on the BPA Platform Server, by default they will run using an account called Local System. This account has a set of rights to perform various activities but generally does not have sufficient network permissions to allow access rights to tasks, this often results in tasks failing. The impersonation feature specifies how...
1625 – Installation error – This installation is forbidden by system policy
Last Updated: June 29, 2022Symptom When you install or update you may receive the following error: Error 1625: This installation is forbidden by system policy Cause You are not logged in as an administrator. A group policy is preventing you from installing the software. Resolution Ensure that the account you logged into the computer with is a member of...
Configurator: An error has occurred while processing:Initialization Error details: Access to the path … is denied.
Last Updated: June 29, 2022Symptom After upgrading to TaskCentre 4.6 SR1, attempting to start the Configurator results in the following error message (the path details may change): An error has occurred while processing:Initialization Error details: Access to the path ‘Global\_F34DAA94501B464A9EAE1A2CC546E55D’ is denied. Cause On some Windows Server 2008 machines, the Windows Installer files remain on out-of-date versions even after...
Error 1402. Could not open key: HKEY_LOCAL_MACHINE32
Last Updated: June 29, 2022Symptom When you apply apply hotfix 4.5SR 4F (Build 4.5.1198) you get the following error message: Error 1402. Could not open key: HKEY_LOCAL_MACHINE32\SOFTWARE\Wow6432Node\Orbis Software\TaskCentre\Providers\{Eaa826F- XXXXXXXX}. Verify that you have sufficient access to that key, or contact your support personnel. Cause Caused by an updated version of InstallShield introduced in Hotfix SR 4F (1198) that looks...
TaskCentre 4.5 SR 4 upgrade prompts for Windows Installer hotfix
Last Updated: June 29, 2022Symptom After running the TaskCentre 4.5 SR4 upgrade you may receive the following warning: The following Windows Installer hotfix may be required to successfully upgrade the current product installation: http://support.microsoft.com/kb/972397 Would you like to abort the installation and open the hotfix page? NOTE: This is a Microsoft hotfix for the Windows Installer; it is NOT...
An error has occurred while processing: Initialization Error details: Cannot decode the product key
Last Updated: July 5, 2022Symptom When you run the Configurator the following error message is received: An error has occurred while processing: Initialization Error details: Cannot decode the product key Cause Caused by an expired main product key license (You will also find that tasks cannot be run.) Resolution The resolution is to renew the main product key license....
BPA Platform Server service fails to start with error 0x80040e14
Last Updated: July 4, 2022Symptom The BPA Platform server service fails to start, the following error is received: 0x80040e14 Cause When the BPA Platform server service starts up it attempts to read various parameters from the SQL store. In this case the parameters are unable to be read due to a defective data structure. Applies To BPA Platform with...
BPA Platform Server services failing to start with error: Server Initialisation Failure – ErrorInformation 9/0x80070005
Last Updated: June 29, 2022Symptom Unable to start the BPA Platform Server service. Any attempt made to start the service fails and the following error is produced in the Windows error logs: Server Initialisation Failure - ErrorInformation 9/0x80070005 Cause The BPA Platform Server service has insufficient permissions to access certain local resources on the machine, i.e. files, registry keys,...
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...
Error 0x800700a4 Failed to connect to Task Runner CP for Task <TASK NAME >
Last Updated: August 3, 2022Symptom You may see the following error entry logged against the BPA Platform event log: Failed to connect to Task Runner CP for Task 0x800700a4 Cause 0x800700a4 is a Windows error which decodes to “No more threads can be created in the system.” Background Connection points (The ‘CP’ in the error message) are an integral...
No tasks are running and the TaskCentre event log shows error 0x80041349 “Error while processing event”
Last Updated: June 29, 2022Symptom Scheduled and triggered tasks are not running. An examination of the BPA Platform event log shows the following error: 0x80041349 “Error while processing event” Cause This occurs where the server license key has expired. Resolution Contact [email protected] to renew the server license key.
Task fails at runtime with error: Task initialisation failure, error code 0x80040300
Last Updated: June 29, 2022Symptom When a task contains many connection steps an initialisation failure can occur. The following system error is recorded to the event log: Error code: 0x80040300 Description: Task initialisation failure This can occur when the following types of connection steps are in use: Web Service Connector Database Query (ODBC or OLEDB) External Memory (ODBC or...
Task fails at runtime with the error: “System.UnauthorizedAccessException: Access to the registry key….is denied”
Last Updated: June 29, 2022Symptom A task is failing at runtime and is producing the following error message: System.UnauthorizedAccessException: Access to the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Orbis Software\TaskCentre\Providers\{B30672F2-176C-4F71-A35E-8C50A99BE230}\parameters’ is denied. Cause A “parameters” key that the task is expecting to be present is missing for the associated registry key: {B30672F2-176C-4F71-A35E-8C50A99BE230} Solution Manually add the missing parameter key within the registry at...
Task Run Failed, error code 0x8007007e
Last Updated: June 29, 2022Symptom Task failing at run time with the following error code: “Task Run Failed”, error code 0x8007007e Cause The fault mode occurs when the VBScript COM registration in the registry has been changed to point to a proprietary dll. This change is typically caused by Anti-Virus software as part of a ‘defence in depth’ approach....
Task Runtime Error: The connection used cannot be found in the global configuration
Last Updated: June 29, 2022Symptom At task runtime a step with a database connection fails with the following error message even though the connection is present in the global configuration: “The connection used can not be found in the global configuration” Solution Navigate to the TaskCentre registry key. On 32 bit systems: HKLM\SOFTWARE\Orbis Software\TaskCentre On 64 bit systems: HKLM\SOFTWARE\Wow6432Node\Orbis...
BPA Platform has stopped working, tasks are failing when queued to run
Last Updated: June 29, 2022Symptom All tasks are failing to run when they are queued, the BPA Platform event logs will display ‘initialisation failure’ error messages. Cause A likely cause would be that the license for your SQL Server Store has expired. This may mean that your 30 day evaluation period has finished or your purchased license has come...
KB39707 – TaskCentre 4.7 Hotfix resolving issues at runtime with images formatted using the Format as HTML tool
Last Updated: August 3, 2022Symptom Two separate issues are covered in this hotfix: Issue 1 At runtime, a task runner intermittently crashes when the task contains a Format as HTML step, itself containing an embedded image. Issue 2 A Send Message (SMTP) step consuming HTML output from a Format as HTML step, contains HTML with images attached in dynamic...
myBPAPlatform Graphics Not Displaying Correctly
Last Updated: July 12, 2022Introduction The article aims to explain how to ensure embedded graphics are displayed correctly in your myBPAPlatform workflow portal. Scenario After configuring myBPAPlatform, you see this when launching the web portal: Resolution Missing graphics in the web portal is caused by Static Content not being enabled for your web server. Do the following: From the...
Multiple 0x80040205 errors in TaskCentre event log from source: IWClTcp.ITCAPISession
Last Updated: July 1, 2022Symptom The TaskCentre event log shows multiple 0x80040205 errors. The source of the error is IWClTcp.ITCAPISession. Cause Normally when a task that contains a SQL trigger is deleted, the corresponding trigger is dropped from the table. In cases where the trigger does not get dropped the SQL Agent attempts to launch a task that is...
Required permissions to create SQL Server triggers, and have the triggers run a TaskCentre task
Last Updated: August 3, 2022Permissions to Create or Delete a trigger Before you can work with triggers from the Microsoft SQL Server Trigger tool, you must have the following permissions to create or delete the trigger: Action Required Permission Browse databases on the SQL instance from the Microsoft SQL Server Trigger tool Server level CONNECT SQL – Grants the...
SQL Instance Not Connectable
Last Updated: July 4, 2022Symptom Within the Configurator, the SQL Agent instance prerequisites screen displays the following error: SQL Instance Not Connectable The Configurator prompts for credentials but fails to clear the error, no matter what credentials are entered. Cause Both Shared Memory and TCP/IP must be enabled network protocols for the SQL server instance being connected to. Resolution...
SQL triggers not working. Error code 0x80037000
Last Updated: July 1, 2022Symptom Tasks triggered by the SQL trigger agent do not run and the BPA Platform event log records the following error code: 0x80037000 Cause This error occurs because by default versions of SQL Server starting with SQL Server 2005 provide a restricted set of features. Resolution The resolution is to enable OLE Automation by using...
Unable to run an SQL Server trigger: Database is modified but Task fails to trigger
Last Updated: July 1, 2022Symptom An SQL Server trigger has been created on a database table but when the table is modified the task is not triggered to run. The Windows Event Viewer log on the agent side will display the following error code stating that the task failed to queue: Error: 70000 Severity: 16 State: 1 Trigger on[Table...
Unable to run an SQL Server trigger: SQL Server blocked access to procedure ‘sys.sp_OACreate’ of component OLE Automation Procedures
Last Updated: July 1, 2022Symptom Unable to run an SQL Server trigger, the following error message is received: SQL Server blocked access to procedure ‘sys.sp_OACreate’ of component ‘Ole Automation Procedures’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Ole Automation Procedures’ by using sp_configure....
When configuring the Microsoft SQL Server Trigger Agent, OLE Automation is not detected
Last Updated: July 1, 2022Symptom Unable to configure the Microsoft SQL Server Trigger Agent from the TaskCentre Configurator tool as it does not detect the OLE Automation flag from the database. The Configurator log shows the following error: TCConfigurator.AddIns.SQLTriggerAddIn.SQLAgentHelper::IsOLEAutomationEnabled: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing aconnection to SQL Server. The server was not found or was...
Windows application event log shows Access Denied (-214724891) from Microsoft SQL Server Trigger Agent
Last Updated: July 1, 2022Symptom The Windows application event log shows Access Denied (-214724891) when firing a TaskCentre SQL agent trigger. This occurs when a trigger is fired using SQL Server 2005 or higher. The following error is logged to the Windows Event Log and SQL Logs: Error: 70000 Severity: 16 State: 1 Trigger on “<TABLE NAME>” failed to...
Oracle Trigger Agent – Bad version number in class file
Last Updated: July 1, 2022Symptom When you install the TaskCentre Oracle Agent on a Windows system you may see the following exception: Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in class file. On UNIX and Linux systems this shows as: Exception in thread "main" java.lang.ClassFormatError: TCInstallerMain (unrecognized class file version) Cause The version of java installed is incompatible...
Configuring the SMTP Virtual Server for the Email Trigger (SMTP) Agent
Last Updated: August 3, 2022Introduction In order for the Email Trigger (SMTP) Agent to receive incoming emails, the SMTP Virtual Server (available as part of IIS version 6.0) must be installed. Unfortunately, later versions of IIS (from Windows Server 2008 onwards) do not have SMTP functionality as standard. But they do allow IIS 6.0 to be installed and used...
Email attachments – An event was unable to invoke any of the subscribers 0x80040201
Last Updated: July 1, 2022Symptom When using a variable to save email attachments the following error is produced: An event was unable to invoke any of the subscribers 0x80040201 Cause There are two separate causes: The attachment file size is zero bytes, this normally indicates a blank file. The data file variable has not been setup as an Array...
Call COM tool fails at design time with error: The operation failed 0x8002802b
Last Updated: July 1, 2022Symptom You have a .NET assembly that you are calling from COM. From within the Call COM action you can view and select the object, but when you save the object it fails with the following error: The Operation failed 0x8002802b Cause The Call COM tool was not accepting types generated from a COM callable...
Run VB Script step fails at task runtime with error 0x800a01ad
Last Updated: July 1, 2022Symptom When using the CreateObject method in the Run VB Script step you receive the error: 0x800a01ad - Error while evaluating expression: ActiveX component can't create object: 'GetObject' You may also see a companion entry in the TaskCentre event log: 0x80070005 - The script requested a disallowed object Cause Caused by the task owner not...
Select Publishing Site drop down list not populated when you select a remote web server
Last Updated: July 1, 2022Symptom After you select a remote web server under the Publishing tab of the Create Workflow Job tool, the Select Publishing Site drop-down list does not get populated. Cause The user has insufficient rights to access IIS objects on the remote machine. The Create Workflow Job tool connects to the IIS objects on the web...
System.Bad Image Format Exception Could not load file or assembly “Interop.iwwfeaLib”
Last Updated: July 1, 2022Symptom You may receive the exception text “System.BadImageFormatException” in the component “iwwfeaLib” Cause Caused by loading the 64 bit workflow components into a 32 bit web application pool. Resolution Within IIS 7 under the Advanced properties for the application pool that workflow is running under, ensure the the ‘Enable 32-bit Applications’ property set to ‘False’.
System.Unauthorized Access Exception: Retrieving the COM class factory for component with CLSID failed
Last Updated: July 1, 2022Symptom After opening a workflow job through the web browser you may get the following exception page. System.UnauthorizedAccessException: Retrieving the COM class factory for component with CLSID {B5DF154A-A87D-4858-8B32-9F60B3E62B65} failed due to the following error: 80070005 Cause The account that the web site application pool runs under does not have sufficient permissions to call onto Workflow...
Format As HTML tool: Can not launch the HTML editor as there is no registered application for this feature
Last Updated: July 8, 2022Symptom Unable to load the HTML editor within the Format As HTML tool. Selecting the Edit button causes the following error to occur: Can not launch HTML editor as there is no registered application for the feature Cause The default editor has been set to an incompatible application or has not been set at all....
Getting “Aggregation unsupported for type: System.String”
Last Updated: August 3, 2022Introduction This article guides you through the necessary steps to aggregate string columns. Scenario You’ve created a task where the Format as HTML Pro is consuming the recordset outputted by a Convert XML to Recordset step. In the Format as HTML Pro step, you are creating either sub- or grand totals or both, yet when...
Unable to import XML schema – Error ‘no type has been selected for the scheme element’
Last Updated: July 1, 2022Symptom Unable to import an XML schema into the output step of an MMO (Multi Message Operation) during the creation of a web service connector task. The following error is displayed: no type has been selected for the scheme element Cause BPA Platform does not support a schema which contains attributes. Resolution When defining MMO...
Web service connection fails with the error: “The underlying connection was closed: An unexpected error occurred on a send”
Last Updated: July 1, 2022Symptom A task using the Web Service Connector Tool to make a secure call is failing at runtime with the following error; this also occurs if the web service connection is tested via the connector tool global configuration. iwwshr.Exceptions.WebServiceCallFailedException: The underlying connection was closed: An unexpected error occurred on a send. Cause The connection is...
‘Select Publishing Site’ drop-down list does not display a list of websites
Last Updated: July 1, 2022Symptom Under the ‘Publishing’ tab of the ‘Create Workflow Job’ tool, the ‘Select Publishing Site’ drop-down list does not display a list of websites. Cause Caused by Windows User Account Control (UAC) preventing access to the Windows Management Instrumentation (WMI) interfaces from the BPA Platform client. You are more likely to experience this issue on...
Letters with accents display a black diamond symbol
Last Updated: February 14, 2023Symptom When writing text to a web service which includes special characters, for example letters with accents above them, the characters are replaced with the symbol; Example: Text containing the German word “Für” will appear as “Fr” Cause The special characters used are unknown to the encoding and fall outside of the ASCII character set...
Magento update fails with: System.ServiceModel.Fault Exception The image is not specified
Last Updated: August 3, 2022Symptom Note: This particular exception is specific to the Magento SOAP service. Unable to upload images when using the Magento API web service in conjunction with the Web Service Connector tool. The following error is received: System.ServiceModel.Fault Exception The image is not specified Solution Please refer to the following knowledgebase article which provides instructions on...
Passing ‘&’ or ‘<' to a SOAP operation causes error: System.Xml.XmlException
Last Updated: July 1, 2022Symptom Calling an operation on a SOAP web service fails with the following error: System.Xml.XmlException Cause Caused by passing either the ampersand ( & ) or less than ( < ) character to an operation that takes a parameter. When the error occurs, any of the following exceptions will be raised: System.Xml.XmlException: An error occurred...
Solution to ReadpickLists schema problem with the SalesLogix System web service 7.5.4
Last Updated: July 1, 2022Summary The TaskCentre Web Service Connector tool relies on web service descriptions received from the web services. There are some known problems with the SalesLogix version 7.5.4 SDATA web service schemas. In these cases the web service operation schema needs to be manually altered to work around the misleading description. Prerequisites TaskCentre has to be...
Client crash when defining the operation of a Web Service Connector step with Web Service Connector Tool Pack Release 1.0 Service Release 1
Last Updated: July 1, 2022Symptom Upon defining the “Operation” of a step in the Web Service Connector, the BPA Platform client crashes. This is due to the tool trying to create a schema.txt file to the C:\ directory and the active user does not have permission to write to C:\. Resolution Give the user administrative permissions to write to...
When you click the Edit button in the Format As HTML step nothing happens
Last Updated: July 1, 2022Symptom When you click the Edit button in the Format As HTML step nothing happens. Cause No Default HTML editor is defined. Resolution Within Internet Explorer set the default HTML editor under the Programs tab of Internet Options.
DTL Elements marked as “Don’t Create Element” appear in the outgoing SOAP envelope
Last Updated: August 3, 2022Symptom Using the Transwise web service and the doBooking operation, DTL elements marked as Don’t Create Element appear in the outgoing SOAP envelope. The web service returns the following error: Attribute 'http://www.w3.org/2001/XMLSchema-instance,nil' must not appear on element 'deliveryNoteInfo', because the {nillable} property of 'deliveryNoteInfo' is false Using a web proxy, such as Fiddler, to review...
Tasks with Run Microsoft Word (Merge) steps are failing to run – Error – “Word cannot initialise”
Last Updated: July 1, 2022Symptom An automated task containing a Run Microsoft Word (Merge) step is failing to run at the scheduled runtime. However, if the task is run manually then it executes as normal. The following error may appear in the TaskCentre event log: Word cannot initialise Cause This is linked to an issue caused by the disconnect...
Crystal Report error: Logon failed for table
Last Updated: July 1, 2022Symptom The Run Crystal Report step fails at task runtime with the following error message: Logon failed for table” even though the logon details are correct You may also see the following related error codes within the TaskCentre event log. 0x80040e41 0x800403f1 0x80020009 Cause Occurs where the logon details for the report contains a long...
Task with Run Crystal Report step fails at runtime. The BPA Platform event log shows error code: 0x80020009
Last Updated: July 1, 2022Symptom A task with a Run Crystal Report step fails at runtime. The BPA Platform event log shows the following error code: 0x80020009 Cause This is a network print share permissions issue that can occur when printing Crystal Reports from a task environment. Resolution Note: Before applying the resolution you should first ensure that the...
Troubleshooting guide for the Run Crystal Report tool
Last Updated: August 3, 2022Summary This article is intended to be used as a troubleshooting guide for errors that arise from the use of the Run Crystal Report tool in a task. Error returned from Crystal Reports – (0x80020009) Cause 1: A parameter required by the report has not been mapped within the Run Crystal Report tool. Solution 1:...
MS Reporting Services Report tool only processing one record in a recordset
Last Updated: July 1, 2022Symptom The MS Reporting Services Report step is only producing one report even though a recordset with multiple rows has been passed. Cause A ‘Looping’ function has not been used. This function tells the report tool to generate a report for each row of a recordset, after a row has been processed and a report...
Run Microsoft Reporting Services Tool – Fails with “ExecutionNotFoundException” at task runtime
Last Updated: July 1, 2022Symptom Unable to save a Microsoft Reporting Services Report when using a ‘Save File’ step. The following error occurs: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: The report execution gwp42y55mesyqzb4accp3pur has expired or cannot be found Cause Using Windows Integrated Authentication where the Report Server is not local to the TaskCentre server host. Note: Setting task impersonation will not make the...
Filter Data: RowsProcessed property does not reflect the number of filtered rows.
Last Updated: August 3, 2022Symptom The Filter Data step’s RowsProcessed property does not reflect the number of filtered rows. Please follow the below link for a similar symptom encountered with the RowCount property of the Database Query: Database Query RowCount Property Cause Many ODBC drivers and OLEDB provider do not return a row count to the task environment. Instead,...
Call Stored Procedure step fails at task runtime with error 0x80040e21
Last Updated: July 1, 2022Symptom When a task contains a Call Stored Procedure step that accepts parameter values, it may fail at runtime with the following error: 0x80040e21 Cause Occurs when the parameter value can’t be converted into the specified data type. For example, if a stored procedure requires a parameter type of DBTIMESTAMP and you pass it a...
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...
Updating oracle stored procedure with > 32 KB fails with ‘the operation failed 0x80040e14’
Last Updated: July 1, 2022Symptom Updating an Oracle stored procedure using the Call Stored Procedure (OLEDB) tool returns the following error code: the operation failed 0x80040e14 Cause The underlying error is ‘ORA-01460: unimplemented or unreasonable conversion requested’. This is caused by binding more than 32KB data to a stored procedure parameter when using the Oracle OLEDB Provider. Resolution Add...
Database Query: RowCount property not reflecting the amount of rows produced by a recordset
Last Updated: August 3, 2022Symptom The Database query step’s RowCount property does not reflect the number of rows returned by the query. It may contain a value such as -1, or 0 (zero) in place of the expected number of rows. Please follow the below link for a similar symptom encountered with the RowsProcessed property of the Filter Data:...
Global ODBC connection test fails with error 0x80040154
Last Updated: July 4, 2022Symptom When you click the Test button after creating an ODBC connection it fails with the following error code: 0x80040154 Cause Caused by the Microsoft Data Access objects not being registered. Resolution Register the dao350 and dao360 dlls found in C:\Program Files\Common Files\Microsoft Shared\DAO\ with the RegSvr32 utility.
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...
Creating a formula field within the OLEDB query tool fails with error 0x80070582
Last Updated: July 4, 2022Symptom When you create a new formula field within the OLEDB query tool you may see the following error: 0x80070582 Cause Caused by having multiple tasks with OLEDB query tool opened and editing the same formula field. Background 0x80070582 is a Windows error code meaning “Class already exists”. In the context of this issue the...
TaskCentre Server installation fails with the error: Failed to load and use iwinstall.dll
Last Updated: July 1, 2022Symptom Unable to install the TaskCentre Server, the following error message is received when an install is attempted: Failed to load and use iwinstall.dll, caused by missing .net 2.0 or higher Cause This only affects the installer, it requires .Net 2.0 framework to be present. The TaskCentre Server will still function as normal if later...
Creating a Global OLEDB Connection – Server name length restriction
Last Updated: July 4, 2022Symptom When creating a new Database Query (OLEDB) global connection and selecting a server from the drop down list the interface restricts the display of the server name to no more than 20 characters. This can make instances with particularly long names difficult to identify. Solution When creating the connection and within the Available OLEDB...
Import Flat File tool – Locks a file for the duration of a task run preventing it from being moved by the File Management Tool
Last Updated: July 1, 2022Symptom When importing a file using the Import Flat File tool and attempting to move it using the File Management tool, an error message is received advising the file is in use. An example of an error message would be: The specified file [FILE PATH] is in use Where FILEPATH is the location of the...
Task failing at runtime with the error: Failed to print document 0x80070bc4
Last Updated: July 1, 2022Symptom A task using a Print Document step fails at runtime with the following error: Failed to print document 0x80070bc4 Cause The code 0x80070bc4 is a Windows error code meaning “No printers were found”. The most likely cause being that the printers are deployed via a group policy, whereby the printers only get created when...
Configuring TaskCentre to use a Gmail SMTP account: Error – The message received was unexpected or badly formatted
Last Updated: July 1, 2022Symptom When configuring a Send Email (SMTP) global connection to use a Gmail SMTP account, the following error is received when attempting to test the connection: SMTP server connection test failed: The message received was unexpected or badly formatted Cause RC4 based cipher suites in use by TaskCentre are no longer supported by ‘smtp.gmail.com’. Note: This issue has been caused by a...
Office 365 – Email sending limit prevents TaskCentre from sending more than 30 emails per minute. Error: 4.4.2 Message Submission Rate
Last Updated: July 1, 2022Symptom With Office 365 as your mail server a cap of 30 emails per minute is introduced. If a task is producing a high volume of emails that exceeds this limitation then the following error will occur: 4.4.2 Message submission rate for this client has exceeded the configured limit Solution Slow down the rate at...
Selecting the Secure SMTP option in the SMTP global config causes task to fail with error: TLS Session Negotiation Failed. Connection Aborted
Last Updated: July 1, 2022Symptom When you configure the Global SMTP Configuration within TaskCentre (Tools > Output > Send Email (SMTP)) to use the Secure SMTP option, you may receive the following error message at task run time: TLS Session Negotiation Failed. Connection Aborted Cause This is caused by entering the IP address of the SMTP server instead of...
Send Email (SMTP) output giving “?” signs
Last Updated: August 3, 2022Symptom The output from a Send Email (SMTP) step contains question marks (?) signs in place of certain characters, for example, currency symbols (£). Cause The email contains characters that are being incorrectly interpreted. Resolution You must declare the character set (charset) that BPA Platform references: Upgrade to the latest version of BPA Platform. Recreate...
Unable to send email through Office 365 hosted facilities. Error: TLS Session Negotiation Failed. Connection Aborted
Last Updated: August 3, 2022Symptom A connection to Office 365 has been created using the Send Email (SMTP) global configuration but at task runtime the following error appears in the event log: TLS Session Negotiation Failed. Connection Aborted If you attempt to test the connection the following message is received: SMTP server connection test failed: Connection has been lost Cause This issue...
TaskCentre Server installation fails with the error: Failed to load and use iwinstall.dll
Last Updated: July 1, 2022Symptom Unable to install the TaskCentre Server, the following error message is received when an install is attempted: Failed to load and use iwinstall.dll, caused by missing .net 2.0 or higher Cause This only affects the installer, it requires .Net 2.0 framework to be present. The TaskCentre Server will still function as normal if later...
Exchange Agent: Error when creating a new subscription – ID is malformed
Last Updated: July 1, 2022Symptom Unable to create a new exchange subscription when using the stored procedure Subscribe, the following error is received: Creating subscription for email [EMAIL ADDRESS] based on the requested subscription 15 has failed 3 times. Agent will not attempt to create it until it is restarted. - Id is malformed Cause This is caused by...
MS Dynamics CRM Connector tool: Global configuration – Unable to connect with Microsoft Dynamics CRM
Last Updated: July 1, 2022Symptom Within the global configuration of the Microsoft Dynamics CRM Connector tool, when trying to create a new connection to a Microsoft Dynamics CRM platform an error similar to the following is received: System.ArgumentException: The selected Deployment Type does not match the available endpoint or System.ServiceModel.Security.SecurityAccessDeniedException: Access is denied Cause The account being used in...
Sage 200 Connector Tool – Error: Could not load file or assembly
Last Updated: July 1, 2022Symptom When creating a connection to Sage 200 using the Sage 200 connector tool global configuration, an error message similar to the following: Could not load file or assembly Sage.Accounting.Financials, Version = 16.0.0.0 The error format being: Could not load file or assembly [NAME], [VERSION] Where NAME is a Sage assembly and VERSION is the...
Sage 200 Connector: Error – The type initializer for ‘Sage.Accounting.Application’ threw an exception
Last Updated: July 1, 2022Symptom At runtime the task fails with the following error shown in the event log: The type initializer for 'Sage.Accounting.Application' threw an exception Enable Use Extended Logging within the Sage 200 Connector tool global settings: With extended logging now on, run the failed task again and check the event log. You may receive the following:...
SAGE 50 Accounts 2012 – ODBC query fails with “DAO error column not found ODBC — call failed”
Last Updated: July 1, 2022Symptom When you query data within the Database Query (ODBC) tool you may receive the following error: DAO error column not found ODBC -- call failed Cause The error is due to changes that have been made to the “Sage 50 v18 ODBC driver” in Sage 50 Accounts 2012 update 3. The change causes queries...
Salesforce Connector tool – Error validating source XML against schema
Last Updated: July 1, 2022Symptom When validating source XML against the schema, the following error message is received: The element 'ELEMENT_NAME' has invalid child element 'ELEMENT_NAME' Cause This error occurs after a user defined field (UDF) is created in Salesforce, this change is published to the . Resolution Any change made to the Salesforce API is a breaking change...
Creating a schema in the SalesLogix Connector global config gives the error: System.Data.OleDb.OleDbException (0x80004005)
Last Updated: July 1, 2022Note: The SalesLogix Connector Tool is now known as the Infor CRM Connector Tool. Symptom Creating a schema in the SalesLogix Connector produces the error code: System.Data.OleDb.OleDbException (0x80004005) Cause The account for the SLXConnectorWS website application pool, does not have sufficient permissions on to the SalesLogix OLEDBlayer. Resolution Using IIS Manager set the application pool...
SalesLogix Connector step fails at task runtime with error “Could not find file C:WindowsTEMPxxxxxxxx.dll”
Last Updated: July 1, 2022Note: The SalesLogix Connector Tool is now known as the Infor CRM Connector Tool. Symptom When you call an operation in the SalesLogix Connector step it fails with the following error message: Could not find file 'C:\Windows\TEMP\xxxxxxxx.dll' Cause When the SalesLogix Connector communicates with the SalesLogix Connector web service, the web service attempts to create...
SalesLogix Connector step fails at task runtime with the error – Could not find ‘C:|iwtemp\xxxxxxxxx.dll’
Last Updated: July 1, 2022Note: The SalesLogix Connector Tool is now known as the Infor CRM Connector Tool. Symptom The SalesLogixConnector step fails at task runtime with the following error appearing in the event log: Could not find file 'C:\iwemp\xxxxxxxxx.dll' Cause The SLX tools add the following XML to the iwtskrun.config file in the TaskCentre installation directory: <system.xml.serialization> <xmlSerializer...
System.BadImageFormatException Could not load file or assembly ‘SLXConnectorWS’
Last Updated: July 1, 2022Note: The SalesLogix Connector Tool is now known as the Infor CRM Connector Tool. Symptom You may receive the exception text: System.BadImageFormatException Could not load file or assembly ‘SLXConnectorWS’ or one of its dependencies. An attempt was made to load a program with an incorrect format. Cause Caused by loading the 32 bit SLX Connector...
System.Data.OleDb.OleDbException Unable to initialize data dictionary. Invalid object name ‘SYSTEMINFO’
Last Updated: July 1, 2022Note: The SalesLogix Connector Tool is now known as the Infor CRM Connector Tool. Symptom When you refresh schemas in the SLX connector schemas you may get the following exception: System.Web.Services.Protocols.SoapException: System.Data.OleDb.OleDbException: Unable to initialize data dictionary. Invalid object name 'SYSTEMINFO' Cause The error “Unable to initialize data dictionary. Invalid object name ‘SYSTEMINFO'” is returned...
System.Data.OleDb.OleDbException: No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80004E4D)
Last Updated: July 1, 2022Note: The SalesLogix Connector Tool is now known as the Infor CRM Connector Tool Symptom Within the SalesLogix Connector Tool configuration when you add or update a connection configuration and then refresh the schemas, you may get the following error message. System.Data.OleDb.OleDbException: No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80004E4D) Cause The username and password details...
System.Data.OleDb.OleDbException: No error message available, result code: E_UNEXPECTED(0x8000FFFF)
Last Updated: July 1, 2022Note: The SalesLogix Connector Tool is now known as the Infor CRM Connector Tool. Symptom Within the SalesLogix Connector Tool when you add or update a connection configuration and then refresh the schemas, you may get the following error message: System.Data.OleDb.OleDbException: No error message available, result code: E_UNEXPECTED(0x8000FFFF) Cause Caused by entering an incorrect Server...
Task fails at runtime with the error: “System.UnauthorizedAccessException: Access to the registry key….is denied”
Last Updated: July 4, 2022Symptom A task is failing at runtime and is producing the following error message: System.UnauthorizedAccessException: Access to the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Orbis Software\TaskCentre\Providers\{B30672F2-176C-4F71-A35E-8C50A99BE230}\parameters’ is denied. Cause A “parameters” key that the task is expecting to be present is missing for the associated registry key: {B30672F2-176C-4F71-A35E-8C50A99BE230} Solution Manually add the missing parameter key within the registry at...
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...
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...
Failed to connect or logon to SLD – Error code: -8037
Last Updated: July 4, 2022Symptom Creating a connection fails with the error: Failed to Connect to DIAPI Server: SAP B1 Error Response - Failed to connect or logon to SLD, please check connection parameters and configure file (Error Code: -8037) Cause The ‘Backend Server Name’ (found under the ‘Database’ tab), has been entered as ‘localhost’. Resolution Use the database...
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.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...
Sage 300 Connector Tool — OrderUniquifier Generating Errors
Last Updated: August 3, 2022Summary You have created a task where the OrderUniquifier object should be auto-generated for Add operations. It is not, and the value seems to be truncated. You are also seeing an error similar to: Exception occurred during processing of GetByKey Sage 300 object (OEORD): The value specified for 'OrderUniquifier' could not be converted to Decimal:...
Run Sage 50 / 200 Report Tool v1.4 — Getting “No supported Sage 200 product found or incorrect login details”
Last Updated: July 4, 2022Introduction Tasks with the Run Sage 50 / 200 Report tool, connected to Sage 200c (2017 or 2018), are failing. In the Event Log, you are seeing “No supported Sage 200 product found or incorrect login details”. However, the connection to Sage 200 is valid, as are the login credentials used. Cause Due to the...
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...
Web Service Connector Tool is Unable to Generate the XML Document
Last Updated: August 3, 2022Summary When using the Web Service Connector tool, you see “An exception was raised” errors in the Event Log for the task step. This article describes the symptoms and how to resolve the problem Cause The types of errors you see are: and: with the task step failing to generate. This is typically caused by...
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...
TaskCentre Server services failing to start with error: Server Initialisation Failure – ErrorInformation 9/0x80070005
Last Updated: July 4, 2022Symptom Unable to start the TaskCentre Server service. Any attempt made to start the service fails and the following error is produced in the Windows error logs: Server Initialisation Failure - ErrorInformation 9/0x80070005 Cause The TaskCentre Server service has insufficient permissions to access certain local resources on the machine, i.e. files, registry keys, communication components....
TaskCentre Server service fails to start with error 0x80040e14
Last Updated: July 4, 2022Symptom The TaskCentre server service fails to start, the following error is received: 0x80040e14 Cause When the TaskCentre server service starts up it attempts to read various parameters from the SQL store. In this case the parameters are unable to be read due to a defective data structure. Applies To TaskCentre with SQL server hosted...
TaskCentre API Web Service Install Problem IIS Version 8
Last Updated: July 4, 2022Symptom When attempting to install the TaskCentre API Web Service the following is received: The wizard was interrupted before the Task API could be completely installed Figure 1. Task API installation wizard. Cause This is the result of an Application Pool default setting in IIS Version 8 that must be changed. Solution Within IIS check if any TCAPI Application Pools...
Automating EU VAT Registration Number Validation (VIES)
Last Updated: July 4, 2022Normally when trading business to business you do not charge VAT on supplies made to your customers. If you trade with companies within the EU then similarly you do not normally charge VAT. But if the company you trade with is not registered for VAT then you must charge VAT. Fortunately the EU provide an...
Locked solutions ODBC Memory works at runtime but shows error at design time
Last Updated: September 28, 2022ODBC Memory events in a task that have been exported from the original task creation machine are functioning correctly at runtime however, at design time an error is displayed. This article provides details about the issue and how it can be resolved: Cause This issue is caused by the export from the original task creation...
Valid certificate .pfx file password rejected by Web Service Connector Tool
Last Updated: November 2, 2022The Web Service Connector tool rejects valid certificate password.
