APAR status
Closed as program error.
Error description
Environment:??OS: Solaris, Cognos 8.2 (SX64) upgrade to 10.1 (also tested on upgrade from 8.2 to 8.4.1 with same results)??Installed in separate directories on a single server (GW, CM, RS), Tomcat??Java: 1.5.0_17 and 1.5.0_12 tested??Sybase 15.0.1????Upgrading of schedules from 8.2 to 10. results in application deadlocks. IR COGCQ00264292 was previously raised for same issue and contains traces, logs and thread dumps.????An in-house test was performed by Tony McLay, which comprised of the following:????1) Installed 8.2.??2) Created 20 reports and 10 jobs all with trigger schedules.??3) Upgraded to 10.1. ????Result: The updating 10.1 install locked up on the updateSchedules (synchSchedules mechanism). Inspection points to an application deadlock where threads open a transaction but also query the db outside that transaction - as suspected given globeop's feedback. This can lead to blocks at the db that induce deadlocks at the application level (hence no db deadlock detection). This is more likely for Sybase (and Oracle) where we use 'read_committed' for db queries (reads).??
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh * * Pack 1 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM28352
Reported component name
COG8 BI COG CON
Reported component ID
5724W12CC
Reported release
841
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-07
Closed date
2011-09-13
Last modified date
2011-09-13
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 COG CON
Fixed component ID
5724W12CC
Applicable component levels
RA11 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWN","label":"Portal v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"841","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
13 September 2011