JR63289: ODBC CONNECTOR WRITE/LOAD JOBS TO AZURE DATA WAREHOUSE MIGHT FAIL WHEN THERE ARE MORE NUMBER OF COLUMNS IN THE SCHEMA

APAR status

• Closed as Vendor Solution.

Error description

• ODBC Connector write/load jobs connecting to SQL Azure Data
  Warehouse or Synapse Analytics might throw an error message
  like below when there are more number of columns (noticed with
  more than 100 columns) in the schema:
  
  ODBC function
  "SQLExecute" reported: SQLSTATE = : Native Error Code = 8,016:
  Msg = [IBM (DataDirect OEM)][ODBC SQL Server Wire Protocol
  driver][SQL Server Azure Data Warehouse]The incoming tabular
  data stream (TDS) remote procedure call (RPC) protocol stream
  is incorrect. Parameter 2 (""): Data type 0xE7 has an invalid
  data length or metadata length.
  (CC_OdbcDBStatement::rejectRows, file CC_OdbcDBStatement.cpp,
  line 2,134)
  
  
  
  This is a problem with the DataDirect SQL
  Server Native Wire Protocol driver (VMsqls00.so) and is
  resolved with the driver version: 08.02.0390 (B0734, U0520).
  

Local fix

• n/a
  

Problem summary

Problem conclusion

Temporary fix

Comments

• This is a problem with the DataDirect SQL Server Native Wire
  Protocol driver (VMsqls00.so) and is resolved with the driver
  version: 08.02.0390 (B0734, U0520). This can be found with any
  driver set branded on or after 4th Feb, 2021.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels