IBM Support

PI13677: WHEN LOGGED IN AS THE ADMIN USER, UNABLE TO VIEW PROJECTS PAGE -4.3.1

Fixes are available

IBM uBuild 5.0.1
IBM uBuild Fix Pack 1 (5.0.1.1) for 5.0.1
IBM uBuild Fix Pack 2 (5.0.1.2) for 5.0.1
IBM uBuild Fix Pack 3 (5.0.1.3) for 5.0.1
IBM uBuild Fix Pack 4 (5.0.1.4) for 5.0.1
IBM uBuild Fix Pack 5 (5.0.1.5) for 5.0.1
IBM uBuild Fix Pack 6 (5.0.1.6) for 5.0.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The uBuild admin user cannot view Projects page due to
PersistenceException:

Output from the logs:
com.urbancode.ubuild.domain.persistent.PersistenceException:
Error restoring Project objects : ORA-01795: maximum number of
expressions in a list is 1000

        at
com.urbancode.ubuild.domain.persistent.DaoSql.restoreRangeForSQL
Query(DaoSql.java:471)
        at
com.urbancode.ubuild.domain.persistent.DaoSql.restoreFirstResult
sForSQLQuery(DaoSql.java:394)
        at
com.urbancode.ubuild.domain.persistent.DaoSql.restoreAllForSQLQu
ery(DaoSql.java:358)
        at
com.urbancode.ubuild.domain.project.ProjectDaoSql.restoreAll(Pro
jectDaoSql.java:142)
        at
com.urbancode.ubuild.domain.project.ProjectDaoSql.restoreAll(Pro
jectDaoSql.java:45)
        at
com.urbancode.ubuild.persistence.UnitOfWorkDefault.restoreAll0(U
nitOfWorkDefault.java:755)
        at
com.urbancode.ubuild.persistence.UnitOfWork.restoreAll(UnitOfWor
k.java:669)
        at
com.urbancode.ubuild.domain.project.ProjectFactory.restoreAll(Pr
ojectFactory.java:70)
        at
com.urbancode.ubuild.web.dashboard.DashboardTasks.viewDashboard(
DashboardTasks.java:81)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum
number of expressions in a list is 1000

        at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
        at
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
        at
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
ment.java:207)
        at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPr
eparedStatement.java:884)
        at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleSt
atement.java:1167)
        at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
atement.java:1289)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
ePreparedStatement.java:3584)
        at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePr
eparedStatement.java:3628)
        at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(O
raclePreparedStatementWrapper.java:1493)
        at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery
(DelegatingPreparedStatement.java:92)
        at
com.p6spy.engine.logging.P6LogPreparedStatement.executeQuery(P6L
ogPreparedStatement.java:172)
        at
com.urbancode.ubuild.domain.persistent.DaoSql.restoreRangeForSQL
Query(DaoSql.java:448)
        ... 161 more

Local fix

  • None at this time

Problem summary

  • ****************************************************************
* USERS AFFECTED:                                              *
* All Adminstrators                                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Issues were encountered with viewing projects page as Admin  *
* user.                                                        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

Problem conclusion

  • A fix is provided in IBM uBuild 5.0.1

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI13677
    • 

  • Reported component name
    UBUILD
    • 

  • Reported component ID
    5725M7500
    • 

  • Reported release
    500
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2014-03-13
    • 

  • Closed date
    2014-04-02
    • 

  • Last modified date
    2014-04-02
    • 





    

  • 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
    UBUILD
    • 

  • Fixed component ID
    5725M7500
    • 



Applicable component levels


    

  • R500  PSN
       UP
    • 

  • R500  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS4JLT","label":"IBM uBuild"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            17 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback