go to post Julius Kavay · Nov 9, 2022 I do not work with Ensemble nor do I have Ensemble installed... But you could take a close look on that Ens_Enterprise_MsgBank.MessageHeader class, and check, if there is a mapping into an other, possibly readonly, database. Maybe somebody with ENS experience has a solution for you
go to post Julius Kavay · Nov 9, 2022 As I learned the hard way, abstract classes do not have storage implementation, hence no indices either
go to post Julius Kavay · Nov 9, 2022 One of the possible solutions /// You can change the s:b]"" to an comma if there is always exact one space between the words /// and remove the ,1) from $lts() if all word are numbered from 1..N with no number missing ClassMethod WordOrder(s) { s z="" f i=1:1:$l(s," ") s b=$p(s," ",i) s:b]"" $li(z,$zstrip(b,"*ap"))=$zstrip(b,"*n") q $lts(z," ",1) } This is a working solution and maybe not the shortest
go to post Julius Kavay · Nov 8, 2022 I never had this kind of problem, but a quick and dirty method would be: 1) remove the 'Mount Read-only' flag, 2) run the tune table utility, 3) reenable the 'Mount Read-only flag'. I hope, you do not have some mean application, waiting for the chance of his life, to get a writable database...
go to post Julius Kavay · Nov 7, 2022 License counting depends on how you access Cache/IRIS (i.e. Web interface or some kind of client).
go to post Julius Kavay · Nov 7, 2022 You can it enter via terminal, no question about, but it's a little bit cumbersome // create the class s cls=##class(%Dictionary.ClassDefinition).%New() s cls.ProcedureBlock=1 s cls.Super="%RegisteredObject" s cls.Name="ObjectScript.RightTriangle" // add one method s mth=##class(%Dictionary.MethodDefinition).%New() s mth.Name="Main" s mth.Description="Compute area and hypotenuse of a right triangle" d mth.Implementation.WriteLine($c(9)_"write !,""Compute the area and hypotenuse of a right triangle"",") d mth.Implementation.Write($c(9,9)_"!,""given the lengths of its two sides.""") d cls.Methods.Insert(mth) // add one more method s mth=##class(%Dictionary.MethodDefinition).%New() s mth.Name="Area",mth.Description="Area, computed from sides 'a' and 'b'" s mth.FormalSpec="a,b" d mth.Implementation.WriteLine($c(9)_"quit a*b/2") d cls.Methods.Insert(mth) // save the class (it's NOT compiled!) w cls.%Save() As you may see, creating a class via an IDE is simpler... but yes, in an emergency case you can do it also via a console access
go to post Julius Kavay · Nov 5, 2022 First, ##class(%PopulateUtils).StringMin(16,16) generates random printable chars for testing (as replacement for user input) and is not ment to be used to generate cryptographic random chars. If you need cryptographic random chars, use $system.Encryption.GenCryptRand(length). This is just a hint and is not a reason for your current problem. Second, despite my very limited C# experience, there is one thing in your code, I do not understand. If the initial vector (IV) is used, then it should be used (for enryption and decryption) the same IV on both sides, but you create an IV on Cache side (with the populate utils) and an other one on the C# side: byte[] IV = new byte[16]; (new Random()).NextBytes(IV); That your decryption can't work. To have a successful comunication, agree with the other party on- a passphrase (the key), padding is done inside the encoding function - an IV (or left it empty on both sides)- and on how the data will be sent: either as the encoded (binary) data or as a readable (base64) data.ISC's implementation of AESCBCEncrtypt/Decrypt works well. One of my application uses it to communicate with an Windows application written in Delphi, without any problem since more the 15 years (we do not use the IV). So your problem will be some kind of a home-made problem:- not using the same keys on both sides- applying some kind of transformation (utf-8, base64, etc.)- something suchlike
go to post Julius Kavay · Nov 4, 2022 One of the problems could be the Bas64 encoding. This function inserts after each 76th byte a CRLF which possibly confuses the other party. Try with Set EncryptedBase64=$SYSTEM.Encryption.Base64Encode(encrypted, 1) The parameter 1 says, do not insert CRLFs. Also, the text you encrypt must be an ANSI (8bit) text. If you are on a unicode system, you should call Set encrypted=$SYSTEM.Encryption.AESCBCEncrypt($zcvt(text,"O","UTF8"),key,iv)
go to post Julius Kavay · Nov 3, 2022 I understand your answer (#2) the way as this is a one time job. The simplest and quickest way to do this is: - disable all indices (comment them out), - compile the class or classes - do the bulk insert - enable all indices (by removing comment markers) - compile the class or classes - rebuild the indices Class My.Class { /* disable all indices index1 someindex1 on someprop1; index2 someindex2 on someprop2; */ }
go to post Julius Kavay · Nov 2, 2022 You are just one letter away from solution... set db=##Class(SYS.Database).%OpenId("/trak/base/tc/db/ct",,.sc) //................................^^^ Id, not ID!
go to post Julius Kavay · Nov 2, 2022 The problem has nothing in common with Cache or IRIS, it's an OS setting. If a network drive is not available (for example the target is switched off), Windows waits an half an eternity. You have to ask your sysadmin or Google, providing your Windows version. The very first hit I found is this but it's somewhat old.
go to post Julius Kavay · Oct 20, 2022 Nice, merely your insert rate is somewhat low. About ten years ago, Cache inserted in proof-of-concept project 112000 rows per second. Seen in this way, the (708000/20) 35400 are a bit little...
go to post Julius Kavay · Oct 20, 2022 I do not use Ensemble, but I would try using the JSON-Adaptor, something like this Class MessageB Extends (Ens.Request, %JSON.Adaptor) { Property ClientId As %String(MAXLEN = ""); Property message As %Stream.TmpBinary; } For example s r=##class(MessageB).%New() s r.ClientId=12345 d r.message.Write("part1") d r.message.Write("part2") w r.%JSONExportToStream(.s) d s.Rewind() w s.Read(s.Size) --> {"ClientId":"12345","message":"cGFydDFwYXJ0Mg=="}
go to post Julius Kavay · Oct 20, 2022 REST-API is not my daily bread, so show me a few lines of your (problematic) code and I will try my best
go to post Julius Kavay · Oct 19, 2022 Your solution is nearly perfect, here my quick (untested) version. ClassMethod Encode() { // You read N bytes (which MUST be divisible by 3) and write N*4/3 encoded bytes // 3 * 8190 = 24570; 24570 * 4 / 3 = 32760; 32760 < 32768; to avoid (slow) long strings set CHUNK=24570 set NOCR=1 // don't insert CRLF after each 72 written bytes set encodedData=##class(%Stream.TmpBinary).%New() // adapt this to your needs: %Stream.Whatever... set request=##class(%Net.HttpRequest).%New() set request.Server="..." do request.Get("/...") if request.HttpResponse.StatusCode = 200 { while 'request.HttpResponse.Data.AtEnd { do encodedData.Write($system.Encryption.Base64Encode(request.HttpResponse.Data.Read(CHUNK),1)) } } QUIT encodedData // as an alternative, you could return a string or a streamobject set YOURMAXSTRING = 32767 // or 3641144 if encodedData.Size <= YOURMAXSTRING { do encodedData.Rewind() quit encodedData.Read(encodedData.Size) } else { quit encodedData } }
go to post Julius Kavay · Oct 19, 2022 Assuming, fields which contains commas are quoted ("aaa,bbb,ccc") and (for the simplicity) fields does not contains quotes, then something like this should do the job ClassMethod CSV(filename) { s old=$system.Process.SetZEOF(1) // use $zeof instead of error trap s result=[] o filename:"r":0 i $t { u filename while '$zeof { read line i line]"" do result.%Push(..fields(line)) // ignore empty lines } } c filename d $system.Process.SetZEOF(old) q result } ClassMethod fields(line) { s a="", f=0, row=[] f i=1:1:$l(line) { s c=$a(line,i) i c=44,'f d row.%Push(a) s a="" continue i c=34 s f='f continue s a=a_$c(c) } q row } A test output: USER>s res=##class(DC.Help).CSV(fn) USER>zso res (0).(0).............: 12162 (0).(1).............: CHAPTER I (0).(2).............: Certain infectious and parasitic diseases (A00-B99) (0).(3).............: 003 (A20-A28) (0).(4).............: Certain zoonotic bacterial diseases (0).(5).............: A28 (0).(6).............: Other zoonotic bacterial diseases, not elsewhere classified (0).(7).............: A28 (0).(8).............: Other zoonotic bacterial diseases, not elsewhere classified (0).(9).............: N (0).(10)............: N (0).(11)............: N (0).(12)............: N (0).(13)............: N (0).(14)............: (0).(15)............: (0).(16)............: (0).(17)............: (0).(18)............: (0).(19)............: (0).(20)............: (0).(21)............: (0).(22)............:
go to post Julius Kavay · Oct 11, 2022 Oh yes, some 45 years ago, 2K (for caretaker and despooler), 4K as regular partition. Nowdays you need 2GB or 4GB! Just a factor of 10^6. And yes, I feel as a real developer too. The problems solution matters, not the tools.
go to post Julius Kavay · Oct 10, 2022 At least, you are one step further (in your initial post, you wrote "...because the code is hanging at Set tSc=Httprequest.Get(HttpURL)..."). Maybe the provided MAC number is wrong. The MAC Number CC:1B:E0:E2:3C:10 belongs to Cassia Networks. Is that the right number? I know exactly nothing about Cassia Networks and Cassia SDK... sorry.
go to post Julius Kavay · Oct 10, 2022 This is just a hint: your Get() argument should be URL-encoded (colons are not allowed in an URL): Set tSc=Httprequest.Get($zcvt(HttpURL,"O","URL"))
go to post Julius Kavay · Oct 10, 2022 You are mixing two different things... Property Data1 As list of %String; Property Data2 As %List; are two very different things. The first (Data1, equates to your DataObj.Services) is an object while the second one (Data2) is a simple scalar value (in this case a string which in its structure casually matches the inner structure of a $list() respective $listbuild() function). write $listvalid(oref.Data1) ==> 0 // NOT a list write $listvalid(oref.Data2) ==> 1 // a VALID list write $isobject(oref.Data1) ==> 1 // a valid (list)object write $isobject(oref.Data2) ==> 0 // not a valid (list)object $listnext() does NOT work on objects (your DataObj.Services) is an object