it is pretty much the same error that I started this posting with. Here is the output for the script failure on agent 650
I am also running your Chocolatey product on this server and the secript is failing for that also.
The Script(5874) failed in the Else section at step 69. The reason: Row index out of bounds
Script: S5874 - Starting at Server Time: Wednesday, August 14, 2019 6:05:24 AM
IF F5 ValueOne (P1): CMD Comparer (P2): 2 ValueTwo (P3): FRAMEWORK T: 0.6519412
L2 F114 File (P1): 'C:\ProgramData\chocolatey\choc...' Check (P2): 1 Jump (P3): 2 T: 0.6579412
L3 F20 SetType(P1):1 Parameter(P2):'C:\ProgramData\chocolatey\choc...' VariableName(P3):CHOCOEXE T: 8.2947505
L4 F129 Jump (P1): 6 T: 8.2947505
L11 F29 Message (P1): Funstion Call is - [UPDATE] T: 8.2967501
L12 F70 Value (P1): CMD Comparer (P2): 2 To (P3): INSTALL Jump (P4): :INSTALL T: 8.3007528
L13 F70 Value (P1): CMD Comparer (P2): 2 To (P3): UPDATE Jump (P4): :UPDATE T: 8.3027538
L63 F139 Note (P1): :UPDATE T: 8.3037549
L64 F20 SetType(P1):1 Parameter(P2):1 VariableName(P3):LOOPCOUNT T: 8.3057559
L65 F196 SQL (P1): 'SELECT b.ID As AppAssocID,s.Name, b.RepoName, s.version, a.LastUpdate, b.version as RepoVe...' T: 8.3067571
L66 F139 Note (P1): :LOOPSTARTUPDATE T: 8.3097586
L67 F20 SetType(P1):1 Parameter(P2): VariableName(P3):APPASSOCID T: 8.3157629
L68 F20 SetType(P1):1 Parameter(P2): VariableName(P3):REPONAME T: 8.3167697
L69 F197 Variable (P1): sqldataset RowIndex (P2): 1 T: 8.3187647
Here is the chocloatey log same agent:
The Script(5878) failed in the Else section at step 120. The reason: Row index out of bounds
Script: S5878 - Starting at Server Time: Tuesday, August 13, 2019 1:01:16 PM
IF F5 ValueOne (P1): MYCMD Comparer (P2): 8 ValueTwo (P3): INSTALLFRAMEWORK T: 0.0830541
L2 F114 File (P1): 'C:\ProgramData\chocolatey\choc...' Check (P2): 0 Jump (P3):
ROGRAMDATA T: 0.0890541
L5 F139 Note (P1):
ROGRAMDATA T: 8.1394699
L6 F20 SetType(P1):1 Parameter(P2):'C:\ProgramData\chocolatey\choc...' VariableName(P3):CHOCO T: 8.1404711
L7 F129 Jump (P1): :FUNCTIONS T: 8.1414713
L12 F139 Note (P1): :FUNCTIONS T: 8.1424721
L13 F70 Value (P1): MYCMD Comparer (P2): 8 To (P3): INSTALLAPP Jump (P4): :INSTALLAPP T: 8.1444734
L14 F70 Value (P1): MYCMD Comparer (P2): 8 To (P3): REMOVEAPP Jump (P4): :REMOVEAPP T: 8.1464747
L15 F70 Value (P1): MYCMD Comparer (P2): 8 To (P3): RUNUPDATES Jump (P4): :RUNUPDATES T: 8.1494769
L115 F139 Note (P1): :RUNUPDATES T: 8.1514802
L116 F20 SetType(P1):1 Parameter(P2):1 VariableName(P3):LOOPCOUNT T: 8.1524787
L117 F196 SQL (P1): 'SELECT Application FROM plugin_p4l_chocolatey_computers Where ComputerID = '650' and Upda...' T: 8.1544804
L118 F139 Note (P1): :LOOPSTARTUPDATE T: 8.1594835
L119 F20 SetType(P1):1 Parameter(P2): VariableName(P3):APPASSOCID T: 8.160484
L120 F197 Variable (P1): sqldataset RowIndex (P2): 1 T: 8.1614845