Invalid identifier Startable ORA-00904

Camunda 7 Topics Discussion & Questions
1

Hi all,
I am trying to deploy a simple bpmn having only one user task.
When I deploy I get the error saying:
ORA-00904: "STARTABLE_" invalid identifier

CAMUNDA Version: 7.11

comple error is:
“message”:"ENGINE-03083 Exception while executing batch database operations with message '\n error flushing statements. Cause: org.apache.ibatis.executor.BatchExecutorException:
org.camunda.bpm.engine.imple.persistence.entity.ProcessDefinitionEntity.insertProcessDefinition (batch_index #3) failed 2 prior sub executor(s) completed successfully, but it will be rolled back. Cause: java.sql.BatchUpdateExecution: ORA-00904: "STARTABLE_": invalid identifer\n\n###

2

Can you upload your model and give more details about how you’re trying to depoy the process?

3

irrespective of any specific BPMN,
for any BPMN
a simple start event → user task → end event
it’s giving the same error for any BPMN deployment.

This error started popping up after
I executed the migration scripts from 7.9 to 7.10 and 7.10 to 7.11

4

Sounds like you didn’t properly run the migration scripts.
STARTABLE is a field that should have been created by the migration script.

5

yeah, I executed the script now to add STARTABLE_, and it works fine now,
but I am not sure why this is missed as I have cross verified all migration scripts and STARTABLE_ is not part of it.
Can you point me in to correct direction here?

6

The column was added in 7.10.0, so please check the script {database}_engine_7.9_to_7.10.sql
Nexus: https://app.camunda.com/nexus/service/rest/repository/browse/public/org/camunda/bpm/distro/camunda-sql-scripts/7.10.0/
Source code: camunda-bpm-platform/engine/src/main/resources/org/camunda/bpm/engine/db/upgrade/h2_engine_7.9_to_7.10.sql at master · camunda/camunda-bpm-platform · GitHub

1 Like