My Oracle Support Banner

EIM Job To Load LOV Is Failing in IP17 (Doc ID 2592317.1)

Last updated on JUNE 01, 2023

Applies to:

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

Symptoms

EIM Job to load LOV is failing

Import LOV using EIM job, used LOV.ifb created by the utility provided for EIM LOV Load. The Job is failing and not able to load LOVs in DR environment.
Getting below error in log.


ERROR
-----------------------

IMTrace EIMTraceSubEvent 3 0000284b5d787189:0 2019-09-20 05:37:10 9/20/19 5:37 Error SBL-EIM-00107: ODBC error 37000:
EIMTrace EIMTraceSubEvent 3 0000284b5d787189:0 2019-09-20 05:37:10 [1076673536][ODBC Oracle driver][Oracle]ORA-00900: invalid SQL statement
EIMTrace EIMTraceSubEvent 3 0000284b5d787189:0 2019-09-20 05:37:10 (native error 900)
EIMTrace EIMTraceSubEvent 3 0000284b5d787189:0 2019-09-20 05:37:10 9/20/19 5:37 Warning: Pre-session SQL statement for [List of Value] failed.
GenericLog GenericError 1 0000284b5d787189:0 2019-09-20 05:37:10 (compmain.cpp (1565) err=65643 sys=0) SBL-EIM-00107: ODBC (SQL) error
GenericLog GenericError 1 0000284b5d787189:0 2019-09-20 05:37:10 (smisched.cpp (923) err=65643 sys=0) SBL-EIM-00107: ODBC (SQL) error
SQLTraceAll SQLTraceAll 4 0000284b5d787189:0 2019-09-20 05:37:10 (SQLFreeStmt) Conn Handle: 156886568, Stmt Handle: 159191568, Time : 0.028ms
SQLStatementOptions Free Statement 4 0000284b5d787189:0 2019-09-20 05:37:10 (SQLFree Stmt) Conn Handle: 156886568, Stmt Handle: 159191568, Time: 0.028ms
SQLStatementOptions Free Statement Details 5 0000284b5d787189:0 2019-09-20 05:37:10 (SQLFreeStmt) Option: SQL_DROP
SQLTraceAll SQLTraceAll 4 0000284b5d787189:0 2019-09-20 05:37:10 (SQLFreeStmt) Conn Handle: 156886568, Stmt Handle: 159244168, Time : 0.053ms
SQLStatementOptions Free Statement 4 0000284b5d787189:0 2019-09-20 05:37:10 (SQLFree Stmt) Conn Handle: 156886568, Stmt Handle: 159244168, Time: 0.053ms
SQLStatementOptions Free Statement Details 5 0000284b5d787189:0 2019-09-20 05:37:10 (SQLFreeStmt) Option: SQL_DROP







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
References


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