IT14703: ERROR WHEN INSERTING TIME STAMPS FROM UNIX OR LINUX INTO A DATETIME COLUMN IN AN SQL SERVER DATABASE

APAR status

• Closed as program error.

Error description

• When inserting a time stamp from Unix or Linux into a DATETIME
  column in an SQL Server database a database error is received.
  
  additional Symptom(s) Search Keyword(s):
  
  [unixODBC][IBM][ODBC SQL Server Wire Protocol driver][Microsoft
  SQLServer]The incoming tabular data stream (TDS) remote
  procedure call
  (RPC) protocol stream is incorrect. Parameter 1 (""): The
  supplied value is not a valid instance of data type datetime2.
  Check the source data
  for invalid values. An example of an invalid value is data of
  numeric type with scale greater than precision.'
  With a Native Error Code of 8023  and SQLState 22003
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of WebSphere Message Broker V8.0, IBM Integration Bus
  V9.0 and IBM Integration Bus V10.0 using the DataDirect V7.1 SQL
  Server Wire Protocol ODBC driver.
  
  
  Platforms affected:
  AIX, HP-UX Itanium platform, Linux on Power platform, Linux on
  x86 platform, Linux on x86-64 platform, Linux on zSeries
  platform, Solaris x86-64 platform, Solaris SPARC platform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  There is an intermittent failure that results in an attempt to
  insert a corrupted time stamp into a DATETIME or DATETIME2
  column of a SQL Server database. This only applies to the
  Message Broker or IBM Integration Node running on Linux or unix
  systems.
  
  This ODBC error may also be seen in the syslog file:
  [unixODBC][IBM][ODBC SQL Server Wire Protocol driver][Microsoft
  SQLServer]The incoming tabular data stream (TDS) remote
  procedure call (RPC) protocol stream is incorrect. Parameter 1
  (""): The supplied value is not a valid instance of data type
  datetime2. Check the source data for invalid values. An example
  of an invalid value is data of numeric type with scale greater
  than precision.'
  The Native Error Code is 8023 and the SQLState is 22003.
  
  There are a number of resource name changes between WebSphere
  Message Broker and IBM Integration Bus Version 9.0.  For details
  visit
  http://pic.dhe.ibm.com/infocenter/wmbhelp/v9r0m0/topic/com.ibm.e
  tools.mft.doc/bb23814_.htm
  

Problem conclusion

• The product includes an updated level of DataDirect SQLServer
  Wire Protocol ODBC driver that resolves the problem.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.5
  v8.0       8.0.0.9
  v9.0       9.0.0.8
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  INTEGRATION BUS

• Fixed component ID

  5724J0530

Applicable component levels

• R900 PSY

     UP