IBM Support

Error "BPCUI0002E Failed to retrieve data from the database." when navigating in the TPC 5.2 Web GUI

Troubleshooting


Problem

After a successful installation or upgrade to TPC 5.2, the following error may occur when navigating in the Web GUI: Error BPCUI0002E Failed to retrieve data from the database. The error is seen in the TPC log: /opt/IBM/TPC/web/log/tpctrace1.log 2013-11-14 14:07:44.971+01:00 -8263810662774370370 com.ibm.tpc.internal.api.util.Hypervisor getGenericSummarizedHealthStatus() TPCInternalAPIException: BPCUI0002E com.ibm.tpc.internal.api.TPCInternalAPIException: BPCUI0002E and Caused by: org.apache.openjpa.persistence.PersistenceException: DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=assert zzjn dim temp taob has a dummy resid , DRIVER=3.65.77 {prepstmnt 519600988

Resolving The Problem

This is a known DB2 issue:
APAR IC86835: SQL STATEMENT FAILS WITH SQL0901N (REASON "ASSERT ZZJN DIM TEMP TAOB HAS A DUMMY RESID ")
http://www-01.ibm.com/support/docview.wss?uid=swg1IC86835

Apply the "Local Fix" or upgrade to DB2 10.1 FP3

Related Information

[{"Product":{"code":"SS5R93","label":"IBM Spectrum Control"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"5.2","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
22 February 2022

UID

swg21660006