Portfolio Sync failed: 'varbinary(max)' is not a valid DataType

book

Article ID: 205825

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Portfolio Sync job fails with the following error.

Synchronize Portfolio: Unknown error.

The bg-ca.log shows the following error message.

ERROR 2030-31-30 05:05:05,902 [Dispatch Synchronize portfolio investments : [email protected] (tenant=clarity)] job.PFMSyncManager 
(clarity:admin:7993850__D3-0493-4A03-B4BE-3D203A6A5AAC:Synchronize portfolio investments) java.lang.IllegalArgumentException: 'varbinary(max)' is not a valid DataType
at com.niku.dbtools.xmlobjects.types.DataType.valueOf(DataType.java:294) at com.niku.dbtools.SQLServerExtractor.createColumn(SQLServerExtractor.java:227)
at com.niku.dbtools.AbstractExtractor.getColumns(AbstractExtractor.java:1426)
at com.niku.dbtools.AbstractExtractor.getTable(AbstractExtractor.java:547) at 

Cause

Due to an older version of dbtools.jar having been placed in the customlib folder of the Clarity folder structure.

Environment

Version: 15.8.1

Resolution

Remove all .jar files of older versions from the customlib folder.