IBM Support

JR47036: EMPTY BPM PROPERTY CAUSES CONSTRAINT VIOLATION WHILE TWX FILE IS IMPORTED INTO ORACLE DATABASE.

Subscribe

You can track all active APARs for this component.

 

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":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
19 July 2013