#Caché

Hello.

I want to store a mailbox in Caché, persistently.

Does anyone have some code for downloading all messages from mailbox into Caché? And maybe automatic syncing after download? I know, there is  %Net.POP3 but maybe someone has already done that.

Thank you.

Does someone knows if any Studio version or, if in its new versions, it will be able to recognize new Javascript statements like arrow function, let, const etc ?

We have an interface that need to be disabled then re-enabled when it starts to queue up. I wrote the following code to do this functionality in a process. This works in our development domain, but in production it says it fails to disable the job - it only shuts down the interface without updating the production/starting the interface back up. Error message: "Failed to stop job '36831290' within 60 seconds. Status '<unknown>" 

Is there something wrong with how I'm trying to do this? 

set tSC = ##class(Ens.Director).EnableConfigItem(itemname,0,0) 

set tSC =

I need to send the data from a view that returned NULL, but is going as empty. The fields are of type String.

I'm using: 

SET tSC  = ##Class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tSteamJson,pObj,,,,"e")

{
    "altura": "",
    "atendimento_id": "3060382",
    "data_atualizacao": "2021-12-16 10:39:12.0",
    "data_coleta": "2021-12-16 10:37:00.0",
    "data_liberacao": "2021-12-16 10:39:12.0",
    "dor": "1",
    "dor_nr_seq_result": "",
    "escala_dor": "",
    "escala_temp": "C",
    "freq_cardiaca": "80",
    "freq_respiratoria": "22",
    "glicemia_capilar":

to dismount/mount a database, use Dismount() and Mount() methods in SYS.Database class available in %SYS namespace.
NB: the database ID is its Directory

You'll find  some examples of how to dismount/mount and check if a database is mounted (Mounted=1) or not (Mounted=0), and quickly see all the attributes of a database (via zwrite)

%SYS>set db="/opt/irisapp/data" 

%SYS>w ##class(SYS.Database).%OpenId(db).Mounted                     
1
%SYS>w ##class(SYS.Database).%OpenId(db).Dismount()
1
%SYS>w ##class(SYS.Database).%OpenId(db).Mounted   
0
%SYS>w

Hello!

I send request: 

set hr=##class(%Net.HttpRequest).%New()
set hr.Server = "server.com"
set hr.Location = "method?param=value"
do hr.EntityBody.Write("{ "name": "value" }")
set tSC=hr.Send("POST")
But when request incoming to server.com URI = "method%3Fparam%3Dvalue".
How I can disable urlencode params in URI, so that the URI remains "method?param=value"?

we have a issue with just the 1 namespace, where users log using ldap but arent getting any roles assigned to them.

Ldap does work as the user account is created as a ldap user. 

I have gone through the various settings to check that all is setup as required, but cant find a reason why the roles arent being assigned. 

Setting the Scene

I was editing the properties of a persistent ObjectScript class the other day and noticed that the storage definition wasn't updating to reflect my latest changes.

In this case, I deleted a property that was no longer needed from the class definition, saved, recompiled, and still saw it in the storage definition.

No problem, I thought. If the storage definition gets autogenerated on compile, I can just delete it and recompile the class. Sure enough, after doing this, I no longer saw the deleted property in the storage definition.

There, problem solved... right?

(cue wrong answer

I want to make the LOCATION for a %Stream.FileCharacterGzip property we have in a class parameterisable (as in stored in a global), so it can be different for different customers. Is that possible?  I've tried doing it a few different ways:
Creating a parameter
Parameter STREAMLOC = {^websystem("auditstream-location")};
then I tried to reference that in the 

Property HTMLZIPDoc As %Stream.FileCharacterGzip(LOCATION = ..#STREAMLOC);

but the compiler doesn't like that. 

I've also tried adding something to %OnOpen and %OnNew:
Method %OnOpen() As %Status [ Private, ServerOnly = 1 ]
{
    S

Millions of professionals use a wonderful tool, spreadsheets, for engineering calculations and financial analysis. It attracts a user-friendly interface and clear data organization. Cell formulas provide rich opportunities for automating calculations. No programming is required. (For example, Microsoft Excel)

But in order to expand the scope of the tool, it is necessary to increase the dimension of the tables and the speed of calculations.It is necessary to create a single, common database for a group of users.Cell formulas should be able to do everything.

I have an auditing class that defines some sqlComputed properties and can be extended by other persistent classes to enable auditing of its properties.  

Class Audit.ModifiedTracker [ abstract ] {
/// Last time this record was saved
Property LastModifiedTime As %TimeStamp [ SqlComputeCode = {Set {*}=$zdt($zts,3)}, SqlComputed, SqlComputeOnChange = ("%%INSERT", "%%UPDATE") ]; 
/// User responsible for modifying record
Property LastModifiedUser As %String [ SqlComputeCode = {set {*} = ..GetModifiedUser()}, SqlComputed, SqlComputeOnChange = ("%%INSERT", "%%UPDATE") ];

Now, I would like to

Is there any information regarding using Cache ODBC DSN's to connect to SAP Crystal Server 2020?  We have added all the necessary DSN on the server, and yet when running reports to access the required ODBC connections, we cannot seem to get the connections to establish.

I am using Crystal Reports XI against a Cache database. Are the values in the database case sensitive?

Hi everyone

I see that a new Apache bug has been discovered, and since various InterSystems products use an Apache webserver, have Intersystems released any news or updates on this? I'm not seeing any updates, press releases from them. Anyone know anything?

Andy

Do you know if any InterSystems product is compromised due to the Log4j vulnerability?

December 13, 2021 - Advisory: Vulnerability in Apache Log4j2 Library Affecting InterSystems Products

InterSystems is currently investigating the impact of a security vulnerability related to Apache Log4j2.

The vulnerability — impacting at least Apache Log4j2 (versions 2.0 to 2.14.1) — was recently announced by Apache and is reported in the United States National Vulnerability Database (NVD) as CVE-2021-44228 with the highest severity rating, 10.0.

Please see this page for more details about the vulnerability and updates on whether InterSystems Products are affected.

Hi members,

I have these data :

and need to exploit the first character of cot field (Library CDU classification) like this :

I get this result... it's approximatively what I want... but I need it in just one line !

With mySQL I get it with just GROUP BY rcddate

In Cache SQL I have to add {fn LEFT(cot,1)} to get the counts of each first character of cot... and seems {fn WEEK(rcddate)} doesn't make the job !

There is a trick ? or I make something wrong ?

kind regards.

Hello everyone I'm newb using COS and
I would like to know What is the definition of ROUTINE in COS ?
is there anything related to Global?
is it all information that it's possible to persist on the database?

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 ?

Hello everybody

I'm in need of a lot of help from you.
I work in a company with all system cached script, using global.

I need to develop web applications accessing the cache database, and global.

Could you help me indicate the best language option to develop web applications, and easier to access cache, and if possible send me some examples of applications accessing globals.

I thank you all.

Hugs

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?

Is it possible to rename a Caché-Instance on Windows?

ccontrol doesnt work on a Windows system =/

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

In the previous part of this short series, we have learned about simple use case – acting as an OAUTH[1] client.Now, it’s time to bring our experience to a whole new level.

Hi All,

I would like to download odbc drivers for Cache database to be able to install it on our SQL server.

I am trying to create a linked server to Cache database.

I couldn't find a link for the drivers, there was one post with FTP reference to download but it doesn't seem to work.

I will be grateful for any help.

Thank you

Sap.

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.

Can you help me to solve that issue?

When using an undimensioned array is there a way to write the array to a file? Something like this

DIM C()
C('TEST') = 2
C('WEST') = 5
C('BEST') = 1
WRITE C on myfile, 1

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.

If you want to add your own