Developer Community for InterSystems IRIS, Caché, Ensemble, HealthShare, InterSystems Business Intelligence and Text Analytics

Question

Ponnumani Gurusamy · Sep 14, 2016

Difference between Cache object script and Mumps

Listout the Difference between Cache object script and Mumps

#Object Data Model #Caché

0 2

0 2.5K

Question

Steve Riddle · Nov 9, 2016

How to work out the cause of a STORE error

Hi,

I have a process that is importing lots of data from an external file, but every now and then I come across a STORE error.

I know that the STORE error is occurring in the %Save method of the class but I know very little else and I think its something to do with a lage amounts of Related Objects.

Is there a method of finding out more information regarding this error i.e. which actual object was being saved etc etc.

Thanks

Jim

#Data Import and Export #Debugging #Caché

0 9

0 2.5K

Question

Mack Altman · May 26, 2016

Cache 2010.1 and Office 365 SMTP Relay

Does anyone have any experience with getting, unfortunately, an older version of Cache to authenticate via SMTP to send email? I have verified that the settings are set up properly on the mailbox as I have successfully sent an email from a LAMP server, which comes from the same IP address.

If you have any thoughts, I would greatly appreciate it.

This is the error I receive

ERROR #6034: SMTP server connection failed during MAIL FROM command: <READ>zSend+105^%Net.SMTP.1.

#Authentication #ObjectScript #Frontend #SOAP #Caché

0 6

0 2.4K

Question

Chris Sanford · Oct 13, 2016

Parsing EDI 271 input into JSON output

My organization has been tasked with parsing raw EDI 271 messages into JSON strings in order to feed a downstream application. A few key details about the task:

#DTL #JSON #Ensemble

1 6

0 2.4K

Question

Ponnumani Gurusamy · Sep 15, 2016

difference between method and ClassMethod of Class definition

What are the difference between method() and ClassMethod() in Cache Class definition

#Object Data Model #Caché

2 5

0 2.4K

Question

Isaac Aaron · Jun 3, 2016

Read I/O Performance On >50,000 IOPS

Hello

During some consultant activity I did at a client's I have discovered something very interesting. It seems like the current processing cycle as written in ObjectScript has trouble utilizing an SSD-based storage machine with five-digit IOPS.

#Caché #Field Tests

2 6

0 2.4K

Question

Vladimir Prushk... · Jun 9, 2016

Create GUID

Is there a system function/method which can create a GUID ?

#ObjectScript #Caché

2 2

0 2.4K

Question

Don Rozwick · Dec 8, 2016

JSON to HL7

I have a project to convert a JSON message with two patient identifiers into an HL7 ADT^A31. Is there any documentation or training that you would think is appropriate?

Currently using Ensemble 2014.1.5 on AIX

#HL7 #JSON #Ensemble

0 1

0 2.4K

Question

Josh Barney · Mar 24, 2016

Help with Mime attachment HTTP post request

I believe the I have followed the instructions to attach a document to the body of a post request but nothing is being sent out in the files{} port of the request. I can either get the stream in "data", not visible at all, or visible but no form data. Any help would be appreciated, below is what I have:

#Code Snippet #REST API #Frontend #Caché

1 3

0 2.4K

Question

Laura Cavanaugh · Sep 16, 2016

cookies - login vs. session

What's the difference between a Login Cookie and a Session Cooke Path?

What's that cookie in my browser from?

Thanks,

Laura

#Frontend #Caché

0 5

0 2.3K

Question

Mike Kadow · Jul 18, 2016

How do I execute a "Basic Class Query?"

I have a NewBie Question.

I have been playing around with "Basic CLass Queries."

I have defined a very simple "Basic Class Query." (see below)

However, I cannot find in the I/S documentation how to execute this query.

Any help is appreciated.

#Caché #SQL

0 8

0 2.3K

Question

sansa stark · Oct 17, 2016

Export CSV

Hi All,

We created CSV file in cache.

There was one problem, how we insert "," comma in values.

Thanks,

sansa.

#Beginner #CSV #Object Data Model #Caché

0 8

0 2.3K

Question

Evgeny Shvarov · Jul 8, 2016

Top from the group SQL query in Caché

Hi!
There is interesting question in Stackoverflow.
This query works for MS SQL:

SELECT * 
FROM 
(
    SELECT *, ROW_NUMBER() OVER (PARTITION BY client_id ORDER BY date_updated DESC) AS rn
    FROM client_address
) a
WHERE a.rn = 1

There is one answer there, which solves the task:

#SQL #Caché

2 5

0 2.2K

Question

Jenna Poindexter · May 6, 2016

JSON Representation of a global structure

Hi:

I'm looking for some help with JSON notation for a global structure. I need a way to represent a global structure in JSON where the global structure both has a value at a given node as well as sub-nodes.

#Globals #JSON #Node.js #Caché

0 14

0 2.2K

Question

Eduard Lebedyuk · Jun 23, 2016

How do I compact database?

Long story short, I created some test data, then deleted it. The database (cache.dat) is 67 GB in size (was around 1 GB before tests).

