My Oracle Support Banner

LOV_EIM.exe Database Error Cannot find the object 'LOV_EIM_LOAD', because it does not exist or you do not have permission on SQL Server (Doc ID 2539861.1)

Last updated on DECEMBER 23, 2019

Applies to:

Siebel CRM - Version 19.4 and later
Information in this document applies to any platform.

Symptoms

Running the LOV_EIM.exe on 19.4 on SQL Server without locking Project 'Table Common' gives the below error

ERROR
-----------------------
DBCLog DBCLogError 1  [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'LOV_WS_REPO_ID'.

SQLError Statement 0  SQL Statement:
GRANT EXECUTE ON LOV_EIM_LOAD TO SSE_ROLE

DBCLog DBCLogError 1 [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot find the object 'LOV_EIM_LOAD', because it does not exist or you do not have permission.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from 19.2 to 19.4
2. Run LOV_EIM.exe


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.