#InterSystems IRIS

Hello,

I'm using a ComplexBatchFileService to retrieve and process a 425 Mo File ( lines )

At some point the Business Service is in failure , and displays this error :

ERREUR #5002: Erreur Cache: <FILEFULL>%SaveData+18 ^CFAO.EOS.MasterFilePR.PMP.RM.ART1.Record.1 ^CFAO.EOS.MasterFileE50F.RecordD(535405931),e:\eos\
+
ERREUR #5002: Erreur Cache: <ROLLFAIL>%TRollBack+10 ^%occTransaction

Good Morning SMEs,

I am a .NET developer and new to using this IRIS Component. We are using InterSystems.Data.Clients ADO.NET component to connection to IRIS, I am able to open the connection but when i called Close, ADO.NET code showing connection is closed state in .NET code but in IRIS side it showing as connection is still open. The will close only after recycling apppool or closing IISExpress/calling application

Here are the steps I used to open the IRIS connection.

How I can get current date/time on format YYYYMMDDhhmmss?

I tried $ZDATETIME($HOROLOG,8), but I got 20220606 17:59:56 and I want 20220606175956

Thanks

Hi there,

I'm passing a JSON object to the server as such:

{"key":"value","key":"value","key":"value"}

From the client:

- Build object

object=JSON.stringify(object)

-pass to server side method as %String

On the server:

s object={}.FromJSON(object)

Instead of getting something like

object=<OBJECT REFERENCE>[2@%Library.DynamicObject]

I get

object="991@%Library.DynamicObject"

I can't access that object using %Get as if says invalid OREF.

Hi, what’s the best way to check if your query return 0 records?

How do I use ANSI escape codes to produce green text in InterSystems IRIS terminal?

Hi All,

I am looking for a reporting tool (Analytics purpose) which can be built using cache object script/MUMPS. Basically my requirement is to find a tool where I can implement cache code to report data for my application.

I am unaware of DeepSee and how it works. Please assist for the same.

Do you have cases using datadog to monitor intersystems products?

Continuing on the journey of implementing %UnitTest, @Timothy.Leavitt's Test Coverage package, and automated testing with Jenkins.

My question today: why do we utilize a unit test root directory?

I've been defining packages and classes to write unit tests as I've been developing and I run the tests on the command line or using a routine file that is setup as a debug target which has been working great. I use DebugRunTestCase() to do this (so the classes aren't deleted).

Hi all,

any news about support of the IRIS platform in the DBeaver? I only found this https://github.com/dbeaver/dbeaver/issues/6289 Github issue. They are waiting for a new version of the JDBC driver.

Thanks for the answer

From IRIS log, I found lots of following content

05/05/22-01:05:11:375 (16166) 0 [Generic.Event] ECP: Mirror Connection request from 'SM25SDLMIIRROR:LOCALHOST.LOCALDOMAIN:IRIS' (10.xxx.xxx.27:33040)

05/05/22-01:05:11:376 (16166) 1 [Generic.Event] ECP: Active server not defined, cannot redirect mirror connection

Could any one explain a little bit for me?

What it the best method to call an object without ID but having RowID

SET task.Title = ##class(RESTAPI.TITLE).%OpenId(obj.Title)

I have tried using %OpenId() but it returns null

Any help would be grateful thank you.

Hi

I have an a Ens.Request subclass (Invoice) that has a relationship property to another persistent class (InvoiceItems), with properties of its own and the inverse relationship defined referring back to Invoice.

When building a DTL with these classes, the Relationship’s inverse relationship (Invoice, within InvoiceDetails) is displayed.

Given I have a property

Class All.AllBooks Extends %Library.Persistent
{

Property ID As %Integer;

Property Title As User.Book;

}

In the class method

ClassMethod GetABookById(id As %Integer) As %Status
{

SET MyBooks = ##class(All.Allbooks).%OpenId(id)

SET obj = {

     "ID" : (MyBooks.%Id())

     "Title" : (MyBooks.Title)

}

WRITE obj.%ToJSON()

Quit 1
}

How do Access the foreign key in JSON() data