$system.UpgradeAll("",.ERRLOG) may give you a hint on problems.
Studio sticks with dictionary version. If there is a mismatch Studio refuses. And Mgmt Portal only shows Class documentation.
I'm not so familiar with Healthshare: Is there eventually some Read/Only DB involved that blocks Update ?
I think of class... EXTENDS (read/only class), ENSLIB ???
eventually check qualifiers. Do $system.OBJ.ShowQualifiers()
It could be necessary to set some of them by do $system.OBJ.SetQualifier()
Try to run $system.OBJ.UpgradeAll() to catch all namespaces involved
Some namespaces are excluded. %SYS for sure, not so sure about SAMPLES
Great stuff!
just a few years to late for me but good for future projects
I faced a similar issue some years back.
As PHP is so close to web servers I decided to use a WebsService to call the ClassMethod aka Procedure.
It was easy on both ends and I could avoid the ODBC module (at that time only 32bit)
I'd expect better text search in a source control repository.
Anyhow there is either a bug or a setup problem related to your Error msg in Atelier.
Do you have any Windows based PC available to use Studio ?
This routine is mapped to another database, are you sure you want to change it??
No => yes%DIRFULL.INT
reply with NO (default) and you won't change any %*routine if you work from your namespace (RPMS?)
I should learn
to type faster
you use %session.AppTimeout which has a default of 900 (sec).
but SetCookie asks for a Time !
method SetCookie(name As %String, value As %String, expires As %String = "", path As %String = "", domain As %String = "", secure As %Boolean = 0, httpOnlyFlag As %Boolean = 0)
I see from https://stackoverflow.com/questions/13154552/javascript-set-cookie-with-expire-time
what string this might be.
'Mon, 18 Nov 2019 08:50:17 GMT';My assumption - your 900 was just not recognized and the default (=session) was set
BTW.
why don't you use your source control for this type of text search?
just a guess:
with 850 chars length, this looks somewhat oversized.
and the query itself doesn't make much sense:
?query=.*Cache.*
&documents=*.cls,*.java,*.png,*.confluence,*.html,*.mediawiki,*.tracwiki,*.mdtext,*.shtml,*.doc,*.workingsets,*.chromium,*.patch,*.adoc,*.js,*.emof,*.macrodef,*.markdown,*.bmp,*.htpl,*.diff,*.xml,*.bas,*.xmi,*.ico,*.shtm,*.textile,*.twiki,*.ent,*.ecore,*.wsdl,*.ant,*.svg,*.md,*.prefs,*.jpeg,*.json,*.txt,*.int,*.rtn,*.xhtml,*.server,*.csr,*.mod,*.css,*.csp,*.class,*.xsd,*.docx,*.gif,*.log,*.exsd,*.xsl,*.xslt,*.e4xmi,*.mac,*.setup,*.mvb,*.ad,*.asciidoc,*.wml,*.dtd,*.mvi,*.htm,*.jpg,*.inc,*.properties
&max=2147483647
&sys=1
&gen=0
I doubt that you have all those file extensions available in Caché or IRIS
Reduce it to the few useful ones that you konw from Studio:
*.prj,*.mac,*.int,*.mvi,*.inc,*.bas,*.cls,*.csp,*.csr,*.xml,.*js.*.css,*.xsl.*.xsd,*.mvb,*.dfi
I don't trust this line: Set zdh=$zdatetimeh("11/14/2019 15:18:56")
rather use
Set zdh=$zdatetimeh("2015-11-14 15:18:56",3)
to be sure about zdh
by default IRISLIB is always read-only mounted as it holds most of system methods, utilities, compiles, ...
all code that just executes but not changes during runtime and that you should not try to change
differently, IRISSYS holds all dynamic system data that can change during runtime and therefore requires read-write access
As configurations, namespace tables, .....
Though with system management privileges you may change this.
But I'd recommend not to touch it unless you are an in-depth IRIS expert.
SqlComputeOnChange should trigger on INSERT
while it should trigger only if the value is CHANGED by an UPDATE.
If you need recalculation in any case you may use an ordinary Update TRIGGER to adjust your property as you need.
Right!
But without Git (several years back) . . . . . . . .
It's a matter of organization and discipline anyhow.
another way to explain your phenomenon:
I experienced such a case where the bomb was sleeping for 5 years.
Nobody remembered the change of a.INC and not the reason for the change.
if your class inherits from some other the include may have gone there?
typically explained by: "We do not reference it here. "
It seems that you have lost the ????.inc the includes the definitions of
$$$vaExtentGbl
$$$vaSegment
$$$vaSegmentGbl
$$$vaDataSegName
$$$vaDataDocName
either you lost the related Include statement or the whole file is lost 
So in Studio run a "search in files" over *.inc for
#Define vaExtentGbl
#Define vaSegment
#Define vaSegmentGbl
#Define vaDataSegName
#Define vaDataDocName
to find out which .inc you are missing.
The query you changed is totally unrelated to it, as far as it seems.
OK.
It took some investigations to understand what's going on.
the is a Class
it switches between <Ping></Ping> and <Ping />
BUT: if ALL Properties of your reply are empty then you just get
an empty body <soapenv:Body></soapenv:Body>
as soon as you set some dummy value into Property Ping you get <Ping> </Ping>
or you add a dummy property.
Digging into %SOAP.... message classes shows, that the generated messages don't use
Check XML projection of Property Ping
especially handling of null strings controlled by XMLNIL & XMLIGNORENULL parameter.
see Handling Empty Strings and Null Values
if you add to your data class
Class NAMEHERE.myDate [ ClassType = datatype, ClientDataType = DATE, OdbcType = DATE, Not ProcedureBlock, SqlCategory = DATE ]
these 2 methods you get a kind of self healing code.
It is accessed every time you load or save your property
Hi Alex,
"in logical Mode the date shows normal format, in my case, for example 10/1/2019"
in logical mode you get the pure content from global which is here NOT a $H value !!
$ZD() expects an Integer to convert => it is just +"10/1/2019" => 10
then $ZD(10) = " 10/1/1841"
So it seems that some of your Dates are not stored using DisplayToLogigal resulting in an Integer
but written directly (e.g. coming from ZEN) into your object / global.
To fix it you may run something like if +in'=in set in=$zdh(in))
InterSystems Docker Images
https://wrc.intersystems.com/wrc/coDistContainers.csp
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 )
It's a matter of design of the table.
pls. provide the table description
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.
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.png)
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 SubTotal
FROM sample.person o
where age < 20
.png)
"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-11
I'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.