...
12. Certain types of script errors (such as missing end delimiter) can cause a packager job to hang indefinitely. To avoid having this happen, you can set a Script Execution Timeout for your REF environments.
- It is recommended to set it on your REF dbDef step only, not for your higher environments.
- You can configure the number of seconds packager should wait before timing out when deploying a script, for example 600 seconds (10 minutes).
...
- You can use the number of seconds that seems appropriate for the types of scripts you typically package. The timeout period is per each individual script.
- If a script is taking longer than the timeout value, packager will fail with a timeout error and indicate which script timed out.
...
- Having packager fail with a timeout error allows packager to finish all of its steps normally, including restoring/reverting REF DB to its previous state from prior to the error. This is better than having packager hang indefinitely then terminating the job manually, which could leave REF in an unexpected state with an incomplete deployment.
Note that the Script Execution Timeout only applies to changes executed using sqlplus/sqlcmd/clpplus. It does NOT apply to scripts packaged in the function/procedure/package/view/trigger folders (when using fixed folders) or to folders using packageMethod=STOREDLOGIC (when using flexible folders).
There are different ways you can set the timeout, use the method you prefer:
...
- There were performance improvements during the forecast stage for those who run deployPackager on Windows clients or Windows agents in Datical DB version 6.8 (and higher).
- There were performance improvements for those who use the Stored Logic Validity check in Datical DB version 6.12 (and higher).
- There were performance improvements for several operations in Datical DB version 6.14 (and higher). From the 6.14 Release Notes - Areas where you may notice improvements:
- Status/Pipeline Status operations in the Datical DB GUI
- 'status' & 'statusDetails' commands in the CLI
- Complex operations which run status implicitly (CLI & GUI)
- All types of 'deploy' operations
- All types of 'rollback' operations
- Deploy Packager
- Convert SQL
- Change Log Sync
15. Although not specifically about packager, this link includes ways to improve Deploy performance:
...