Try changing Batch Handling to "Whole Batch".

Good question. In OAuth the response will include the expiration time, so that's what I was expecting here.

If the response doesn't include an expiration time does the vendor's documentation say anything about if tokens can be used for more than 1 request and if so how long it's valid for? If you know it's supposed to be valid for 60 minutes then you could just log the time when you requested the token and use that to track it.

It doesn't look like OAuth. If it were, the payload should include a grant_type and username is called "username" rather than "email":

https://www.oauth.com/oauth2-servers/access-tokens/password-grant/
https://www.oauth.com/oauth2-servers/access-tokens/client-credentials/

There could be non-OAuth token-based authentication methods. I expect the %SYS.OAuth stuff won't work for something non-OAuth.

What does the payload look like that you have to send in order to get a token? We can see if it looks like OAuth or not.

OnInit() only gets called when starting the operation.

If your tokens have an expiration time then you need to check if the token is expired on each call and fetch a new one if needed. You can just store the token and expiration time in properties and check them on each call.

I would start by checking if some other process is already using port 5000 (or whatever port JavaGateway is trying to run on). It would also be good to check the JavaGateway

Since you're on Linux you can check this with netstat:

netstat --listening --numeric-ports

I found this in the docs:

• From the server, users can:
  • Run, filter and modify reports.
  • Export to a variety of formats.
  • Schedule reports to be distributed via email or FTP.

https://docs.intersystems.com/components/csp/docbook/DocBook.UI.Page.cls...

And docs on the API:
https://reportkbase.logianalytics.com/v23.1/api/index.html

Have you looked at the Zen demos in the SAMPLE namespace?
https://docs.intersystems.com/ens201817/csp/docbook/DocBook.UI.Page.cls?...

This demo page shows a file upload control:
http://<HOST>:PORT/csp/samples/ZENDemo.ControlTest.cls

One quick/dirty(?) way is to do a "View Code in Namespace" for "%SYS". Under the %SYS namespace the percent classes are not filtered out.

I found a tokenize method in one of the %DeepSee packages:

USER>w ##class(%DeepSee.extensions.utils.StringMatchUtils).tokenize("this is a string blah blah.",.tokenArray)
1
USER>w

tokenArray=6
tokenArray(1)="this"
tokenArray(2)="is"
tokenArray(3)="a"
tokenArray(4)="string"
tokenArray(5)="blah"
tokenArray(6)="blah"
USER>

Would the built-in management reports meet your needs?
https://docs.intersystems.com/hs20222/csp/docbook/DocBook.UI.Page.cls?KE...

And these docs on HealthShare auditing should be helpful:
https://docs.intersystems.com/hs20222/csp/docbook/DocBook.UI.Page.cls?KE...

Standalone installers for Caché ODBC drivers are available on the software distribution page in the WRC.

Hi Rochdi,

You don't need to use %File and then copy it to a file stream. You can just use %Stream.FileCharacter to directly open and read the file:

  Set stream=##class(%Stream.FileCharacter).%New()
  Set sc=stream.LinkToFile("c:\myfile.txt")
  While 'stream.AtEnd {
  Set line=stream.Read()
  ; Process the chunk here
  }

And I can confirm that I've also seen %Stream.FileCharacter significantly outperform %File for reads.

-Marc

I suspect the problem is that you're using a %DynamicObject. BPLs should use persistent/persistable objects because business process execution can in some cases be suspended temporarily and then resumed. Before execution is suspended, context objects are saved into the DB.

%DynamicObjects are not persistent objects, so their values are lost when execution is suspended. You can overcome this by using %ToJSON to serialize the %DynamicObject into a stream property of the context object. Streams are persistable.

It's not clear to me what "early binding" means in the context of a data transformation. Do you mean something that happens at the time the DTL is compiled rather than at runtime?

If you can clarify what you mean by "early binding" that will help us get you an answer.