$get works as fast as global could be read. Some ideas:
You can to change default file I/O from GB18030 to UTF8.
To do that, execute do ^NLS and choose:
2) Select defaults 2) I/O tables 4) File
And choose UTF8 there. After that, your I/O table should look like that:
I/O table Current default --------------------- -------------------- .... 4) File UTF8 (*)
After that, restart Cache and delete/reimport faulty files in Atelier
Note that this action (changing NLS defaults) can be disruptive to existing Cache applications.
Let's see Cache locale.
Open Cache terminal and execute:
zn "%SYS" do ^NLS
There, choose 1) Display current locale and copy the output (should be two screens) here.
What's the server locale?
If you're sure that your id bigger ids are generated later, you can only get the first id from index and after that iterate the data global directly:
set FromDateH = (+$h-1)
set id = ^TestI("StartDateIDX",FromDateH,id)
for {
set id=$order(^TestD(id),1,dat)
quit:id=""
//dat=$lb("a","b","c","d","e")
}Also you can use three-argument form of $order to iterate and get data in one command.
Finally, consider checking work-heavy system with %SYS.MONLBL to verify what lines consume more time.
Open Atelier project Properties and check encoding there. Set to UTF8 if it's not.
I just don't know which Azure product.
For Azure it would be Virtual Machines as you need to specify these parameters.
Article would be great.
InterSystems Cloud Manager can deploy to Azure. First Look for ICM is a step by step guide to run InterSystems IRIS in a cloud.
Generally you need to run ICM locally (or on some preexisting server) and then specify a configuration of what you want. ICM would then provision the servers, install InterSystems IRIS, etc.
There are many ways to launch InterSystems IRIS.
If you want to launch it on AWS you can do it one of the following ways.
What to choose?
You can use cross-platform Atelier IDE.
Setting the credentials on the Operation did not work.
Do you redefine request object in your own code? It really should and does work. Please consider posting an example.
Maybe Ensemble Message Bank can help?
Depending on PDF type (character-based) using GZIP file stream may provide additional size advantages.
It would be easier to start and finish the transaction in one method (or rather one request to a BO).
Why not send the request to BO containing a list of UPDATES to perform and BO would automatically wrap them in a transaction, returning either a success or error and the position of failed UPDATE statement? Even better send list of some struct and construct statements in BO.
While workarounds are possible (1 Job for BO + indefinite timeout + FIFO on caller part) it would probably be a bad idea.
Some examples of calling HTTPS GitHub API.
Have you tried setting autocommit off and calling COMMIT/SET TRANSACTION NAME/ROLLBACK manually?
I think that would get the results you need.
1: How can the httprequest object be viewed in Ensemble?
You can use DEBUG=2, to see the output you need to start your BH in Debugging mode.
Another option would be to install Debugging proxy such as Fiddler and specify ProxyServer/ProxyPort settings in your BH.
Finally, you can install packer sniffer such as WireShark and see the raw packets.
These options are discussed more in detail in my series of articles Debugging Web: part1, part2.
2: How is the Adapter password set?
No need to write code for that, just set Credentials setting in your BH.
Do you want to accept requests via HTTPS?
If so, you need to:
How many Jobs are working on that BP?
SELECT $TRANSLATE(CallbackComment ,'''','?') FROM SQ.CBPhoneResult_View WHERE PhoneDateODBC = '2018-04-09'
Also try
As i have mentioned that i am using the Intersystem ODBC
Where? I thought you were using SMP.
Try to change SELECT field CallbackComment to one of:
Looks like Timeout issue.
1. Do you have index on PhoneDateODBC?
2. Can you execute the same query using some JDBC tool?
It's a REST broker method so status should be returned.
Thank you, missed the TABs.
You can receive all filter values for cube if you pass its name as a datasource:
/Info/FilterMembers/YourCubeName
Here's an output I get:
USER> USER> USER> This is written by INT routine USER> which is created from a script injected to csession. USER> USER> D ^MyBootRoutine ^ <NOROUTINE> *MyBootRoutine USER> USER> USER>
Looks like it's still line-by-line execution.
It's executed during container build, so to load something I need a script.
This answer by @Timothy Leavitt explains how to get CLS line from INT line.
Maybe we can add that functionality to Atelier?