We need to upgrade our cache instance from 2016.2 to the latest version.

I find the documentation about the "Upgrade Path" but I cant  find where I can get the files to upgrade in the documentation.

Also I cant find how to make this upgrade, they talk about strategies but dont talk how to perform the task to upgrade.

Is there any documentation of how to make and upgrade and where I can get the files?

0 4 106

I am using the EnsLib.RecordMap.Operation.BatchFileOperation by inheriting it to another class and to write a batch to a file. But for some reason this has not been working fine.

The issue started after I accidentally rebuilt all files in the production and the production file was missing. after importing production file from SVN Repository, the production was stopped and started to make sure all the business hosts are compiled and using latest classes.

1 1 49

Dear Developers,

I have a complex ZEN PDF report that has multiple tables that essentially are the same but are populated by different global definitions. The code has hardcoded groups for these tables but I would like the number of tables to be variable as many as there are global levels for a particular report.

Is there any way that I could build a report from a variable source of data rather that hardcoding 10 or more exact sections like the code below ? 

The code below is for table 2 in my report

0 1 106

I'm trying to implement an OAuth2 server, but I have som issues when trying to setup JWT under OAuth 2.0->Client.

I get the error message saying "No match between server name 'localhost' and SSL certificate values 'cache'". I have set up a SSL/TLS configuration as simple as possible without any certificate files. I'm accessing my server via HTTPS with an unsigned certificate.

Can anyone point me in the right direction on how to resolve the issue I'm encountering. 

0 1 76

My objective is to find routine's Date/Time Saved someplace inside Cache. The routine's Date/Time Modified as returned by various queries like %Library.RoutineIndex and as seen on the File Open screen is actually Date/Time Compiled last, not Date/Time Saved last. Does anyone know if Date/Time Saved is created when the Save icon is pressed or the routine is imported? Such a timestamp should be immune to subsequent compilations with no changes.

0 5 108
Yone Moreno · Aug 5, 2021
Convert hexadecimal to base64

Hello, first of all thanks for your time reading our question 💭


We would need to be able to transform a hexadecimal string to a base64 coded one. 🔄

To be specific, our use case is this:

1º We have our hexadecimal as follows:


2º We convert it to ASCII:



using this online tool:

0 5 336

In a typical database, changing the type of a column from some kind of date/time to a string would require a degree of migration effort for existing values. In Caché, my suspicion is that this is not the case, and I could simply change a property definition from %Timestamp to %String (MAXLEN = "30") and recompile, without needing to worry about damaging the existing data stored for this property. Is this correct? Or would I find the existing data in this property being lost or corrupted?

Thanks in anticipation

0 3 93
Virat Sharma · Jul 31, 2021
Ensemble learning query

Hi All,

I am new beginner to cache/mumps language. I want to learn Ensemble code but I do not have any application access to Ensemble code.

Is there documentation apart from Intersystems Ensemble documentation that can help me to learn Ensemble. Any notes or documents will be very handful

Please assist!! Thanks in advance.

0 2 100
Renan Santos · Jul 28, 2021
Integration via ASTM protocol

 Good afternoon people,

I'm setting up an integration using ASTM protocol via Interoperability, but I'm having a problem in returning the communication, the message stays in Loop and doesn't return the information to the device simulator that is executing the operation.

Has anyone of you worked with this protocol and are able to help me unravel this protocol?

0 2 70



  From time to time I get the following error after executing a select statement:

[SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]
[Location: <ServerLoop>] InterSystems.Data.CacheClient.CacheException [SQLCODE: <-400>:<Fatal error occurred>]
[Cache Error: <<UNDEFINED>Main+65^%SYS.DBSRV *%qsc(1187,8)>]

After repeating the query, the query succeeds.

How do I start debugging this type of issue?

0 3 143
Neil Thaiss · Jul 28, 2021
%XML.Reader Limitations

Hi all,

Are there limitations to the size of a file or stream that %XML.Reader will parse?

I am trying to parse a large, 573MB, XML file using either the 'OpenFile' or 'OpenStream' methods, but both return errors.

When I try to use the 'OpenStream' method I get a 'ERROR #6301: SAX XML Parser Error: input ended before all started tags were ended' error',

and when I try the 'OpenFile' method I get a 'ERROR #6301: SAX XML Parser Error: <STORE>'.

0 2 96

I have a routine tag that takes an argument and I want this argument to be an array reference.  So I try something like:

do mytag(.myarr)

The mytag tag, adds subscripts to myarr.

When I evaluate myarr after the tag call, only the subscripts passed in are retained in myarr.  The subscripts added by mytag are missing.  Is there a way to pass an array so it will behave the way I want it to?

0 6 120