Fixes are available
APAR status
Closed as program error.
Error description
When the customer exports a process application that contains empty strings, import fails when the database is Oracle. The failure is aᅠSQLIntegrityConstraintViolationException. Exception:com.lombardisoftware.client.delegate.BusinessDelegateE xception SourceId:importSnapshot ProbeId:0x02 Reporter:com.ibm.bpm.pal.action.OtherActionsImpl@7bf79a10 com.lombardisoftware.client.delegate.BusinessDelegateException: PreparedStatementCallback; SQL [insert into LSW_PROCESS_ITEM (PROCESS_ITEM_ID,VERSION_ID,NAME,TWCOMPONENT_NAME,TRACE_CATEGORY ,TRACE_L EVEL,TRACE_MESSAGE,TRACE_SYMBOL_TABLE,DOCUMENTATION,GUID,LAST_MO DIFIED,P ROCESS_ID,TWCOMPONENT_ID,ERROR_HANDLER_ITEM_ID,LAST_MODIFIED_BY_ USER_ID, DATA,IS_LOG_ENABLED,IS_TRACE_ENABLED,IS_EXEC_CONTEXT_TRACED,SAVE _EXEC_CO NTEXT,IS_ERROR_HANDLER_ENABLED) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; ORA-01400: cannot insert NULL into ("BPMDB00"."LSW_PROCESS_ITEM"."NAME") ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("BPMDB00"."LSW_PROCESS_ITEM"."NAME") at com.lombardisoftware.client.delegate.BusinessDelegateException. asBusine ssDelegateException(BusinessDelegateException.java:41) at com.lombardisoftware.client.delegate.common.WebsphereDelegateHe lper.doA sCurrentSubjectContextSensitive(WebsphereDelegateHelper.java:177 ) at com.lombardisoftware.client.delegate.RepositoryServicesDelegate Default. importUploadedFile(RepositoryServicesDelegateDefault.java:1746) at com.ibm.bpm.pal.action.OtherActionsImpl.importSnapshot(OtherActi onsImpl. java:108) at com.lombardisoftware.repository.server.ObjectManagementServiceI mpl.impo rtThunderdomeObject(ObjectManagementServiceImpl.java:1748) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccesso rImpl.ja va:60) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho dAccesso rImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:611) at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC. java:569 ) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall( RemoteSe rviceServlet.java:208) at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost (RemoteS erviceServlet.java:248) at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doP ost(Abst ractRemoteServiceServlet.java:62) ... Caused by: com.lombardisoftware.expimp.ExportImportException: PreparedStatementCallback; SQL [insert into LSW_PROCESS_ITEM (PROCESS_ITEM_ID,VERSION_ID,NAME,TWCOMPONENT_NAME,TRACE_CATEGOR Y,TRACE_ LEVEL,TRACE_MESSAGE,TRACE_SYMBOL_TABLE,DOCUMENTATION,GUID,LAST_M ODIFIED, P ROCESS_ID,TWCOMPONENT_ID,ERROR_HANDLER_ITEM_ID,LAST_MODIFIED_BY_ USER_ID, DATA,IS_LOG_ENABLED,IS_TRACE_ENABLED,IS_EXEC_CONTEXT_TRACED,SAVE _EXEC_CO NTEXT,IS_ERROR_HANDLER_ENABLED) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; ORA-01400: cannot insert NULL into ("BPMDB00"."LSW_PROCESS_ITEM"."NAME") ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("BPMDB00"."LSW_PROCESS_ITEM"."NAME") at com.lombardisoftware.expimp.ExportImportException.asExportImpor tExcepti on(ExportImportException.java:44)
Local fix
iFix
Problem summary
**************************************************************** * USERS AFFECTED: BPM user using Oracle database * **************************************************************** * PROBLEM DESCRIPTION: When the customer enters an empty * * name for an element of a service, and * * exception will be thrown trying to * * write the record to the Oracle * * database. This be because the name * * field in the database table is * * nonnullable, and the empty will be * * inserted in to the database as null * * on Oracle only. * **************************************************************** * RECOMMENDATION: * **************************************************************** When the customer enters an empty name for an element of a service, and exception will be thrown trying to write the record to the Oracle database.
Problem conclusion
Code was changed to check for an empty string for the name. IFix was created for BPM v8.0.1.1. Fix code was also put into all future releases. IFix file is available in Fix Central, installation instruction can be downloaded together with iFix file.
Temporary fix
Comments
APAR Information
APAR number
JR47036
Reported component name
WEB PROC SERVER
Reported component ID
5724L0100
Reported release
800
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-06-21
Closed date
2013-07-19
Last modified date
2013-07-19
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
R800 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.0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
07 January 2022