PH49263: STORED PROCEDURE WITH AN IN PARAMETER GIVES AN ERROR WHEN PARAMETER'S LENGTH EXCEED 255 CHARACTERS

APAR status

• Closed as fixed if next.

Error description

• When using an Informix Stored procedure inside a Query Item.
  This stored procedure has an IN string parameters (which are
  configured in Framework Manager as characterlength16). When  the
  parameter's length exceed 255 characters, we get the error "
  RQP-DEF-0177 An error occurred while performing operation
  'sqlExecute' status='-6'.
  UDA-SQL-0026 An illegal data conversion has been attempted
  during the operation "{0}".
  "
  So, we've tried to modify this parameter into Framework Manager
  to convert it to characterlength32 (to see if it's a datatype
  overflow problem...) But, when we try to modify it in FM, we get
  a Fatal error and FM is closed
  Data type of the parameter in database is lvarchar (8000) .
  Database connection type CQM
  

Local fix

• The problem does not appear in DQM connection
  

Problem summary

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

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

Applicable component levels