Question Dineshkumar Muniyasamy · Jun 20, 2018

Hi All,

On button click from my zen page am calling the $System.SQL.ShowPlan() to calculate the cost of the SQL query.

In Cache` 2016.2 I faced a problem , when the logged in user didn't have the %development resource(<PROTECT> error).

But in Cache` 2017.2 it's working without the %development resource.

Is there any changes done on this area in the versions above 2016.2.

Thanks,

Dinesh

2
0 344
Question CM Wang · Aug 16, 2017

I try to run below two statements

Set tRS = ##class(%ResultSet).%New("%Dictionary.ClassDefinition:SubclassOf")
​set tSC = tRS.Execute("%Persistent")

and I always get <PROTECT>check+5^%Dictionary.ClassDefinitionQuery.1

The login user is _SYSTEM and should have all the permissions.

I cannot run queries in the $SYSTEM.SQL.Shell(). I would get <PROTECT>%GenerateMetadata+16^%SQL.StatementMetadata.1

However, when I run the query through SMP, everything is fine.

Any idea where could I start to investigate ?

Thanks.

5
0 3194
Article Chris Stewart · Apr 21, 2017 3m read

or "Didn't you say you would cover Persistent Objects in Part 5, Chris?"

Yes, that was the plan.  This is a pretty important topic, so it get's its own Article

Up until now, we've display widget JSON that has been created by a basic loop.  Clearly this isn't of much value.  Now we have our stack connected together, and we can see that the data is flowing to the Welcome page, it's time to complete the stack and start feeding our service from "real" data.

4
0 1675
Question Shavkat Shamukhamedov · Aug 2, 2016

I cannot connect to Cache from node.js  

I have installed in Windows 10 the following: CACHE 2016, node.js v 4.4.7 and  express .

-  where can I get cache.node? The link in the Intersystmes documentation  http://globalsdb.org/downloads/  doesn't work. I found cache0100.node and cache0120.node  in my Cache instance's  \bin directory. But I am not sure if I can use them or not.

 - how to install cache.node ? Where do I place it exactly? 

Can anyone recommend any tutorial or code example with installation instructions?

Thank you!

12
1 3642
Question Minsu Kim · Jul 4, 2018

Hello Global masters,

I have some question about How can I connect C# to Cache Object without VisM?

I am always using VisM when I want to connect C# to Cache Object becouse I learn it from my co-worker .

but When I asked something in here about Cache Object and someone worte "don't use VisM because it is old thing" like that.

So I want to know about that

Thank you

Minsu.

1
0 418
Question Maryanne Martin · Jul 3, 2018

New to Cache/Studio. Just installed Client option for Cache (cube).

Attempting login to Management Portal for dev/tst/prd environments yields ERROR #822.

Any suggestions on where to begin to resolve would be appreciated.

Thanks!

4
0 2772
InterSystems Official Steve Brunner · Jul 3, 2018

InterSystems is pleased to announce the availability of Caché and Ensemble 2017.2.2

There are many corrections in these releases.  Please find a full list of the corrections in the release notes.

The version number of the kits is 2017.2.2.865.0.

The list of platforms is the same as for 2017.2.1.  For complete platform details please refer to the 2017.2 Supported Platforms document.

HealthShare Health Connect based on Ensemble 2017.2.2 is not yet available, but will be announced soon.

0
0 856
Question Paster-Bachar Gadi · Jun 28, 2018

Hi DC,

I'm looking for some creative outside-the-box thinking and gaudiness.
I have a device that send its data in UDP Multicast.

I need to parse this data and send it to an outside SQL table (sql outbound adapter)
I planned on a udp inbound adapter but apparently it is not operable.

Can anyone direct me to a thought on how to grab the data and send it to my future process?

I have thoughts on scripts that capture the data to file and then I will use the file inbound adapter, or maybe in some way, forward the UDP, packet to a TCP one (don’t know if possible)  and then use the TCP inbound adapter…

3
0 512
Question Stephen Wilson · Aug 8, 2017

I came across this behaviour when debugging some Cache ObjectScript code.  I have provided a simple example below.

Example 1:

START
 ZBREAK /TRACE:ON:"C:/temp/zbreak_trace.log"
 ZBREAK *VAR1:"T"
 ZBREAK *VAR2:"T"
 ZBREAK *VAR3:"T"
 Set (VAR1,VAR2,VAR3)=""
 Kill VAR1,VAR2,VAR3
 Quit

Trace Output:

Trace: ZBREAK SET VAR3="" at START+5^TRACE

Trace: ZBREAK KILL VAR1 at START+6^TRACE

Trace: ZBREAK KILL VAR2 at START+6^TRACE

Trace: ZBREAK KILL VAR3 at START+6^TRACE

$ZV value:

Cache for Windows (x86-32) 2017.1 (Build 792) Mon Mar 20 2017 20:20:07 EDT
3
1 419
Question Christopher Henson · Jul 2, 2018

I am working on a TrakCare JIRA issue that requires accessing class properties in a different installation of TrakCare on another machine. For instance, I need to compare the deprecated items in the current version of TrakCare to the deprecated items in a previous release. Is there anything in the built in classes that will allow me to do this, or  is it something I'll need to do with a SQL stored procedure or something else I haven't thought of?

2
0 358
Question Antonio Garcia Martinez · Jul 2, 2018

Hi,

I was wondering if there is any information about the events I can use when using a business service. I am using "OnProcessInput" event to define the logic of my script but I would need to run a different script when finished. I guess it would be easier to understand if I provide more information. My business service just calls a store procedure to receive messages from a database. Once there are no messages received I need to run a different query but I cannot find any option to determine when the last message has been received.

1
0 360
Announcement Evgeny Shvarov · Jul 2, 2018

Hi, Community!

This post is a digest of the Developer Community postings in June 2018.

Most viewed

Atelier 1.2 Stable Release  230

InterSystems IRIS Data Platform 2018.1.1 Release  199

"IF THEN - $SELECT - $CASE" - What is the best way?  179

$CASE For Long Stories  148

Translate a number to text  147

Sort ordering  141

Extending method keywords  138

Stop Storing Atelier Credentials  133

COMANDO $ZF  130

Multi Language Sort  125

Most voted

Atelier 1.2 Stable Release  7

Translate a number to text  7

InterSystems IRIS Data Platform 2018.1.1 Release  6

Multi Language Sort  5

InterSystems on DeveloperWeek NYC, June 18-20  5

Atelier at EclipseCon France 2018  4

Installation Manifest - I can disabled the journal globals by the XML?  3

Creating SSL-Enabled Mirror on InterSystems IRIS Using Public Key Infrastructure (PKI)  3

One simple Docker trick to halve your image build time  2

DC June 2018 Release  2

Most commented

Communication link failure trying to access Studio  15

$CASE For Long Stories  14

How to convert page number to roman numeral in ZEN Report?  14

Extending method keywords  13

How to navigate to parent of Serial Object?  12

Kill process started by JOB  11

Custom file pass through Operation writing out unreadable pdf files  11

Has anyone tried REST API Put Or Post on AWS S3 ?  10

%ProcessError+6 ^%Net.Remote.Proxy.1 error occurs inconsistently  10

How to Update Caché User Full Name field via SQL?  9

Top 10 Authors to Follow by Views

Francisco LópezPosts,  147

Eduard LebedyukPosts,  73

Daniel KutacPosts,  45

Pete GreskoffPosts,  34

Top 10 Experts to Follow

Nicole AaronAnswers,  +11

Robert CemperAnswers,  +10

Eduard LebedyukAnswers,  +9

Vitaliy SerdtsevAnswers,  +7

Benjamin SpeadAnswers,  +4

Francisco LópezAnswers,  +4

Evgeny ShvarovAnswers,  +3

Dmitry MaslennikovAnswers,  +3

Gilberto JuniorAnswers,  +3

Timothy LeavittAnswers,  +2

0
0 222
Question José Pereira · Jun 29, 2018

Hi.

I would like to know if DeepSee has some feature regarding synchronization which could help me with this:

I have two tables, TableA and TableB in a 1:n relationship, and one cube for each table, CubeA and CubeB.
CubeA have a list dimension based on records from TableB.
Both tables has DSTIME parameter set to "AUTO".

Some application proccess updates data only on TableB, leading an entry on ^OBJ.DSTIME global for synchronization of CubeB.
However, as the TableA wasn't updated, there isn't such entry for CubeA.

Thus, filtering on CubeA dimension which depends on records from TableB is affected.

2
1 293
Question Ewan Whyte · Jun 29, 2018

I'm trying to add an Operation to store DICOM files but each time I add a Operation using the class EnsLib.DICOM.Operation.TCP it reverts into Services and I cannot work out why this is happening. I've tried following the guide online (link at the bottom) but the Operation still reverts to a Service.

Any pointers would be appreciated,

Thank you.

https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…

1
0 390
Question Thembelani Mlalazi · Jun 22, 2018

I have a service that takes a file and pass it through to the production .While I am passing the file through I get the file stream and set it to a variable within my message and the variable is of type %Ens.StreamContainer. But after all processing and I need to write out my file to a pdf format The file gets written but is a corrupt file since I can not read it I have tried this with asimple pass through everything is fine .But here I do not know what I am doing wrong here is the operation code

11
0 994
Question Rodrigo Flores · Jun 28, 2018

Hi,


is there way when select a value in filter column and the second column filter use only value referred to the first selection??

we use to active filter to column in table, but not know how relationship the filter between columns of table.

only in the table context in zen page.

1
0 357
Question CM Wang · Jun 27, 2018

I am trying to read some binary data from a local file or through socket.

The binary data is like H.264 codec, I need to read data BYTE by BYTE (even BIT by BIT) and decide the next step based on the data read so far.

I check the documentation and it seems like most of the sample focus on human readable IO, ie: LINE by LINE.

Could I achieve my goal through COS?

Thanks. 

3
0 1491
Question David Crawford · Jun 18, 2018

I thought I should be able to go to the application error log or look at d ^%ER when I get the following error in the browser when troubleshooting a CSP page:

An error occurred with the CSP application and has been logged to system error log (^ERRORS)

However nothing is being generated in these logs. Where are these logs being made?

Thank you

9
1 2561
Question Virginia Rogers · Jun 26, 2018

Hello,

I need to add a new property ("Injection") to an existing database.  The existing database contains, in part:

An "ImageStudy" which contains one or more "ImageFiles"  defined as follows:

Class PET.ImageStudy Extends (%Persistent) 
{
Relationship ImageFiles as PET.ImageFile [cardinality=children,inverse=Study]
...
}
Class PET.ImageFile Extends (%Persistent)
Relationship Study as PET.ImageStudy [cardinality=parent,inverse=ImagFiles]
...
}
7
0 592
Question Mike Dawson · Jun 26, 2018

I have a class thus:-

Class RMH.ClinDoc.Response.GetEPRDisplayResponse Extends Ens.Response [ProcedureBlock]

{

Property GetEPRDisplayResult As %XML.String;

}

The property GetEPRDisplayResult  contains  html content.

When I write out the property in a terminal,  all the html special character content is encoded e.g. '<' is &lt;  '>' is &gt ; etc....

I want to display this html in a browser and have it render as normal.

So my question is how to I store html content in a cache object such that it renders correctly in a browser?

3
0 826
Question Eduard Lebedyuk · Jun 25, 2018

I have this local, containing a list of books of arbitrary length:

set books=2
set books(1, "author") = "Alice"
set books(1, "title") = "Hello"
set books(1, "pages") = "123"
set books(2, "author") = "Bob"
set books(2, "title") = "World"
set books(2, "pages") = "456"

And I want to generate this PDF (there could be more than two tables), each book is a separate table:

The header is always the same (Author, Title, Page) but the number of tables would be different.

ZEN reports sounds relevant, but I'm not sure how to pass data from local there and how to draw a separate table for each result.

3
0 973
Question Mack Altman · Jun 25, 2018

Typically, I have time to review the documentation, which I'm sure is here. However, I have a workaround (TEST1) but I was wondering if anyone could assist me in advising how I would need to adapt the curly brace snippet (TEST2) to provide the same result.

Thanks for any help you can provide.

TEST1(STATUS=1) K (STATUS)X "S MSG=$S(STATUS:""HELLO"", 1:""GOODBYE"")"W !,MSGQTEST2(STATUS=1) PUBLIC {X "S MSG=$S(STATUS:""HELLO"", 1:""GOODBYE"")"W !,MSG}
3
0 386