Hello,
I am migrating from activiti5 to flowable6, when i launch my spring boot application and run a simple process instance, i got this error :
org.apache.ibatis.exceptions.PersistenceException:
Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “NAME_” : identificateur non valide
The error may exist in org/flowable/db/mapping/entity/HistoricProcessInstance.xml
The error may involve org.flowable.engine.impl.persistence.entity.HistoricProcessInstanceEntityImpl.insertHistoricProcessInstance-Inline
The error occurred while setting parameters
SQL: insert into ACT_HI_PROCINST ( ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, START_TIME_, END_TIME_, DURATION_, START_USER_ID_, START_ACT_ID_, END_ACT_ID_, SUPER_PROCESS_INSTANCE_ID_, DELETE_REASON_, TENANT_ID_, NAME_, CALLBACK_ID_, CALLBACK_TYPE_, REFERENCE_ID_, REFERENCE_TYPE_ ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Cause: java.sql.SQLSyntaxErrorException: ORA-00904: “NAME_” : invalid identifier
my command runner for test is :
@Bean
public CommandLineRunner init(final RepositoryService repositoryService,
final RuntimeService runtimeService,
final TaskService taskService) {
return new CommandLineRunner() {
@Override
public void run(String... strings) throws Exception {
System.out.println("Number of process definitions : "
+ repositoryService.createProcessDefinitionQuery().count());
System.out.println("Number of tasks : " + taskService.createTaskQuery().count());
runtimeService.startProcessInstanceByKey("oneTaskProcess");
System.out.println("Number of tasks after process start: "
+ taskService.createTaskQuery().count());
}
};
}
can you please provide information of which script create the new column “NAME_” on the table act_hi_procinst.
thanks,