PowerBuilder 2019 Build 2170

We have a utility app that copies default data from a reference database (SQL Anywhere 12) to the users SQL Server database. The end user runs this utility when upgrading to a new version of the main application.

The problem we are having is with an internal app that populates the SQL Anywhere database from a SQL Server database maintained by our DBA.

For each table, it creates a pipeline on the fly and assigns it to the Syntax property of a pipeline object. It then makes a call like this:

li_return = pipe_obj.Start ( tr_source, tr_target, dw_result )

It recently started failing with -7 (Column mismatch) on just one table. We have 2,385 tables being processed.

Here is the table definition:

CREATE TABLE [dbo].[ManagedTaskSetDefinition](
	[AppID] [int] NOT NULL,
	[Name] [varchar](50) NOT NULL,
	[Code] [varchar](15) NOT NULL,
	[IsQueuingSet] [bit] NOT NULL,
	[HasBeenProcessed] [bit] NOT NULL,
	[CreatedDateTimeOffset] [datetimeoffset](7) NOT NULL,
	[ManagedTaskTargetListDefinitionAppID] [int] NULL,
	[ManagedTaskScheduleDefinitionAppId] [int] NULL,
	[IsInitiatedBySystemEvent] [bit] NOT NULL,
	[ManagedTaskSystemEventDefinitionAppID] [int] NULL,
	[IsActive] [bit] NOT NULL,
	[QueuedDateTimeOffset] [datetimeoffset](7) NULL,
	[ReRunNumberOfDays] [int] NULL,
	[CreatedByApplicationUserAppId] [int] NULL,
	[InitiatedBy] [char](1) NOT NULL,
	[LastRunDateTimeOffset] [datetimeoffset](7) NULL,
	[CutOffDaysAfterStart] [int] NULL,
	[CutOffTime] [time](7) NULL,
	[RunTimeParameters] [varchar](max) NULL,
	[AppRowVersion] [timestamp] NOT NULL,
	[ChangeUser] [varchar](513) NOT NULL,
	[ChangeJob] [varchar](63) NOT NULL,
	[ChangeTime] [datetime] NOT NULL,
 CONSTRAINT [PKManagedTaskSetDefinition] PRIMARY KEY CLUSTERED 
(
	[AppID] ASC
)

If anyone has any suggestions, it would be appreciated.