HCOSS Bind Script error: "StartIndex cannot be less than zero. Parameter name: startIndex"

When running a Bind Script File in HCOSS , the HCOSS log files show error: "StartIndex cannot be less than zero. Parameter name: startIndex" error. But no error dialog is shown from HCOSS.

In HCOSS, on the Manage Packages and Plans section, open your .hcodsn Bind Script File.

Then select the SQL Server Connection (E.g SQL Server Native Client 10.0, version 2007.100.1600.22). When you press Execute All, the script runs and but then stops too early. No message appears, the build scipt executing progress disappears and nothing further is displayed.

In the log file we see the error: "StartIndex cannot be less than zero. Parameter name: startIndex".

The issue can occur if you have more than 50 entries in the bind script file.  The fix is to change an option through the Visual Studio IDE.  See the instructions below on what to change:

The 50-row result limit is controlled by an OpenEsql option. From Visual Studio, select Tools > Options > Micro Focus COBOL Tools > OpenESQL Assistant. Under the Query section, set the Maximum Result Rows value to -1.

Please change this option, then try to execute the bind scripts and the issue should not reoccur.