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

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