IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IT10616

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-08-11

  • Closed date

    2015-08-18

  • Last modified date

    2015-08-25

  • 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

  • R525 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
25 August 2015