FAILED_ACT_ID_ detail about table

Camunda 7 Topics Discussion & Questions
1

Can someone tell me table name for this column FAILED_ACT_ID_ for my issue j.s.BatchUpdateException: Unknown column ‘FAILED_ACT_ID_’ in ‘field list’\n\tat s.r.GeneratedConstructorAccessor272.newInstance(Unknown Source)\n\tat

2

Hi @pinturjs,

there are three:

ALTER TABLE ACT_HI_JOB_LOG
  ADD FAILED_ACT_ID_ varchar(255);

ALTER TABLE ACT_RU_INCIDENT
  ADD FAILED_ACTIVITY_ID_ varchar(255);

ALTER TABLE ACT_HI_INCIDENT
  ADD FAILED_ACTIVITY_ID_ varchar(255);

Have a look how to upgrade you database here: https://docs.camunda.org/manual/7.13/update/minor/712-to-713/#database-updates.

And be aware that the process engine can only create the initial database for you, the upgrade has to done manually: https://docs.camunda.org/manual/7.13/user-guide/process-engine/database/#database-configuration

Hope this helps, Ingo

1 Like
3

Thank you so much @Ingo_Richtsmeier

4

@Ingo_Richtsmeier can you please me the perfect way to find database updation change.
The URL you shared is just confusing there is no information about DB updation/alter query.
Still, I m facing Unknown column ‘DEPLOYMENT_ID_’ in 'field list kind of issue.

Plz guide me i m new for camunda.

5

Hi @pinturjs,

behind the link 2 you get a section of the docs with a link to “Camunda Nexus”.

This links you to all the database update scripts for all versions. Select your desired version (most likely 7.13.0) and download the camunda-sql-scripts-7.13.0.zip.

In the zip you will find a folder “upgrade” which contains all upgrade scripts for all databases.

Run the scripts for your database.

Hope this helps, Ingo

1 Like