Failed statement: CREATE INDEX IX_LISA_TEMP_TABLE1__ ON LISA_TEMP_TABLE1

Products

• CA Application Test
• Service Virtualization

Issue/Introduction

Recently had a Linux patch applied to our DevTest machine.

Since patch was applied Registry has this error:

2019-11-27 20:27:19,343Z (15:27) [main] ERROR System.err                     - [DevTest AGENT:][ERROR][21171][1][main][Nov 27, 2019 3:27:19 PM] !!!!!!!! Database user permission check failed !!!!!!!!

2019-11-27 20:27:19,403Z (15:27) [main] ERROR System.err                     - [DevTest AGENT:][ERROR][21171][1][main][Nov 27, 2019 3:27:19 PM] Please ensure the user has privileges to create/alter/drop table, view, procedure and index and manipulate data.

2019-11-27 20:27:19,403Z (15:27) [main] ERROR System.err                     - [DevTest AGENT:][ERROR][21171][1][main][Nov 27, 2019 3:27:19 PM] Failed statement: CREATE INDEX IX_LISA_TEMP_TABLE1__ ON LISA_TEMP_TABLE1__ (COL2)  Error: INDEX command denied to user 'svc_evuinonprod'@'va1amgtlsql0003.aca.afsiep.net' for table 'lisa_temp_table1__'

 

Cause

Recent Linux patch had been applied and the server re-booted without bringing down all DevTest components.  Not absolutely sure this is the cause, but the database was running with no issues before the patch was applied.

Environment

Release : 10.5

Component : CA Service Virtualization

Resolution

Needed to create a new Registry database.

Basically, the IX_LISA_TEMP_TABLE1__ is used to check whether the user has DB permissions to create the Lisa tables or not.

/**
* Checks whether it is possible and safe to change inner database structure. If migration is
* going to take place, it places safeguard before this process is started and makes
* sure user does have appropriate permissions.
*/