Absent Member.. bzdafro Absent Member..
Absent Member..

How to manage deploying database scripts that exceed workflow step timeout

Sometimes when we execute MSSQL or Oracle scripts they exceed the workflow step timeout.  When this happens we have no way of knowing if the script is still running... or when it completes.  This most offen happens on large Deploy to PROD updates.   We recently ran into a situation where a package line timed out and the user ended up cancelling the pkg line the following day.   A week later, either the DBA or the application team noticed that our PPM connection was still running but in a stuck state.  They had to manually kill the process.  This is the first time I have run into something that extreme.  However we need to improve our process.   Has anyone run into this?

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.