Hi All,
I am on SQLcl 25.22 and facing an issue when trying to redeploy the object which got failed during original deployment.
Scenario.
I am running deploy command which ran into an error where the script was trying to grant permission to same schema owner.
Since you cannot grant permission to self, it failed.
I simply commented out the grant script in stage.changelog.xml and created another zip file to deploy.
If I am deploying the zip having V2 version, it is now failing because it is trying to regenerate the objects stated in stage.changelog.xml instead of executing only those objects which couldn't be executed in the original deployment.
I understand from https://forums.oracle.com/ords/apexds/post/sqlcl-project-deploy-how-does-error-handling-and-rollback-u-8214 that a fixed forward approached is used
and
1. Fix the broken script.
2. Generate a new artifact.
3. Deploy the new artifact.
Should have worked but not sure if I am missing any step.
Can anyone advise what steps should I do incase my deployment fails and my objects are already under dist/release/1.0 and there is nothing new to export.
Appreciate any inputs
Thanks, Ajax