go to post Alexander Koblov · Jan 9, 2020 Check if you have Windows-keys enabled in Terminal settings. If yes -- this can handle Ctrl-C as "Copy to clipboard"
go to post Alexander Koblov · Dec 27, 2019 David, relative cost is only useful when you compare different plans for the same query. By itself "relative cost" means nothing. To look into query performance we need to see a) Query itself b) Execution plan c) Sources of all classes / tables from the query, so that we see how fields are defined, indexes that are available and selectivity of fields.
go to post Alexander Koblov · Dec 20, 2019 I also see this error for some tables. I don't know what's causing this. I've googled it and looks like some error with ODBC Connections from Power BI.
go to post Alexander Koblov · Dec 18, 2019 Hi Vikram. Looks like you trying to use InterSystems IRIS Power BI Adaptor to connect to Caché. This adaptor does not support Caché. Use ODBC connection to connect to Caché from Power BI. Hope this helps, Alexander.
go to post Alexander Koblov · Dec 2, 2019 Hi Laura. There should be only one copy of zenutils.js. It should be only in csp\broker. CSP Gateway first looks for any static file (including zenutils.js) in appropritate folder (.e.g. csp\samples). If file is not present there, CSP Gateway then looks for that file in csp\bpoker. Hope this helps, Alexander.
go to post Alexander Koblov · Dec 2, 2019 The best way to handle such problems is: a) Enable Audit (System Administration -> Security -> Auditing) b) Enable logging of audit events LoginFailure and Protect (Configure System Events) c) Reproduce the error d) Check Audit database if it has any reported LoginFailure or Protect events. If yes -- check details of these events.
go to post Alexander Koblov · Nov 28, 2019 Hi Thembelani. See InterSystems IRIS Adoption Guide (available in WRC -> Online Distributions -> Docs) %Library.CachePopulate was renamed to %Compiler.Type.Populate
go to post Alexander Koblov · Nov 27, 2019 The best I know is $TR/$J combination: USER>w $TR($J("",10)," ","x") ; repeat x 10 times xxxxxxxxxx USER>w $TR($J("",5)," ","y") ; repeat y 5 times yyyyy
go to post Alexander Koblov · Oct 7, 2019 Relative cost is only used to compare different plans for the same query. Relative cost is not useful for comparing two different queries. Can you post screenshot of both queries with corresponding plans?
go to post Alexander Koblov · Oct 7, 2019 You should look into query plans for these queries. Generally, they can be different.
go to post Alexander Koblov · Sep 18, 2019 Unpack IAM-0.34-1-1.tar.gz first. Docker image is inside this archive
go to post Alexander Koblov · Sep 17, 2019 To add on what Dmitry said. We need to see the query, its plan and corresponding classes with selectivity information. For example, do you really want to run query without join condition? select o.col1, o.col2, op.partnum, op.amount from orders o join orderpositions op where o.orderDate > $H-1000
go to post Alexander Koblov · Sep 17, 2019 Hi Kris. What version of Caché do you have? SetHttpHeader is correct method to add headers. ISCSOAP began logging headers starting from 2016.1. In order to log headers you need to add "h" to the ^ISCSOAP("Log"). https://cedocs.intersystems.com/ens20161/csp/docbook/DocBook.UI.Page.cls...
go to post Alexander Koblov · Sep 11, 2019 Following this useful table (https://stackoverflow.com/a/33206814/82675) you can have blinking text as follows: USER>write $C(27)_"[5m"_"Hello"_$C(27)_"[0m"
go to post Alexander Koblov · Sep 10, 2019 Contact InterSystems Support: https://www.intersystems.com/support-learning/support/immediate-help/
