go to post Robert Cemper · Nov 4, 2019 I did a retry on a different instance and couldn't reproduce the message. I'm sorry.
go to post Robert Cemper · Nov 1, 2019 Hi Vic, I clicked on ACTIVATE, selected the key file but nothing changed. I got this one by mail this one: InterSystems IRIS Server for x86-64 (Microsoft Windows):256 Natural Language Processing (NLP), Sharding, Enterprise Cache Protocol (ECP) Same with the Demo Key I downloaded worked fine: LicenseCapacity=InterSystems IRIS 2019.1, Enterprise:64, Concurrent User, Platform Independent I'm wondering which license server is referred with a stand-alone installation.I feel lost.
go to post Robert Cemper · Oct 31, 2019 After using the correct license file the message was gone. But I still don't understand the "content" & context.
go to post Robert Cemper · Oct 30, 2019 For a more precise explanation: Table definitions with ALL indices are required and the complete query plans not just a summary. And also your version ( $ZV )
go to post Robert Cemper · Oct 30, 2019 It's a matter of design of the table. pls. provide the table description
go to post Robert Cemper · Oct 29, 2019 If RESTR_DATETo you try to change is part of the Idkey you can't do an UPDATE on it. Instead you need an INSERT with new Contents and DELETE of the old.
go to post Robert Cemper · Oct 28, 2019 and with ROW number select %VID as Row ,* from ( SELECT age , (Select sum(i.age) from sample.person i where i.id <= o.id and age < 20 ) as SubTotal FROM sample.person o where age < 20)
go to post Robert Cemper · Oct 28, 2019 As your table is not available I took a Table from SAMPLES using a subselect SELECT age , (Select top all sum(i.age) from sample.person i where i.id <= o.id and age < 20 ) as SubTotalFROM sample.person o where age < 20
go to post Robert Cemper · Oct 26, 2019 "cautionary M tales" is really ages old and outdated. But see it from reverse side: You can run without any change code that was written 40 years ago on PDP-11I've seen it and can confirm it.I know of no other system that allows spanning that range of time without touching the code. But you are not forced to write that style. Or you can even write your code in BASIC if you dislike COS.
go to post Robert Cemper · Oct 25, 2019 IN expects a series of values like In (1,5,23,7) but :portCode supplies a String as 1 single value "'AB','TS','SK','GM'" which is useless better use SET portCode = $lb("AB","TS","SK","GM") and SELECT STRING(Descrtiption,' (',Code,')') as Description,Code FROM Test.Codes WHERE Code %INLIST :portCode
go to post Robert Cemper · Oct 13, 2019 As I see from code ^OPNLib.Game.CWLF is just a Global variable to maintain the actual state of the display structured by Worlds and Display lines.And it rebuilds the image in cyles. It has nothing to do with the class definition but is an independent structure.So you just see it in various methods.
go to post Robert Cemper · Oct 9, 2019 Honestly, I never saw an <INVALID OERF> related to a lack of memory. It typically happens if you do set obj=##class(MyClass).%OpenId(id,,.status) and do not check for success. https://cedocs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?PAGE=CLASS&LIBRARY=%25SYS&CLASSNAME=%25Library.Persistent#METHOD_%OpenId so if you miss if '$isobject(obj) { .... error processing using status....} or similar then the next access to obj.MyProperty will throw <INVALID OERF> Only checking the status will tell you if you really ran out of memory
go to post Robert Cemper · Oct 8, 2019 keyword RENAME TO is not supported by ALTER TABLE see docs. https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_altertable
go to post Robert Cemper · Oct 7, 2019 There are more chances to get a timeout, but this is the most probable reason.
go to post Robert Cemper · Oct 7, 2019 The management portal has various screens with update features. (e.g Job status) Íf IRIS service stops the update fails with a timeout. This is your alert.
go to post Robert Cemper · Oct 7, 2019 with &SQL(SELECT MAX(ID) FROM Cinema.Film) you eliminate the need of ORDER BY ... and save time
go to post Robert Cemper · Sep 23, 2019 Ok. Sorry, don't have it available anymore.WRC should have it.
go to post Robert Cemper · Sep 23, 2019 ERROR <Ens>ErrException: <METHOD DOES NOT EXIST>zCopyFrom+28^%Stream.TmpCharacter.1 *Rewind Pls. add Version. (I couldn't identify any REWIND in CopyFrom)
