Error with install command

[SCanzano]

On a new environment we did

set r=##class(%Net.HttpRequest).%New(),r.Server="pm.community.intersystems.com",r.SSLConfiguration="ISC.FeatureTracker.SSL.Config" d r.Get("/packages/zpm/latest/installer"),$system.OBJ.LoadStream(r.HttpResponse.Data,"c")

as instructed in other documentation

We now get errors when calling the install command

ERROR! ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={213|214}>

ERROR #6084: Unknown errors detected, but no error code reported

can this error message be cleaned up .. what exactly is this saying

errRowID is not a column in the table SELECT ID, Counter, ModuleName, RowCount, GlobalRefs, LinesOfCode, TimeSpent, StartTime, UserName, IPAddress, MachineName, ExeName, ModuleCount, Pid, DiskWait, CursorName, NameSpace, RoutineInfo, RoutineName, StatsGroup, StatsMarker, TimeToFirstRow, TotalTime FROM %SYS_PTools.Stats

[isc-tleavitt]

@SCanzano what IRIS version? (w $zv)

[isc-tleavitt]

334 is similar but there's no real resolution there.

[isc-tleavitt]

Also if you zwrite %objlasterror after this do you get any hints from the stack trace as to what caused this?

Handy debugging trick if not:

zbreak *%objlasterror:"N":"$d(%objlasterror)":"set ^mtemperr($i(^mtemperr))=%objlasterror"
<do the thing that hits some weird error %Status>
zw ^mtemperr

That'll have every error %Status created, with stack trace included of course.

Two places I've seen behavior like this in the past: errors clearing CSPGateway cache on compilation of CSP files, and source control extensions misbehaving. Hopefully the stack trace will give us a hint.

[SCanzano]

%objlasterror has

0 Ô�ÕSQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={465|466}>� HSCUSTOM�"$^zSHA1Hash+9^%Library.File.1 +2K$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1D$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1F$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1(D^zInstall+61^%ZPM.PackageManager.1 +2.D^zShellInternal+53^%ZPM.PackageManager.1 +1%D^zShell+2^%ZPM.PackageManager.1 +1D^ZPM^%ZLANGC00 +X^@ +1R0 NÄ@zLoad+1^%SYSTEM.OBJ.1 HSCUSTOM^zLoad+1^%SYSTEM.OBJ.1^1 and $ZVERSION= IRIS for UNIX (Red Hat Enterprise Linux 7 for x86-64) 2022.1.2 (Build 574_0_23421U) Wed May 15 2024 15:32:17 EDT

[isc-tleavitt]

ok, that's clearly unrelated from the SQL stats error. Can you try the zbreak variation?

[SCanzano]

I believe I found the error but not 100% clear

With the installation of our bootstrap module we deliver an installer manifest class and has

  <Resource Name="RCIPM.InstallerManifest.CLS" Preload="true" Flags="cuk">
      </Resource>

and

   <Invoke Class="RCIPM.InstallerManifest" Method="setup" Phase="Reload" When="After" CheckStatus="false">
      </Invoke>

in our installer manifest class we want to see if there is RCLIB database, if not defined then create it and add %ALL package mapping with the RC package.

The error we had was when checking to see if the RCLIB database was defined we utilized %SYS.Database which only provides access to the local database definitions and not the Remote databases. On this environment there was no Local RCLIB but there was a remotely mounted RCLIB. When the installer manifest tried to create a Local RCLIB db this failed as we are not allowed to have both a local RCLIB and remote RCLIB database.

So I think this type is not being properly "bubbled" up from the Installer manifest class and the

   <Invoke Class="RCIPM.InstallerManifest" Method="setup" Phase="Reload" When="After" CheckStatus="false">
      </Invoke>

[SCanzano]

@isc-tleavitt ok I might have been mistaken. If I try installing zprofile which I'm assuming is a simple, or simple-spellchecker from pm.community.intersystems.com I get errors

zpm:HSCUSTOM>install -v zprofile

Module zprofile was downloaded from registry (https://pm.community.intersystems.com) Loading from /intersystems/HSPRDAA/mgr/.modules/HSCUSTOM/zprofile/1.0.2/

Load started on 08/20/2024 19:56:28 Loading file /intersystems/HSPRDAA/mgr/.modules/HSCUSTOM/zprofile/1.0.2/module.xml as xml Imported document: zprofile.ZPM Detected 3 errors during load. ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={193|194}

ERROR #6084: Unknown errors detected, but no error code reported ERROR! ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={193|194}> ERROR #6084: Unknown errors detected, but no error code reported zpm:HSCUSTOM>q

HSCUSTOM>zw

%ROWCOUNT=1 %ROWID=1 %SAX=1 %objlasterror="0 Ô�ÕSQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={193|194}>� HSCUSTOM�"$^zSHA1Hash+9^%Library.File.1 +2K$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1D$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1F$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1(D^zInstall+60^%ZPM.PackageManager.1 +1.D^zShellInternal+53^%ZPM.PackageManager.1 +1%D^zShell+2^%ZPM.PackageManager.1 +1D^ZPM^%ZLANGC00 +X^@ +1R0 NÄ@zLoad+1^%SYSTEM.OBJ.1 HSCUSTOM^zLoad+1^%SYSTEM.OBJ.1^1" %sqlcontext=

[SCanzano]

following your recommendation for a dymnamic breakpoint and setting ^mtemperr for a simple install simple-spellchecker I get quite a bit of info but just seems to be mostly repeating

^mtemperr=49 ^mtemperr(1)="" ^mtemperr(2)="" ^mtemperr(3)="" ^mtemperr(4)="" ^mtemperr(5)="" ^mtemperr(6)="" ^mtemperr(7)="" ^mtemperr(8)="" ^mtemperr(9)="" ^mtemperr(10)="" ^mtemperr(11)="" ^mtemperr(12)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={47|48}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={47|48} / ^mtemperr(13)="0 "$lb($lb(5770,"DeploymentServer",1,,,,,,,$lb(,"HSCUSTOM",$lb("e^zDeploymentServerOpen+1^%ZPM.PackageManager.Client.RemoteServerDefinition.1^3","e^zInstall+10^%ZPM.PackageManager.1^1","d^zShellInternal+53^%ZPM.PackageManager.1^1","d^zShell+2^%ZPM.PackageManager.1^1","d^ZPM^%ZLANGC00^2","d^^^0"))))/ ERROR #5770: Object open failed because 'DeploymentServer' key value of '1' was not found / ^mtemperr(14)="" ^mtemperr(15)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={49|50}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={49|50} / ^mtemperr(16)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={51|52}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={51|52} / ^mtemperr(17)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={53|54}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={53|54} / ^mtemperr(18)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={55|56}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={55|56} / ^mtemperr(19)="" ^mtemperr(20)="0 "$lb($lb(5001,"Error removing directory /intersystems/HSPRDAA/mgr/.modules/HSCUSTOM/simple-spellchecker/1.0.1/",,,,,,,,$lb(,"HSCUSTOM",$lb("e^zRemoveDirectoryTree+3^%ZPM.PackageManager.Developer.File.1^1","e^zLoadModuleFromArchive+8^%ZPM.PackageManager.Developer.Utils.1^1","e^zLoadModuleReference+104^%ZPM.PackageManager.Developer.Utils.1^1","e^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1^1","e^zInstall+60^%ZPM.PackageManager.1^1","d^zShellInternal+53^%ZPM.PackageManager.1^1","d^zShell+2^%ZPM.PackageManager.1^1","d^ZPM^%ZLANGC00^2","d^^^0"))))/ ERROR #5001: Error removing directory /intersystems/HSPRDAA/mgr/.modules/HSCUSTOM/simple-spellchecker/1.0.1/ / ^mtemperr(21)=1 ^mtemperr(22)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={57|58}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={57|58} / ^mtemperr(23)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={59|60}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={59|60} / ^mtemperr(24)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={61|62}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={61|62} / ^mtemperr(25)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={63|64}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={63|64} / ^mtemperr(26)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={65|66}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={65|66} / ^mtemperr(27)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={67|68}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={67|68} / ^mtemperr(28)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={69|70}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={69|70} / ^mtemperr(29)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={71|72}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={71|72} / ^mtemperr(30)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={73|74}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={73|74} / ^mtemperr(31)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={75|76}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={75|76} / ^mtemperr(32)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={77|78}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={77|78} / ^mtemperr(33)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={79|80}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={79|80} / ^mtemperr(34)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={81|82}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={81|82} / ^mtemperr(35)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={83|84}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={83|84} / ^mtemperr(36)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={85|86}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={85|86} / ^mtemperr(37)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={87|88}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={87|88} / ^mtemperr(38)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={89|90}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={89|90} / ^mtemperr(39)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92} / ^mtemperr(40)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1")),"0 "$lb($lb(6084,,,,,,,,,$lb(,"HSCUSTOM",$lb("e^zLoad+1^%SYSTEM.OBJ.1^1"))))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}- > ERROR #6084: Unknown errors detected, but no error code reported / ^mtemperr(41)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}> / ^mtemperr(42)="0 "$lb($lb(6084,,,,,,,,,$lb("zLoad+1^%SYSTEM.OBJ.1","HSCUSTOM",$lb("e^zLoad+1^%SYSTEM.OBJ.1^1"))))/ ERROR #6084: Unknown errors detected, but no error code reported / ^mtemperr(43)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1")),"0 "$lb($lb(6084,,,,,,,,,$lb("zLoad+1^%SYSTEM.OBJ.1","HSCUSTOM",$lb("e^zLoad+1^%SYSTEM.OBJ.1^1"))))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>- > ERROR #6084: Unknown errors detected, but no error code reported / ^mtemperr(44)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}> / ^mtemperr(45)="0 "$lb($lb(6084,,,,,,,,,$lb("zLoad+1^%SYSTEM.OBJ.1","HSCUSTOM",$lb("e^zLoad+1^%SYSTEM.OBJ.1^1"))))/ ERROR #6084: Unknown errors detected, but no error code reported / ^mtemperr(46)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1")),"0 "$lb($lb(6084,,,,,,,,,$lb("zLoad+1^%SYSTEM.OBJ.1","HSCUSTOM",$lb("e^zLoad+1^%SYSTEM.OBJ.1^1"))))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>- > ERROR #6084: Unknown errors detected, but no error code reported / ^mtemperr(47)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1"))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}> / ^mtemperr(48)="0 "$lb($lb(6084,,,,,,,,,$lb("zLoad+1^%SYSTEM.OBJ.1","HSCUSTOM",$lb("e^zLoad+1^%SYSTEM.OBJ.1^1"))))/ ERROR #6084: Unknown errors detected, but no error code reported / ^mtemperr(49)="0 "$lb($lb(5002,"SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>",,,,,,,,$lb(,"HSCUSTOM",$lb("$^zSHA1Hash+9^%Library.File.1 +2","$^zGetModule+24^%ZPM.PackageManager.Client.REST.PackageManagerClient.1 +1","$^zLoadModuleReference+76^%ZPM.PackageManager.Developer.Utils.1 +1","$^zLoadQualifiedReference+8^%ZPM.PackageManager.Developer.Utils.1 +1","D^zInstall+60^%ZPM.PackageManager.1 +1","D^zShellInternal+53^%ZPM.PackageManager.1 +1","D^zShell+2^%ZPM.PackageManager.1 +1","D^ZPM^%ZLANGC00 +2","X^@ +1")),"0 "_$lb($lb(6084,,,,,,,,,$lb("zLoad+1^%SYSTEM.OBJ.1","HSCUSTOM",$lb("e^zLoad+1^%SYSTEM.OBJ.1^1"))))))/ ERROR #5002: ObjectScript error: SQL error(s) have occurred during the running of the 'statsINFO()' method. Invoke the following method for additional details: set errID=##class(%SYS.PTools.Stats).getPToolsError(...) WHERE errRowID={91|92}>- > ERROR #6084: Unknown errors detected, but no error code reported /

[dgonzalez-intersystems]

Hi! Just in case it could help.

I've been facing this error today. I installed ZPM and, when I tried to install a module, I got the the error "SQL error(s) have occurred during the running of the 'statsINFO()" because of an error trying to get info from INFORMATION_SCHEMA.STATEMENTS (same error as #334 ).

I checked the status of SQL Stats as in https://github.com/intersystems/git-source-control/issues/137#issuecomment-1061050380, and I noticed that it was set to Option 1

I changed it to Option 0 so that no stats-collections would be included in query code generation, but I kept getting the same error.

Then, I installed ZPM again (leaving SQL Runtime Stats Collection Option set to 0)

s r=##class(%Net.HttpRequest).%New(),r.Server="pm.community.intersystems.com",r.SSLConfiguration="ISC.FeatureTracker.SSL.Config" d r.Get("/packages/zpm/latest/installer"),$system.OBJ.LoadStream(r.HttpResponse.Data,"c")

After that, I could install the module I wanted without errors.

To be sure this was what solved my problem, I set back the SQL Runtime Stats Collection Option to 1, I installed ZPM again and, when I tried to install a module, I got again the same error as at the beginning.

So my feeling is this error has to do with the "SQL Runtime Stats Collection Option" when ZPM was installed, not the current "SQL Runtime Stats Collection Option"

[isc-tleavitt]

@dgonzalez-intersystems thank you - this is fantastic information.