Forum Stats

  • 3,734,233 Users
  • 2,246,913 Discussions
  • 7,857,192 Comments

Discussions

lb genobject -type apex

Agustin Conejos
Agustin Conejos Member Posts: 15 Green Ribbon

Hello,


I am using sqlcl 21.1 on

 cat /etc/*release o

Oracle Linux Server release 7.8

NAME="Oracle Linux Server"

VERSION="7.8"


trying to export an apex application with a priviliged user got the a nullpointerexception.


SQL> lb genobject -type apex -applicationid 1000 -skipExportDate -expOriginalIds -split

May 21, 2021 9:01:45 AM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run

SEVERE: oracle.dbtools.raptor.scriptrunner.commands.liquibase.liquibaseCommand.handleEvent(liquibaseCommand.java:230)

java.lang.NullPointerException

    at oracle.dbtools.raptor.scriptrunner.commands.liquibase.liquibaseCommand.handleEvent(liquibaseCommand.java:230)

    at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:346)

    at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:226)

    at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:344)

    at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:227)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:421)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:432)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1333)

    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:513)


Please help.

Best Answer

Answers

  • Scott Wesley
    Scott Wesley Member Posts: 5,966 Gold Crown
    Accepted Answer

    Try a 20.x version of SQLcl.

    It worked for us.

  • Agustin Conejos
    Agustin Conejos Member Posts: 15 Green Ribbon

    thanks @Scott Wesley ....

    It looks like a bug from version 21


    SQL> lb genobject -type apex -applicationid 1000 -skipExportDate -expOriginalIds -split

    Exporting application 1000

     Completed at Mon May 24 08:52:30 CDT 2021

    Action successfully completed please review created file controller.xml


    Regards

  • Agustin Conejos
    Agustin Conejos Member Posts: 15 Green Ribbon

    @Scott Wesley


    one quick question...


    i just noticed even though i executed the command line on the path i wanted


    the lb genobject command created the whole path twice


    SQL> pwd

    /home/user/repo/apex/home/user/repo/apex/f1000/application/


    1- i moved to / and executed sqlcl from there hoping the $HOME path will only be once


    SQL> lb genobject -type apex -applicationid 1000 -skipExportDate -expOriginalIds -split


    Exporting application 1000

     Completed at Mon May 24 09:07:30 CDT 2021


    Processing has failed for your request.

    /f1000/application/init.xml (No such file or directory)


    (looks like it was not concatenated here)

    :-/

    2- I tried passing the "-dir" parameter in the documentation but is not working yet


    SQL> pwd

    /home/user/repo/apex/

    SQL> lb genobject -type apex -applicationid 1000 -dir /home/user/repo/apex -split

    Processing has failed for your request.

    ERROR: Unknown parameter -dir

  • Scott Wesley
    Scott Wesley Member Posts: 5,966 Gold Crown

    Huh, I actually found the -dir parameter only worked for APEX, and not other object types

    Though I'm very early exploration days, so I'm not much help.

  • Agustin Conejos
    Agustin Conejos Member Posts: 15 Green Ribbon

    @Scott Wesley thanks a lot men!


    i think i am going to downgrade a little more maybe i can find a client to suits my needs

  • Agustin Conejos
    Agustin Conejos Member Posts: 15 Green Ribbon

    SQLcl: Release 20.2 Production on Tue May 25 08:58:43 2021


    Copyright (c) 1982, 2021, Oracle. All rights reserved.




    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options




    SQL> lb genobject -type apex -applicationid 1300 -dir /dev/repo/ -split


    Processing has failed for your request.

    ERROR: Unknown parameter -dir


    i tried again SAME as you described without luck on

    oracle linux 7.8 Operative system and both

    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

    Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

    Version 18.12.0.0.0

Sign In or Register to comment.