Direct links to fixes
2.3.0.1-CSI-ISCO-IF0009
Version 7.5.1 Fix Pack 2 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 5 for the IBM Business Process Manager products
Download Version 8.0.1 Fix Pack 3 for the IBM Business Process Manager products
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products
IBM SmartCloud Orchestrator Interim Fix 7 for 2.3.0.1
IBM SmartCloud Orchestrator Interim Fix 6 for 2.3.0.1
IBM SmartCloud Orchestrator Interim Fix 5 for 2.3.0.1
IBM SmartCloud Orchestrator Interim Fix 8 for 2.3.0.1
IBM SmartCloud Orchestrator Interim Fix 9 for 2.3.0.1
APAR status
Closed as program error.
Error description
Due to performance consideration, displayName of sub-level bpds are not always included in the change notifications that are broadcasted by repository. When these changes are merged into client's local model, the displayName of client model is incorrectly removed and causing subsequent save issue. Typical symptoms: Unable to save BPD. Unable to view snapshot. Typical error messages seen in the SystemOut.log: ---------- Server restart helps the issue for a period of time. Caused by: java.lang.IllegalArgumentException: Starting snapshot does not exist at com.lombardisoftware.server.ejb.persistence.versioning.SnapshotC ontextManager.findBaseSnapshot(SnapshotContextManager.java:226) at com.lombardisoftware.server.ejb.persistence.versioning.SnapshotC ontextManager.acquireSnapshotContext(SnapshotContextManager.java :320) at com.lombardisoftware.server.ejb.persistence.versioning.BranchCon textImpl.readAccess(BranchContextImpl.java:161) at com.lombardisoftware.server.ejb.persistence.versioning.BranchMan ager.readAccess(BranchManager.java:215) at com.lombardisoftware.server.ejb.persistence.PersistenceServicesC ore.getVersionSummaryId(PersistenceServicesCore.java:829) at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) ---------- ---------- CWLLG2229E: An exception occurred in an EJB call. Error: Snapshot.75f9ba4e-08ad-4a19-b0a9-1cdac649a208 com.lombardisoftware.client.persistence.common.ObjectNotFoundExc eption: Snapshot.75f9ba4e-08ad-4a19-b0a9-1cdac649a208 at com.lombardisoftware.client.persistence.common.versioning.Versio ningContext$Snapshot.getBranchId(VersioningContext.java:310) at com.lombardisoftware.server.ejb.persistence.versioning.BranchMan ager.readAccess(BranchManager.java:215) at com.lombardisoftware.server.ejb.persistence.PersistenceServicesC ore.findByFilter(PersistenceServicesCore.java:266) at sun.reflect.GeneratedMethodAccessor199.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) ---------- Oracle specific: ---------- CWLLG2229E: An exception occurred in an EJB call. Error: PreparedStatementCallback; SQL [insert into LSW_BPD (BPD_ID,VERSION_ID,RESTRICTED_NAME, TIME_SCHEDULE_TYPE,TIME_SCHEDULE_NAME,TIME_SCHEDULE_EXPRESSION, HOLIDAY_SCHEDULE_TYPE,HOLIDAY_SCHEDULE_NAME,HOLIDAY_SCHEDULE_EXP RESSION,TIMEZONE_TYPE,TIMEZONE,TIMEZONE_EXPRESSION,NAME,DESCRIPT ION,TYPE,PARENT_FLOW_OBJECT_ID,GUID,LAST_MODIFIED,ROOT_BPD_ID,PA RENT_BPD_ID,TEMPLATE_ID,LAST_MODIFIED_BY_USER_ID,PARTICIPANT_REF ,BUSINESS_DATA_PARTICIPANT_REF,PERF_METRIC_PARTICIPANT_REF,DATA, XML_DATA,IS_TRACKING_ENABLED,IS_SPC_ENABLED,IS_CRITICAL_PATH_EN AB LED) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,? ,?)]; Cannot insert the value NULL into column 'NAME', table 'BPMDB. LSW_BPD'; column does not allow nulls. INSERT fails.; nested exception is java.sql.BatchUpdateException: Cannot insert the value NULL into column 'NAME', table 'BPMDB.LSW_BPD'; column does not allow nulls. INSERT fails. ---------- DB2 specific: ---------- CWLLG2229E: An exception occurred in an EJB call. Error: PreparedStatementCallback; SQL [insert into LSW_BPD (BPD_ID,VERSION_ID,RESTRICTED_NAME,TIME_SCHEDULE_TYPE,TIME_SCHED ULE_NAME,TIME_SCHEDULE_EXPRESSION,HOLIDAY_SCHEDULE_TYPE,HOLIDAY_ SCHEDULE_NAME,HOLIDAY_SCHEDULE_EXPRESSION,TIMEZONE_TYPE,TIMEZONE ,TIMEZONE_EXPRESSION,NAME,DESCRIPTION,TYPE,PARENT_FLOW_OBJECT_ID ,GUID,LAST_MODIFIED,ROOT_BPD_ID,PARENT_BPD_ID,TEMPLATE_ID,LAST_M ODIFIED_BY_USER_ID,PARTICIPANT_REF,BUSINESS_DATA_PARTICIPANT_REF ,PERF_METRIC_PARTICIPANT_REF,DATA,XML_DATA,IS_TRACKING_ENABLED,I S_SPC_ENABLED,IS_CRITICAL_PATH_ENABLED) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Error for batch element #1: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=14, COLNO=18, DRIVER=4.11.69; nested exception is com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #1: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=14, COLNO=18, DRIVER=4.11.69 com.lombardisoftware.client.delegate.BusinessDelegateException: PreparedStatementCallback; SQL [insert into LSW_BPD (BPD_ID,VERSION_ID,RESTRICTED_NAME,TIME_SCHEDULE_TYPE,TIME_SCHED ULE_NAME,TIME_SCHEDULE_EXPRESSION,HOLIDAY_SCHEDULE_TYPE,HOLIDAY_ SCHEDULE_NAME,HOLIDAY_SCHEDULE_EXPRESSION,TIMEZONE_TYPE,TIMEZONE ,TIMEZONE_EXPRESSION,NAME,DESCRIPTION,TYPE,PARENT_FLOW_OBJECT_ID ,GUID,LAST_MODIFIED,ROOT_BPD_ID,PARENT_BPD_ID,TEMPLATE_ID,LAST_M ODIFIED_BY_USER_ID,PARTICIPANT_REF,BUSINESS_DATA_PARTICIPANT_REF ,PERF_METRIC_PARTICIPANT_REF,DATA,XML_DATA,IS_TRACKING_ENABLED,I S_SPC_ENABLED,IS_CRITICAL_PATH_ENABLED) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Error for batch element #1: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=14, COLNO=18, DRIVER=4.11.69; nested exception is com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #1: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=14, COLNO=18, DRIVER=4.11.69 at com.lombardisoftware.client.delegate.BusinessDelegateException.a sBusinessDelegateException(BusinessDelegateException.java:46) at com.lombardisoftware.client.delegate.PersistenceServicesDelegate Default.save(PersistenceServicesDelegateDefault.java:631) at com.lombardisoftware.server.ejb.clientservices.LibrarySupport$10 .call(LibrarySupport.java:449) at com.lombardisoftware.server.ejb.clientservices.LibrarySupport$10 .call(LibrarySupport.java:416) at com.lombardisoftware.server.ejb.persistence.versioning.BranchMan ager$2.withWriteAccess(BranchManager.java:308) at com.lombardisoftware.server.ejb.persistence.versioning.BranchCon textImpl.writeAccessWithDBLock(BranchContextImpl.java:556) at com.lombardisoftware.server.ejb.persistence.versioning.BranchCon textImpl.writeAccessInTransaction(BranchContextImpl.java:492) ----------
Local fix
Restarting the server.
Problem summary
==>The display name is not always included in the change notifications for BPDs that are broadcasted by repository. EDITIONS AFFECTED: ==>IBM Business Process Manager V7.5.1 to V8.5.0.1 Advanced, Standard, and Express PROBLEM DETAILED DESCRIPTION: ==>When Process Designer handles these notifications where display name value is null, the display name of local sublevel BPD model is also set to null. If you later try to save this sublevel BPD again, the save operation fails with a data integrity violation because the repository does not accept a null display name. Subsequent attempts to save the BPD also fail and the starting snapshot missing error is displayed.
Problem conclusion
==>A fix is available for IBM BPM versions, 7.5.1.0 8.0.1.1 8.0.1.2 8.5.0.0 8.5.0.1 that includes logic to check and handle null display names to ensure that they are added in the notification handling code of Process Designer and, therefore, prevent the display name from being removed from the local model. On Fix Central (http://www.ibm.com/support/fixcentral), search for JR48696 by: 1. Select the product group, product, installed version, and platform, and click Continue. 2. Select APAR or SPR, enter JR48696, and click Continue. When downloading 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
JR48696
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
2013-12-03
Closed date
2013-12-19
Last modified date
2014-04-24
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
R850 PSY
UP
Document Information
Modified date:
12 October 2021