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__'
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.
Release : 10.5
Component : CA Service Virtualization
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.
*/