Last updated on DECEMBER 18, 2015
Applies to:Siebel eConfigurator - Version 188.8.131.52.2 [IP2014] and later
Information in this document applies to any platform.
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 *****
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms