IBM Support

RS03486: USING ORACLE, DECISION SERVICE DEPLOYMENT FROM THE BC FAILS "ORA-01795: MAXIMUM NUMBER OF EXPRESSIONS IN A LIST IS 1000"

Fixes are available

IBM Operational Decision Manager V8.10.3 Download Document
IBM Operational Decision Manager V8.10.3 Mod Pack
Operational Decision Manager for z/OS 8.10.3 Mod Pack
Operational Decision Manager V8.9.2.1: Interim Fix 20
Operational Decision Manager V8.9.2.2: Interim Fix 11
IBM Operational Decision Manager V8.9.2.3 Fix Pack
IBM Operational Decision Manager for z/OS 8.9.2.3 Fix Pack
Operational Decision Manager V8.9.2.1: Interim Fix 22
Operational Decision Manager V8.9.2.1: Interim Fix 23
Operational Decision Manager V8.9.2.1: Interim Fix 24
Operational Decision Manager for z/OS 8.10.2.2 Fix Pack
IBM Operational Decision Manager V8.10.2.2 Fix Pack
Operational Decision Manager V8.9.2.1: Interim Fix 26
Operational Decision Manager V8.9.2.1: Interim Fix 27
Operational Decision Manager V8.9.2.2: Interim Fix 13
Operational Decision Manager V8.9.2.1: Interim Fix 28
Operational Decision Manager V8.9.2.1: Interim Fix 30
Operational Decision Manager V8.9.2.1: Interim Fix 31
Operational Decision Manager V8.9.2.2: Interim Fix 14
Operational Decision Manager V8.9.2.1: Interim Fix 34
Operational Decision Manager V8.9.2.2: Interim Fix 15 for Decision Center
IBM Operational Decision Manager V8.10.4 Mod Pack

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This stack trace is printed server side:

Error: java.sql.SQLSyntaxErrorException: ORA-01795: maximum
number of expressions in a list is 1000

at
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494
)
at
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446
)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1052)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:537)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:255)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:610)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
ment.java:253)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
ment.java:86)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPr
eparedStatement.java:765)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleSt
atement.java:921)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
atement.java:1099)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
ePreparedStatement.java:3640)
at
oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPrepa
redStatement.java:1384)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePr
eparedStatement.java:3687)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(O
raclePreparedStatementWrapper.java:1165)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(W
SJdbcPreparedStatement.java:478)
at sun.reflect.GeneratedMethodAccessor133.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
ilog.rules.teamserver.transaction.logger.IlrStatementInvocationH
andler.executeStatement(IlrStatementInvocationHandler.java:59)
at
ilog.rules.teamserver.transaction.logger.IlrPreparedStatementInv
ocationHandler.invoke(IlrPreparedStatementInvocationHandler.java
:32)
at com.sun.proxy.$Proxy153.executeQuery(Unknown Source)
at
ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.retrieve
DetailsFromStatement(IlrElementDAOJDBC.java:10053)
at
ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.findElem
ents(IlrElementDAOJDBC.java:8309)
[...]
Caused by: Error : 1795, Position : 298, Sql = SELECT
ILOG.VARIABLE.ID, ILOG.VARIABLE.ORIGINALID, ILOG.VARIABLE.TYPE,
ILOG.VARIABLE.CONTAINER, ILOG.VARIABLE.TYPE,
ILOG.VARIABLE.BOMTYPE, ILOG.VARIABLE.INITIALVALUE,
ILOG.VARIABLE.NAME, ILOG.VARIABLE.VERBALIZATION from
ILOG.VARIABLE, ILOG.VARIABLESET, ILOG.VERSION where
((((ILOG.VERSION.BASELINE IN (758073, 22265, 22255, 535059,
22237, 188412, 22261, 18268, 1962, 188403, 22271, 231747, 6784,
22249, 48596, 1959, 628679, 1971, 22243, 241469, 740219, 758073,
758073, 758073, 758073, 758073, 758073, 758073,[...]758073,
758073, 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073))) AND ILOG.VERSION.ELTORIGINALID =
ILOG.VARIABLESET.ORIGINALID AND ILOG.VERSION.TYPE =
ILOG.VARIABLESET.TYPE AND ILOG.VARIABLE.BASELINE =
ILOG.VERSION.BASELINE AND ILOG.VERSION.ID =
ILOG.VARIABLESET.STARTID AND ILOG.VERSION.PROJECT =
ILOG.VARIABLESET.PROJECT AND ILOG.VARIABLE.CONTAINER =
ILOG.VARIABLESET.ORIGINALID AND ((ILOG.VARIABLESET.ENDID =
2147483647 AND ILOG.VERSION.ELTORIGINALID =
ILOG.VARIABLESET.ORIGINALID AND ILOG.VERSION.TYPE =
ILOG.VARIABLESET.TYPE AND ILOG.VERSION.ID =
ILOG.VARIABLESET.STARTID AND ILOG.VARIABLE.STARTID <=
ILOG.VARIABLESET.STARTID AND ILOG.VARIABLESET.ENDID <=
ILOG.VARIABLE.ENDID) ) AND ILOG.VARIABLESET.BASELINE =
ILOG.VARIABLE.BASELINE)) AND ILOG.VARIABLE.TYPE IN (39) AND
(ILOG.VARIABLE.CONTAINER = :1 ), OriginalSql = SELECT
ILOG.VARIABLE.ID, ILOG.VARIABLE.ORIGINALID, ILOG.VARIABLE.TYPE,
ILOG.VARIABLE.CONTAINER, ILOG.VARIABLE.TYPE,
ILOG.VARIABLE.BOMTYPE, ILOG.VARIABLE.INITIALVALUE,
ILOG.VARIABLE.NAME, ILOG.VARIABLE.VERBALIZATION from
ILOG.VARIABLE, ILOG.VARIABLESET, ILOG.VERSION where
((((ILOG.VERSION.BASELINE IN (758073, 22265, 22255, 535059,
22237, 188412, 22261, 18268, 1962, 188403, 22271, 231747, 6784,
22249, 48596, 1959, 628679, 1971, 22243, 241469, 740219, 758073,
758073, 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073,
[...], 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073, 758073, 758073, 758073, 758073, 758073, 758073,
758073, 758073, 758073, 758073))) AND ILOG.VERSION.ELTORIGINALID
= ILOG.VARIABLESET.ORIGINALID AND ILOG.VERSION.TYPE =
ILOG.VARIABLESET.TYPE AND ILOG.VARIABLE.BASELINE =
ILOG.VERSION.BASELINE AND ILOG.VERSION.ID =
ILOG.VARIABLESET.STARTID AND ILOG.VERSION.PROJECT =
ILOG.VARIABLESET.PROJECT AND ILOG.VARIABLE.CONTAINER =
ILOG.VARIABLESET.ORIGINALID AND ((ILOG.VARIABLESET.ENDID =
2147483647 AND ILOG.VERSION.ELTORIGINALID =
ILOG.VARIABLESET.ORIGINALID AND ILOG.VERSION.TYPE =
ILOG.VARIABLESET.TYPE AND ILOG.VERSION.ID =
ILOG.VARIABLESET.STARTID AND ILOG.VARIABLE.STARTID <=
ILOG.VARIABLESET.STARTID AND ILOG.VARIABLESET.ENDID <=
ILOG.VARIABLE.ENDID) ) AND ILOG.VARIABLESET.BASELINE =
ILOG.VARIABLE.BASELINE)) AND ILOG.VARIABLE.TYPE IN (39) AND
(ILOG.VARIABLE.CONTAINER = ?), Error Msg = ORA-01795: maximum
number of expressions in a list is 1000

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Decision Center users deploying in the Business Console      *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Decision Center incorrectly finding the name of the baseline *
* that contains the variable project when it should use the    *
* baseline name from the dependency.                           *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

    



Problem conclusion


    

  • The code was fixed.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    RS03486
    • 

  • Reported component name
    WS DECISION CTR
    • 

  • Reported component ID
    5725B6900
    • 

  • Reported release
    892
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2019-10-09
    • 

  • Closed date
    2019-10-11
    • 

  • Last modified date
    2019-10-11
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    WS DECISION CTR
    • 

  • Fixed component ID
    5725B6900
    • 



Applicable component levels


    

  • R892  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"892","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            24 November 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback