In my opinion the problem is that your text is already in UTF8 but with wrong characters due to a wrong decode so you can't remove it with $ZCONVERT, you should define the charset of the data from the class that is receiving the JSON to decode the JSON properly.

To declare a specific charset for a REST API (I guess that you are using a class that extends %CSP.REST) you have to define the following parameter:

Parameter CHARSET = "utf-8";

In my case I was receiving UTF8 texts, you should configure it with your specific charset.

About the CSPSystem, I had some troubles to connect when I used the superuser from VSC and the webgateway had the CSPSystem user configured, It solved when I changed the user to superuser.

Probably you are right and is not necessary to change the CSPSystem (my current configuration it's using CSPSystem and works fine) it just was pure chance.

You can use $ZF(-100) command to execute operative system commands (here an example), with that command you can look for the process that is locking the superserver.

Well, I highly recommend to you to not use the same instance of Health Connect for TEST, DEV and PRODUCTION, even more, I recommend to you to deploy each environmnent in different servers.

It won't be the first time that a code un DEV has a infinite loop creating heavy globals that use all the space in the disk. 

You can check the process running for each namespace and the CPU time:

And using de PID you can identify in your Operative System (Windows or Linux) the process to check the memory used.

Have you tried to merge the pdf using Embedded Python? In IRIS 2023 is already available, you only require to install the pypdf library in your instance to use it.

You can find an example of pdf merge using python here.

Maybe the error is on the declaration of the table, use the parameter NODELIMITEDIDS for the declaration:

CREATE FOREIGN SERVER server-name FOREIGN DATA WRAPPER jdbc CONNECTION 'mysqlconnection' NODELIMITEDIDS

This is a personal opinion but I think that it means that the restoring of the journal didn't affect all the databases of the system located in different folders.

Hi @Martin Staudigel you only can include DTD in the XSD if you define it using specific flags.

The solution is to create a new class to import the schema in XSD programatically. This is an example of the code:

Class XML.SchemaReader Extends %Persistent

{
ClassMethod ImportClasses(fileName As %String = "C:\Temp\example.xsd") As %Status
{
#include %occInclude
#include %occSAX
		#dim sReader as %XML.Utils.SchemaReader = ##class(%XML.Utils.SchemaReader).%New()
		#dim features as Filero.DataType.String
		set sReader.SAXFlags = $$$SAXFULLDEFAULT-$$$SAXVALIDATIONREUSEGRAMMAR
		set sReader.MakePersistent = 0
		set sReader.MakeRelationships = 0
		set sReader.GenerateXMLNILNOOBJECT = 1
		set sReader.GenerateXMLNIL = 1
		set sReader.KeepEmptyClasses = 1
		set features("BINARYASSTREAM") = 1
		quit sReader.Process(fileName,"ImportedScheme",.features)
}
}

This code will create a package "ImportedScheme" in your IRIS

As the creator of the idea, you have all my support! The localized versions are really confusing with literal translations that have no sense.

If you execute the bat file from the command line of Windows...does it work? Maybe the PATH to the java bin folder is not accessible from the Ensemble user.

Try removing the Tiempo de espera and... Could you show the popup when you click on the magnifying glass of Llamadas? Just to be sure that it had correctly detected the calls.

Try to put together all the calls followed by the sync, all of them inside the scope and at the end, after the sync, the catchall.

The problem with web applications is that sometimes the behaviour is a bit "stange", it's possible that the DTL page would be cached on explorer's memory and this makes it to work with errors.