JR62368: CMIS QUERIES THAT QUERY FOR ECM DOCUMENTS DON'T WORK CORRECTLY IF TABLE ALIAS OR SELECT ALL COLUMNS ARE USED

8.5.7.201706-WS-BPM-IFJR62453
8.6.10019003-WS-BPM-IFJR62453
8.6.10019002-WS-BPM-IFJR62453
8.6.10019001-WS-BPM-IFJR62453
8.6.10018001-WS-BPM-IFJR62453
8.6.0.201803-WS-BPM-IFJR62453
workflow.20001.delta.repository

APAR status

• Closed as program error.

Error description

• In a BPD service endpoint where a CMIS query can be passed in as
  a parameter, the service doesn't return any documents if the
  IBM Business Process Manager (BPM) document CMIS query contains
  a table alias for the cmis:objectId column.
  
  For example, the following query uses table aliases:
  
  SELECT cmis:objectId AS id FROM IBM_BPM_Document
  
  Also, the following error message is returned when you run a
  CMIS query that contains Select all columns when configured in
  an ECM Coach like the ECM Document List:
  
  "The query contains an invalid object type ID"
  
  for example,
  
  SELECT * from Invoice WHERE (InvoiceNo = 10)
  
  This issue occurs after you install interim fix JR61612.
  
  PRODUCTS AFFECTED
  IBM Business Automation Workflow
  IBM Business Process Manager
  

Local fix

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is available or will be available that ensures a CMIS
  query works correctly when Select all columns or alias names
  with a BPD endpoint are used.
  

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

  BUS AUTO WORKFL

• Fixed component ID

  5737H4100

Applicable component levels