"Supplied inconsistent metadata for a column" Error when using MSSQL Linked Server to query DV

Solution Unverified - Updated -

Issue

  • Using MSSQL Linked Server, which connects via ODBC and runs queries with openquery. Receive the below errors:
Supplied inconsistent metadata for a column. The column "Price" (compile-time ordinal 16) of object "select * from test.Product limit 100" was reported to have a "LENGTH" of 17 at compile time and 13 at run time."

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.2.4
  • Microsoft SQL Linked Server

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content