go to post Robert Cemper · May 29, 2018 I was unsure if I counted all separators right.but if you got it from Message Viewer it should be correct.did you verify you really got the message in hands? eg, by a TRACE or similar ?
go to post Robert Cemper · May 29, 2018 Assuming your separators are |~^&and if I counted correctly than FT1:16.... is empty but FT1:17.4.2 is 06CL
go to post Robert Cemper · May 25, 2018 You are right! This may work only in special situations.I reproduced your case simplified.SQL inbound adapter keeps a list of processed ids:if your id is in there it is skipped. Could be there is some other trick but not as in docs. the list looks like thisENSDEMO>zw ^Ens.AppData("SQLservice")^Ens.AppData("SQLservice","adapter.sqlparam","%LastKey")=198^Ens.AppData("SQLservice","adapter.sqlrow",196)=1^Ens.AppData("SQLservice","adapter.sqlrow",197)=1^Ens.AppData("SQLservice","adapter.sqlrow",198)=1^Ens.AppData("SQLservice","adapter.sqlrow",199)=1^Ens.AppData("SQLservice","adapter.sqlrow",200)=1^Ens.AppData("SQLservice","adapter.sqlrow",201)=1^Ens.AppData("SQLservice","adapter.sqlrow",202)=1^Ens.AppData("SQLservice","adapter.sqlrow",203)=1Manually removing it fixed my demo.
go to post Robert Cemper · May 25, 2018 according to your description I'd rather assume that you look for this functionality, especially concerning %LastKeyclassmethod ClearStaticAppData(pConfigName As %String)Clear static data for a config item. This is normally used to store already-processed status for input files, and other persistent values related to adapters, such as the %LastId for the SQL Inbound Adapter.or classmethod InitializeLastKeyValue(pConfigName As %String, pNewLastKey As %String = 0) as %String
go to post Robert Cemper · May 25, 2018 A Compile has also an errlog parameter ist is clear that it does an inner error trapping. ClassMethod Compile(ByRef classes As %String = "",qspec As %String = "",ByRef errorlog As %String,recurse As %Boolean = 0) As %Status [ CodeMode = expression ]. therfore at termination it doesn't end in your catch{ } I think it may even react specially on RESJOB by just doing a HALT.in a development environment, you may try to investigate this using a %ZSTOP routine
go to post Robert Cemper · May 24, 2018 first option:get the schema behind *.XSLX and import it using XML Schema wizard.It's incredible huge covering all XLS features you know and also that you don't want to know.several hundred classes. XML Schema WizardI gave up by lack of understanding where to start. I'm not strong with XLS features.second option:use ActiveX_64 to access *.XLSin Windows, your Studio has an Activate wizard that creates access to your local installed DLL.so you need to have EXCEL installed on your server.The wizard generates still a remarkable number of classes but it is more comprehensiveusing them you can do Scripting in EXCEL. Activate Wizard be careful to really get the 64bit version of the DLL
go to post Robert Cemper · May 23, 2018 I found this much more interesting! Stable with growth and double score from the follower.
go to post Robert Cemper · May 23, 2018 If your Table is on a Caché instance you may use the DSTIME feature that is also used to update DeepSee cubes.You track changes, deletes, inserts and can act appropriately.
go to post Robert Cemper · May 22, 2018 I remember a similar situation some years back with a rather sophisticated multilevel directory structure on UNIX.The final solution, especially for al kind of searching in unique file names, was a classwith the filename as ID and directory, summary, creation date, last modification as properties.The search (in SQL) out performed anything used before.The only extra work was kind of a register at file creation/modification which happened at a moderate rate. + a nightly batch job to verify and do the reality check.
go to post Robert Cemper · May 22, 2018 It is not directly what you look for but GlobalReferences are to some extent proportional by some factor to instantiations.especially if you deduct GlobalReads.##CLASS(%SYS.ProcessQuery) could be a source for those figuresif you compare it to "normal" code it could be an indicator.
go to post Robert Cemper · May 22, 2018 use Do $System.OBJ.ShowObjects() to list your refernced objects.The output goes to $IO or eventually a TmpCharStream.The start of the last line is your count of orefs .
