IT10616: CONNECT:DIRECT SERVER ADAPTER DOES NOT START AND THROWS AN ERROR

si_52_build_5020500_interimfix_8
si_52_build_5020500_interimfix_8
si_52_build_5020500_interimfix_8

APAR status

• Closed as program error.

Error description

• Connect:Direct Server adapter does not start and throws an
  error:
  
  ERROR [ServicesController.runStartup.TMG.DIG.
  001_CDSERVER_ADAPTER_node11435353363025/2457] RepositoryShslDB.
  localNodeStartup(TMG.DIG.001_CDSERVER_ADAPTER_node1) -
  SQLException: com.microsoft.sqlserver.jdbc.SQLServerException
  Error Code: 242 - The  conversion of a nvarchar data type to
  a datetime data type resulted in an out-of-range value.
  

Local fix

• RTC 471624
  HAB
  

Problem summary

• Users Affected:
  All
  
  Problem Description:
  SQL Server timestamp conversion exception. The adapter
  incorrectly
  relies on implicit type conversion from String to Timestamp by
  the JDBC driver during store operations. The issue is exposed
  when the date format for a locale is different from the one the
  adapter assumes. For example, If the date format for a locale
  is 'dd/mm/yyyy' and the adapter assumes 'mm/dd/yyyy,' then
  an SQL Exception may be thrown by the JDBC driver.
  
  Platforms affected:
  All
  

Problem conclusion

• Resolution Summary:
  Connect:Direct Server adapter now uses the Timestamp data type
  internally and no longer requires implicit date/time conversion
  from String to Timestamp.
  
  Delivered In:
  5020500_8
  

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

  STR B2B INTEGRA

• Fixed component ID

  5725D0600

Applicable component levels