Hi SQLcl Team,
- I have an APEX application with Supporting Objects, which are .sql scripts.
- APEX Supposing Objects scripts are not in any way part of “stageable” files to the best of my knowledge. They were exported by
project export command on 24.2. APEX and 25.4.1. SQLcl.
- However, on 26.1. these files prevent
project stage from running, Please take a look:
SQL> project stage
Stage is Comparing:
Old Branch refs/heads/main
New Branch refs/heads/apex-upgrade-26.1
ERROR: The following files failed processing:
The hash value of the file deinstall-script.sql is incorrect and can not be automatically adju
sted (hard object)
The hash value of the file cla-maintenance-tables.sql is incorrect and can not be automaticall
y adjusted (hard object)
The hash value of the file cla-maintenance-tables.sql is incorrect and can not be automaticall
y adjusted (hard object)
Run the following to export the hard objects with hash mismatches:
project export -o FLOPS.deinstall-script.sql,SUPPORTING-OBJECTS.cla-maintenance-tables.sql,SUP
PORTING-OBJECTS.cla-maintenance-tables.sql
ERROR: An error has occurred processing your request:
Stage process failed: Unrecoverable hash issues present.
SQL>
```
Here `cla-maintenance-tables.sql` is referencing file supporting-objects/install-scripts/cla-maintenance-tables.sql under app 109 APEXLANG root src/database/cla_apex/apex_apps/f109/cla-maintenance109
Please take a look when you have a chance. It looks like a bug to me.
Thanks,
Alex