search cancel

Devtest connectivity issue with Oracle 19c database

book

Article ID: 215697

calendar_today

Updated On:

Products

CA Application Test

Issue/Introduction

Installed DevTest on new server with default Derby DB and able to start the services and connect to it. Then configured the Oracle DB connection details in site.properties and started Registry and seen the following errors:

2021-05-13 07:09:34,484Z (00:09) [main] ERROR com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - Cannot execute DDLs for module REPORTING
2021-05-13 07:09:34,485Z (00:09) [main] ERROR com.itko.lisa.coordinator.TestRegistryImpl - Database initialization is not possible in module REPORTING. Not enough permissions for current db user.
com.itko.lisa.exception.UpgradeException: Database initialization is not possible in module REPORTING. Not enough permissions for current db user.
at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfDatabaseCanBeChanged(DatabaseSafeGuard.java:86)
at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2191)

Environment

Release : 10.6

Component : CA Application Test for Mobile

Database:  Oracle 19.7

Cause

ojdbc7 jar for Oracle 19.7 caused the issue.

Resolution

The reported error is throwing from the oracle driver (ojdbc7). It is recommended to replace ojdbc7 jar with ojdbc8 jar for Oracle database version 19.7. Please do the below to resolve the issue.
. Dowload the ojdbc8.jar from  https://www.oracle.com/database/technologies/appdev/jdbc-ucp-19-7-c-downloads.html.
. Place the ojdbc8 jar in Devtest_home/lib/shared folder.
. Remove the ojdbc7 jar.
. Restart the Registry after making the above changes.