How do I compact that?

#Caché #System Administration

0 4

0 2.2K

Question

Francis Galiegue · May 20, 2016

How to completely scratch a previously existing Caché installation?

Hello!

I am trying to install Caché 2016 on a Debian Jessie machine; so I downloaded the latest release from WRC, OS RHEL x86_64, in tarball format.

I untarred it, then launched cinstall; unfortunately a library was missing. I then elected to kill all the processes (which wasn't easy), remove the two users created, and start again.

#Caché #System Administration

0 6

0 2.2K

Question

Scott Beeson · Feb 12, 2016

Get columns dynamically?

In MSSQL I think you can do something like this:

select *
from HS_IHE_ATNA_Repository.COLUMNS
where TABLE_NAME=&#39;Aggregation&#39;

How can I do this in Cache SQL?

[%msg: < Table 'HS_IHE_ATNA_REPOSITORY.COLUMNS' not found>]

#Beginner #Caché #SQL

0 11

1 2.2K

Question

David Reche · Apr 3, 2016

Best Ensemble Global Buffer Configuration

Usually I recommend to set the global buffer (GB) as large as possible in order to maintain in memory more globals as possible. I don't know if this is a standard recommendation, but I want to discuss what should be the best buffer size for a Ensemble instance that only process messages.

#Globals #Ensemble #System Administration

1 6

0 2K

Question

Simcha Gershon · Nov 8, 2016

ERROR #5034: Invalid status code structure

Did any one encountered such error while saving an object?

What does it mean & how to over come it.

Thanks Simcha

ERROR #5034: Invalid status code structure

#Object Data Model #Caché

0 6

0 2K

Question

Eduard Lebedyuk · Jun 3, 2016

How to detect a character encoding?

Let's say I open a stream/file.

If it's not in UTF8 i need to call $ZCVT, and if it's already in UTF8, then I don't need to call $ZCVT.

Is there any way to determine character encoding for input stream/file?

#Caché

0 4

0 2K

Question

Glenda Anaya · Jun 9, 2016

Ensemble 2015.2.3 - Certificate is not valid for TLS Web client authentication

Hi,

We recently updated Ensemble, on our Unix DEV server , from version 2013.x to 2015.2.3 (Build 855U) and when we test our SSL/TLS configuration we get the following error:

ERROR #729: Certificate /qmd/ens_chldev_1/mgr/SILCert/SILCSSSJR-CER.cer is not valid for TLS Web client authentication .

The certificate was working fine before the update in DEV and it is working fine in our PROD Unix server with Ensemble 2012.x. Any ideas why we are getting this error?

#SOAP #Ensemble

1 5

0 2K

Question

Paul Riker · Jul 18, 2016

HL7 Segment Query

I want to query the cache database for messages where a specific HL7 segment equals a specific value. Does Cache have a pipe to XML or hl7 segment query function?

#Message Search #SQL #Caché

0 3

0 1.9K

Question

Eduard Lebedyuk · Apr 19, 2016

JSON, Cache and Date/Time

I have a Cache classes with %TimeStamp (e.g. 2016-04-18 12:29:11) and %Date (eg. 64027) properties. And I have a javascript client app, which needs full CRUD over this properties.

But in javascript date/time are defined by ISO8601 (e.g. timestamp 2016-04-18T12:29:11Z, date 2016-04-18).

#JavaScript #JSON #Object Data Model #REST API #Frontend #Caché

5 1

0 1.9K

Question

Brian Palmund · Aug 9, 2016

How to get custom HTTP request headers

I cant find any description on how to read custom http request headers in a REST service.

On some occations i want to read http headers passed along when customers uses our REST API or headers added by the CND provider. Does anyone know how to read these http headers?

For example:
cloudflair.com sends a vistors country information along to the server using a customer http header called "CF-IPCountry". We would like to read this information and use it for statistics.

#REST API #Caché

0 3

0 1.8K

Question

Ponnumani Gurusamy · Aug 18, 2016

How to run mac routines from terminal?

I wrote a macro in studio. Its how to run with Terminal.

do macro name ^filename is correct are not

#Caché #Studio #Terminal

0 1

0 1.8K

Question

Rustam Ibragimov · Sep 9, 2016

Trimming...

Hello, guys.

I found one interesting moment in Cache Object Script. It doesn't have(or at least I didn't find) trimming function. By trimming I mean if a string has some whitespaces/tabs/carriage returns from very beginning or/and from very right, this function removes them.

I have found several workaround ways.

1. Using Cache Basic

#Caché #ObjectScript

1 6

0 1.8K

Question

prabakaran a · Dec 27, 2016

Upload and strore the file

Hi all,

How to store the upload file in CSP?

Thanks,

Prabakaran A.

#CSP #Caché

0 6

0 1.8K

Question

Mack Altman · Nov 21, 2016

How do you iterate through SQL in Cache ObjectScript; and across namespaces?

I would like to integrate SQL into our ObjectScript routines in order to illustrate how SQL can be used to minimize development time. However, there are two questions I have.