IBM Support

Client hangs/freezes "Not Responding" when click "Transfer - Publish data and structures - Define data mart", after creating new data mart, caused by APAR PH27153

Troubleshooting


Problem

User clicks "Transfer - Publish data and structures - Define data mart". 
  • Initially the screen appears as expected (everything works as normal).
User selects an existing data mart, and clicks 'Save As'. User chooses a new name, and presses 'Save'.
=> The Controller client hangs (saying 'Not Responding').
This seems to last forever (for example they can wait 30 minutes or so). If the user forcibly ends the CCR.EXE session, and re-opens the same menu item ("Transfer - Publish data and structures - Define data mart") then none of the data mart information appears.
  • Instead, everything looks empty/blank.

Symptom

Example:
User opens the menu item, and chooses an existing data mart (for example 'CBI').
  • User clicks 'Save As':
image 4925
User chooses a new name, and presses 'Tick' button:
image 4926
=> The Controller client hangs (saying 'Not Responding'):
 image 4933
This seems to last forever (for example at lest 30 minutes with no change).
If the user forcibly ends the CCR.EXE session...
image 4934
...then re-opens the same menu item ("Transfer - Publish data and structures - Define data mart") then none of the data mart information appears.
  • Instead, everything looks empty/blank:
image 4935
  
In addition, the Controller client says 'Not Responding' (see above).

Cause

Defect (reference APAR PH27153) in Controller 10.4.1 IF3 (10.4.1100.150) and later versions of 10.4.1.x.
  • This causes a SQL query to run with an infinite loop (neverending SQL process). This process only ends when the SQL server is restarted.
  
Example:
In one real-life example:
  • Everything worked OK when using Controller 10.4.1 RTM (10.4.1100.133)
  • The problem started after upgrading/patching to  Controller 10.4.1 IF4 (10.4.1100.158)

Resolving The Problem

Fix:
Await the release of a future version of Controller 10.4.1.x, which contains a fix for APAR PH27153.
 
Then:
  • Obtain downtime (nobody using the system)
  • VITAL: Restart the Microsoft SQL database server (to end the looping SQL query)
  • Upgrade to the later version of Controller.
 
Workaround:
Downgrade to Controller 10.4.1 IF2.

Document Location

Worldwide

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS9S6B","label":"Cognos 8 Controller"},"ARM Category":[{"code":"a8m50000000KzNaAAK","label":"Publish Data (DM)"}],"ARM Case Number":"TS003899116","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 August 2020

UID

ibm16244110