cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with act_ru_execution table at export/import db2 database

emmanuelb
Champ in-the-making
Champ in-the-making
Hi, we have a problem when export/import db2 database with the column uni_business_key from table act_ru_exectution.
We need to export database, then drop and recreate the database, and then import.

We view that when import, db2 dont execute this part of query:

UNI_BUSINESS_KEY" VARCHAR(255) NOT NULL GENERATED ALWAYS AS (case when "BUSINESS_KEY_" is null then "ID_" else "BUSINESS_KEY_" end) ,
"UNI_PROC_DEF_ID" VARCHAR(64) NOT NULL GENERATED ALWAYS AS (case when "PROC_DEF_ID_" is null then "ID_" else "PROC_DEF_ID_" end) )",

So, when startup our application we have this error:
SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=3, TABLEID=13, COLNO=11
3 REPLIES 3

jbarrez
Star Contributor
Star Contributor
We have removed that constraint on the master branch, and will be part of 5.15.
So, you can ignore/remove it, it has no business impact.

emmanuelb
Champ in-the-making
Champ in-the-making
Thanks, it works!!

jbarrez
Star Contributor
Star Contributor
Great to hear that!