add a debug to OnPreHTTP and check the ^%global
k ^%global S a="" F  s a=$O(%request.Data("")) Q:a=""  m ^%global(a)=%request.Data(a)

sometimes, better to check: $D(%request.Data("action",1)) and not $G

You need to map static files in IIS to the CSPms (for default website)

Look at XData css in class: WebTerminal.StaticContent 

Hello Caio,

There is no DECLARE @variable (SQL server) or DECLARE variable (Oracle) on Cache but there are few options:

1. Use a host variable(s) in embedded SQL:

2. Use the same with Dynamic SQL

3. Writing a SP

According to the documentation for Embedded SQL: "A host variable cannot be used to specify an SQL identifier, such as a schema name, table name, field name, or cursor name. A host variable cannot be used to specify an SQL keyword".
Using Embedded SQL | Using InterSystems SQL | InterSystems IRIS Data Platform 2023.1

You will need to use dynamic SQL

Yes. the SMTPTRACE is the one that will allow log on SMTP (pity that they did not do that by an external parameter)
The DB that you need to mount as RW is IRISLIB

I would try to increase the ODBC timeout on the client side (PDA). If this does not help, opening a WRC might be helpful, since they can help you analyze your IRIS instance load and configuration (high CPU, cache buffers, memory) that might make your instance more robust and stable to those errors

Hi @Ashok Kumar T,
you are correct, I was mistaken. The correct one is: "%System/%Login/Terminate"
Auditing | InterSystems IRIS Data Platform 2024.3
 

Hello,

You may use an existing library for SSO using MS or google account with "Microsoft Authentication Library (MSAL)"
Overview of the Microsoft Authentication Library (MSAL) - Microsoft identity platform | Microsoft Learn

For CSP pages, we used the JavaScript library MSAL.js
 

You can't directly do that in a BPL since it doesn't have persistence methods. You may convert your %DynamicArray into objectScript array or serialize your data into JSON that can be passed to PBL as a string

The CSP gateway has a "mirror aware" function that will always point you to the primary in a failover pair. This works most of the times, but in rare cases it keep a connection disabled after a primary swtich.

Another option is to use an external load balancer that has some kind of "health probe". Then, you could have a simple REST/API call (called by that health probe) that will return 200 for the primary and 404 (or 500) for the backup. This way going through that LB will always point you to the primary.

Hi,

You said the issue was only 1 server, and you could fail over to the mirror backup server, which could connect to LDAP from within IRIS. I assume you run the d TEST^%SYS.LDAP function to check connectivity.

If only 1 server can't connect, I would ask myself (investigate) "what was changed?" 
using REDEBUG could help to see more information re. the issue.

In any case, I recommend opening a WRC for that, if you can not find the root cause.

Hi Scott,

My remarks:

As mentioned here:

1. As already mentioned by @David.Satorres6134, global mapping for specific globals (or subscript level mapping) to different databases (located on different disks) may give you a solution for space, and also increase your overall performance.
2. Using ^GBLOCKCOPY is a good idea when there are many small globals. For a very big globals, it will be very slow (since it uses 1 process/global) so I recommend writing your own code + using the "queue manager" to do merges between databases for 1 global in parallel.

Both MAC routines and class methods are compiled to INT routines, which are then compiled to OBJ (binary) code that is executed. To achieve better performance, try to make your code compact and efficient

The best practice is put a token (that was safely acquired by the sender) rather than a user/password in the header. This token will give you both authentication, authorization and validity (expiration date and time or retention). Then, the recipient can verify those.

No, there is no limit for the size of %Library.DynamicObject, but the  %ToJSON() might give a <MAXSTRING> - here is a workaround for such: 

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

Ephraim,

When you say "corrupted" to better understand...
- Did you try to mount the DB (from the SMP of with ^MOUNT)? Sometimes if IRIS/Cache was "forced" than a *.lck file on the DB folder need to be deleted in order to allow a successful mount. 
- If the DB is mounted, did you got a <DATABASE> (or other) error? if so, then what was said using ^Integrity and ^Repair could help - but only if you fully understand how to use those tools (!) Most of the time, a corrupted DB is fixable using those tools, or at least data can be 99% recovered. Depending on the number of errors: if its huge than sometimes it is faster to recover the DB from a valid backup + journal files. 

BTW - if this is a mirrored DB than there are other considerations as well. 

Happy new year!

Was the normal procedure done after the upgrade?
e.g. $system.OBJ.CompileAllNamespaces("cru")

I would put also embedded python here

On a given machine any process can run "as fast" as the CPU clock rate (higher = faster = more operations/sec.)

It is true that a single process can do approx. 15-20 MB/sec. (depends on the CPU clock rate & the disk type: SSD, Premium SSD, Nvme)

The best way to overcome this limitation is do to a "heavy I/O" processes in parallel using the queue manager.
On machines with 16/32 cores, you may achieve your "infrastructure limits" (160MB/sec) easily and even more (we managed to go to a 1000MB/sec of Nvme disks)