4 Replies Latest reply on Dec 30, 2016 5:38 AM by rpc1

    Error while SmartImport : oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.dwg.SQLWorkReposException: ORA-01795: maximum number of expressions in a list is 1000

    3261246

      Hi,

      My project has a nightly build process which runs in certain interval and imports xml files to the ODI repository. The import of xml files is automated using odi SDKs. Until recently, it was all running fine. Suddenly, it had started throwing error. Please help me with this. The log is as following.

       

      Dec 26, 2016 03:42:29 PM Importing EDW_RELATIONSHIP_MANAGEMENT

      Dec 26, 2016 03:46:29 PM EDW_RELATIONSHIP_MANAGEMENT successfully imported in 239seconds

      Dec 26, 2016 03:46:29 PM Importing EDW_RECEIVABLE_CUSTOMER

      oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.dwg.SQLWorkReposException: ORA-01795: maximum number of expressions in a list is 1000

       

      at com.sunopsis.dwg.smartie.SmartImportManager.internalDoSCOMatching(SmartImportManager.java:2008)

      at com.sunopsis.dwg.smartie.SmartImportManager.getSmartImportHierarchy(SmartImportManager.java:2549)

      at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.internalGetSmartImportHierarchy(ISmartImportInstanceImpl.java:198)

      at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.access$100(ISmartImportInstanceImpl.java:68)

      at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl$1.doAction(ISmartImportInstanceImpl.java:248)

      at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)

      at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)

      at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.getSmartImportHierarchy(ISmartImportInstanceImpl.java:243)

      at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.getSmartImportHierarchy(ISmartImportInstanceImpl.java:274)

      at oracle.odi.impexp.smartie.impl.SmartImportServiceImpl.importFromXml(SmartImportServiceImpl.java:104)

      at oracle.odi.impexp.smartie.impl.SmartImportServiceImpl.importObjectsFromXml(SmartImportServiceImpl.java:135)

      at smartimport.RunSmartImport.importODIMappings(RunSmartImport.java:185)

      at smartimport.RunSmartImport.connectODIRepo(RunSmartImport.java:155)

      at smartimport.RunSmartImport.run(RunSmartImport.java:94)

      at smartimport.SmartImport.main(SmartImport.java:44)

      Caused by: com.sunopsis.dwg.SQLWorkReposException: ORA-01795: maximum number of expressions in a list is 1000

       

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)

      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)

      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)

      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)

      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)

      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1270)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:5070)

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1677)

      at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

      at java.lang.reflect.Method.invoke(Method.java:497)

      at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:160)

      at com.sun.proxy.$Proxy3.executeQuery(Unknown Source)

      at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java:631)

      at com.sunopsis.dwg.dbobj.generated.GeneratedSnpObjState.getObjectLst(GeneratedSnpObjState.java:705)

      at com.sunopsis.dwg.smartie.SmartImportUtil.queryForDeferredLinks(SmartImportUtil.java:534)

      at com.sunopsis.dwg.smartie.SmartImportUtil.processDeferredLinks(SmartImportUtil.java:659)

      at com.sunopsis.dwg.smartie.SmartImportUtil.getTargetObjChildSCOs(SmartImportUtil.java:704)

      at com.sunopsis.dwg.smartie.MatchEngine.doSCOMatchingForSmartImportObject(MatchEngine.java:1517)

      at com.sunopsis.dwg.smartie.SmartImportManager.internalDoSCOMatching(SmartImportManager.java:1980)

      ... 14 more

       

      Thanks in advance. Attached is the code piece for smartimport automation.