Error running SQLCL lb command

User_6AKAM

Does anyone know why this error occurs?

Thanks,

Johnny

Scott Wesley

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

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

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