IBM Support

JR33573: MCPK DATA SAMPLE CREATION FAILS IF COLUMN CONTAINS DATETIME/TIMESTAMP FIELD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Error in log:
    
    [IIS-CONN-ODBC-000004] ODBC function {0} reported:  SQLSTATE =
    22007: Native Error Code = 242: Msg = [Microsoft][ODBC SQL
    Server Driver][SQL Server]The conversion of a char data type to
    a datetime data type resulted in an out-of-range datetime value.
    
    
    IA 8.1 RP3 on Windows 2003 SP2 with SQL Server 2005 xmeta and
    iadb repository.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    Users attempting to create a Data Sample where one of the
    columns is an Informix datetime data type
    ****************************************************************
    PROBLEM DESCRIPTION:
    The creation of Samples involving Informix datetime fields was
    failing with the error "[IIS-CONN-ODBC-000004] ODBC function
    {0} reported:  SQLSTATE =
    22007: Native Error Code = 242: Msg = [Microsoft][ODBC SQL
    Server Driver][SQL Server]The conversion of a char data type to
    esulted in an out-of-range datetime   value."
    ****************************************************************
    RECOMMENDATION:
    Update to Information Analyzer 81 RUP4.  This change is also
    included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • In Information Analyzer 81 RUP4 you will be able to create a
    Data sample containing an Informix datetime column.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33573

  • Reported component name

    WIS INFORM ANAL

  • Reported component ID

    5724Q36IA

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-06

  • Closed date

    2009-08-17

  • Last modified date

    2009-12-18

  • 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

    WIS INFORM ANAL

  • Fixed component ID

    5724Q36IA

Applicable component levels

  • R810 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
18 December 2009