Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

User_E418YJul 11 2022 — edited Aug 11 2022

Hello,
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
begin
apex_util.set_security_group_id( apex_util.find_security_group_id( p_workspace => '$workspace'));
APEX_UTIL.PAUSE(2);
end;
/
cd dist
cd db
lb update -changelog controller.xml
cd ..
cd app
lb status -changelog controller.xml
lb update -changelog controller.xml -log

Comments

Processing

Post Details

Added on Jul 11 2022
1 comment
362 views