Forum Stats

  • 3,770,238 Users
  • 2,253,082 Discussions
  • 7,875,370 Comments

Discussions

Error running SQLCL lb command

User_6AKAM
User_6AKAM Member Posts: 6 Red Ribbon

Does anyone know why this error occurs?

Thanks,

Johnny

Answers

  • Scott Wesley
    Scott Wesley Member Posts: 6,127 Gold Crown

    I am Johnny's colleague and have further context on this.

    Database: 11.2.0.4

    APEX: 20.2

    SQLcl: 21.1

    Connected via a proxy user to an account to the parsing schema of the application.

    ie: parsing schema of f100 is APEX_PARSER

    sql scott[apex_parser]@db11g

    Gen object of type table in the apex_parser schema completes successfully.

    Running with -debug on a new application returns:

    lb genobject -type apex -applicationid 300 -debug[{log=false, replace=false, type=apex, password=, enable=true, context=, grants=false, silent=false, debug=true, runalways=false, synonyms=false, emit_schema=false, count=, changelog=, label=, runonchange=false, url=, command=genobject, fail=false, help=false, filename=, report=true, name=, privs=true, user=, isSqlCl=true}]
    oracle.dbtools.raptor.liquibase.exceptions.ProcessFailedException: writeChangeLogMap
        at oracle.dbtools.raptor.liquibase.generator.SchemaGenerator.writeChangeLogMap(SchemaGenerator.java:212)
        at oracle.dbtools.raptor.scriptrunner.commands.liquibase.LiquibaseActions.genApexObjectChangelogs(LiquibaseActions.java:608)
        at oracle.dbtools.raptor.scriptrunner.commands.liquibase.liquibaseCommand.handleEvent(liquibaseCommand.java:183)
        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)
    2021-05-19 13:01:23.261 SEVERE oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run oracle.dbtools.raptor.scriptrunner.commands.liquibase.liquibaseCommand.handleEvent(liquibaseCommand.java:227)
    java.lang.NullPointerException
        at oracle.dbtools.raptor.scriptrunner.commands.liquibase.liquibaseCommand.handleEvent(liquibaseCommand.java:227)
        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)
    
    
    -db           null
    -user      null
    -password    null
    workspaceidnull
    -applicationid 300
    -debug     true
    -skipExportDate false
    -expPubReports false
    -expSavedReports    false
    -expIRNotif   false
    -expTranslations    false
    -instance    false
    -expWorkspace  false
    -expMinimal   false
    -expFiles    false
    -expFeedback  false
    -expTeamdevdata     false
    -deploymentSystem    null
    -expFeedbackSince    null
    -expOriginalIds     false
    -split false
    -expNoSubscriptions   false
    -expComments  false
    -expSupportingObjects
    -expACLAssignments   false
    -expLocked   false
    -nochecksum   true
    -dir
    -list  false
    -changesSince
    -changesBy
    -expComponents
    Exporting Application 300
     begin
       ? := apex_export.get_application (
            p_application_id     => ?,
            p_split          => ?='Y',
            p_with_date        => ?='Y',
            p_with_ir_public_reports => ?='Y',
            p_with_ir_private_reports => ?='Y',
            p_with_ir_notifications  => ?='Y',
            p_with_translations    => ?='Y',
            p_with_pkg_app_mapping  => ?='Y',
            p_with_original_ids    => ?='Y',
            p_with_no_subscriptions  => ?='Y',
            p_with_comments      => ?='Y',
            p_with_supporting_objects => ?,
            p_with_acl_assignments  => ?='Y',
            p_components       => apex_string.split(?,'#') );
     end;
     Start Wed May 19 13:01:22 AWST 2021
     SQLTypeName: APEX_200200.WWV_FLOW_T_EXPORT_FILE
     Attr0: f300.sql
     Completed at Wed May 19 13:01:23 AWST 2021
    

    Scott.

  • Scott Wesley
    Scott Wesley Member Posts: 6,127 Gold Crown
    edited May 24, 2021 5:17AM

    This appears to be a regression issue.

    Taking lead from this unanswered question, I tried exporting using SQLcl 20.2 with success.

    edit - this also works with 20.4.2, just not the latest release.

  • fszilinski
    fszilinski Member Posts: 5 Blue Ribbon
    edited Oct 26, 2021 11:48AM

    Confirmed, sqlcl-21.1.1.113.1704 gives me the same NullPointerException, with Release 21.3 Production it worked again.