PK96318: REPORT WITH DATE PROMPT FAILS VALIDATION AND RUNS WITH ERROR AFTER 8.3 HOTSITE 8.3.85.1027 .

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • QFS-ERR-0139 The request has multiple errors.
    RQP-DEF-0354 The query contains one or more unresolved prompts.
    QE-DEF-0383 Invalid format for prompt 'd1'. Expected format for
    datetime:CCYY-MM-DDThh:mm:ss.
    QE-DEF-0383 Invalid format for prompt 'd2'. Expected format for
    datetime:CCYY-MM-DDThh:mm:ss.
    

Local fix

  • workaround :
    CAST(Order_date as DATE) between ?d1? and ?d2? on the filter.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * QFW throws exception for unrecognized/invalid  data type due *
    * to an extra XML attribute for Date&Time prompts that is      *
    * meant only for Date prompts.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos 8 Business Intelligence 8.3 Fix Pack   *
    * 5.                                                           *
    ****************************************************************
    

Problem conclusion

  • The fix is to restrict the XML attribute to only Date prompts
    where it's appropriate.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK96318

  • Reported component name

    COG8 BI ANALY S

  • Reported component ID

    5724W12AS

  • Reported release

    830

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-16

  • Closed date

    2009-12-23

  • Last modified date

    2009-12-23

  • 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

    COG8 BI ANALY S

  • Fixed component ID

    5724W12AS

Applicable component levels

  • R830 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Analysis Studio

Software version:

8.3

Reference #:

PK96318

Modified date:

2009-12-23

Translate my page

Machine Translation

Content navigation