Task assignment fails with Cannot insert NULL into (""PEOPLEASSIGNMENTS_POTOWNERS"."ENTITY_ID") error

Solution In Progress - Updated -

Issue

The actors assignment for a task is defined as a combination of fixed string and a variable. During process execution, the var1 variable could be set to an empty String due to business logic. Depending on the order of the string/variable in the actors assignment, this could work or lead to a failure during process execution:

    This works:
        bpmsAdmin,#{var1}
    This fails:
        #{var1},bpmsAdmin

Example failure when using Oracle:

12:28:11,344 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-10.213.29.102:8080-3) SQL Error: 1400, SQLState: 23000
12:28:11,344 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-10.213.29.102:8080-3) ORA-01400: cannot insert NULL into ("PEOPLEASSIGNMENTS_POTOWNERS"."ENTITY_ID")

12:28:11,344 INFO  [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (http-10.213.29.102:8080-3) HHH000010: On release of batch it still contained JDBC statements
12:28:11,344 WARN  [org.jbpm.services.task.persistence.TaskTransactionInterceptor] (http-10.213.29.102:8080-3) Could not commit session: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

Environment

  • Red Hat JBoss BPM Suite
    • 6.4

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.