Question Arto Alatalo · Mar 10, 2022 Alternatives to View Journal Is View Journal of Cache Management Portal the only way to search in Cache journals? I need a way to define several search conditions and Portal often breaks on http timeout. #Journaling #Management Portal #Caché 0 6 0 293
Question Arto Alatalo · May 5, 2020 ERROR #5005: Cannot open file '/var/cache/cache.cpf_3458', why? Every time I click Save on System > Configuration > Memory and Startup page, I get "ERROR #5005: Cannot open file '/var/cache/cache.cpf_XXX' " error message, where XXX is a random number. This problem appeared some time ago without any clear reason. All file access right are seems OK. Any ideas? #Caché 0 3 0 540
Question Arto Alatalo · May 5, 2020 Ooops "Daemon WRTDMN died. Freezing system". But why??? (We are in contact with IS support for this problem but I would like to ask Community too, perhaps somebody experienced this problem in the past) Hello Community, we need your help with Cache 2017.2 freezing on Linux machine. Since we moved our primary production Cache from Windows to Linux in the begging of this year, we have experienced system freezing twice. Yesterday without any good reason Cache stopped to respond with the log shown below. Questions: #Red Hat Enterprise Linux (RHEL) #Caché 0 5 0 637
Question Arto Alatalo · Apr 29, 2020 OpenId() is slow, why? Hi Community! I need your advice. The method below is 6 times slower on production server than on developing machine: #Object Data Model #ObjectScript #Performance #Caché 0 27 0 819
Question Arto Alatalo · Apr 15, 2020 %CacheSQLStorage: data location as variable If two globals have same structure, how to reuse one CacheSQLStorage-based class to read both locations? Thanks! Update: Let's say we have two globals: ^a(1)="dataa1"^a(2)="dataa2" and ^b(1)="datab1"^b(2)="datab2" i.e. the structure difference is global name only. I would like to have two classes TableA and TableB both are inherited from TableAB, and TableAB taking global name as a parameter. #Mapping #ObjectScript #Caché 2 14 0 416
Question Arto Alatalo · Mar 27, 2020 Management Portal: how to view globals in opposite order? A simple question: View Global Data page shows globals always in ascending subscript order. Very often I need to see latest page, is there any trick for this? Update: I mean to see last subscripts in Management Portal, not using the code #Globals #Management Portal #Caché 2 27 0 545
Question Arto Alatalo · Jan 30, 2020 Query Plan uses temp-file, why? A quick question regarding to SQL Query Plan:Why these two requests have different plans, in particularly, why second request needs temp file? To me, temp file is a bad thing which should be avoided, right? select * from Test.Log where cdate = 1 select * from Test.Log where cdate > 1 Plan for 1: Read index map Test.Log.cdateIndex, using the given %SQLUPPER(cdate), and looping on ID.For each row: Read master map Test.Log.IDKEY, using the given idkey value. Output the row. Plan for 2: #SQL #Caché 0 4 0 189
Question Arto Alatalo · Nov 1, 2019 Cache Studio: Debug->Go fails with error 6704 All of the sudden, Cache Studio's Debug->Run command started to fail with error '6704 Target has exited debugger' (German: Kein Anbinden möglich). What could be a reason of that? Today we installed Cache Web Terminal (https://intersystems-community.github.io/webterminal/), could it be possible that the terminal somehow hijacked some debugging api end-point? #Debugging #Caché 0 5 0 308
Question Arto Alatalo · Aug 12, 2019 How to read global via Stream interface? I have global with binary data, structured like:^a(1)=<binary>^a(2)=<binary>^a(n)=<binary>What could be easiest way to read it via Stream interface? I.e. to pass an adapter to a function expecting Stream? #ObjectScript #Caché 1 4 0 555
Question Arto Alatalo · Feb 21, 2019 Compilation error on %ExtentMgr.GlobalRegistry.LockUse I'm getting this compilation error:Kompilieren der Klasse digi.packetFEHLER #5002: Caché-Fehler: <FUNCTION>zLockUse+5^%ExtentMgr.GlobalRegistry.1> FEHLER #5030: Während der Kompilierung von Klasse 'digi.packet' ist ein Fehler aufgetretenwhen importing one of my classes on the production server into one particular namespace: #ObjectScript #Caché 0 8 0 575