Registry Service not able to start - Failed statement: CREATE TABLE LISA_TEMP

Products

Service Virtualization

Issue/Introduction

Our DBA created DEVTEST Tables for IAM , ED , Registry and CAI using the DDL from DevTest/Database folder with DBA privileges. Once the tables are created , we created a user - APPUser in Oracle, that has less privileges to start all the DevTest components.

IAM and ED starts fine.

While starting Registry service, its giving the error message.

The error message

2021-04-12 20:46:02,108Z (16:46) [main] ERROR System.err - [DevTest AGENT:][ERROR][9328][21][main][Apr 12, 2021 4:46:02 PM] !!!!!!!! Database user permission check failed !!!!!!!!

2021-04-12 20:46:03,277Z (16:46) [main] ERROR System.err - [DevTest AGENT:][ERROR][9328][21][main][Apr 12, 2021 4:46:03 PM] Please ensure the user has privileges to create/alter/drop table, view and index and manipulate data.

2021-04-12 20:46:04,301Z (16:46) [main] ERROR System.err - [DevTest AGENT:][ERROR][9328][21][main][Apr 12, 2021 4:46:04 PM] Failed statement: CREATE TABLE LISA_TEMP_TABLE1__ (COL1 varchar(10) not null, COL2 varchar(10)) Error: ORA-01031: insufficient privileges

2021-04-12 20:46:05,337Z (16:46) [main] ERROR com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard - DDLs cannot be executed in this module REPORTING database user does not have sufficient permissions.

2021-04-12 20:46:05,337Z (16:46) [main] ERROR com.itko.lisa.coordinator.TestRegistryImpl - Database initialization is not possible in module REPORTING. Not enough db permissions to execute DDL statements.

com.itko.lisa.exception.UpgradeException: Database initialization is not possible in module REPORTING. Not enough db permissions to execute DDL statements.

at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfAllDatabasesAreWritable(DatabaseSafeGuard.java:157)

at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfMigrationIsPossible(DatabaseSafeGuard.java:134)

at com.itko.lisa.utils.db.safeguard.DatabaseSafeGuard.checkIfDatabaseCanBeChanged(DatabaseSafeGuard.java:104)

at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2191)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

at com.exe4j.runtime.WinLauncher$2.run(Unknown Source)

This is critical and impacting our onboarding for perf testing.

Environment

Release : 10.7 or newer

Component : CA Service Virtualization

Cause

BAsed on what we found in the latest log file , it could be seen that we are trying to setup agent schema " Creating Pathfinder Schema"

Resolution

For DB users with less priviledges, Make sure you set the property lisa.database.migration.safeguards to false in local.properties. It is true by default. It is important to ensure that the db user has dba level privileges during the upgrade.

1. in local.properties add :

lisa.database.migration.safeguards=false

2. for the error you are seeing, its trying to create the Agent tables.

Changed rules.xml to skip setting up the Broket/Agent tables.

Solution to skip setting AGENT/Broker tables:

Edit rules.xml file in LISA_HOME folder. Add the XML elements in bold. Make sure you add the property separately under agent, broker and console sections as shown below. Save the file and restart registry.

<?xml version="1.0" encoding="UTF-8"?><rules>
<agent guid="-2032180703" name="DEFAULT">
<property comment="Enable querying of the JMX counters via the agent" key="lisa.agent.jmx.enabled" value="true"/>
   <property comment="Persistence" key="PERSISTENCE_DISABLED" value="true"/>
</agent>

<broker>
<property comment="The logging level of the root category" key="lisa.log.level" value="dev"/>
   <property comment="Persistence" key="PERSISTENCE_DISABLED" value="true"/>
</broker>

<console>
<property comment="Broker url when run in embedded mode (i.e. in LW)" key="lisa.console.agent.broker.url" value="tcp://localhost:2009?daemon=true"/>
   <property comment="Persistence" key="PERSISTENCE_DISABLED" value="true"/>
</console>
</rules>

3. Also , make sure the connection pool size is at a higher number, and you don't get starvation on connection pools.