PK91009: DEADLOCKING AND SCHEDULED REPORTS FAILING

APAR status

• Closed as program error.

Error description

• Error is: CNC-JOB-3305 An error occurred when executing a Job.
  Consult the log files. CNC-BAL-0509 One or more errors have
  occurred. Your request could not be fully processed.
  

Local fix

Problem summary

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

Problem conclusion

• Fixes to avoid deadlock.
  1.  Encapsulate SQL statements within transaction context to
  enable retries on deadlock and better manage integrity.
  2.  Modifications to reduce database contention. such as single
  deletion per transaction.
  3.  Have updates to shared structures be performed by the same
  thread.
  

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

• Fixed component name

  COG8 BI REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• R830 PSN

     UP