Direct links to fixes
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 number
JR62368
Reported component name
BUS AUTO WORKFL
Reported component ID
5737H4100
Reported release
I00
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-06-03
Closed date
2020-06-10
Last modified date
2020-06-18
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS8JB4","label":"IBM Business Automation Workflow"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"18.0.0.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
20 July 2020