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

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 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