#Caché

I've been accessing Cache tables from a developer/reporting side, but am now involved in a project to create a data warehouse for our application. I'm trying to find a query I can use to return the sizes of all the tables in the database, so we can identify the largest tables and handle those individually. Can someone give me a query I can run against our Cache database to return the sizes of all the tables from largest to smallest?

Thanks for the help

Using Prometheus to monitor Caché ，when config application /metrics done， Prometheus connection error: “server returned HTTP status 404 Not Found”

When i use &sql(SELECT ......) in Cache I can watch the generated code
In the generated .int code and see what is happening.
Just with my normal rights

Now in IRIS I have just 4 line calling some class %sqlcq.***
With enough rights i find there is no such class but the generated .int routine
%sqlcq.IRISAPP.xEZgUjdXCCgQdZQPpRdOye1Ci2ue.1
That holds the code that i had in my .int on Cache

Can i switch this back somehow ?

Hi

How to clean cachetemp/CACHE.DAT, without cache restart?

I have the procedure to clean cachetemp/CACHE.DAT in my scritp stop/start cache, but, in some cases, I need to clean this base without restart.

It's possible?

Created by Daniel Kutac, Sales Engineer, InterSystems

Warning: if you get confused by URLs used: the original series used screens from machine called dk-gs2016. The new screenshots are taken from a different machine. You can safely treat url WIN-U9J96QBJSAG as if it was dk-gs2016.

Part 2. Authorization server, OpenID Connect server

Is InterSystems ODBC driver backwards compatible? If I use cache version 2018, can I upgrade the ODBC drivers to the 2021 version or it is better to upgrade to the 2018?

I programmed some server command by my own. That server commands worked fine for a long time.

Suddonly I received

Studio Action "Attempted Edit" not supported on 127.0.0.1:57772[CTAE01]

by using one of my server commands.

There is an explanation:

Error running command vscode-objectscript.serverCommands.contextOther: Running the contributed command: 'vscode-objectscript.serverCommands.contextOther' failed.. This is likely caused by the extension that contributes vscode-objectscript.serverCommands.contextOther.

Pouring The Coffee: Creating and scheduling a task

Don't you wish a fresh, hot cup of coffee could be waiting for you right when you get into the office? Let's automate that!

Cache and IRIS come with a built-in Task Manager, which should have a familiar feel to those used to using the Windows task scheduler or using cron on Linux. Your user account will need access to the %Admin_Task resource to use it, and you can access it in the management portal under System Operation -> Task Manager. When first installed, there are roughly 20 types of task that you can schedule.

I often get this message when trying to attach to the routine second time. The only way I was able to fix this is by restarting the Cache server.

Then I can do debugging once, but second time, the error pops up again. Very annoying. Is there a way to fix that without restarting the server ?

Thank you

Dean Kavicki

I am trying to create a scheduled task but get not implemented error when I try to run it.

Class PICIS.Core.Tasks.CleanEntry Extends %RegisteredObject
{

ClassMethod ClearTasks(pBackupFile As %String = "d:\Temp\BackupTasks.xml", pDelete As %Boolean = 0)
{
// Create backup file
Set tBackup = ##class(%Stream.FileCharacter).%New()
Set tBackup.Filename = pBackupFile
Do tBackup.WriteLine("<?xml version=""1.0"" encoding=""UTF-8""?>")
Do tBackup.WriteLine("<Tasks>")

[SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<MAXSTRING>zExecute+3^%sqlcq.LIM.cls1043369.1>]
[Location: <ServerLoop>]
[SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<MAXSTRING>zExecute+3^%sqlcq.LIM.cls1043369.1>]
[Location: <ServerLoop>]
at InterSystems.Data.CacheClient.CacheADOConnection.GetServerError(Int32 rc)
at InterSystems.Data.CacheClient.CacheADOConnection.processError(Int32 error, Int32 allowError)

In the Caché Foundations course, students are learning about Caché Development and ObjectScript syntax at the same time. To help students complete the exercises, we provide an ObjectScript Quick Reference (aka "the Cheat Sheet").

It is not a reference for all of ObjectScript! It is a list of the ObjectScript commands and functions that students use during the course, along with common syntax for objects, collections, etc. It also contains some useful macros.

Hi all,

I have a process that recive a datetime in ISO 8601 format (YYYY-MM-DDThh:mm:ss+001) to %timestamp value.

Example: set myDatetime = "2021-11-04T11:10:00+0100"

I've triyed use $SYSTEM.SQL.CONVERT(myDatetime,"SQL_TIMESTAMP") but it doesn't work.

Any idea?

Regards,
Kurro Lopez