Stuart Strickland · Sep 9, 2021

This function is supposed to tell me that argument 1 is a valid variable name or not.

Doesn't work with an array variable, eg W $ZNAME("WLCOM(I)",0).

Not a question, just a whinge really.....

0 3 141
Omar Ali Ateen · Sep 8, 2021
Arabic Language

Good Day

I have http response comes with strange characters "ليس لديه الØ", but it's normal when i test in postman. Is there any method to read arabic.


0 9 265

Hello everyone


I am new to cache. In an interview i was asked how to optimize a sql query.

I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries. 

I want to know what will be the answer for how to optimize SQL query in cache. 

Thanks in advance!!

0 2 107
Virat Sharma · Sep 5, 2021
Global Access command query

Hello everyone, 

I am new to cache. I want to know is there any direct command to know how to find maximum number of subscripts in global A through direct command.

I mean the answer is 9 but how to check it using a direct command on terminal.


Thanks in advance!!









0 3 157

Hello Everyone

I am new to cache. I know there are 2 types of methods in cache. One is Instance method (Which can be call through object creation of particular class) and other is Class methods (which can be call through ##Class(MyPackage.Car).CarModels()). 

I want to know the difference when to create a instance method vs when to create a class methods.

Thanks in advance!!.

0 3 123

Hi everyone - In IRIS we would like to arrange the access of two users in such a way that each has access to exactly one (his) database only. Which resource does this (%DB_%DEFAULT allows each of the two users access to both databases). If you create new resources (%DB_Database1 and %DB_Database2) and then add them to individual roles (each for the user to), the access for the users, for example, via a REST client does not give the desired separation (instead once Ok, other database 401 Unauthorized both OK).

0 2 140

I'm using FOP 1.1 for ZEN reports and would like to install fonts within the Windows/Fonts directory.

I added the xml tags in fop.xconf but so far I have been unable to get the correct font.

    <renderer mime="application/pdf">

        <!-- automatically detect operating system installed fonts -->



Any advice would be appreciated.

0 5 181

I am running csession on AIX. I have been using the command "csession cache -U%SYS". In the session the namespace shows as "%SYS>" as expected. I was simply doing queries to the best of my knowledge. At some point csession starting failing to reference the namespace instead showing /cachesys/mgr which is the main dir for the cache instance. I am not aware of doing anything that would cause this but more importantly, how do I correct it? I

0 8 175

I'm trying to save a list of AccessTokens a user for a specific user. This way I could present it together with other user-data.

I have tried calling ##class(OAuth2.Server.AccessToken).OpenByCode(authCode) from %OAuth2.Server.Authenticate's AfterAuthenticate() method. This only returns things like State and AuthorizationCode, but the AccessToken is empty at this point (afterwards it becomes filled out).

Is there a way to achieve storing the AccessToken as part of the login system?

0 1 119
Augusto Estefan · Sep 1, 2021
Database increase a lot



The database is increasing a lot (almost a 1TB) and getting bigger with no sense after migration, the use of the plataform did not increase after the migration so is strange for us this increase.

how can I check everything is ok in the database? for example any table getting bigger.

Before the migration the logs were like:

07/22/21-17:18:26:304 (19701) 0 Starting Expansion for database /opt/Intersystems/HS/HS_201521705/mgr/cachetemp/. 276 MB requested.

0 7 203
Sivasubramani N... · Sep 1, 2021

        We are using AWS SSO authentication in our application to validate the users. For validating the users, we are passing the username and password from AWS SSO to our application. We need to validate the user in our application without using the password.

         We developed the login class using zenPage. We used <loginForm> tag in the login page which is used for the automatic validation.
         Is there any possible way to achieve this?

Thanks in advance.

0 1 84
Eamonn Fox · Sep 1, 2021
Querying a task

How do I programatically query a task set up in the task manager? I need to know the code being executed.


0 2 109
Kevin McGinn · Aug 31, 2021
Understanding process jobTpe

I have a client running cache on an AIX platform. I put together a objectscript to allow for the viewing the processes running against the database using a select from SYS.Process. One of the values I want in the view of the processes information is Jobtype but I want to convert it from the numeric value to a string value. In the Intersystems documentation there is a reference to an include file $ that should include macros that make this translation. I have not been able to track down this include file.

0 2 82

In Caché, it's possible to iterate a local array using $QUERY() :

set a("foo") = 50
set a("bar") = 30

set key = "a"
     set key = $QUERY(@key)
     write key_" = "_@key

This code works perfectly, unless it's called in a job (eg: a routine called by the JOB command).

1 3 189
Syed M · Aug 27, 2021
SSO Login


   We have an application that is logged using AWS SSO.
   We are passing username and password from the AWS SSO to our application for validating the user.
   But what we need is, we need to login to application without using the password.
   Is there any possible way available for this?

Syed M

0 1 95
ivo Ver Eecke · Aug 24, 2021
ECP system ID


I'm looking through some journal entries in the hope of finding the root source of an issue.
I was wondering if and how you can map a "ECP system id" to a server.

Any hints would be welcome

Best regards


0 0 114

After linking in Oracle Table with Field Column's Data Types of NUMBER, my updates into these table fields are resulting in data that is being rounded to 2 decimal places. I insert a record with 1234.1234 and 1234.12 is stored.

It appears Cache xDBC might be manipulating my values prior to sending to Oracle. Is there a setting or system parameter that is controlling this? If so, is there a way to relax this from occurring so the values I send are being stored in Oracle with the same values?

0 10 130

Hey everyone as you may know I am a beginner and I am kindly asking for some assistance in a problem I have been solving. The problem is that I am calling a user defined function within a procedure called occupiedseatsAdj and the compiler comes up with this error. 

0 2 64
Syed M · Aug 20, 2021
PBKDF2 Decryption

Hi all
    Is there anyway to decrypt the PBKDF2 encrypted data in a table?

Syed M

0 4 317

Hi - Looking at encoding a .rtf file to Base64 - I've seen the Base64Encode Method and I can pass text but how would you pass a file?  Or is there another method that can do this?

The end goal is to place the encoded output in a MDM^T02 (in OBX Segment) HL7 Message.

Appreciate any pointers - Thank You


0 2 113

I have a CSP page that throw a "414 error - Request-URI Too Long" when I put lot of text (eg : 10000 characters) into a field of a submitted form. The form is submitted using POST method.

Based on some experiments I made, it seems the max size of a URL is around 8200 characters.

What is the official limit, and is there a way to increase it ? I searched in the documentation but couldn't find anything.

0 4 102