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)
go to post Eduard Lebedyuk · Jul 7, 2018 As i have mentioned that i am using the Intersystem ODBCWhere? I thought you were using SMP.Try to change SELECT field CallbackComment to one of:%EXTERNAL(CallbackComment)%INTERNAL(CallbackComment)%ODBCOUT(CallbackComment)
go to post Eduard Lebedyuk · Jul 7, 2018 Looks like Timeout issue.1. Do you have index on PhoneDateODBC?2. Can you execute the same query using some JDBC tool?
go to post Eduard Lebedyuk · Jul 6, 2018 You can receive all filter values for cube if you pass its name as a datasource: /Info/FilterMembers/YourCubeName
go to post Eduard Lebedyuk · Jul 6, 2018 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.
go to post Eduard Lebedyuk · Jul 6, 2018 It's executed during container build, so to load something I need a script.
go to post Eduard Lebedyuk · Jul 6, 2018 This answer by @Timothy Leavitt explains how to get CLS line from INT line.Maybe we can add that functionality to Atelier?
go to post Eduard Lebedyuk · Jul 5, 2018 First you need to load CSV into class.After that you can convert objects of your new class into json using SQL JSON_OBJECT function or %ZEN.Auxiliary.altJSONProvider.
go to post Eduard Lebedyuk · Jul 5, 2018 You can determine, where does the message comes from by inspecting it's header, get header Id from: $$$JobCurrentHeaderId and query Ens.MessageHeader class. Alternatively, check "process" variable in BPL or current context in ObjectScript processes. Maybe the whole object would be available somewhere.
go to post Eduard Lebedyuk · Jul 4, 2018 Check out this list of tools for C#/InterSystems interoperability.I think you need Caché Managed Provider for .NET.In <installdir>\dev\dotnet there are several examples available.
