PI26240: UDA ERRORS WHEN EXECUTING REPORT IN BATCH BUT WORKS INTERACTIVELY

APAR status

• Closed as program error.

Error description

• When executing a report in batch it fails with:??RQP-DEF-0177 An
  error occurred while performing
  operation?'sqlPrepareWithOptions' status='-16'. DPR-ERR-2082 An
  error has?occurred. ??Actually error in cogserver.log is
  UDA-SQL-0327 An invalid object name was detected in the SQL
  request. UDA-SQL-0328 Unable to find the column?<column
  name>.??The same report work interactively without errors.
  

Local fix

• 1   ) Set 'Use Local Cache = Yes' on the AllData query (in Repor
  t Studio)
  2 a) Rename ..\configuration\cqeconfig.xml.sample to cqeconfig.x
  ml
     b) Add this setting inside the query engine section
           <entry name="RequestHintLocalCacheHasHigherPriority" va
  lue="0"/>
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.2 Fix Pack  *
  * 1                                                            *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

• A fix for this APAR is targeted for IBM Cognos Business
  Intelligence 10.2.2 Fix Pack 1
  
  The Fix Pack Release Schedule can be found at
  www-01.ibm.com/software/analytics/cognos/support/fixpacks.html
  

APAR Information

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

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

  PI34163

Fix information

• Fixed component name

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels