Unable to populate cache in the server.log

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

In the server.log file from Identity Manager, there is the following error message:

----------------------------

09:03:51,964 DEBUG [ims.jdbc.JDBCManagedObjectProvider] (ServerService Thread Pool -- 121) SELECT "IM_ENVIRONMENT_JDBC"."UNIQUE_NAME", "VERSION", "SMOID", "DIRECTORYDN", "PUBLICALIAS", "ALIAS", "DESCRIPTION", "FRIENDLYNAME" FROM "IM_ENVIRONMENT_JDBC" WHERE "UNIQUE_NAME"=? ORDER BY "UNIQUE_NAME"  DESC (4)
09:03:51,964 DEBUG [ims.jdbc.JDBCManagedObjectProvider] (ServerService Thread Pool -- 121) Is scroll insensitive result set type: true
 Is forward only result set type: false
09:03:51,964 DEBUG [ims.jdbc.JDBCManagedObjectProvider] (ServerService Thread Pool -- 121) No results found from the query: SELECT  FROM  WHERE "UNIQUE_NAME"='4'
09:03:51,964 ERROR [ims.jdbc.JDBCManagedObjectProvider] (ServerService Thread Pool -- 121) Unable to populate cache: No object of type IM ENVIRONMENT JDBC found for identifier '4'

----------------------------

Environment

Identity Manager 14.x

Cause

There is some reference for an old environment ID (OID) in the Identity Manager database.

Resolution

In your Identity Manager database, check if you have the environment ID mentioned in the server.log.

In our case, the error message refers to env_oid = 4

--------

No object of type IM ENVIRONMENT JDBC found for identifier '4'

--------

 

Search in all tables below and check if there is some reference to env_oid or envoid in the tables below:

bulk_task
connection
Explore_and_correlate 
FWPASSWORDPOLICY
IM_Admin_policy
IM_certification_policy
IM_member_policy
IM_owner_policy
IM_role_task
IM_role
IM_screen_definition
IM_screen_field
IM_screen
IM_Tab
IM_Admin_policy
IM_task_handler
IM_task
PX_action_element
PX_condition
PX_data_element
PX_policy
PX_rule
PX_when
AUXdata12
auxdataproviders12
DX_TMP_DATA
SNAPSHOT_TYPE
IM_TAB_DEFINITION
IM_IDENTITY_POLICY_SET
IM_IDENTITY_POLICY
IM_APPROVAL_POLICY
IM_WEBSERVICE_CONFIG
IM_WEBSERVICE_CUSTOM
FWSERVICE
FWSERVICE_PREREQUISITES
FWSERVICE_REQUEST
RPTINSTANCE
WF_ACTIVITY_INSTANCE
WF_PROCESS_INSTANCE
WF_WORK_ITEM
WF_WORK_ITEM_ASSIGNEES
imsAuditTaskSession12
imsAuditEvent12

 

Backup the table and delete the row(s) which refers to the value of environment id you see in the server.log, after that restart the Identity Manager service.

 

Additional Information

Clustered vApp seeing old OID