KB46432 – TLS 1.2 Support for BPA Platform SQL Server Store and Trigger Agent

Introduction Microsoft have included support for TLS 1.2 in their SQL Server drivers’ updates — https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/. TLS 1.2 support was not available in BPA Platform 2018 or any previous versions for any SQL Server connection or Microsoft SQL Server Trigger Agent connection. Resolution The…

Read More

How to Design a “Chunked” Task to Process a Large Amount of Rows Over Multiple Task Runs

Introduction You may find that running tasks that process high volumes of rows may results in multiple errors due to the large amount of processing. This article describes how to design such a task, but where the high number of rows processed is “chunked”…

Read More

SAP Business One Integration Tool Pack — Getting Error XML: “Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.”

Summary 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…

Read More

Printing PDF documents using SumatraPDF

Summary A number of web services return PDF documents in their output, such as labels from courier companies. This article explains how BPA Platform can print PDF documents using an external PDF tool, such as the open-source utility SumatraPDF. This utility can be used…

Read More

Why are my SAP Business One UDT, UDF, and UDOs not Triggering my Tasks?

Summary 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…

Read More

Upgrading TaskCentre — From v4.1 to BPA Platform 2018

Introduction This article describes how to upgrade TaskCentre v4.1. The upgrade must be completed in stages as a single jump from v4.1 to v2018 is not possible. Because of this, this article is suitable to use when upgrading from any version to the latest;…

Read More

Failed to load company list from server – Error code: 8007007e

Symptom 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…

Read More

Why is my New Field in my Data Connector’s Object not Available for Linking?

Summary 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…

Read More

Using HTTPS Connections with the Sage 300 Connector

Summary The Sage 300 Connector tool is able to communicate with the Sage 300 server over HTTP and HTTPS. HTTP communication is enabled by default. This article describes how to configure both the Sage 300 and BPA Platform servers to use HTTPS. Note: You…

Read More

Web Service Connector Tool is Unable to Generate the XML Document

Summary 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…

Read More