Can’t open BusinessConnect Certificate Store.

Can’t open BusinessConnect Certificate Store.

book

Article ID: KB0082151

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect 6.X.X

Description

In the Administrator, when opening BusinessConnect > System Settings > Certificate Store we can see attached (Error.png) error screenshot. In the administrator logs, this error occurs:

<<<<<
Caused by: java.lang.NullPointerException
    at com.tibco.ax.gui.bcwebadmin.consoles.ss.castore.CredentialListAdapter.getCollection(CredentialListAdapter.java:110)
    at com.tibco.ax.gui.bcwebadmin.consoles.ss.castore.CaTableModel.applyFilter(CaTableModel.java:69)
>>>>>

Issue/Introduction

Can’t open BusinessConnect Certificate Store.

Environment

All

Resolution

Perform the query shown below. This will give the identifiers of business entities (transports, etc), plus any missing participants. Please note the query doesn't identify all missing business entities for which a credential item can be associated because a full query would be quite complex, and disclose persistence layer details which should not be disclosed.

SELECT OWNER_OID, CLAZZ FROM BC_KEYSTOREITEM WHERE OWNER_OID NOT LIKE ServerInfo?% AND OWNER_OID NOT LIKE DmzInfo?% AND OWNER_OID NOT IN (SELECT OBJOID FROM BC_PARTICIPANT); 

Please note: ServerInfo?% and DmzInfo?% should be wrapped in single quotes when executed on the database.

No database backup is required as this is a select operation.

The result of this query returns records of credential entities owned by participants that do not exist in system (orphan records). 
Make a backup of bc_keystoreitem table data and delete these records. This should solve the problem.