Error in fetching jobs for tasksessionID: java.lang.NullPointerException after Oracle table move

Products

• CA Identity Suite
• CA Identity Manager

Issue/Introduction

Client needed to move the Task Persistence and Audit tables into one Oracle host and two separate schemas. Once the tables were moved, we were unable to select existing tasks from the "View Submitted tasks" UI.  When selecting the tasks you receive:

 java.lang.NullPointerException

 

Server.logs returns:

ERROR [ims.RuntimeStatusDetail] (default task-2) Error in fetching jobs for tasksessionID XXXXX-XXXXXX-XXXXXX-XXXXX java.lang.NullPointerException
    at com.netegrity.ims.persistence.PersistenceProvider.getTaskSessionFromResultSet(PersistenceProvider.java:5038)
    at com.netegrity.ims.persistence.PersistenceProvider.getTaskSession(PersistenceProvider.java:347)

Environment

Standalone

14.4.2

Oracle database

Cause

The Task Persistence and Audit tables were migrated from one location to another.  This seemed to be complete.  When I reviewed the tasksession tables and compared them with the old location, we found no BLOB data was moved.  BLOB data was null in the new location.  SQL server moves over all data including BLOB data without additional configuration.  This is not true with Oracle

Resolution

The Oracle DBA found by default, the BLOB data was not set to be moved over with the migration.  Once the full data including the BLOB data was moved, the issue was resolved. All new and existing tasks could be viewed.