Article - CS411690

PAI Cube building failed with error "255:: Error occured while performing external sorting" in Servigistics Intellicus

Modified: 11-Feb-2026   


Applies To

  • Servigistics Intellicus 7.3 NA to 25.1

Description

  • PAI Cube Building process fails with error:
    • ------------------------------------------------------------------------------------------------------
      Build Failed
      --------------------Last Build Summary--------------------
      Build Type : Full
      Build No : 1
      Completed On : <dateTime>
      Summary:
      -1:: java.lang.NullPointerException
      255:: Error occured while performing external sorting
      204021:: Error while building CUBE.
      204029:: Failed to build cube as failed to get cube object details from repository
      
      --------------------All Build Summary--------------------
      Completed On :  <dateTime>
      Summary :
      -1:: java.lang.NullPointerException
      255::Error occured while performing external sorting
      204021::Error while building CUBE.
      204029::Failed to build cube as failed to get cube object details from repository
      ------------------------------------------------------------------------------------------------------
    • Intellicus ReportEngine log contains:
      • <datetime> <thread>  : Trying to acquire new connection object for: DemoStagingDB
        <datetime> <thread>  : DBConnPooling: Populating new batch with size = 5 for pool =
        <datetime> <thread>  : DBConnPooling: Total DB connections in all pools of container:DemoStagingDB are =30
        <datetime> <thread>  : DBConnPooling: Populating failed,expansion capacity fell short
        <datetime> <thread>  : Failed to expand the connection pool:
        <datetime> <thread>  : DBConnPooling: Populating new batch with size = 5 for pool =
        <datetime> <thread>  : DBConnPooling: Total DB connections in all pools of container:DemoStagingDB are =30
        <datetime> <thread>  : DBConnPooling: Populating failed,expansion capacity fell short
        <datetime> <thread>  : Failed to expand the connection pool:
        <datetime> <thread>  : 17918041:Unable to acquire connection. Either increase the connection Timeout settings or increase the maximum number of connections in the Pool
        com.impetus.interaj.providers.DataProviderException: 76~X~Unable to acquire connection. Either increase the connection Timeout settings or increase the maximum number of connections in the Pool
        at com.impetus.interaj.dataprovider.connection.ConnectionPool.acquireConnection(ConnectionPool.java:808) [?:?]
        at com.impetus.interaj.dataprovider.connection.DBConnectionPool.acquireConnection(DBConnectionPool.java:80) [?:?]
        at com.impetus.interaj.dataprovider.connection.ConnectionPoolContainer.acquireConnection(ConnectionPoolContainer.java:1380) [?:?]
        at com.impetus.interaj.dataprovider.connection.ConnectionManager.acquireConnection(ConnectionManager.java:4181) [?:?]
        at com.impetus.interaj.dataprovider.connection.ConnectionManager.acquireConnection(ConnectionManager.java:4211) [?:?]
        at com.impetus.interaj.dataprovider.DataSourceManager.getDSConnection(DataSourceManager.java:287) [?:?]
        at com.impetus.interaj.dataprovider.rdbms.JDBCDataSourceManager.getDSConnection(JDBCDataSourceManager.java:936) [?:?]
        at com.impetus.interaj.dataprovider.rdbms.JDBCDataSourceManager.executeQuery(JDBCDataSourceManager.java:1010) [?:?]
        at com.impetus.interaj.dataprovider.rdbms.RDBMSResultSet.executeQueryOnDataSourceManager(RDBMSResultSet.java:1589) [?:?]
        at com.impetus.interaj.dataprovider.rdbms.RDBMSResultSet.executeFinalQueryOnDataSource(RDBMSResultSet.java:1776) [?:?]
        at com.impetus.interaj.dataprovider.rdbms.RDBMSResultSet.executeSQLQuery(RDBMSResultSet.java:1650) [?:?]
        at com.impetus.interaj.dataprovider.rdbms.RDBMSResultSet.executeAsTable(RDBMSResultSet.java:1333) [?:?]
        at com.impetus.interaj.dataprovider.etl.BaseResultSet.executeResultSetAsProcedureOrTableOrDefault(BaseResultSet.java:2646) [?:?]
        at com.impetus.interaj.dataprovider.etl.BaseResultSet.populate(BaseResultSet.java:1332) [?:?]
        at com.impetus.interaj.dataprovider.rdbms.RDBMSResultSet.populate(RDBMSResultSet.java:3062) [?:?]
        at com.impetus.interaj.dataprovider.etl.sort.DatabaseSort.applySorting(DatabaseSort.java:167) [?:?]
        at com.impetus.interaj.dataprovider.etl.sort.SortedResultSet.applySorting(SortedResultSet.java:135) [?:?]
        at com.impetus.interaj.dataprovider.etl.sort.SortedResultSet.run(SortedResultSet.java:201) [?:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
This is a printer-friendly version of Article 411690 and may be out of date. For the latest version click CS411690