New Join Changes In SWI Internal Product VOD Causing ORA-01795 Error (Doc ID 2090768.1)

Last updated on DECEMBER 18, 2015

Applies to:

Siebel eConfigurator - Version 8.1.1.14.2 [IP2014] and later
Information in this document applies to any platform.

Symptoms

After upgrading to IP2014, SWI Product Import Web Service failing to import and release the large Product Structure. It's failing with below error

 

1) Create CP product structure for 1000+ components
2) invoke the SWI Product Import Web Service through SOAP UI
3) Below SQL error is seen

ObjMgrLog Error 1 00004e53561a1200:0
2015-11-04 10:46:20 (oracon.cpp (3899)) SBL-DBC-00105: An error has occurred executing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.

SQLParseAndExecute Execute 5 00004e53561a1200:0 2015-11-04 10:46:20 ORA-01795: maximum number of expressions in a list is 1000

ObjMgrSqlCursorLog Execute 5 00004e53561a1200:0 2015-11-04 10:46:20 End: ExecuteStmt for Sql Cursor at 1935a250

ObjMgrSqlLog Detail 4 00004e53561a1200:0 2015-11-04 10:46:20 ***** SQL Statement Failed Execute Time for SQL Cursor with ID 1935A250: 0.083 seconds *****

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms