Fixes are available
APAR status
Closed as program error.
Error description
Duplicate Query Variable entries created in database during process instance migration . During process instance migration, duplicate entries can get created in BPEDB table QUERYABLE_VARIABLE_INSTANCE_T. This is observed when the migration instance contains a correlation set as well as query properties. Duplicates are characterized by same PIID and VARIABLE_NAME/PROPERTY_NAME. As a result of the data duplication query table queries can yield the following SQL error: . DB2 SQL Error: SQLCODE=-811, SQLSTATE=21000, SQLERRMC=null, DRIVER=4.12.55 . The error indicates more than one result returned in a scalar fulselect query.
Local fix
Problem summary
The entries in the QUERYABLE_VARIABLE_INSTANCE_T table are properties of BPEL process variables that are evaluated when variable is updated in the database. The problem did happen because this evaluation was triggered before the existing entries of this process instance where migrated to the new version. This resulted in new entries and finally to duplicate entries after the already existing entries where migrated.
Problem conclusion
The problem was fixed by changing the order in which the entities that belong to the process instance are migrated FIX AVAILABILITY: iFix for 8.0.1.0 is available on Fix Central, search for APAR JR46863 at http://www.ibm.com/support/fixcentral/ iFix for 8.0.1.1 is available on Fix Central, search for APAR JR46863 at http://www.ibm.com/support/fixcentral/ Fix is also included in 8.0.1.2 Fix is also included in 8.5.0.1 When obtaining any of the above fixes, be sure to download the accompanying readme, for itself and any prerequisite fixes, and review them thorougly.
Temporary fix
Comments
APAR Information
APAR number
JR46868
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-06-06
Closed date
2013-08-15
Last modified date
2013-08-15
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
R801 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
08 January 2022