Try to check who calls GetBatchHeader and what it returns.
At a glance, I think it's called from GetBatchObject method of EnsLib.RecordMap.Service.BatchStandard class:
Set tStatus = $classmethod(..BatchClass, "GetBatchHeader", pIOStream, pTimeout, .pBatch, .pLookAhead) If $$$ISERR(tStatus) Quit
Check that tStatus is not an error, fix GetBatchHeader it if it's an error.
As I originally said
Note that changing value back would still mark property as modified.
Any change (except immediate same value) would set m%PropName to 1.
I think that checking m%PropName and only if it equals one additionally checking GetStored would work faster.
m%PropName returns 1 if the property value was modified, 0 if not.
Thanks. I've read Config.Mirrors docs, got the memo that it shouldn't be used to edit, and only recalled ^MIRROR routine. SYS.Mirror and %SYSTEM.Mirror would be way better.
You can determine that in run time with:
Here's a simple example of how it all works
Class User.Person Extends (%Persistent)
{
Property Name As %String(DISPLAYNAME = "Name");
Property Age As %Integer(DISPLAYNAME = "Age");
/// Create one user
ClassMethod Recreate() As %Status
{
do ..%KillExtent()
set person = ..%New()
set person.Age = $random(100)
set person.Name = $random(100)
quit person.%Save()
}
/// do ##class(User.Person).Test()
ClassMethod Test()
{
$$$QuitOnError(..Recreate())
set person = ..%OpenId(1)
do person.ModificationState()
set person.Age = $random(100)
do person.ModificationState()
set person.Name = $random(100)
do person.ModificationState()
}
/// Show current object state
Method ModificationState()
{
write "Object modified: ", $system.CLS.GetModified(), !
write "Name prop modified: ", ..IsNameModified(), !, !
}
/// Get name property modification status
Method IsNameModified() As %Boolean
{
quit m%Name
}
}
Executing in terminal:
>do ##class(User.Person).Test() Object modified: 0 Name prop modified: 0 Object modified: 1 Name prop modified: 0 Object modified: 1 Name prop modified: 1
Note that changing value back would still mark property as modified.
Installer manifest can call arbitrary code.
It's a url not a file so you need to use OpenURL for that:
set reader=##class(%XML.Reader).%New()
set httprequest=##class(%Net.HttpRequest).%New()
set httprequest.SSLConfiguration="...."
set status=reader.OpenURL("https://.....",,httprequest)But as @Robert Cemper pointed out it's a dtd file and so would not be parsed by XML reader.
If you want to generate classes automatically from XML schema, you'll need XSD files. Documentation.
What's your current locale? If it's not Chinese you may want to change it. Note that it significantly affects system behavior and you should understand the implications in such a change.
???? often indicates the data loss during encoding conversions consider this Cyrillic example:
set t = "Привет" USER>zzdump t 0000: 041F 0440 0438 0432 0435 0442 Привет USER>zzdump $zcvt(t, "I", "UTF8") 0000: 3F 3F 3F 3F 3F 3F ?????? USER>zzdump $zcvt(t, "O", "UTF8") 0000: D0 9F D1 80 D0 B8 D0 B2 D0 B5 D1 82 Ð.Ñ.ивеÑ.
Note the difference between question marks and the last output. Last output is just encoding translation, but the first conversion - into questions completely lost the information, so you need to look deeper.
You can try to modify TCP/IP IO table via ^NLS utility in %SYS namespace
do ^NLS 1) Display current locale 2) Select defaults 3) Change locale 4) Display loaded settings 5) Advanced NLS option? 2 1) Internal tables 2) I/O tables 3) CSP files 4) Date, time and number formats Category of defaults? 2 Items marked with (*) represent the locale's original default I/O table Current default --------------------- -------------------- 1) Process RAW (*) 2) Cache Terminal UTF8 (*) 3) Other terminal UTF8 (*) 4) File UTF8 (*) 5) Magtape UTF8 (*) 6) TCP/IP RAW (*) 7) System call RAW (*) 8) Printer CP1251 (*) I/O table: 6 1) RAW (*) 2) UTF8 3) UnicodeLittle 4) UnicodeBig 5) CP1250 6) CP1251 7) CP1252 8) CP1253 9) CP1255 10) CP866 11) CP874 12) EBCDIC 13) KOI8R 14) Latin2 15) Latin9 16) LatinC 17) LatinG 18) LatinH 19) LatinT Selection for TCP/IP: 1 =>
If you absolutely do not want to upgrade, you can take old json classes from 2014 (or 2017) and import them into Cache 2008.
The classes are:
That said an upgrade would be a preferable solution.
You can create a separate query table with fields: query, user, time, arg1. arg2. ar3, ..., argN.
And log information about the queries as is. This way you would be able to:
Additionally there's ODBC logging and JDBC logging might be available depending on the database vendor.
Not really. The statement is passed as is and three arguments are passed separately.
Why do you need that?
The final text would only be "compiled" on a target system if at all.
Why do you need that?
Default XMLPROJECTION for collection properties is WRAPPED, which adds wrapping tag.
Define your list property this way:
Property LIST As list Of test.List(XMLPROJECTION = "ELEMENT");
Added latest release, check it out.
Should be fixed now.
Seems possible.
Do you want to download data from Dynatrace into Ensemble or to send data (i.e. alerts) into Dynatrace?
value in the database gets overwritten
You need to set the whole value at once with SetParameter.
If you mean different procedure calls than you need to debug the procedure itself.
1. If you replace:
set sc=gc.SetParameter(hstmt,$LB(gc.PutData(hstmt,.temp)),2)
with:
set sc = gc.PutData(hstmt, "TEXT")
or with:
set sc = gc.SetParameter(hstmt,$LB("TEXT"),2)What do you get?
2. Also in your original 4-parameter generated code the stream is bound via:
s err=$zf(-5,%SQLGateway,62,QHandle,4,1,1,12,500,0,500)
which is equal to
set sc=gc.BindParameter(hstmt, 4,1,1,12,500,0,500)
In your new code you bind the stream with:
Set sc=gc.BindParameter(hstmt,2,1,1,12,0,0,-2)
Is it from some other generated code?
First you need to link the procedure, and after that you would be able to call it from your BO.
Is your stored procedure in Ensemble or MSSQL?
Do you have a server connection defined?
Tried that, not the best idea. Tracing and debugging become much harder and you can't query as easily via SQL.
Usually I work with JSON input in Ensemble like this:
Just one point it's Angular2 not AngularJS - I think AngularJS could be delivered by CSP but I doubt that it would be the best way to deliver Angular2
What's the difference between AngularJS and Angular2 in regards to CSP?
AngularJS is the first version, Angular 2-5 are collectively referred as Angular and somewhat compatible between themselves. @Sergei Sarkisian?
Connection is not license. From docs:
Maximum number of processes (connections) per user is 12.
Will this affect our own internal tasks?
It shouldn't as that would be one connection and license slot.Still, I'd recommend contacting WRC to clarify the issue completely.
source code in your posts
Check this article. No external tools required. More articles about how to get the most from community are available on the link at the bottom of the page:
Recently I built a REST API, 1 typical client for which generated dozens of requests per second, I tested locally with one client and usually got 10 to 20 thousands of exceptions in a few minutes as one "run" of the client.
In the end I wrote a custom logging system, because even one minimal run hanged UI.
Code.
I'd like to add that you need to purge the log often, in my experience the UI becomes not very responsive after about 10 000 entries per namespace per day.
The CSP part (REST for sure and maybe SOAP) could be managed by these two tools:
Additionally you cat use ^ZSTART routine to check if user can login.
Execute queries and show tables
State is not required (and in fact harmful) for that case. Here's why.
Users do not care for thousands of results.
That doesn't happen. User most often cares about one specific result, or a small group of them - dozen(s), rarely up to a hundred but to be extremely generous let's say that user cares about 1000 individual records at the same time tops.
So, how do we work with that assumption?
There are several things to do.
One other case where user might be actually interested in the exact number of the results is when he needs that number only. For example our user might be interested in the number of incidents per month and calculate it himself by filtering incidents by date and getting the results count. This requirement could be addressed in several ways:
tl;dr users are not interested in thousands of results, so we need to build systems where they get only the results they really need.
The call to
$$setStream^%apiGTW(QHandle,RawData,0,1)
Is roughly equal to:
#dim gc As %SQLGatewayConnection
#dim RawData As %Stream.Object
//set sc = gc.ParamData(hstmt, .index) //not sure if it's required
while 'RawData.AtEnd {
set string = RawData.Read(16000)
quit:string=""
set sc=gc.PutData(hstmt, string) // PutDataW
}Examples are available in EnsLib.SQL.Common class:
Method putLOBStream(pHS As %String, pStream As %Stream.Object, tBin As %Boolean) As %Status
{
Set tSC=..%Connection.ParamData(pHS,.tInd) Set:$$$SQLCODENeedData=..%Connection.sqlcode tSC=$$$OK Quit:$$$ISERR(tSC) tSC
Set temp=pStream.Read(16000)
If (temp = "") {
Set err=..%Connection.PutData(pHS,"")
} Else {
While ""'=temp {
If ..IsUnicodeDLL&&'tBin { Set tSC=..%Connection.PutDataW(pHS,temp) }
Else { Set tSC=..%Connection.PutData(pHS,temp) }
Quit:$$$ISERR(tSC)
Set temp=pStream.Read(16000)
}
}
Quit tSC
}All brokers effectively have Parameter UseSession = 1;
But the default value in %CSP.REST is Parameter UseSession As BOOLEAN = 0;
So the developer has to remember to override this every time (or sub-class)
I recommend having an abstract broker, which does technical stuff like CORS, UseSession, Encoding, JSON transformation. All other brokers must extend it (and they don't do technical stuff, only business logic). More on that.
Use same GroupById
If two (or more) web applications share the same GroupBy value, then session opened in one application would be valid in all other applications with the same GroupBy value. This way user needs to login only once (or not at all if we have domain/SSO authentication configured). It's also documented (but hard to find), more docs.
But if it's a third party app then there is no CSP/ZEN app - the use case I have in mind is a 3rd party web developer is creating a complex shop system that needs to communicate with Caché
CSP app could contain only HTML/JS/CSS. So it could be an AngularJS web application, but also hosted with Caché (as a Caché CSP web application).
I have no idea or interest in what technology they are using and it may be that their programming language does not easily support cookies so the CSPCHD (the session cookie) does not get passed.
If you host a web-application via Caché (Ensemble, HealthShare, InterSystems IRIS) then your web application would be authorization-aware automatically. Browser sends relevant cookies/headers with each request so developer don't need to think about it.
I am thinking that in this case the authentication needs to be passed with each Rest call - not an issue
(or use OAUTH which I know little about)
You can do it like this:
This way you pass login/pass only once instead of with every call. But I'd still recommend Caché security system.