go to post Eduard Lebedyuk · Aug 8, 2018 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.
go to post Eduard Lebedyuk · Aug 8, 2018 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.
go to post Eduard Lebedyuk · Aug 7, 2018 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.
go to post Eduard Lebedyuk · Aug 7, 2018 Open Atelier project Properties and check encoding there. Set to UTF8 if it's not.
go to post Eduard Lebedyuk · Aug 5, 2018 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.
go to post Eduard Lebedyuk · Aug 5, 2018 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.
go to post Eduard Lebedyuk · Aug 4, 2018 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.Provision a EC2 instance with SUSE/RHEL/Ubuntu AMI and install InterSystems IRIS on Linux. Here's the guide. Quickstart.Provision a EC2 instance with SUSE/RHEL/Ubuntu AMI, install Docker and run InterSystems IRIS in a container. Documentation. First Look.Use InterSystems Cloud Manager to provision AMI and run InterSystems IRIS. Documentation. First Look.What to choose?If you need to run a lot of or a variable number of servers choose 3.If you're unfamiliar with Docker choose 1.If you're familiar with Docker (or want to become familiar with it) choose 2.
go to post Eduard Lebedyuk · Aug 2, 2018 Application code opens transaction somewhere but does not commit or rollback it.Check <code> elements, maybe there's a TSTART there somewhere.
go to post Eduard Lebedyuk · Jul 29, 2018 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.
go to post Eduard Lebedyuk · Jul 26, 2018 Depending on PDF type (character-based) using GZIP file stream may provide additional size advantages.
go to post Eduard Lebedyuk · Jul 24, 2018 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.
go to post Eduard Lebedyuk · Jul 23, 2018 Have you tried setting autocommit off and calling COMMIT/SET TRANSACTION NAME/ROLLBACK manually?I think that would get the results you need.
go to post Eduard Lebedyuk · Jul 23, 2018 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.
go to post Eduard Lebedyuk · Jul 23, 2018 Do you want to accept requests via HTTPS?If so, you need to:Install external web server. If you're on Linux I recommend Apache.Obtain a domain name. Let's encrypt offers free certificates.Enable HTTPS for your web server.
go to post Eduard Lebedyuk · Jul 8, 2018 SELECT $TRANSLATE(CallbackComment ,'''','?') FROM SQ.CBPhoneResult_View WHERE PhoneDateODBC = '2018-04-09' Also try %EXTERNAL(CallbackComment)%INTERNAL(CallbackComment)%ODBCOUT(CallbackComment)