#Caché

Hello everyone,

I would like to know what is the best terminal emulator in your opinion? I am using MobaXTerm, but  i'm having some difficulties with the charset configuration. 

Best Regards.

UPDATE:
It turns out it was just me being a dummy, and the snmpd was correctly telling me there is no value associated with that exact key. I should have used snmpwalk instead of snmpget to display the whole tree.
Original Post follows:
Hello!
I'm trying to set up SNMP monitoring on Caché, using documentation and this article
I'm running net-snmp on Red Hat Enterprise Linux Server release 7.3 (with CentOS repositories), and Caché version 2017.1
It looks like snmpd is running as AgentX master, and Caché subagent is running too
/opt/cache/mgr/SNMP.log with debug shows no errors and it looks like cache

Why is it not common to handle inclusion, alteration and exclusion rules directly in the Caché database, using their controls on web pages, as is usually done in other databases such as Oracle, SQL Server? 

Hi developers,

We're hosting a User Group session for our Deltanji source control and Serenji debugger users on Wednesday, November 3rd at 11-12pm EDT / 3-4pm GMT.

We'll be showcasing some advanced features of Deltanji and Serenji in VS Code with time for a discussion - so feel free to bring along any problems you need help solving or share your feedback on our tools. We'd love to hear your thoughts. 

You can find out more on Eventbrite. 

Everyone is welcome. If you're interested in our tools this is a great chance to hear what others have to say, as well as asking your own questions.

We hope to see you on November 3rd! 

Do we hv any command to prevent the execution of update/delete SQL w/o “Where” Clause？ 

hello!

i have object bellow

Set object = ##class(%ZEN.proxyObject).%New()
set object.city = "New York"
set object.Target = "TEST" 
set object.Details = "TEST"
set object.RefCode = "123"
set object.Reason = "123TTTT"

I want to get string from json object. 

Could you help please ?

If I open a terminal and type the following commands, sc is an error:

set validator = "sc = ##class(%Library.Numeric).IsValid(""BLAH"")"
set @validator
write sc

At the end, when I write sc I get:

0 L'BLAH9
             DOCXT010,#e^zIsValid+1^%Library.Numeric.1^1e^^^1

However, if I call the following class method using the arguments "%Library.Numeric" and "BLAH", sc is undefined

