"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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.