I’m facing issues with replicating data from my Caché 2016 database to a PostgreSQL database. I need to handle around 300 data updates per minute, and whenever certain tables are modified, those changes must be reflected in other databases.
I inherited some legacy MUMPS / ObjectScript code. A code review identified an exclusive NEW and that is not allowed per our coding standards.
The original code contains:
RUN(CALL,DRVNAME) S $EC="" S ^TMP($J,"RMPV","DRVNAME")=DRVNAME N TMPFILE,OLDIO S OLDIO=$IO I $G(^TMP("RMPV","SILENT"),1) S IOP="NULL",%ZIS=0 D ^%ZIS I '$G(POP,1) U IO D INIT^@DRVNAME D ; scope variables .N (DUZ,CALL) ; Protect %response .S IOF="""""",IOM=80,U="^" .D @CALL U OLDIO Q
Everytime I try to send a POST FHIR bundle I'm getting the following response: 404 Not Found. I'm not really sure why, although it works fine with a GET!
This is an example:
Response:
It might be something related to request path but not really sure.
We have a service account that is running queries to pull some data. It has read only access to the tables, but, unfortunately, the tool is starting a transaction before it reads the database. The query takes more than 20 minutes (21 - 23 minutes), so we're getting the console message that the transaction is open longer than 20 mins. Is there a way to prevent a user/service account from being able to start a transaction since it only has read access to all of the tables in the database?
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?
I'm currenlty searching the developers coummnity , but thought I asked this question while I search. How can I use the task schedulrer to purge backups? Do i have to create my own class? Examples on doing this?
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?
I'm attempting to build a fairly complicated object graph, with nested objects and collections, in order to create a FHIR bundle.
In its most basic form there is a <bundle></bundle> element that represents the root, and there can be a number of nested <entry></entry> child elements.
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.
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 -
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
Every time I try to update an SQL table using odbc connection, I'm getting: ERROR <Ens>ErrException: <MAX $ZF STRING>zPrepareW+1^%Library.SQLGatewayConnection.1
My variable `check1` is a string. It is either the empty string (for invalid/false answer) or a non-empty string for a valid/true input. If it is valid, I want to return it. I wrote this code:
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. */
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
I'm trying to project a series of objects and nested objects to XML, and I'm having difficulties getting the XML representation exactly the way I need it to be. Here's what I'm working with, nothing complicated:
If you want to raise an arbitrary custom error in a TRY block, you can pass an exception with a throw as follows. In the following example, a custom error is raised if Stcount is less than 1.
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??