How to resolve "Server Error: [Canary Labs][DSI] (20029) Function not supported" in TIBCO Data Virtualization Server when connecting from Canary Labs Data Warehouse?

How to resolve "Server Error: [Canary Labs][DSI] (20029) Function not supported" in TIBCO Data Virtualization Server when connecting from Canary Labs Data Warehouse?

book

Article ID: KB0071782

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

The ODBC-JDBC jar is used to successfully connect to TIBCO Data Virtualization (TDV) Server from the Canary Labs Data Warehouse (DWH). However, running any queries result in the below error.
***
- Server Error: [Canary Labs][DSI] (20029) Function not supported.

***

Environment

All supported environments

Resolution

Verify the Canary Labs DWH Software is up to date. If not, update the software to a later available version to resolve the issue.

Issue/Introduction

This article illustrates steps that can be taken to resolve "Server Error: [Canary Labs][DSI] (20029) Function not supported" in TIBCO Data Virtualization Server when connecting from Canary Labs Data Warehouse