1. create a wrapper class with classmethods mapping to your routine(s)

or better

2. convert your routines to classes

then use $CLASSMETHOD | Caché ObjectScript Reference | Caché & Ensemble 2018.1.4 – 2018.1.9
to call these dynamically.

This also addresses the issue that xecute is highly risky from a security point of view, it can easily be targeted with injection attacks.

Hi Enrico, my sample code does that exactly. It takes number1 and converts it to a number than it compares the result to the original number1 field. 
Quirk of type conversion in ObjectScript if a value is converted from string to number ObjectScript walks the values from left to right and stops at the first non numeric character ie.
123ABC   becomes 123

The if clause checks then if 123 = 123ABC so the org value is non numeric.

Using && in the IF clause means do a logical AND check but short circuit the check ie. if condition 1 is already false go directly to the else clause and do not check cond2 and3

pure objectscript way no functions needed, we just use the IRIS type conversion behavior:

 

set number1="123123"
set number3="123123123 Not a pure number"
if ((+number1=number1) && (+number2=number2) && (number1>=number2)) {
    set div=number1-number2
} else {
    w !,"Conditions not met"
}

A simple health probe would be to have the LB poll /csp/mirror_status.cxw on the respective webserver it will return success if this webserver is connected to the active mirror and failed if its connected to the backup mirror.

Hi Fred,

on the AWS instance what does the command "iris list" return?
Also you can have a look at the messages.log file located at the <installDir>/mgr/messages.log

This should give you an idea of what the issue is.

very quick and dirty test, probably only works on small streams, also needs to actually read the whole stream for compare.

 

# test compare - streams are same
set stream1=##class(%Stream.TmpCharacter).%New()
set stream2=##class(%Stream.TmpCharacter).%New()
do stream1.WriteLine("ABC123")
do stream2.WriteLine("ABC123")
do stream1.Rewind()
do stream2.Rewind()
w (stream1.Read() = stream2.Read())

1

# test compare - stream are different
set stream1=##class(%Stream.TmpCharacter).%New()
set stream2=##class(%Stream.TmpCharacter).%New()
do stream1.WriteLine("ABC123")
do stream2.WriteLine("DEF456")
do stream1.Rewind()
do stream2.Rewind()
w (stream1.Read() = stream2.Read())

0

Hi Jingesh,

have a look at this older dev community article: Synchronize data with DSTIME | InterSystems Developer Community |

Hope it helps.

Hi Scott,

my first thought here was use ^GBLOCKCOPY.

GBLOCKCOPY can copy all globals from one database into a new database or namespace.

So in your case create a new namespace with the correct mappings and new default databases. then use ^GBLOCKCOPY to copy all globals into this namespace. The copy to namespace follows the mapping definition for the namespace and should split Global(data) and Routine(also in globals) into the respective default databases.
This new databases can also created mirrored and then would be populated on all nodes respectively.

A caveat though i would test this first as i am a bit unsure if it really gets all globals located in a database(including system), although i am pretty sure it does.

Hi Richard,

at the version of Cache you are using there is no terminal via web browser. Not even sure if the community webterminal is working with this old version of Cache.

Only recent IRIS versions have introduced a terminal service via web technologies to be used with VSCode.

This sounds very strange. Have you tried using a linked table instead of an external table? 

Might be worth raising this with WRC as External tables is a new feature with IRIS 24.2

Hi Tam,

please contact WRC they can assist with your request.

Best Regards

Timo

Hi,

so just to summarize what i understood. 

You have a superclass with some logging method. Now every time the logging method is called from a child class it logs the name of the superclass instead of the Child class?

If so the issue is that $CLASSNAME returns the name of the class where the method is located not where a method is called from.

To work around this behaviour you would need to rewrite your logging method to be a codegenerator, e.g.

instead of:

ClassMethod Log()
{
    w $CLASSNAME()
}

rewrite it like this:
 

ClassMethod Log() [ codemode = generator, forcegenerate ]
{
    do %code.WriteLine("    w $CLASSNAME()")
    quit 1
}

This will locate the Log method from the superclass to the child class and have $CLASSNAME resolve to the child classname.

Ther eis one inherent flaw i found when using linux service definitions. If you once stop/start IRIS using iris stop/start command it breaks the automated shutdown.

To work around this we usually define 2 service definition, one for normal control and one to ensure the instance goes down during shutdown.

example definitions:
 

    [Unit]

    Description=Shutdown management for ISC IRIS Instance SAMPLEINST - to ensure DB instance is properly shutdown on system reboot

    [Service]

    Type=oneshot

    RemainAfterExit=true

    ExecStart=/bin/true

    ExecStop=/usr/bin/iris  stop SAMPLEINST quietly

    [Install]

    WantedBy=multi-user.target

    # normal management

    [Unit]

    Description=Management for ISC IRIS Instance SAMPLEINST

    [Service]

    Type=oneshot

    RemainAfterExit=true

    ExecStart=/usr/bin/iris start SAMPLEINST quietly

    ExecReload=/usr/bin/iris   stop SAMPLEINST quietly restart

    ExecStop=/usr/bin/iris   stop SAMPLEINST quietly

    [Install]

    WantedBy=multi-user.target

    Alias=IRIS-iSAMPLEINST.service

Hi Ron, pretty sure this version is no longer publicly available.
Try contacting WRC if you need that exact version.

I hope you still got your license key saved somewhere.

Hi,

Try setting the Cookie security to LAX. This essentially has nothing to with the IRIS/Cache version but with the CORS standard implemented in modern browsers.

Cookies with SameSite attribute set to None are only allowed if they are secure. refer to https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

Hi Luis,

just looking at documentation try disabling: Do Not Use Delimited Identifiers by Default
 

snip from documentation (ref: documentation:

Do Not Use Delimited Identifiers by Default

The Do not use delimited identifiers by default option controls the format of identifiers in the generated routines.

Select this check box if you are using a database that does not support delimited SQL identifiers. This currently includes the following databases:

• Sybase
• Informix
• MS SQL Server

Clear the check box if you are using any other database. All SQL identifiers will be delimited.