IBM Support

PI87080: ERRORS IN REPORT BUILT AGAINST MULTIPLE SQL SERVER DATABASES, USING CONVERT() FUNCTION: RQP-DEF-0177,UDA-SQL-0015,UDA-SQL-0564

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • A complex report combines queries from multiple SQL Server data
    sources.  The report uses the SQL Server convert() function in
    some calculations with syntax similar to convert(varchar(20),
    [QueryItem]).  When the report is executed, errors are thrown
    indicating that malformed SQL was sent to the database:
    
    RQP-DEF-0177 An error occurred while performing operation
    'sqlPrepareWithOptions' status='-56'.
    UDA-SQL-0115 Inappropriate SQL request.
    UDA-SQL-0564 [Microsoft SQL Server Native Client 11.0]Deferred
    prepare could not be completed.
    UDA-SQL-0564 [Microsoft SQL Server Native Client
    11.0]Statement(s) could not be prepared. (SQLSTATE=42000,
    SQLERRORCODE=8180)
    UDA-SQL-0564 [Microsoft SQL Server Native Client 11.0]Incorrect
    syntax near '<alias>'. (SQLSTATE=42000, SQLERRORCODE=102)
    UDA-SQL-0564 [Microsoft SQL Server Native Client 11.0]'varchar'
    is not a recognized built-in function name. (SQLSTATE=42000,
    SQLERRORCODE=195)
    

Local fix

  • Change vendor-specific CONVERT() functions to CAST() functions
    instead.
    

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI87080

  • Reported component name

    COG REPORT STUD

  • Reported component ID

    5724W12RS

  • Reported release

    B07

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-08

  • Closed date

    2019-06-05

  • Last modified date

    2019-06-05

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

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

Fix information

Applicable component levels



Document information

More support for: Cognos Analytics
Report Authoring v11x

Software version: B07

Reference #: PI87080

Modified date: 05 June 2019