#Caché

I have created on class method which execute below command

From terminal : _System account works fine where code=0

From Studio : _System account give syntax error where code=1

set code = $zf(-1,"python C:\keys\GetToken.py")

w !, code

I am relatively new to Intersystems cache database management. As I understand it, a database is set with a maximum size or unlimited and the size of each space allocation for the database is defined. My understanding is that the cache database will then manage the allotment of space to the database as the current space allocation is consumed. Though I do not know why one would want to do this, I have been told that the space allocation to a database can be set to be handled manually. This is something, if true, I was not aware of.

Hi Developers! As part of an internal company hackathon at InterSystems, I'd love community feedback on a few topics. Feel free to chime on any/all of these via comment or direct message to me.

1. If you were to launch a new application/project, what problems would you need to solve right off the bat? What technologies would you use? Why?
2. What are the most common and repeated problems that you find yourself solving?
3. Where in InterSystems' technologies do you spend most of your time?
4. In a solution you have recently implemented, how were your time/efforts allocated? (e.g.

Hello Caché-Community,

where can I download the current ODBC Drivers for InterSystems Caché.
The links in the following post don't work anymore:

https://community.intersystems.com/post/odbc-drivers

Best regards

Florian Hansmann
 

Is there a way to ensure a certain global(s) are always in buffer ?!

Is there a method call to check if a global is in buffer ?

I have a workstation with a CACHE instance up and running.

On that same workstation there is also an instance of IRIS (fresh install). I would like to migrate manually the CACHE database to IRIS (ideally, all globals, routines and classes).

What I tried is to copy C:\InterSystems\Cache\mgr\CACHE.DAT to C:\InterSystems\IRIS\mgr\IRIS.DAT (after shutting down both instances) but it does not work.

I got the following message : (112) The service for the IRIS instance did not start.

Is there a better way ? (eg: using Portal or some API from command line).

Hi all.

I'm trying to create a route rule that can call to a web service according to a parameter of a message.

My first attempt is the following:

I have a common class with all information, BuscarHuecoRequest, and check what is the value of property "CodigoProveedor".

The table T_PROVEEDOR contains the list of code with the code of the provider, if is F, calls to WSF, if is C, calls to WSC, etc... Using a transformation to convert the values to this provider.

Hi,

I wonder if anyone tackled the following problem-

Sending a mail with an embedded image is straight forward using %Net.SMTP

S status=Message.AttachFile(Dir,FileName)

D Message.TextData.Write("..<img src=""cid:xyz.png"">..")

Outlook displays such an Email as expected- with the image in the body of the mail.

Gmail displays the image as an attached file.

There are a lot of suggestions online about this, but none is working for me.

Did anyone face and solved this issue?

Regards,

Nael Naseraldeen

First of all thanks for your help and time

We would need to find inside PID:3 which one meets the following condition:

PID 3.4.1 = "CAC" and PID 3.5 = "JHN"

We have been investigating how could we do it

We have achieved to get single fields in a call request as follows:

request.GetValueAt("ORCgrp(1).ORC:OrderingProvider(1).IDNumber")

##class(Ens.Util.Time).ConvertDateTime(request.GetValueAt("PID:DateTimeofBirth"),"%Y%m%d","%Y-%m-%d")

However, how would you recommend us to look for a specific field in PID meets a specific criteria?

How would you find inside PID if there are PID 3.4.

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.

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 @validator
write sc,!

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.

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.cls?

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.

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!

Is there a way to create anything like this?

Multiples result sets.