go to post Alexander Koblov · Apr 9, 2020 %XML.TextReader traverses XML nodes. Each node can have different type. NACS is node of type Element. It does not have any value. Node 111111 is of type Chars. However it does not have any name. Thus the output that you see. Hint: change line in your code as follows to see types of nodes : set practices = practices_textreader.Name_"("_textreader.NodeType_"):" Take a look here for data model of XML: https://www.w3.org/XML/Datamodel.html See also class reference for %XML.TextReader. Particularly for Value property. It explains what this property holds depending on type of node.
go to post Alexander Koblov · Feb 27, 2020 No, Alexey, for 2020.1 I don't know. And for 2019.1.4 -- I don't know what version is this.
go to post Alexander Koblov · Feb 27, 2020 IRIS 2019.1.1+ https://docs.intersystems.com/iris20191/csp/docbook/platforms/ISP_techno... Caché 2018.1.3+ https://cedocs.intersystems.com/ens201813/csp/docbook/platforms/ISP_tech...
go to post Alexander Koblov · Feb 20, 2020 To get status of ECP servers you should use class SYS.ECP in %SYS namespace [1] It has methods GetClientConnState and GetServerConnState [1] https://docs.intersystems.com/iris20194/csp/documatic/%25CSP.Documatic.c...
go to post Alexander Koblov · Feb 19, 2020 No other settings. What %Service_Telnet does is it starts/stops process that listens on port 23 (by default). If you disable this service than process is stopped, so nothing from Caché side is listening on port 23.
go to post Alexander Koblov · Feb 19, 2020 Hi Anzelem. If that is the question on how you can disable telnet -- then you should disable service %Service_Telnet in System Administration > Security > Services. https://cedocs.intersystems.com/ens201813/csp/docbook/DocBook.UI.Page.cl...
go to post Alexander Koblov · Feb 19, 2020 Hi Laura. First question -- what algorithm does openssl_public_encrypt use? PHP reference [1] and source code [2] says that this is RSA. So in Ensemble you can use $system.Encryption.RSAEncrypt() [3] Important thing to note about RSA encryption, is that length of the plaintext can not be greater than the length of the modulus of the RSA public key contained in the certificate minus 42 bytes. [1] https://www.php.net/manual/en/function.openssl-public-encrypt.php [2] https://github.com/php/php-src/blob/master/ext/openssl/openssl.c#L5549 [3] https://cedocs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cl...
go to post Alexander Koblov · Feb 17, 2020 Thanks for sharing Paul. Though reference article for $username has this documented: $USERNAME contains the username for the current process. This can be in one of two forms: The name of the current user; for example: Mary. This value is returned if multiple security domains are not allowed. The name and system address of the current user; for example: Mary@jupiter. This value is returned if multiple security domains are allowed. To allow multiple security domains, go to the Management Portal, select System Administration, Security, System Security, System-wide Security Parameters. Select the Allow multiple security domains check box. Changes to this setting apply to new invoked processes; changing it does not affect the value returned by the current process. https://cedocs.intersystems.com/ens201813/csp/docbook/DocBook.UI.Page.cl...
go to post Alexander Koblov · Feb 12, 2020 Following command lists all collations. Even not loaded: %SYS>do ^COLLATE E.g. %SYS>w $zv IRIS for Windows (x86-64) 2019.1.1 (Build 612U) Mon Oct 28 2019 11:29:24 EDT %SYS>do ^COLLATE Status Number Abbrev Name ---------- ------ ------ ---------------------- Built-in 0 OANS ISM Pre-6.2 Built-in 1 ANSI ISM 6.2->6.4 Built-in 2 COBR Ipsum/Cobra Built-in 3 DTMC DTM-compatible Built-in 4 CBR2 Ipsum/Cobra-2 Built-in 5 UNIC IRIS standard Not loaded 10 GER1 German1 Not loaded 11 POR1 Portuguese1 Not loaded 12 POL1 Polish1 Not loaded 13 GER2 German2 Not loaded 14 SPA1 Spanish1 Not loaded 15 DAN1 Danish1 Available 16 CYR1 Cyrillic1 Not loaded 17 GRE1 Greek1 Not loaded 18 CZE1 Czech1 Not loaded 19 CZE2 Czech2 Not loaded 20 POR2 Portuguese2 Not loaded 21 FIN1 Finnish1 Not loaded 22 JAP1 Japanese1 Not loaded 24 POL2 Polish2 Not loaded 27 FRE1 French1 Not loaded 28 FIN2 Finnish2 Not loaded 29 HUN1 Hungarian1 Not loaded 30 GER3 German3 Not loaded 31 POL3 Polish3 Not loaded 32 SPA2 Spanish2 Not loaded 33 DAN2 Danish2 Not loaded 34 GRE2 Greek2 Not loaded 35 FIN3 Finnish3 Not loaded 36 LIT1 Lithuanian1 Available 37 CYR3 Cyrillic3 Not loaded 38 SLO1 Slovenian1 Not loaded 39 SLO2 Slovenian2 Not loaded 40 TUR1 Turkish1 Not loaded 41 DAN3 Danish3 Available 42 UKR1 Ukrainian1 Available 43 CYR4 Cyrillic4 Not loaded 44 CZE3 Czech3 Not loaded 46 MAL1 Maltese1 Not loaded 48 MAL2 Maltese2 Not loaded 49 SPA4 Spanish4 Not loaded 50 SLO1 Slovak1 Not loaded 51 SPA5 Spanish5 Not loaded 52 FIN4 Finnish4 Not loaded 53 CZE4 Czech4 Not loaded 54 GER4 German4 Not loaded 56 FRE2 French2 Not loaded 57 GER5 German5 Not loaded 58 NOR1 Norwegian1 Built-in 128 OSTR ISM Pre-6.2 string Built-in 129 NSTR ISM 6.2->6.4 string Built-in 133 USTR IRIS standard string Available 144 CYR1S Cyrillic1 string Available 165 CYR3S Cyrillic3 string Available 170 UKR1S Ukrainian1 string Available 171 CYR4S Cyrillic4 string
go to post Alexander Koblov · Feb 5, 2020 Hi Brian. I never used Crystal Reports, however code 30 might correspond to "Table or view not found". See https://cedocs.intersystems.com/ens201813/csp/docbook/DocBook.UI.Page.cl...
go to post Alexander Koblov · Jan 16, 2020 Neerav, relative cost is only useful when you compare different plans for the same query. By itself "relative cost" means nothing.
go to post Alexander Koblov · Jan 16, 2020 Yes, first screenshot illustrates what I said. CSPSystem tries access User.Login in USER database, but fails. Give CSPSystem role that has resource protecting user database. Close all connections from Web Gateway to IRIS. Try again. It should work
go to post Alexander Koblov · Jan 16, 2020 Web Gateway user (CSPSystem) should have permissions to read database where custom login page is located. Enable events logging in Audit, reproduce the NOT FOUND error and you'll see events logged.
go to post Alexander Koblov · Jan 13, 2020 Not necessarily set CNT=10e7 write "for test",! set z1 = $zh for i=1:1:CNT { } set z2=$zh-z1 write "time: ",z2,! write "while test",! set z1 = $zh set i=1 while i<=CNT { set i = i+1 } set z2=$zh-z1 write "time: ",z2,! Running this program: USER>do ^test for test time: 2.017099 while test time: 1.542252
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.