IBM Support

JR54229: THE PROCESS FEDERATION SERVER BPEL INDEXER STOPS INDEXING ON ORACLE BECAUSE OF AN ORA-01795 EXCEPTION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

Direct links to fixes

pfs.8570.delta.cf2016.09.repository
8.5.6.0-WS-BPMPFS-IFJR54658

 

APAR status

  • Closed as program error.

Error description

  • When Oracle is the database, the Process Federation Server
unexpectedly stops indexing Business Process Execution Language
(BPEL) instances and tasks. An exception similar to the
following exception is written to the SystemOut.log file:

[8/24/15 16:09:16:750 EST] 000000ad id=
com.ibm.bpm.federated.indexer.bpel.data.collectors.BpelMultilDoc
umentsDataCollector E
CWMFS3202E: Error occurred during retrieving process template
null data, exception is
com.ibm.bpm.federated.indexer.bpel.data.database.PersistenceExce
ption:
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of
expressions in a list is 1000

Local fix

  • ---

Problem summary

  • A database query on Oracle may includes a list of values (a
WHERE...IN (<list of values>), but the list must not be more
than 1000 items.

Problem conclusion

  • A fix is available for IBM BPM V8.5.6.0 that ensures that the
database query is structured so that the ORA-01795 exception
cannot occur.

On Fix Central (http://www.ibm.com/support/fixcentral), search
for JR54658.

 1. Select IBM Business Process Manager with your edition from
the product selector, the installed version to the fix pack
level, and your platform, and then click Continue.
 2. Select APAR or SPR, enter JR54658, and click Continue.

When you download fix packages, ensure that you also download
the readme file for each fix. Review each readme file for
additional installation instructions and information about the
fix.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR54229
    • 

  • Reported component name
    BPM ADVANCED
    • 

  • Reported component ID
    5725C9400
    • 

  • Reported release
    850
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2015-09-09
    • 

  • Closed date
    2016-01-21
    • 

  • Last modified date
    2016-01-21
    • 





    

  • 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
    BPM ADVANCED
    • 

  • Fixed component ID
    5725C9400
    • 



Applicable component levels


    

  • R856  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            21 January 2016
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback