Forum Stats

  • 3,872,939 Users
  • 2,266,490 Discussions
  • 7,911,390 Comments

Discussions

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

User_E418Y
User_E418Y Member Posts: 1 Green Ribbon
edited Aug 11, 2022 9:17AM in SQLcl

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

Tagged:

Answers

  • User_BA9RU
    User_BA9RU Member Posts: 1 Green Ribbon

    Having the same issue, trying to import an application and getting the same error "cannot insert NULL into ("APEX_210200"."WWV_FLOW_PAGE_PLUGS"."PAGE_ID")", I have searched around and don't see to find an answers