go to post Timothy Leavitt · Jan 13, 2022 Right - at this point I'd say set Server to apisidra.ibge.gov.br instead of api.sidra.ibge.gov.br and see if that fixes it.
go to post Timothy Leavitt · Jan 11, 2022 It looks like there might be an issue with the service you're trying to use - at https://apisidra.ibge.gov.br/ , pasting in "/t/1612/n2/all/v/all/p/last/c81/2702/f/u" as "Parâmetros/valores da API:" then clicking "Consultar" I get an alert saying "A solicitação de conexão com pools sofreu timeout". I also see this from ObjectScript with Server set to apisidra.ibge.gov.br instead of api.sidra.ibge.gov.br
go to post Timothy Leavitt · Jan 11, 2022 I'd recommend looking at what (other than valid JSON) is in result.HttpResponse.Data. Also worth looking at result.HttpResponse.StatusCode - is it 400 or 404?
go to post Timothy Leavitt · Dec 15, 2021 This is awesome!! Clarifying question - re: "special tables that only support row-based sampling", would this be tables with custom/non-default storage definitions?
go to post Timothy Leavitt · Dec 14, 2021 Thanks - simple example is: do ##class(%SQL.Statement).%ExecDirect(,"select top 10 'foo'").%DisplayFormatted("CSV",,,.filesUsed) do ##class(%Stream.FileCharacter).%OpenId(filesUsed(1)).OutputToDevice()
go to post Timothy Leavitt · Dec 13, 2021 @Steve Pisani I like the idea of this being configurable. You might want to chime in at https://github.com/intersystems/git-source-control/discussions/78 with your view on how this should work.
go to post Timothy Leavitt · Dec 8, 2021 Note, this also assumes default global names - if you have customized these, you'll want to just get all globals. Also, replace 'C:\InterSystems\IRIS20\mgr\user' with the appropriate database directory for your instance.
go to post Timothy Leavitt · Dec 8, 2021 Here's a full example relating global size back to related classes/tables, expanding on @Vitaliy.Serdtsev's example: select sdef.parent "Class", class.SqlSchemaName||'.'||class.SqlTableName "Table", LIST(sdef.Location) "Globals", SUM(s."Allocated MB") "Allocated MB", SUM(s."Used MB") "Used MB" from %SYS.GlobalQuery_Size('C:\InterSystems\IRIS20\mgr\user','','*D,*S,*I',0,0,1) s join ( select parent,DataLocation as Location from %Dictionary.StorageDefinition where not parent %STARTSWITH '%' union all select parent,StreamLocation from %Dictionary.StorageDefinition where not parent %STARTSWITH '%' union all select parent,IndexLocation from %Dictionary.StorageDefinition where not parent %STARTSWITH '%' ) sdef on sdef.Location = '^'||s.Name join %Dictionary.CompiledClass class on class.Name = sdef.parent group by sdef.parent Note that if you use inheritance with persistent classes sharing an extent this'll be a little bit off (since the same global is used for multiple classes and will be double counted).
go to post Timothy Leavitt · Dec 2, 2021 I feel like a broken record, but InterSystems Support is pretty awesome and probably a better place to start for deeper HealthShare issues than the Developer Community. (And at first glance this seems like a deeper HealthShare issue.) Though it would be great if you could circle back and say what the solution was once you have one in case someone else runs into this!
go to post Timothy Leavitt · Dec 1, 2021 Clarifying: I really enjoy the coding challenges and would highly recommend them, but competing for a top spot is a level of intensity beyond what I'd do. (Even if I wasn't an InterSystems employee and was eligible for prizes other than clout. )
go to post Timothy Leavitt · Dec 1, 2021 Just installed Docker on my machine for the first time (had just used it for GitHub Actions/Travis CI before). I feel a little bit like an old dog trying to learn new tricks... AOC 2021 is a good excuse for it!
go to post Timothy Leavitt · Dec 1, 2021 Based on past years (participating as I have time between my day job and family obligations... so typically dropping off around the 15th), the ObjectScript leaderboard tends to be pretty competitive. Especially in terms of when the challenges drop - I'm not staying up until midnight or whatever it is to be in the top few. Generally, Docker is better on a Mac than Windows, from what I hear.
go to post Timothy Leavitt · Nov 29, 2021 @Peter (Sechaba) Tomodi I'd recommend reaching out to InterSystems Support on this.
go to post Timothy Leavitt · Nov 22, 2021 @Steve Pisani glad to hear you'll be using it - your feedback (via GitHub issue, email, Teams, or carrier pigeon) is certainly welcome! I know it took a long time to get this out, but better late than never! Shout out to @Sarmishta Velury and Adewale Adewuyi (who I can't tag) for helping to make it happen. :)
go to post Timothy Leavitt · Nov 22, 2021 See also: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...
go to post Timothy Leavitt · Nov 22, 2021 Another note on this - there are some new behaviors in recent IRIS versions around the SameSite flag on cookies. (see: https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/Set-Cookie/Sam... for general background and https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls... for an explanation of the IRIS changes). This can make cookies behave differently in iframes, doing HTTP redirects, even opening via a link; how you get to a page has a bearing on cookie behavior. Not sure if that fed into the issue you saw but it's worth noting.
go to post Timothy Leavitt · Nov 15, 2021 @Chris Marais This means that ^PERFMON or ^%SYS.MONLBL is already running somewhere on the system. If you do ^%SYS.MONLBL it should provide some helpful output/options.
