What is this error code: 11402?

Question

The value of the property '' is invalid: 'Unknown SQL type - -99.'.

Unknown SQL type - -99.

I keep getting this error when trying to copy certain tables from a DB2 database with the ODBC connector. Most of the tables copied with no problem. I've received this error trying to copy a batch of tables, and trying to copy a single table to a different source. Under the mapping, I can't even get it to import the schema or preview data source. This is only in the pipeline. I can't use this source in a dataflow.

I can't find any documentation on what this error means and how to fix it.

Answer 1

Hi ,

Thanks for reaching out to Microsoft Q&A.

This error (Unknown SQL type -99) typically occurs when the ODBC driver for DB2 encounters a column data type it does not recognize or map properly to standard SQL types.

Possible Root cause:

DB2 has proprietary or uncommon data types (like XML, DECFLOAT, ROWID, CLOB, or user-defined types) that the ADF or Fabric ODBC connector cannot interpret.

Fix that yo ucan try:

1. Identify problematic columns: Run --> "SELECT TABNAME, COLNAME, TYPENAME FROM SYSCAT.COLUMNS WHERE TYPENAME IN ('DECFLOAT', 'XML', 'ROWID');" These are often the ones causing the issue.
2. Workarounds:
   • Exclude or cast those columns in a DB2 view (for example, CAST(DECFLOAT AS DECIMAL(38,10)) or CAST(XML AS VARCHAR(4000))), and copy the view instead.
   • Ensure the latest IBM ODBC/CLI driver (v11.5+) is installed on the integration runtime.
   • Verify that your ODBC DSN uses the correct driver and 64-bit version.
3. Alternative: Use the DB2 native conn instead of generic ODBC if available, it has better type support.

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.