Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 439 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Error running SQLCL lb command

Does anyone know why this error occurs?
Thanks,
Johnny
Answers
-
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.
-
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.
-
Confirmed, sqlcl-21.1.1.113.1704 gives me the same NullPointerException, with Release 21.3 Production it worked again.