IBM Support

PM16982: DATETIME VALUE IF 0 IN DB WHEN THE SAME IS IMPORTED AND TESTED IN FRAMEWORK MANAGER RETURN CURRENT DATE INSTEAD OF 0 VALUE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Customer has the reporting database on Oracle 10.2.0.1.0 . In
    this database they a table which has a column of datetime. This
    particular datetime column would have datetime value as
    00/00/0000 00:00:00 by default.??After we connect to the
    reporting database  by making a datasource connection in
    Framework manager and then import the table. We then create a
    query subject having this column and try to test the same. You
    will notice that instead of the column returning 00/00/0000
    00:00:00 it returns today?s date .?
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
    * Pack 1                                                       *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM16982

  • Reported component name

    COG8 BI SECURIT

  • Reported component ID

    5724W12SE

  • Reported release

    840

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-22

  • Closed date

    2013-06-11

  • Last modified date

    2013-06-11

  • 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

    COG ADMINISTRAT

  • Fixed component ID

    5724W12AD

Applicable component levels

  • RA21 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHM94","label":"Administration and Configuration v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"840","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013