IBM Support

IV90908: BUILDING MIGRATION CHANGE PACKAGE USERS ARE GETTING AN ORACLE LIMITATION IN WHICH A MAXIMUM OF 1000 LIST ITEMS WERE EXCEEDED

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When building a migration change package users are encountering
    an Oracle limitation in which a Maximum of 1000 list items were
    exceeded.
    
    
    PROBLEM:
    
    When building a migration change package we are encountering an
    Oracle
    limitation in which a Maximum of 1000 list items were exceeded.
    We
    encountered this on some changes to the APPLICATIONAUTH table.
    See the
    attached SQL that failed. The workaround was to do a snapshot
    for
    security but this limitation is at the database level.
    
    java.sql.SQLException: ORA-01795: maximum number of expressions
    in a list is 1000
    
     at
    oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMappi
    ng.java:74)
     at
    oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.j
    ava:131)
     at
    oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError
    .java:204)
     at
    oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
     at
    oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
     at
    oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
     at
    oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.
    java:780)
     at
    oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatemen
    t.java:855)
     at
    oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
    atement.java:1186)
     at
    oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.
    java:1377)
     at
    oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleSta
    tementWrapper.java:387)
     at psdi.mbo.MboSet.getDBValue(MboSet.java:4200)
     at psdi.mbo.MboSet.getDBValue(MboSet.java:4041)
     at psdi.mbo.MboSet.getDBCalc(MboSet.java:4270)
     at psdi.mbo.MboSet.count(MboSet.java:3630)
     at psdi.mbo.MboSet.count(MboSet.java:3644)
     at psdi.mbo.MboSet.count(MboSet.java:3595)
     at
    psdi.dm.DMPackageDef.extractChangeRecordsForMboSet(DMPackageDef.
    java:1072)
     at
    psdi.dm.DMPackageDef.extractChangeRecordsForMbo(DMPackageDef.jav
    a:1140)
     at
    psdi.dm.DMPackageDef.extractChangeRecordsForMboSet(DMPackageDef.
    java:1102)
     at
    psdi.dm.DMPackageDef.extractRecordsForMos(DMPackageDef.java:613)
     at
    psdi.dm.DMPackageDef.extractRecordsForCfgGroup(DMPackageDef.java
    :548)
     at
    psdi.dm.DMPackageDef.loadCFGDATAGrpsForPkg(DMPackageDef.java:380
    )
     at
    psdi.dm.DMPackageDef.loadStagingForPkg(DMPackageDef.java:1500)
     at psdi.dm.DMPackageDef.createPackage(DMPackageDef.java:247)
     at
    psdi.dm.DMPackageDef.extractPkgData(DMPackageDef.java:202)
     at
    psdi.webclient.beans.dm.DMPackageBean.continueCreatePackage(DMPa
    ckageBean.java:268)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
    Method)
     at
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
    Impl.java:95)
     at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:56)
     at java.lang.reflect.Method.invoke(Method.java:620)
     at
    psdi.webclient.system.session.AsyncProcess.run(AsyncProcess.java
    :171)
     at java.lang.Thread.run(Thread.java:809)
    
    
    PERFORMANCE ISSUE: No.
    
    STEPS TO REPRODUCE:
    
    1.Create a Package Definition to Track changes for security
    changes
    2.Approve and Set to Active
    3.Go to "Security Groups" application
    4.Add new Security Group
    5.Go to the "Applications" tab
    6.Click the "Grant Listed Applications" and then "All Above"
    7.Save
    8.Click the "Revoke Listed Applications" and then "All Above"
    9.Save
    10.Go back to the Migration Manager and open the package
    definition created in Step 1.
    11.Navigate to the "Package" tab
    12.Select the "Create" under the packages section
    13.This is where I get the Error message.
    
    
    BMXAA5198E - Could not create package
    TestPckg_uxeamdq1_EAMB_MAXIMO_20161020131716.
    BMXAA4210E - Database error number 1795 has occurred. Invalid
    SQL queries are logged in the log file. Check the SQL query to
    identify the error.
    
    BMXAA6163I - [10/20/16 1:17 PM] Could not export configuration
    records to the staging table for package
    TestPckg_uxeamdq1_EAMB_MAXIMO_20161020131716.
    
    
    CURRENT ERRONEOUS RESULT:
    
    Not able to create a migration package with more than 1000
    lines.
    
    EXPECTED RESULT:
    
    Should be able to create a migration package with more than
    1000 lines.
    
    ENVIRONMENT (SYSTEM INFO):
    
    App Server  IBM WebSphere Application Server 8.5.5.8
    Version  Tivoli's process automation engine
    7.6.0.3-IFIX20160608-1323
    Build 20160113-2204 DB Build V7603-151 HFDB Build HF7603-03IBM
    TPAE
    Integration Framework 7.6.0.3 Build 20160108-1912 DB Build
    V7603-21TPAE
    OSLC Object Structure 7.6.0.0 Build 20160112_031200-0600 DB
    Build V7600-
    01IBM Maximo Asset Management Scheduler 7.6.2.0 Build
    20160114-1313 DB
    Build V7620-42IBM Maximo Spatial Asset Management
    7.5.0.1-20160108-0823
    Build 20120714-2208 DB Build V7501-13 HFDB Build HF7501-07IBM
    Maximo
    Anywhere 7.6.0.0 Build 20160112_031213-0600 DB Build
    V7600-03IBM Maximo
    for Utilities 7.5.0.1-20160823-1200 Build 20120710-0136 DB
    Build V7501-
    14 HFDB Build HF7501-12IBM Maximo Asset Management 7.6.0.3 Build
    20160113-2204 DB Build V7603-01
    Server OS  Windows Server 2012 R2 6.3
    Server DB  Oracle 12.1 (Oracle Database 12c Enterprise Edition
    Release
    12.1.0.2.0 - 64bit Production With the Partitioning, OLAP,
    Advanced
    Analytics and Real Application Testing options)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MAXIMO                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * BUILDING MIGRATION CHANGE PACKAGE USERS ARE GETTING AN       *
    * ORACLE LIMITATION IN WHICH A MAXIMUM OF 1000 LIST ITEMS WERE *
    * EXCEEDED                                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    package:
    	 | release\fix pack | Interim Fix for Release 7.6.0.8 Product
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV90908

  • Reported component name

    MIGRATION MANAG

  • Reported component ID

    5724R46MI

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-11-18

  • Closed date

    2017-02-24

  • Last modified date

    2017-02-24

  • 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

    MIGRATION MANAG

  • Fixed component ID

    5724R46MI

Applicable component levels

  • R760 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"}, "Product":{"code":"SSCLJ96","label":"Migration Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":""}]

Document Information

Modified date:
24 February 2017