PM99376: UNABLE TO IMPORT A STORED PROCEDURE SYNONYM FROM ORACLE DATABASE

APAR status

• Closed as program error.

Error description

• When you import a stored procedure synonym from an Oracle
  Database, the import works fine, but when validated it fails
  with: RQP-DEF-0177 An error occurred while performing operation
  'sqlBindArguments status='-9'.
          UDA-SQL-0107 A general exception has occurred during the
  operation "bind arguments".
                     ORA-01436: CONNECT BY loop in user data
  Table synonyms import and test fine.  The original stored
  procedure object can be imported and tests fine. The synonym
  created for the stored procedure object is in different schema
  with the same name as the stored procedure but it does not work.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Fix Pack 3  *
  *  or upgrade to IBM Cognos Business Intelligence 10.2.1 Fix   *
  * Pack 3                                                       *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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:

  PI34436

Fix information

• Fixed component name

  COG FRAMEWRK MG

• Fixed component ID

  5724W12FM

Applicable component levels

• RA20 PSN

     UP