JR35929: INFORMATION SERVER 8.1 DRS STAGE UTILIZING ODBC SQL SERVER DRIVER FAILS WITH "INVALID TIME FORMAT" ON SOLARIS

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as program error.

Error description

• In Information Server 8.1 on Solaris a job using a DRS stage
  utilizing DataDirect ODBC SQL Server drivers fails with
  "Invalid time format".
  This job worked on previous DataStage 7.5.2.
  

Local fix

• Use SQL type Varchar instead of Timestamp in DataStage columns
  grid.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Suite Version: 8.1.0.0 to 8.1.0.1
  Tiers: Engine
  Operating System: SOLARIS
  Component: DRS stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  On Information Server 8.1 for Solaris 64 bit, DRS stage jobs
  connecting to SQL Server would fail with "Invalid time format"
  when inserting datetime values.
  
  ****************************************************************
  RECOMMENDATION:
  Install patch JR35929 .
  ****************************************************************
  

Problem conclusion

• Resolution was to add a compiler flag for Data Direct drivers
  when building for Solaris.
  

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:

Modules/Macros

• SERVER
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP