Hi
I am trying to execute demo from Quick Start section.
https://docs.oracle.com/en/database/oracle/sql-developer-command-line/25.3/sqcug/quick-start.html
db version - Version 19.28.0.0.0
Oracle SQLDeveloper Command-Line (SQLcl) version: 25.3.0.0 build: 25.3.0.274.1210
Here are the issues that do not permit me to deploy the project package:
6.3.4 Ticket-1
pp11
Line:
!cat dist/releases/next/changes/ticket-1/stage.changelog.xml
--BEGIN--
--END--
--BEGIN CUSTOM--
--END CUSTOM--
In my stage.changelog.xml file I do not have the comment lines
pp12
Line:
Merge output
Document:
dist/releases/next/code/code.changelog.xml
My output:
--> create mode 100644 dist/install.sql
create mode 100644 dist/releases/main.changelog.xml
create mode 100644 dist/releases/next/changes/ticket-1/_custom/dept-data.sql
create mode 100644 dist/releases/next/changes/ticket-1/_custom/emp-data.sql
create mode 100644 dist/releases/next/changes/ticket-1/demo0/indexes/idx_emp_deptno.sql
create mode 100644 dist/releases/next/changes/ticket-1/demo0/ref_constraints/fk_deptno.sql
create mode 100644 dist/releases/next/changes/ticket-1/demo0/tables/dept.sql
create mode 100644 dist/releases/next/changes/ticket-1/demo0/tables/emp.sql
create mode 100644 dist/releases/next/changes/ticket-1/stage.changelog.xml
create mode 100644 dist/releases/next/release.changelog.xml
create mode 100644 dist/utils/prechecks.sql
create mode 100644 dist/utils/recompile.sql
create mode 100644 src/database/demo0/indexes/idx_emp_deptno.sql
create mode 100644 src/database/demo0/ref_constraints/fk_deptno.sql
create mode 100644 src/database/demo0/tables/dept.sql
create mode 100644 src/database/demo0/tables/emp.sql
Document output:
create mode 100644 dist/releases/main.changelog.xml
create mode 100644 dist/releases/next/changes/ticket-1/_custom/dept-data.sql
create mode 100644 dist/releases/next/changes/ticket-1/_custom/emp-data.sql
create mode 100644 dist/releases/next/changes/ticket-1/demo/index/idx_emp_deptno.sql
create mode 100644 dist/releases/next/changes/ticket-1/demo/ref_constraint/fk_deptno.sql
create mode 100644 dist/releases/next/changes/ticket-1/demo/table/dept.sql
create mode 100644 dist/releases/next/changes/ticket-1/demo/table/emp.sql
create mode 100644 dist/releases/next/changes/ticket-1/stage.changelog.xml
---> create mode 100644 dist/releases/next/code/code.changelog.xml
create mode 100644 dist/releases/next/release.changelog.xml
create mode 100644 dist/utils/prechecks.sql
create mode 100644 dist/utils/recompile.sql
create mode 100644 src/database/demo/indexes/idx_emp_deptno.sql
create mode 100644 src/database/demo/ref_constraints/fk_deptno.sql
create mode 100644 src/database/demo/tables/dept.sql
create mode 100644 src/database/demo/tables/emp.sql
6.3.5 Ticket-2
pp 7 Ticket-2
Line:
!cat dist/releases/next/changes/ticket-2/demo/table/emp.sql
!type dist\releases\next\changes\ticket-2\demo0\tables\emp.sql
---------------------------------------------------->
Document table directory is not correct
pp11 icket-2
Line:
!git status
My output:
On branch ticket-2
Changes not staged for commit:
(use "git add ..." to update what will be committed)
(use "git restore ..." to discard changes in working directory)
modified: dist/releases/next/changes/ticket-2/stage.changelog.xml
Document output:
Changes not staged for commit:
(use "git add ..." to update what will be committed)
(use "git restore ..." to discard changes in working directory)
modified: dist/releases/next/code/code.changelog.xml
modified: dist/releases/next/release.changelog.xml
pp 13 Ticket_2
Line:
!git merge "ticket-2"
my output:
--> src/database/demo/tables/emp.sql
Documentation output:
--> dist/releases/next/code/code.changelog.xml
-----------------------------------------------------------------------------------------------------------------------
project verify -v
-------- Results Summary ----------
Errors: 2
Warnings: 0
Info: 6
---------------------------------
------- ------------ -------------------------- ----------------------------------------------------------------------
Level Group Name Test Name Message
------- ------------ -------------------------- ----------------------------------------------------------------------
INFO init verifyprojectname The final project name will be "demo_project"
INFO stage stagechangelogfilesvalid .dbtools/project.config.json generated format: liquibase
All included scripts are present, not cross-referencing and readable
(12 checked)
INFO stage stagesoftobjectisolation SoftObjectIsolation: Change
OK: Code folder is absent.
ERROR stage stageduplicateentries .dbtools/project.config.json generated format: liquibase
dist\releases\main.changelog.xml - There are no duplicate entries.
RELEASE CHANGELOGS - There are no duplicate entries.
dist\releases\next\changes\ticket-2\stage.changelog.xml - There is
one duplicate entry:
dist\releases\next\changes\ticket-2\demo0\tables\emp.sql
ERROR stage stagechangelogcomplete stage.changelog file not found:
dist\releases\next\changes\main\stage.changelog.xml
INFO stage stagesourcediff All modified files are represented in dist folder
All changes in dist folder are represented in src folder
INFO project sqlclversion SQLcl Version check passed
INFO snapshot verifysnapshot Snapshot validation found no issues.
!type dist\releases\next\changes\ticket-2\stage.changelog.xml
Could you help me to execute the demo from quick start documentation section?
Thank you,
Oleg