IBM Support

PI64599: ORA-12704: CHARACTER SET MISMATCH

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Cognos fails to generate the SQL in 10.2.2 without casting the
    literal to an nchar.  After casting, the generated Cognos sql
    works in oracle after removing the FWM schema table prefixes.
    The generated Native SQL is incomplete.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Analytic 11.0.13.0                     *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI64599

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    A22

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-06-21

  • Closed date

    2018-11-02

  • Last modified date

    2018-11-02

  • APAR is sysrouted FROM one or more of the following:

    PI57754

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels



Document information

More support for: Cognos Business Intelligence
Report Studio

Software version: 10.2.2

Reference #: PI64599

Modified date: 02 November 2018


Translate this page: