-
Notifications
You must be signed in to change notification settings - Fork 19
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Error with install command #545
Comments
@SCanzano what IRIS version? (w $zv) |
#334 is similar but there's no real resolution there. |
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:
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. |
%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}>� |
ok, that's clearly unrelated from the SQL stats error. Can you try the zbreak variation? |
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
and
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
|
@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) Load started on 08/20/2024 19:56:28
HSCUSTOM>zw %ROWCOUNT=1 HSCUSTOM>zpm =============================================================================
|
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 |
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 intersystems/git-source-control#137 (comment), 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" |
@dgonzalez-intersystems thank you - this is fantastic information. |
On a new environment we did
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}>
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
The text was updated successfully, but these errors were encountered: