Question Glenn van Bavel · Jun 15, 2017 Timeout 504 while running simple SQL count(*) query Whenever I try to run a simple query on a production database table, I get a timeout 504 error. I'm using the SQL interface in Ensemble. One of the queries is a simple SELECT TOP 10. Even SELECT COUNT(*) gives a timeout. I have tried to run the SQL Runtime Statistics, but this gives me a timeout as well. Does anyone have an idea where I might look to find what is causing this? Thanks in advance, Best regardsGlenn van Bavel, #Caché #SQL 0 3 0 1.6K
Question Glenn van Bavel · May 4, 2017 SNMP Service can't connect with Caché SNMP agent Whenever the Windows SNMP Service restarts, the snmpdbg log says the following. 13:08:59 :Attempting initial TCP connection(s) with 1 Cache instances ...13:08:59 :Get connection with ENSEMBLE on port 197213:08:59 :Connection refused on port 1972, check if Cache instance ENSEMBLE is started.13:08:59 :Cache iscsnmp.dll initialized for 1 configsEnsemble and all productions are running. I've set up Caché SNMP agent on many other servers in our company and those are working fine. However this one server won't budge. #Caché #Monitoring 0 10 0 1.2K
Question Glenn van Bavel · Apr 11, 2017 SNMP: Terminal is "Unable to open Registry key" Hi,Terminal says "Unable to open Registry key 'SOFTWARE\Microsoft\Windows\CurrentVersion\CommonFilesDir.1" when I execute $$Register^SNMP().For monitoring purposes I want to use SNMP in Ensemble. One of the steps I have to do is to use the method $$Register^SNMP() in the terminal "%SYS" namespace. This is mentioned in a Intersystems Docs page. #Caché #Terminal 0 5 0 1.5K