go to post Robert Cemper · Mar 1, 2018 you need an oref in ref and also in Myproperty1, ... So you have to check both . see answer
go to post Robert Cemper · Mar 1, 2018 ClassMethod myfuct( id) As %String{ set ref=##class(myClass).%OpenId(id) If '$isobject(ref) quit "no object 1, no return" if '$isrobject(ref.Myproperty1) quit "no object 2, no return" set str="my return: "_ref.Myproperty1.OtherClass1Property quit str}
go to post Robert Cemper · Mar 1, 2018 you do set ref=##class(myClass).%OpenId(id)but you don't check if you really got an object. the id might be invalidcontinue with if '$isobject(ref) quit ""
go to post Robert Cemper · Mar 1, 2018 the code causing the problem in MyClass.2.int looks most likely like this: Set oid=$select(i%Myproperty="":"",1:$listbuild(i%Myproperty_""))you are inside an ObjectMethod and miss the actual Object reference.This happens when you try to access a property inside a Classmethod. classic mistake:ClassMethod MyMethod(1,2,3) as %Status { set x=..Myproperty}correct use: ClassMethod MyMethod(oref,1,2,3) as %Status { set x=oref.Myproperty}
go to post Robert Cemper · Mar 1, 2018 Whether external backup or backup from a mirror (also asynchronous) or Caché backup you always have to identifythe point in time when your DB is logically consistent. What I think of is no open transactions, no open dependencies.If you know that point in time you could separate your async mirror or shadow and run any backup from there.Or just shut down your async server instance and run snapshots.But there might also be a time gap between master and async server.Once completed your async server can join again and catch up whatever time that may take. The critical point is to know when the async server has reached consistency.But that depends on the application.
go to post Robert Cemper · Feb 28, 2018 there is a method CopyFromStream that really moves the content to a new StreamSo your PDF moves from physical file to a Global stream that you work up and down as a "private" copy.Without touching the original anymore. This might be a useful option.
go to post Robert Cemper · Feb 28, 2018 for a file stream it's a physical file, for a global stream it's a global or part of it.if you clear it you either delete the file or the global (or its part )that holds the stream.stream in Caché describes a sequence of persistent bytes on disk that you work on with dedicated common methods.this must not be mixed up with a stream of characters on a network connection. if you miss a character there it's gone.
go to post Robert Cemper · Feb 28, 2018 Clear() removes all content. The easiest way to CLEAR a file is to remove it. in any file system.
go to post Robert Cemper · Feb 28, 2018 "lightweight" is the theoretical approach for object purists that want to have just 1 object covering the world and don't care about practical use. They often were moaning "oh only 1.n relationship". As you noted "heavy" allows real relation management. And could be faster in some cases.
go to post Robert Cemper · Feb 28, 2018 Hi Alexey,You hit the point: "lightweight" just documents the relation. Full stop. No further service.You have to service (ie. Delete) it at both ends.If you use a serial object with OREF + Status) you still have to service both ends.The "heavy" variant does it centralized at one place.Though from storage point of view you move out the additional subscript level from array.
go to post Robert Cemper · Feb 27, 2018 Hi, Evegeny!for both variants you work along the array by GetNext() methodfor each employee you have an array with the OREFs of the company. So you have the full object at hands.similar the opposite direction from company to employee and employee->nae in SQL or employee.nameAnd as we always have a Collection type Array indexing is simple either by (KEY) or (ELEMENT). whether you need the ID or the OREFhttp://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQLOPT_indices#GSQLOPT_indices_collectionsThe only tricky action is DELETE: there you have to have a method to "DisRelate" before delete.But real commercial systems never delete anything. Just set a flag "isDeleted". Which is much easier for any "undo" action.
go to post Robert Cemper · Feb 27, 2018 It's a value returned from OS:So this might be platform dependent.the call is $zu(140,5,$select($$$isVMS&&(%file'[";"):%file_";*",1:%file))the part for VMS deletes all versions of the file if the name is not terminated by " ;"
go to post Robert Cemper · Feb 27, 2018 First I would expect Soap.InboundAdapter writes to stream and has no limit.But if longstrings are enabled the MAXsize of a %String is ~3.6 MB. Your description sounds to fit this.You may look at your Adapter where the input goes.But it might be also later processing of a stream to cause the problem.
go to post Robert Cemper · Feb 27, 2018 doc say: classmethod Delete(filename As %String, Output return As %Integer) as %Integer Deletes the file filename. Returns true if it succeeds and false otherwise. Pass return by reference to obtain the low level return value in case of errors so try: set success = file.Delete(File, .return) to see the reason for failing
go to post Robert Cemper · Feb 26, 2018 You look for INSERT from Querydoc is here http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_insert#RSQL_insertselectAs far as I see it should work the way you have written(assuming data types between target and source match) To estimate runtime you may try the select count(*) from VwSrcTable first to get a feelinghow many records that will be. Then during load running Select count(*) from DestTable from a 2nd session may let you see your progress.
go to post Robert Cemper · Feb 26, 2018 pls. post your query in detail.it's not obvious what you try to do.
go to post Robert Cemper · Feb 22, 2018 SQLCODE -99 Privilege violationYou have 3 different sets of access rights in this scenarioyour development user the application userthe user your Caché / ENS server installation is running onCheck if also your server has the required access rights at OS level.under *IX it's quite likely that you don't run as root.(though this happens also on other OS)
go to post Robert Cemper · Feb 22, 2018 OMG CCUCL ! (OhMyGod CamelCaseUpperCaseLetters !).Thanks, @Eduard.Lebedyuk . I never could have guessed it.
