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

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 : bg@servernode1 (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 

Environment

Version: 15.8.1

Cause

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

Resolution

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