New post

#Caché

45

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

A customer is using Caché online backups and needs to automatically purge the cbk files with a scheduled task.

This is a wheel has been reinvented uncountable times already and I know somebody out there has a well written, extremely robust version that has already stood the test of time.

Does anyone have a nice routine/class/task for purging old Caché backup files?

0 11
1 1.7K

Hello,
In short, I am trying to get the Content-Length of my response,

We have a CSP application, when we get a new request we begin to process it, throughout the app we WRITE to the response in different places,
now when the response is about to be sent back to the client - we would like to know its Content-Length (in the RESPONSE HEADERS).
So it comes down to two questions:
1. How can we access the Content-Length of our response?

0 1
0 66

I have installed three plugins on VS Code: Intersystems Language Server: v2.3.6, Intersystems ObjectScript: v2.10.5, and Intersystems Server Manager: v3.6.2. I connected to the Caché database and connected a workspace to the InterSystems server. Then I edited the code locally on my client machine.

0 6
0 108

Hi Community,

I have a CSP page I am developing with the intent of pulling files from an SFTP site and placing them in a folder on the local network.

I am having an issue where the CSP page is catching a JS error. The error in the browser is - A JavaScript exception was caught during execution of HyperEvent: SyntaxError: Unexpected identifier 'downloading'. (However, the unexpected identifier changes after refreshing page, or after removing the Write statement with the work 'downloading' in it.)

I think I have narrowed it down to a piece of the Javascript code -

0 9
0 114
Article
· Dec 13, 2024 5m read
SharePoint/ SPO API with intersystems

As part of the Open Exchange competition Salford Royal (Dean White and Mark O'Reilly) developed a REST API for sharepoint as a template that works but can also be a starting point to your own Rest Applications

Prerequisites

This is using the v1 REST sharepoint API you need a tennant id, client id, client secret and tennant name

Setup

Configure an OAuth server

The code in the middle is the tennant ID

Open Exchange app
2 2
0 130

Hi all,

I am trying to establish an HTTPS connection to a server using a %Net.HttpRequest object. I'm able to ping and curl the server via command line. The issue I am running into is that I am able to establish a connection, but something seems to be going wrong with verification from the server side. For example, if I use the CheckSSLCN method on the server, it returns this error message

ERROR #6155: Unable to verify SSL/TLS connected to correct system as no SSL certificate present for this socket. */

1 2
1 131

Hi everybody,

I need to connect a Caché database to Metabase, but Metabase does not support this database.
Metabase only supports these databases:

- Amazon Athena
- BigQuery (Google Cloud Platform)
- Druid
- MongoDB (recommend version 4.2 or higher)
- MySQL (recommend version 8.0.33 or higher, as well as MariaDB version 10.4 or higher)
- Oracle
- PostgreSQL
- Presto
- Redshift (Amazon Web Services)
- Snowflake
- SparkSQL
- SQL Server
- SQLite
- Vertica

0 3
0 161
Question
· Dec 4, 2024
Error importing XSD

I'm attempting to import all the FHIR XSD files provided by http://hl7.org/fhir but get the immediate and unhelpful error message:

I've tried different versions of EOLs to no avail. Any idea what this error could mean?

Here's the XSD I'm trying to import:

<?xml version="1.0" encoding="UTF-8"?>
<!--
Copyright (c) 2011+, HL7, Inc
All rights reserved.

0 0
0 37
Question
· Nov 24, 2024
Intersystems REGEX engine

I am working on a product that uses REGEX and matches it.
The regex is tested both on the client-side (using the JavaScript REGEX engine) and both on the server-side.

But I couldn't find one word about the way intersystems parses the regex, It is quite elementary to state which which engine it works with.

from what I could gather from early implementations and such, the engine is based off PCRE, But I need to confirm this somehow, Can anyone give me a definitive answer, Is there any tool to test the regex other than writing it myself??

0 2
0 143

Let's say I open a stream/file.

If it's not in UTF8 i need to call $ZCVT, and if it's already in UTF8, then I don't need to call $ZCVT.

Is there any way to determine character encoding for input stream/file?

0 8
0 2.2K

Is it possible to check retroactive LOCK history?

context:

I found it in the application error log. Some LOCK errors - ERROR #5803
Is it possible to somehow identify the point in the job or process code that caused these locks?

At the moment I no longer have table LOCKS on the server, but I would like, if possible, to check the time at which the incidents occurred.

0 1
0 85

InterSystems FAQ rubric

Mirroring only synchronizes database files.

To synchronize other files required for your application (CSP files, images, documents, etc.) between the two servers that make up the mirror set follow one of the approaches:

  1. Place those files on a shared disk by introducing a NAS or similar device
  2. Or use file sync software to synchronize files between two servers.
2 0
0 126
Question
· Nov 20, 2024
Error Compiling class

Hi,

When I try to compile a specific class it fails and gives the below error message.

ERROR #5002: Cache error: <FUNCTION>zLockUse+5^%ExtentMgr.GlobalRegistry.1
> ERROR #5030: An error occurred while compiling class 'ClassNameHere'

Is there anything I can do to fix this issue?

Thank you in advance for your response.

0 0
0 61
Question
· Nov 13, 2024
SQL CLASS NODE SYNTAX

I HAVE A NEW SQL CLASS THAT DISPLAYS ENTRIES BASED ON THE FIRST 2 NODES OF A GLOBAL. I FOUND OUT THAT THE CLASS ALLOWS FOR AN ADDITIONAL NODE(s) TO BE INSERTED IN THE "User Specification Node:" along the delimiter and the Piece in the NewStorage Map1 for "ModifyDDDD" shown below. it is not working.

0 5
0 76

InterSystems FAQ rubric

By default, the order of columns in a table is determined automatically by the system. To change the order, explicitly set the order for each property using the property keyword SqlColumnNumber when defining the class.

Example:

Property Name As %String [SqlColumnNumber = 2];

Please see the documentation below.

2 0
0 82

New to Python. Attempting to use pypyodbc to select data from a table in one Cache database, and inserting into a similarly configured table in another. Process works fine except for tables containing Date types. NULL values in date columns are handled without issue, but when data is present, insert fails with:

An error occurred: argument 7: TypeError: 'NoneType' object cannot be interpreted as an integer.

Source table:

0 2
0 93