Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

24.4.1 SQLcl Project verify errors

After initializing a SQLcl project using project init on macOS with SQLcl 24.4.1.0, running project verify immediately reports two errors related to stagechangelogfilesvalid and stagechangelogcomplete, despite no manual modifications. The issue persists even after using project export or project stage.

Is this a bug, or might I have done something wrong during the project initialization or setup?

Environment:

  • OS: macOS Sequoia 15.1.1 (ARM)
  • SQLcl Version: 24.4.1.0
  • Project Setup:
    • Initialized using project init.
    • No other files in the Git repository.

Steps to Reproduce:

  1. Run project init.
  2. Execute project verify -verbose.

Expected Behavior:
project verify should not report errors if no manual changes were made.

Actual Behavior:

SQL> project verify -verbose
-------- Results Summary ----------
Errors:     2
Warnings:   0
Info:       5
---------------------------------
Level     Group Name     Test Name                     Message
-----     ----------     -----------                   -------------------------
INFO      settings       verifynonpublicsettings       No unsupported internal settings found
INFO      init           verifyprojectname             The final project name will be "MUSICDB"
INFO      examples       exampletest                   a message
ERROR     stage          stagechangelogfilesvalid      Cannot invoke "String.toString()" because the return value of "oracle.dbtools.extension.project.commands.stage.utils.StageUtils.getCodeCLog()" is null
 EXCEPTION: Cause=null Message=Cannot invoke "String.toString()" because the return value of "oracle.dbtools.extension.project.commands.stage.utils.StageUtils.getCodeCLog()" is null
ERROR     stage          stagechangelogcomplete        Cannot invoke "String.toString()" because the return value of "oracle.dbtools.extension.project.commands.stage.utils.StageUtils.getCodeCLog()" is null
 EXCEPTION: Cause=null Message=Cannot invoke "String.toString()" because the return value of "oracle.dbtools.extension.project.commands.stage.utils.StageUtils.getCodeCLog()" is null
INFO      project        sqlclversion                  SQLcl Version check passed
INFO      snapshot       verifysnapshot                Snapshot validation found no issues.
This post has been answered by danmcghan-Oracle on Feb 25 2025
Jump to Answer

Comments

Processing

Post Details

Added on Feb 23 2025
4 comments
197 views