Skip to Main Content


Liquibase errors (lb update -changelog controller.xml -log) ORA-01400 cannot insert NULL into

User_E418YJul 11 2022 — edited Aug 11 2022

I would like to get some support about a problem. We have developed an APEX application and we are following the instructions to extract and deploy APEX application code using Liquibase.
However, when running "lb update -changelog controller.xml -log" to deploy the application, we get the next error for all pages in my application.
Error report -
ORA-01400: cannot insert NULL into ("APEX_210200"."WWV_FLOW_PAGE_PLUGS"."PAGE_ID")
ORA-06512: at "APEX_210200.WWV_FLOW_API", line 4112676056
ORA-06512: at "APEX_210200.WWV_FLOW_API", line 14953
ORA-06512: at line 35
01400. 00000 - "cannot insert NULL into (%s)"
*Cause: An attempt was made to insert NULL into previously listed objects.
*Action: These objects cannot accept NULL values.
What would I do to fix it?
My current SQLcl script looks like this
conn $dsn
apex_util.set_security_group_id( apex_util.find_security_group_id( p_workspace => '$workspace'));
cd dist
cd db
lb update -changelog controller.xml
cd ..
cd app
lb status -changelog controller.xml
lb update -changelog controller.xml -log

Post Details
Added on Jul 11 2022
1 comment