In addition to Raj comment. What usually happens is that the deprecated libraries and calls are replaced with redirects to the new implementation.

Hi Touggourt,

Try http and make sure the firewall allows http access. If you wnt https on that port then you need to configure your production accordingly. 

Hi David,

i would check the idle timeout and session time out settings on the web application as well as in the CSPGateway. Long timeouts mean licenses do not get released until the session is dropped.

If you don't know what is getting execute exactly you can use MONLBL (ref : MOMLBL )
Its for performance diagnostics but will give you a statistic of routine code being called etc.

Hi Malcolm,

using a license server is recommended in multi server deployments. But that will not alleviate the issue that users need to login again after a failover. The issue here is that the webgateway loses the login connection to the iris instance on failover and needs to reauthenticate and reestablish. In case of a stateless application this has no user impact, but in case of a non-stateless application the user needs to reauthenticate and all data in flight is lost. 

To resolve this issue you should consider going to a multi-tier setup with appservers using ECP.   
Highlevel design:
webserver(webgateway) connects to
appserver(authenticates and serves the application)
connects to mirror via ecp

ECP is mirror aware and will failover transparently for the appservers. So users stay logged in and don't notice the failover.

Caveat: This only works if the failover is fast and happens before the appservers do any ECP operation and the ECP connection then times out.

refer to: Distributed Cluster

Hi,

a 404 error usually comes from Apache. As we don't know your Apache setup its difficult to advise. It might be that you need to add additional config to allow the new path to be accessible.
Also seeing you call this using a port number other than 80/443, i guess you are using still using PWS, which is not supported for production loads.

It would be good to understand what versions you are talking about. You marked this s IRIS2024.1 but you are talking about Cache odbc drivers. Also it would be good to know which licenses you are using as you are talking of a paywall... Usually IRIS is not limited if you are using a full license. Only limitations in using community are resources, connections and access to some enterprise level protocols (like ECP, Sharding, API Manager). 

Hi Dimitrii,

There are various options here. You can use $job to start new process then continue on with your main process or you can use WorkQueueManager to create a workqueue and feed it with items to process.

Best Regards

Timo

From a performance aspect i would not use objects to retrieve the data, but use SQL.

SQL will take care of the conversion for you.

e.g.

select PAADM_PAPMI_DR->PAPMI_PAPER_DR->PAPER_StName
from SQLUSer.PA_Adm
where
PAADM_Hospital_DR = 2
and
PAADM_AdmDate>='19/03/2025'
and
PAADM_AdmDate<='19/03/2025'

In addition, here is the intro course from learning https://learning.intersystems.com/course/view.php?id=1130

Hi Norman,

we need to seperate 2 areas of fragmentation.
1. filesystem/OS level fragmentation
     nothing that we can do anything about it except running your trusted defrag if the filesystem has one and actually is in need of defragging.
2. database/global fragmentation:
     This is a very interesting topic, usually nothing needs to be done for an IRIS database, IRIS is pretty good in managing global block density. (refer to https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...)

You can use the output of an integrity check to see how your global density is per global in the database. Both defrag and compact operations are non-destructive and non interruptive, so even if they don't finish they can just be started again and will continue on.

Hi Alexey,

without knowing any details, have you checked if your routine cache is big enough to cache both routines?

refer to guide to monitor memory usage

Best Regards

Timo

Hi Pietro,

this depends on your application.
In general, you cannot define DB write access without having read access.
This said, you can though define a user that only has SQL insert rights to specific tables without select rights.
I have not tested this though, but SMP allows this type of setup.

Best Regards

Timo

Hi,
Couple of things to check.

Is there any difference in Server design? .e.g. number of disks, scsi controllers, volume/storage distribution etc
Is the VM definition the same? e.g. storage driver versions (generic scsi controller vs hyperV SCSI controller)
Is the OS on the host and in HyperV the same? 
Is the storage provider design the same? 
Is the IRIS config the same (i.e. cpf file), especially are below settings present?

[config]
wduseasyncio=1
asyncwij=8

I guess both IRIS versions are the exactly the same build although i never heard that to affect disk performance.

Hi,
you can use the concat function:
select {fn CONCAT('HELLO',' world')}