ClassMethod testvalidator(class As %String, value As %String) As %Status{set validator = "sc = ##class("_class_").IsValid("""_value_""")"write validator,!set @validatorwrite sc,!quit sc}

When it tries to

Hello everybody,

I am trying to export a class to xml and remove the tag "xmlns" from mother class. These are my classes to create the XML.

Class Class.Test Extends (%RegisteredObject, %XML.Adaptor)
{ 

Parameter NAMESPACE = "http://mynamespace.com/test"; 
Property Person As Class.Person; Property Address As Class.Address; 

}

Class Class.Person Extends (%RegisteredObject, %XML.Adaptor)
{ 

Parameter NAMESPACE = "http://mynamespace.com/test"; 
Property name As %String; Property age As %String; 

}

Class Class.Address Extends (%RegisteredObject, %XML.Adaptor)
{ 

Parameter

First of all thanks for your time reading this question, and thanks for your help

We have the following use case: we would need to send with MTOM a zip which contains a csv

We have read:

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

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

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

We would need to replicate how SOAPUI does send a zip with a csv as an attachment in a SOAP request, using Ensemble

Being the raw tags as

The latest release of Serenji focuses on the debug experience. Not only can you now debug on the spot, no matter where you are or what you're doing, but we've also added some smaller features that will make debugging more straightforward. 

• Run and Debug CodeLenses - clickable links above each class method, procedure, subroutine or extrinsic function.
• Intuitive prompting for entrypoints and arguments - when debugging a class method, produce, subroutine or extrinsic function. 
• Shaded read-only background - to clearly differentiate between documents which are editable and those that are read-only. 
• Program output in debug console - output is shown in the debug console. 
• Serenji commands on Server Manager's namespace trees - allowing you to launch Serenji through Server Manager. 

Find out more in our release notes here. 

Hi, Community!

When I introduce a field to a persistent class to manage date/time what datatype should I prefer? 

%Date or %TimeStamp? And why?

We have in our company a task that use many times a job command, and we receive this message "<LICENSE ALLOCATION EXCEEDED>". I thought that a new license is consumed only when we acess with another IP address the database.

Can anyone explain this to me?

I am trying to figure out the best ObjectScript analog to mimic, more or less, the %RCOPY functionality. What would be ObjectScript  method(s) if any to copy a routine from the current namespace to another one and compile it there?

I use the following code to start a start a job :

Class MyClass Extends (...)
{
    ClassMethod Foo()
    {
       job $CLASSMETHOD("MyClass","MyMethod") //take forever depending hardware
    }

    ClassMethod MyMethod()
    {
       //do database related stuff
    }
}

On local environment, calling Foo() is instantaneous (a few ms). On production/test servers (which have much better hardware than local) calling this function is slow and take between 200 ms to 800 ms. Obviously starting a new job with "job" command take lot of time on those environments.

I don't know the reason of

I am running csession on AIX. I have been using the command "csession cache -U%SYS". In the session the namespace shows as "%SYS>" as expected. I was simply doing queries to the best of my knowledge. At some point csession starting failing to reference the namespace instead showing /cachesys/mgr which is the main dir for the cache instance. I am not aware of doing anything that would cause this but more importantly, how do I correct it? I

Hi developers, 

We've incorporated VS Code's support for multiple concurrent debug sessions and consoles into the latest release of Serenji. 

So if you're working with processes that relate or are dependent on each other, you can now debug them together. Just launch a second Serenji debug session (F5) whilst the first one is still active. 

This short video below shows how it works. We hope you find this feature useful! 

Laurel 

When refreshing a html or tablePane component using refreshContents() that takes a lot of server-side-processing, I'm running into timeouts every now and then. i.e., the result for the tablePane is that there's nothing displayed at all.

How can we configure (relax) that timeout so also those heavier ones get refreshed eventually? Just overriding %request.Timeout in %OnPreHTTP did not seem to do the trick.

Our company is using Cache FDBMS for Medtrak.

I am trying to insert a record with the following data types : date, time, string and memo field (multiline).  The SQL insert/update works fine without the memo field.  

Here's my SQL statement

Insert into MR_SUB (MRSub_Date,MRSUB_Time,MRSUB_Update,MRSUB_Desc) values(:DTE, :time, :use, :remarks)

Based on FDBMS docs. MRSUB_Desc is a multiline/memo data type 

Hope somebody can help.  Thanks

This training course is addressed to beginners who would like to discover the IRIS Interoperability framework. We will be using Docker and VSCode.

Hello everyone, 

InterSystems Certification has redesigned their IRIS System Administration certification exam, and we again need input from our community to help validate the topics. Here's your chance to have your say in what topics are covered on the InterSystems IRIS System Administration Specialist exam! And, yes, we'd like to hear from you Caché admins too!

Here's the exam title and the definition:

InterSystems IRIS System Administration Specialist

An IT Professional who:

• installs, manages, and monitors InterSystems IRIS environments, and
• ensures data security, integrity, and high

Is there a way to create anything like this?

Multiples result sets.

Hello,
        
        We are using AWS SSO authentication in our application to validate the users. For validating the users, we are passing the username and password from AWS SSO to our application. We need to validate the user in our application without using the password.

         We developed the login class using zenPage. We used <loginForm> tag in the login page which is used for the automatic validation.
         Is there any possible way to achieve this?
         

Thanks in advance.

I would like to know if an encrypted caché database can run significantly slower than a normal "unencrypted" database, in a way that is noticeable to the end user (e.g. slower response time for most pages, especially the ones that rely on read/writing to globals).

I searched in Intersystems knowledge base and couldn't find anything related. I'm looking for possible before/after benchmarks.

The most recent release of Serenji features our innovative gj::locate technology. It was a standalone tool we originally created for a Developer Community contest earlier this year, but we've incorporated it into our debugger after some great feedback from developers. 

It works by navigating you directly to the source of your server-side errors in just a couple of clicks - enabling you to quickly fix errors without the need to count tedious lines of code... and let's be real, who has got time for that when you're under pressure to fix this bug? 

It's simple and straightforward to use:

1. Click on

Folks, 

I am looking to migrate a few legacy debt collection applications built using InterSystems Cache to AWS. Does anyone here have any experience, ideas and best practices on migrating Cache products to the public cloud?

Regards

Sudarshan

+1-917-685-3551

Hello,

I’m looking for a way to find out which category of portal a connector belongs to.
I looked at the class ‘Ens.Config.Production’ and ‘Ens.Config.Item’ but without success.

An idea about the ‘ObjectScript’ code to design?

Best Regards.

Hello

I made for fun a bash script that creates csv files from a %GOGEN exported file. %GOGEN, the utility for exporting globals for Cache 5.xx

First I thought it would be very simply with bash, but ...

• if I want a header in the csv file
• if you export with GOGEN more globals together not only one
• if I want a csv file for every global/indexes has the global ..

The simply bash script goes up 100 lines of code. If I will start again with this, I would use Python or Go, not bash.

Example:

For a EXPORTED.GLO file

    Transferring files on Mar 30 2019 at 10:24 AM
    ^ALD(20190330

i want to write a application for educational purposes which will be able to write,  read and store name , surnames and birthdays of patience in a database in Caché ObjectScript

this are the codes i have already written can someone help me out. 

// fill in ^Data with sample data
 For i = 1:1:100 {
     // Set each node to a random person's name
     Set ^Data(i,"name") = ##class(%PopulateUtils).LastName()
      Set ^Data(i,"surname") = ##class(%PopulateUtils).FirstName()
       Set ^Data(i,"birthday") = ##class(%PopulateUtils).Date()
 }
 

We just upgrade from cache 2016.2 to IRIS 2020.1.1.

After this upgrade we cannot access to the portal web management, and dont give errors about that just this:

09/28/21-15:59:16:654 (20192) 1 [Utility.Event] Private web server has not started after 5 seconds.

Is this normal? 

I followed the guide but dont talk nothing about that.

This is a normal problem when upgrading? 

Thanks!!

Hi all,

I wonder how to sync my server code to my local code using Visual Studio Code.

Previously, using Atelier, you could open a view of server and can copy the code to the current project, also if I change a BP, I could sync the code because I had a signal that It's warning me that there was a change and it needs to be updated.

I thing i shouls opening the ObjectScript: Explorer and select the code directaly, and right click -> Import and compile current file (Ctrl + F7)

If I use this command, the ouptut window shows: