Tirthankar Bachhar · Oct 17, 2024 go to post

I am not sure why this site is blocked in my org - Optum/UHG. 

This page is blocked due to United Health Group policy.

Access to the web site intersystems.customershome.com has been blocked because it considered Uncategorized or a Parked Domain and are not allowed based on UnitedHealth Group's access policies.

Tirthankar Bachhar · May 25, 2021 go to post

I could get it working.

Additionally i had to add additional jar i required for more code i have added just after /shared/FirstDemo.jar.

It worked. Fantastic. 

Thank you so much.

Tirthankar Bachhar · Apr 14, 2021 go to post

Hi @Eduard Lebedyuk / @Alberto Fuentes,

I am trying to use PEX / Java without docker.

So i have a jar containing the FirstOperation class and its all dependencies.

When i configure the object gateway and uses the same it never identifies the JAVA class.

Gives error as below,

Terminating Job 95839 / 'FirstOperation' with Status = ERROR #8104: Gateway Exception: <GATEWAY> java.lang.ClassNotFoundException java.net.URLClassLoader.findClass(URLClassLoader.java:382) workshop.pex.FirstOperation, %QuitTask=

Can you please guide me on, how do it use pex without docker. Why the class Loader can't find the java class within the jar?

I'll really be grateful to you, and wait for your response.

Regards,

Tirthankar

bash-3.2$ docker login

Authenticating with existing credentials...

Login Succeeded

bash-3.2$ docker-compose build

Building jgw

Step 1/9 : FROM openjdk:8 AS builder

---> 9324460525ca

Step 2/9 : ARG APP_HOME=/tmp/app

---> Using cache

---> 89bfa3325c80

Step 3/9 : COPY src $APP_HOME/src

---> Using cache

---> 34b6e7d671c2

Step 4/9 : COPY --from=intersystemscommunity/jgw:latest /jgw/*.jar $APP_HOME/jgw/

ERROR: Service 'jgw' failed to build: invalid from flag value intersystemscommunity/jgw:latest: pull access denied for intersystemscommunity/jgw, repository does not exist or may require 'docker login': denied: requested access to the resource is denied

bash-3.2$

Seems like 'intersystemscommunity/jgw' is not available anymore. 

This was not the exact requirement i had. But using JOB there are issues handling files, specially in APPEND mode.

Using this workMgr, its fantastic. Its the best way to SPAWNS multiple jobs and get your work done.

A big THANK YOU! Save my last 2 weeks of effort.

Thanks so much, made my day. I have been searching for this one exactly!!! This forum is so great, I’m glad to be part of it!

Setting MAXLEN="" or MAXLEN=5000 absolutely resolves the issue related to that specific property. But what about other potential huge list of properties within SDA3 structure?

Please read my whole notes.

Setting MAXLEN="" or MAXLEN=5000 absolutely resolves the issue related to that specific property. But what about other potential huge list of properties within SDA3 structure?

Please read my whole notes.

Tirthankar Bachhar · Aug 24, 2017 go to post

Thanks for your response, that helps! Is there any out of the box utility to deploy cache.dat or code?

What would be your recommended deployment process/aaproach? using manifest?

Tirthankar Bachhar · Feb 28, 2017 go to post

Agreed. Default collation for String is SQLUPPER. You can't define the collation of a index if its defined as Unique as below. Below is prohibited, but you can mention any collation on property instead of specifying in Index.

Index ValueIndex On UniqueStringValue As SQLUPPER [ Unique ];

On the other hand, I mentioned another solution to the actual problem above. Please review/comment on that.

Tirthankar Bachhar · Feb 28, 2017 go to post

Yes, if you have idkey in index, that has to be Exact collation.

But I can tell you one way around it, lets see if you like it. Its tricky though.

Property UniqueStringValue As %String;
Property CopyUniqueStringValue As %String [ SqlComputeCode = { set {CopyUniqueStringValue}={UniqueStringValue}}, SqlComputed, SqlComputeOnChange = UniqueStringValue ];
Index ValueIndex On UniqueStringValue [ IdKey, Unique ];
Index ValueIndex2 On CopyUniqueStringValue As SQLUPPER;

Now, if you do ValueIndex2Exists("hello") or ValueIndex2Exists("Hello") or ValueIndex2Exists("hELLO") you will find match. This will also work on SQL as well if you do - 'Where CopyUniqueStringValue=?'.

This should solve your purpose though, but the space will be duplicated for same index though.

Tirthankar Bachhar · Feb 27, 2017 go to post

There are many predefined methods defined by Cache under Security.* package to maintain/manage Roles/Users/Resources ...ect.

Specific to your query, you can use below command to export/import Roles:

Write ##class(Security.Roles).Export("C:\RolesExport.xml")
Write ##class(Security.Roles).Import("C:\RolesExport.xml")

Roles: 
Please refer to below class doc for more: http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?LIBRARY=%25sys&CLASSNAME=Security.Roles&CSPCHD=000000000000gt0xiwWBxf8D77QROEE$c2JR50xdHrcUuUzSzc&CSPSHARE=1

Resources:
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?LIBRARY=%25sys&CLASSNAME=Security.Roles&CSPCHD=000000000000gt0xiwWBxf8D77QROEE$c2JR50xdHrcUuUzSzc&CSPSHARE=1

Tirthankar Bachhar · Feb 27, 2017 go to post
Property UniqueStringValue As %String(COLLATION = "SQLUPPER");Index ValueIndex On UniqueStringValue [ Unique ];

Use COLLATION as above, to specify the manner in which property values are transformed for indexing.
Below is how data and index will look like,
ZW ^DataGlobal
^DataGlobal=1
^DataGlobal(1)=$lb("",,"Hello")
 
ZW ^IndexGlobal
^IndexGlobal("NameIDX"," HELLO",1)=""
^IndexGlobal("ValueIndex"," HELLO",1)=""
Test:
Write ##class(Package.Data).ValueIndexExists("hello") = 1
Write ##class(Package.Data).ValueIndexExists("HELLO") = 1
Write ##class(Package.Data).ValueIndexExists("heLLO") = 1
Write ##class(Package.Data).ValueIndexExists("hello") = 1
Write ##class(Package.Data).ValueIndexExists("Hello") = 1
Write ##class(Package.Data).ValueIndexExists("HelloGuys") = 0
ISC DocBook: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_basics#GSQL_basics_collation

Tirthankar Bachhar · Nov 14, 2016 go to post

Eduard, if I have understood this correctly,  this is going to only for %Library.DynamicObject right? Not for any other classes, correct? Your posts title looks generic, is that true?

Started writing long, back but posted the same just now. but I see you have solution from  

Can you try with any of the below, and let me know if that works.

Set %session.EndSession=1
Set %session.NewSession=1
 

Hey thanks for your response again. Managed alert will keep notifying in case no action is taken, and escalation level is increased, that I have implemented.
But in this scenario, I believe I'll have to extend Ens.MonitorService.cls and write the custom code to monitor the queue count if its increasing even after crossing the threshold.

Thanks for your response.  I have quoted the same in my post as well. how do I get an alert if the queue size does not comes down even after long time. which might be because of some issues to be looked upon. On this sceneries how do we configure to get an alert.