Transform Data Tool
- Installing Tool Packs
- Installation and Upgrade
- Creating a Demonstration System
- Migrating TaskCentre: Merging repositories from one TaskCentre install into another
- Permissions required in SQL Server to create and maintain a BPA Platform SQL store
- BPA Platform Licensing Troubleshooting Guide
- How to rebuild the BPA Platform internal store
- Enabling and Disabling Tasks Remotely using the BPA Platform API
- Execute a task from within another task using the TaskCentre API
- SAP Business One Connector. Add or Update operation causes error: -8006 Resource error Login
- Extract an email attachment and save to a location
- Forward Mail to the Email Trigger (SMTP) Agent – Exchange 2016
- VB Script for encoding file contents into Base64 Encoded (for use in conjunction with the Web Service Connector Tool)
- dotMailer – Removing a Contact
- Using eBay web services with the Web Service Connector Tool
- Using eBay web services with the Web Service Connector Tool (user token screenshots)
- Using Magento Web Services with the Web Service Connector Tool
- Using ParcelForce expressLink API web service with the Web Service Connector Tool
- Using Shopify Web Services with the Web Service Connector Tool
- Mozenda
- SurveyGizmo
- Using UPS Web Services with the Web Service Connector Tool
- Volusion
- Using Zendesk Web Service with the Web Service Connector Tool
- Configuring the Web Service Connector Tool to work with a proxy server
- Web Service Connector tool – How to map a Constant to a HTTP header
- Web Service Connector Tool – Using Basic Authentication to connect to a web service
- Accessing a workflow job from outside an internal LAN
- DCOM permissions required for running a Run Microsoft Word (Merge) step
- Running BPA Platform 2018 or 2018 Update 1 with Crystal Reports Runtime 13.0.21 or above
- Expanding Convert XML to Recordset functionality using the Data Transformation Component (DTC)
- How to run a SAP HANA database stored procedure using TaskCentre
- Integrating with Microsoft Exchange on Premises or 365
- Microsoft Exchange Connector Tool – Creating a global connection to Exchange
- Microsoft Exchange Connector Tool – Retrieving attachments in calendar items
- Microsoft Exchange Connector Tool – Find operation examples
- System requirements for implementing an Exchange to SAP integration solution
- SalesLogix – Delete account operations on SData created accounts
- The recommended SQL structure to generate multiple child records
- SAP Business One Integration Tool – Troubleshooting Guide
- SAP Business One Integration Tool Pack v. SAP Business One Version
- TaskCentre SAP Integration Tool – Instructions and conversion process from old SAP connector tool
- Using HTTPS Connections with the Sage 300 Connector
- Using HTTPS Connections with the Sage 50 Accounts Connector v2.5
- Using HTTPS with the Task API Web Service 1.0
- Using the SAP Business One Integration Tool Pack v3.0+ with SAP Business One Private Cloud and Microsoft SQL Server
- Using the SAP Business One Integration Tool Pack v3.0+ with SAP Private Cloud and HANA
- How to monitor encrypted HTTP sessions from a web proxy
- How to process XML with Elements with the Same Name
- How to use a web proxy to view HTTP traffic through the TaskCentre Web Service Connector
- How to populate an HTML drop-down form input with dynamic values in the Workflow Job Trigger Tool
- How to send multiple emails using a TaskCentre recordset column
- TaskCentre Exchange Agent – How to create a subscription to monitor a mailbox
- How to Connect to SAP HANA Database Using an OLEDB-ODBC Bridge
- How to export your BPA Platform Tasks
- How to add a Purchase Delivery Note Through the SAP Business One Connector
- How to configure the Web Service Connector Tool for RSS feeds
- Cannot login to BPA Platform. Error: Module cannot be loaded 0x80090005
- Error Message: Unable to establish a connection to the Server. Please check the connection details and Server availability
- Load Failure: The code expected does not match the one contained in the launcher
- Missing Task Browser Window: Unable to access Task data
- Run External Program step fails at task runtime with error 0x80070522 “A required privilege is not held by the client”
- BPA Platform client exhibits delayed response times
- The BPA Platform event log has to be deleted frequently due to reaching high capacity
- An error has occurred while processing: Initialization Error details: Cannot decode the product key
- Unable to open the BPA Platform configurator on the client machine: Error “Cannot retrieve the product key”
- Configuring Impersonation – Allowing BPA Platform to access a remote network location such as a shared folder or printer
- 1625 – Installation error – This installation is forbidden by system policy
- Configurator: An error has occurred while processing:Initialization Error details: Access to the path … is denied.
- Error 1402. Could not open key: HKEY_LOCAL_MACHINE32
- TaskCentre 4.5 SR 4 upgrade prompts for Windows Installer hotfix
- An error has occurred while processing: Initialization Error details: Cannot decode the product key
- BPA Platform Server service fails to start with error 0x80040e14
- BPA Platform Server services failing to start with error: Server Initialisation Failure – ErrorInformation 9/0x80070005
- A task is failing at run time with the following error: “Could not load file or assembly”
- Error 0x800700a4 Failed to connect to Task Runner CP for Task <TASK NAME >
- No tasks are running and the TaskCentre event log shows error 0x80041349 “Error while processing event”
- Task fails at runtime with error: Task initialisation failure, error code 0x80040300
- Task fails at runtime with the error: “System.UnauthorizedAccessException: Access to the registry key….is denied”
- Task Run Failed, error code 0x8007007e
- Task Runtime Error: The connection used cannot be found in the global configuration
- BPA Platform has stopped working, tasks are failing when queued to run
- KB39707 – TaskCentre 4.7 Hotfix resolving issues at runtime with images formatted using the Format as HTML tool
- myBPAPlatform Graphics Not Displaying Correctly
- Multiple 0x80040205 errors in TaskCentre event log from source: IWClTcp.ITCAPISession
- Required permissions to create SQL Server triggers, and have the triggers run a TaskCentre task
- SQL Instance Not Connectable
- SQL triggers not working. Error code 0x80037000
- Unable to run an SQL Server trigger: Database is modified but Task fails to trigger
- Unable to run an SQL Server trigger: SQL Server blocked access to procedure ‘sys.sp_OACreate’ of component OLE Automation Procedures
- When configuring the Microsoft SQL Server Trigger Agent, OLE Automation is not detected
- Windows application event log shows Access Denied (-214724891) from Microsoft SQL Server Trigger Agent
- Oracle Trigger Agent – Bad version number in class file
- Configuring the SMTP Virtual Server for the Email Trigger (SMTP) Agent
- Email attachments – An event was unable to invoke any of the subscribers 0x80040201
- Call COM tool fails at design time with error: The operation failed 0x8002802b
- Run VB Script step fails at task runtime with error 0x800a01ad
- Select Publishing Site drop down list not populated when you select a remote web server
- System.Bad Image Format Exception Could not load file or assembly “Interop.iwwfeaLib”
- System.Unauthorized Access Exception: Retrieving the COM class factory for component with CLSID failed
- Format As HTML tool: Can not launch the HTML editor as there is no registered application for this feature
- Getting “Aggregation unsupported for type: System.String”
- Unable to import XML schema – Error ‘no type has been selected for the scheme element’
- Web service connection fails with the error: “The underlying connection was closed: An unexpected error occurred on a send”
- ‘Select Publishing Site’ drop-down list does not display a list of websites
- Letters with accents display a black diamond symbol
- Magento update fails with: System.ServiceModel.Fault Exception The image is not specified
- Passing ‘&’ or ‘<' to a SOAP operation causes error: System.Xml.XmlException
- Solution to ReadpickLists schema problem with the SalesLogix System web service 7.5.4
- Client crash when defining the operation of a Web Service Connector step with Web Service Connector Tool Pack Release 1.0 Service Release 1
- When you click the Edit button in the Format As HTML step nothing happens
- DTL Elements marked as “Don’t Create Element” appear in the outgoing SOAP envelope
- Tasks with Run Microsoft Word (Merge) steps are failing to run – Error – “Word cannot initialise”
- Crystal Report error: Logon failed for table
- Task with Run Crystal Report step fails at runtime. The BPA Platform event log shows error code: 0x80020009
- Troubleshooting guide for the Run Crystal Report tool
- MS Reporting Services Report tool only processing one record in a recordset
- Run Microsoft Reporting Services Tool – Fails with “ExecutionNotFoundException” at task runtime
- Filter Data: RowsProcessed property does not reflect the number of filtered rows.
- Call Stored Procedure step fails at task runtime with error 0x80040e21
- Running a SAP HANA stored procedure errors with: ‘Unterminated quoted identifier’
- Updating oracle stored procedure with > 32 KB fails with ‘the operation failed 0x80040e14’
- Database Query: RowCount property not reflecting the amount of rows produced by a recordset
- Global ODBC connection test fails with error 0x80040154
- Unable to query a SAP HANA database: Driver error – 10808 [HODBC32] Feature (SCROLLABLE RESULT) not implemented yet
- Creating a formula field within the OLEDB query tool fails with error 0x80070582
- TaskCentre Server installation fails with the error: Failed to load and use iwinstall.dll
- Creating a Global OLEDB Connection – Server name length restriction
- Import Flat File tool – Locks a file for the duration of a task run preventing it from being moved by the File Management Tool
- Task failing at runtime with the error: Failed to print document 0x80070bc4
- Configuring TaskCentre to use a Gmail SMTP account: Error – The message received was unexpected or badly formatted
- Office 365 – Email sending limit prevents TaskCentre from sending more than 30 emails per minute. Error: 4.4.2 Message Submission Rate
- Selecting the Secure SMTP option in the SMTP global config causes task to fail with error: TLS Session Negotiation Failed. Connection Aborted
- Send Email (SMTP) output giving “?” signs
- Unable to send email through Office 365 hosted facilities. Error: TLS Session Negotiation Failed. Connection Aborted
- TaskCentre Server installation fails with the error: Failed to load and use iwinstall.dll
- Exchange Agent: Error when creating a new subscription – ID is malformed
- MS Dynamics CRM Connector tool: Global configuration – Unable to connect with Microsoft Dynamics CRM
- Sage 200 Connector Tool – Error: Could not load file or assembly
- Sage 200 Connector: Error – The type initializer for ‘Sage.Accounting.Application’ threw an exception
- SAGE 50 Accounts 2012 – ODBC query fails with “DAO error column not found ODBC — call failed”
- Salesforce Connector tool – Error validating source XML against schema
- Creating a schema in the SalesLogix Connector global config gives the error: System.Data.OleDb.OleDbException (0x80004005)
- SalesLogix Connector step fails at task runtime with error “Could not find file C:WindowsTEMPxxxxxxxx.dll”
- SalesLogix Connector step fails at task runtime with the error – Could not find ‘C:|iwtemp\xxxxxxxxx.dll’
- System.BadImageFormatException Could not load file or assembly ‘SLXConnectorWS’
- System.Data.OleDb.OleDbException Unable to initialize data dictionary. Invalid object name ‘SYSTEMINFO’
- System.Data.OleDb.OleDbException: No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80004E4D)
- System.Data.OleDb.OleDbException: No error message available, result code: E_UNEXPECTED(0x8000FFFF)
- Task fails at runtime with the error: “System.UnauthorizedAccessException: Access to the registry key….is denied”
- Getting Errors when Updating Documents in the SAP Client
- Failed to load company list from server – Error code: 8007007e
- Failed to load company list from server – Error code: 8007007e
- OBServerDLL.dll version is older than the DI API version – Error code -8003
- Failed to connect or logon to SLD – Error code: -8037
- Unable to initialise OBServerDLL.dll – Error code: -105
- Date deviates from permissible range – Error code: -5002 10000047
- Error code: 998 – An error occurred whilst processing the operation: Exception from HRESULT: 0xFFFFFB9E
- Error whilst processing operation: You are not connected to a company
- SAP error validating source XML against schema – Invalid child element
- To generate document, define the numbering series in Administration module – Error code: -5002
- Unable to get schema – You are not connected to a company
- A task fails with the error: Could not establish trust relationship for the SSL/TLS secure channel
- After installation of the SAP Business One client tools the SAP Business One Event tool is missing
- HTTP Error 404.3 – Not Found – Occurs when connecting to a Sap Business One web service
- IIS App pool fails when you make a call onto the SAP Business One Connector web service.
- IIS App pool fails when you make a call onto the SAP Business One Connector web service.
- Posting a Journal entry using the SAP Business One Connector returns error: 10000415 – Enter valid code.
- SAP B1 – Business Partner address fails to update with error “This entry already exists in the following tables (ODBC -2035)”
- SAP Business One connection error: Error 5-5 (- access is denied) connecting to the DI API
- SAP Business One connection error: Error 5-5 (- access is denied) connecting to the DI API
- SAP Business One connector tool – Error: “Failed to connect or logon to SLD”
- SAP Business One Connector Tool – ‘Unable to contact web service’
- SAP Business One Connector tool – Error: -5002 10000156 Posting date deviates from the defined range.
- SAP Business One Connector Tool – Error: 10000008 – License does not exist
- SAP Business One Connector: Error when updating the ‘Quotation’ object
- SAP Business One Event Tool – Error when trying to remove a company database
- Sap Business One Event Tool : Error 0x80040154 setting up available objects
- SAP Business One installer fails with error: Error: -2147024891 connecting to TaskCentre server
- SAP connector tool step fails at task runtime with error: System.Exception: Failed to send request to Web Service
- Selecting the SAP Business One ‘Installation Number’ causes the TaskCentre client to crash
- System.Bad Image Format Exception Could not load file or assembly ‘Codestone.Compression’
- System.Exception: Tool not licensed. Invalid SAP Business One license count of 0 found
- System.Invalid Operation Exception unrecognized attribute multipleSiteBindingsEnabled
- System.IO.DirectoryNotFoundException Could not find a part of the path
- System.Net.WebException: The operation has timed out
- System.Runtime.InteropServices.COMException (0x80040154)
- System.Web.Services.Protocols.SoapException: Retrieving the COM class factory for component with CLSID {F3D77DAE-6C14-B56F-426th-C550BDE8B09D} failed
- Unable to create a new connection to a SAP Business One database – Error: Load library for observer failed
- Unable to register the SAP Business One event agent with the TaskCentre server – Error: -214702489
- Unable to Register web Service Encryption for COM Interop
- When you add lines to a Sales Order or Purchase Order, the SAP Connector updates the existing lines instead of adding new ones
- You receive error:’ -1000 Property is invalid’ when you add data to a User defined Field (UDF)
- Sage 300 Connector Tool — OrderUniquifier Generating Errors
- Run Sage 50 / 200 Report Tool v1.4 — Getting “Exception occurred. Details: File contains corrupted data”
- Run Sage 50 / 200 Report Tool v1.4 — Getting “No supported Sage 200 product found or incorrect login details”
- SAP Business One Integration Tool Pack — Getting Error XML: “Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.”
- Web Service Connector Tool is Unable to Generate the XML Document
- Why are my SAP Business One UDT, UDF, and UDOs not Triggering my Tasks?
- Why is my New Field in my Data Connector’s Object not Available for Linking?
- TaskCentre Server services failing to start with error: Server Initialisation Failure – ErrorInformation 9/0x80070005
- TaskCentre Server service fails to start with error 0x80040e14
- TaskCentre API Web Service Install Problem IIS Version 8
- How to register a third party server certificate for use on a TaskCentre server
- How to Run PowerShell Scripts with the Run External Program Tool
- Automating EU VAT Registration Number Validation (VIES)
- How to synchronize MailChimp unsubscribes with a CRM system by making use of the TaskCentre Web Service Connector
- What are the Error Codes for the Send Text Message Tool?
- FTP Connections
- Configuring Web Service Connections
- Microsoft Exchange Tool Pack – Overview
- Overview of Web Services
- SOAP Web Service Connections
- REST Web Service Connections
- Importing a TaskCentre Web Service Configuration File
- Forward Mail to the Email Trigger (SMTP) Agent – Exchange 2010
- How to Install a Remote SAP Business One Event Agent
- BPA Platform Administration
- Background to the Bank of England URL
- Run Sage 50/200 Report – Global Configuration
- Saving and Printing Files
- How to Install BPA Platform
- How to Improve Resilience and Ensure Data Integrity in Tasks
- How to Restore the Store from a Backup
- How to Upgrade BPA Platform
- Creating a Tab Separated File in BPA Platform
- How to Include a Date Range in an SQL Statement
- How to Add an Import XML Document Task Step
- How to Migrate an Internal Store to a SQL Server Store
- How to Print PDFs Using Run External Program
- How to Add More Features to BPA Platform
- Locked solutions ODBC Memory works at runtime but shows error at design time
- Configuring Office 365 send mail authentication
- Valid certificate .pfx file password rejected by Web Service Connector Tool
- What are Tasks, Steps and Tools?
- API Key
- Application Programming Interface (API)
- Application Software
- Relational Database
- Data Connector
- Application Integration
- Database
- Cloud Computing
- ESB (Enterprise Service Bus)
- ETL (Extract, Transform, Load)
- JSON
- ODBC
- OLE DB
- Sandbox Environment
- REST API
- SOAP API
- Two-factor Authentication (2FA)
- Web Services
- Webhook
- Data Mapping
- Structured Query Language (SQL)
- GraphQL
- Endpoint
- XML (eXtensible Markup Language)
- IP Address
- Update Concur Vendor API
- URL (Uniform Resource Locator)
- Report Creation and Output Generation – Seller Central Authorisation
- Partial Global Configuration
