JR31214: INVALID PRECISION VALUE ERROR.

APAR status

• Closed as program error.

Error description

• when using the timestamp column as a key in the lookup stage,
  getting an Invalid Precision Value error.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Product: Information Server 8.0.1 Fp1a
  Platform: Intel Redhat Rel 4
  Database: SQL Server 2000
  ****************************************************************
  PROBLEM DESCRIPTION:
  When using a Timestamp column (with or without Microseconds) as
  arse lookup stage, the job is aborting    with the below error.
  
      Item #: 9
           13
  13:35:13
               am:
  [IBM(DataDirect OEM)][ODBC SQL ServerDriver]Invalid precision
  value
          The column was defined as Timestamp with length =
  26 and scale  of 3.
  ****************************************************************
  RECOMMENDATION:
  apply patch JR31214
  The fix has been included in the IS 8.1 FP1. Apply the FixPack1
  for IS 8.1.
  ****************************************************************
  

Problem conclusion

• Fix corrected in this patch
  

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

• ODBC
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSY

     UP