search cancel

SV-Invalid Object LISA_PREF_VERSION in Registry logs

book

Article ID: 189241

calendar_today

Updated On:

Products

CA Cloud Test Mobile CA Application Test

Issue/Introduction

We are running Registry as a Windows Service which logs in as a user account.  The user account is then used with integrated security.

When logged in with one user, everything is fine.  When logged in as a different user, database connectivity fails with the error message "Invalid Object LISA_PREF_VERSION"

I asked the DBA to verify permissions on LISA_PREF_VERSION, but apparently no object exists by that name.

Hence, we could use some help figuring out what DevTest is complaining about.

Database is SQL Server 2017.

Cause

Not enough permission on the User trying to create the Database Tables. 

Environment

Release : 10.5

Component : CA Service Virtualization

Resolution



While creation of the Registry database, the user must be a db_owner. (CREATE, SELECT, UPDATE, DELETE , INSERT , ALTER, ) in SQL SERVER

Once the Database is created , you can reduce the permissions to Read , write and execute on the Database.

SELECT UPDATE DELETE INSERT .