Question Lucas Fernandes · Jul 27, 2021 Data Masking Does Caché or IRIS have Data Masking capability natively to Test/Dev/Report environment, like other databases? #Security #Caché #InterSystems IRIS 0 2 0 406
Question Lucas Fernandes · Jul 28, 2020 Get Application Error Log by SQL Does anyone know if there is a table or query to get the Application Error Log (^ERRORS) by SQL? #SQL #Caché 1 7 0 453
Question Lucas Fernandes · Nov 27, 2019 Recursion with SQL Does Caché have any features similar to PostgreSQL 'WITH RECURSIVE'? Something that allows recursion in SQL. #SQL #Caché 0 3 0 558
Question Lucas Fernandes · Jun 6, 2019 Restore Caché Backup Online I have a FullBackup.cbk file generated by Caché Backup Online. This file has many databases.Is there a Caché feature to restore only one database? #Backup #Caché 0 1 0 578
Question Lucas Fernandes · Mar 25, 2019 Service Unavailable from CSP Gateway + IIS We recently registered unavailability of the Web service in some moments. The application goes offline. Analyzing the IIS logs and logs in "C:\Windows\System32\LogFiles\HTTPERR" I found nothing relevant. #Caché 0 1 1 1.6K
Question Lucas Fernandes · Mar 6, 2019 Applying a custom resource to a Management Portal page through code Can I apply a custom resource to a Management Portal page through code, using the method or global? The documentation only shows the manual mode: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GCAS_rsrcs#GCAS_C181701 Or export the settings already saved. #Management Portal #Caché 0 2 0 344
Question Lucas Fernandes · Aug 15, 2018 Get the total amount of time a process is active HiI want to get the total amount of time that a process is active or the timestamp that it was created/started.I tried the %SYS.ProcessQuery class, but I did not find any related information.Is there any way to get this information from a process?I'm using Caché 2017. #Caché #Monitoring 0 6 0 487
Question Lucas Fernandes · Jul 18, 2018 Atelier. Compilation returns "Failed to read /api/atelier/v1/..." When I try to compile through Atelier (Compile Project), I noticed that in compilation with error it returns this message 'Failed to read /api/atelier/v1/ ...':No additional Atelier files to synchronize.Compile failed: Failed to read /api/atelier/v1/ERP/action/compile?flags=ckCompile failed: Failed to read /api/atelier/v1/ERP/action/compile?flags=ckCompile failed: Failed to read /api/atelier/v1/ERP/action/compile?flags=ckCompile failed: Failed to read /api/atelier/v1/ERP/action/compile?flags=ck #Compiler 1 6 0 653
Question Lucas Fernandes · Feb 26, 2018 Monitoring with Zabbix Hi community,I need to monitor Caché Intersystems with some custom indicators.I started customizing the SNMP Mib. But I've been in a Zabbix event, all speakers use ODBC to monitor their database, Oracle, MySQL, PostgreSQL ...What is the best way? Use ODBC or SNMP Custom Mib?What are you guys using? #Caché #Monitoring 0 2 0 1K
Question Lucas Fernandes · Dec 18, 2017 Get Window Size from terminal Hi,Can I get "Window Size" from terminal? By command line.Terminal > Edit > Window SizeI already tried to use 'do CURRENT^%IS', but without success. It does not return the change, for example, when the column is 132.Is there any routine or method for this? #Caché #Terminal 0 6 0 898