Hi,
I have thousands of object I need to deploy, it is a base release in the development I need to deploy to the production and start working with SQLcl project, here is my objects in dev
After hours in deployment here is my findings and output
- managed to deploy the following objects
I
3. if a package has “&” character it will prompt as substitution variable which needs someone to be on the screen and press enter.
4. After sometime, I get the following error and can't bypass, I am stuck in the middle, here is the error log
Exception in thread "main" liquibase.util.grammar.TokenMgrError: Lexical error at line 3939, column 37. Encountered: '\u0650' (1616),
at liquibase.util.grammar.SimpleSqlGrammarTokenManager.getNextToken(SimpleSqlGrammarTokenManager.java:1410)
at liquibase.util.grammar.SimpleSqlGrammar.getNextToken(SimpleSqlGrammar.java:113)
at liquibase.util.StandardSqlParser.parse(StandardSqlParser.java:42)
at liquibase.util.StringUtil.processMultiLineSQL(StringUtil.java:68)
at liquibase.change.AbstractSQLChange.generateStatements(AbstractSQLChange.java:295)
at liquibase.changelog.ChangeSet.lambda$addSqlMdc$2(ChangeSet.java:1611)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.changelog.ChangeSet.addSqlMdc(ChangeSet.java:1610)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:752)
at liquibase.changelog.visitor.UpdateVisitor.executeAcceptedChange(UpdateVisitor.java:119)
at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:68)
at liquibase.changelog.ChangeLogIterator$2.lambda$run$0(ChangeLogIterator.java:133)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:122)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.Scope.child(Scope.java:252)
at liquibase.Scope.child(Scope.java:256)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:89)
at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:110)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:108)
at liquibase.command.core.UpdateCommandStep.run(UpdateCommandStep.java:105)
at liquibase.command.CommandScope.execute(CommandScope.java:217)
at liquibase.Scope.lambda$child$0(Scope.java:186)
at liquibase.Scope.child(Scope.java:195)
at liquibase.Scope.child(Scope.java:185)
at liquibase.Scope.child(Scope.java:164)
at liquibase.Scope.child(Scope.java:252)
at oracle.dbtools.raptor.liquibase.core.ActiveCommand.runCommand(ActiveCommand.java:434)
at oracle.dbtools.raptor.liquibase.core.CommandGenerator.updateCommand(CommandGenerator.java:380)
at oracle.dbtools.raptor.scriptrunner.commands.liquibase.LbCommand.handleEvent(LbCommand.java:348)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:448)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:241)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:835)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:124)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.runExecuteFile(SQLPLUS.java:1773)
at oracle.dbtools.raptor.newscriptrunner.SQLPLUS.run(SQLPLUS.java:185)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQLPLUS(ScriptRunner.java:460)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:281)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:835)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:124)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.liquibase.util.QueryUtils.runSqlReturnResult(QueryUtils.java:261)
at oracle.dbtools.extension.project.commands.deploy.DeployCommand.run(DeployCommand.java:99)
at oracle.dbtools.extension.project.commands.handler.CommandHandler.DeployCommand(CommandHandler.java:149)
at oracle.dbtools.extension.project.commands.handler.ProjectCommand.handleEvent(ProjectCommand.java:87)
at oracle.dbtools.raptor.newscriptrunner.util.command.ParsedCommandListener.handleEvent(ParsedCommandListener.java:62)
at oracle.dbtools.raptor.newscriptrunner.CommandRegistry.fireListeners(CommandRegistry.java:448)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.lambda$run$0(ScriptRunner.java:241)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunnerContext.runWithStoredContext(ScriptRunnerContext.java:835)
at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:124)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:364)
at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:245)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:1416)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.runSqlcl(SqlCli.java:1640)
at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:405)
It is not clear what the problem is,
5. And here is the “project verify -v" result
-------- 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 "mas_apps"
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.