Issues installing CABI on Linux RHEL with Oracle DB "sequence does not exist"

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Running into some issues when installing Cabi v 8.00 probe with Oracle database 19c as the backend database

Errors below seen in the Cabi.log during the installation:

[Thread-1, cabi]      [exec]      [java] 2024-04-16T11:13:33,741 ERROR SqlExceptionHelper:142 - [TibcoSoftware][Oracle JDBC Driver][Oracle]ORA-02289: sequence does not exist
[Thread-1, cabi]      [exec]      [java] 
[Thread-1, cabi]      [exec]      [java] org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [2289]; could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

Environment

Version: Any
Component: cabi 8.0x

 

 

Resolution

1. Execute the cabi clean script per article How to uninstall and then reinstall CABI in DX UIM 23.4.0

2. Consult with DBA to manually create the hibernate_sequence as below:

    create sequence <databasename>.hibernate_sequence START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;

The CA_UIM is the default name of the UIM database, modify the query above to reflect the correct UIM database. 

3. Query below can be used to validate the presence of the hibernate_sequence

    select object_name,owner,object_type from dba_objects where object_name='HIBERNATE_SEQUENCE';

4. Re-deploy the cabi probe

Additional Information

How to uninstall and then reinstall CABI in DX UIM 23.4.0