I am trying to fetch the data from cache database. But i got the error like "CSP application closed the connection before sending a responce".

Below is the query.

SELECT
CallbackComment
FROM SQ.CBPhoneResult_View Where PhoneDateODBC = '2018-04-09'

I have investigated and found that "CallbackComment" contains the special character single quotes " ' "  for one result and due to this i got this error.

In this field data is enter by customer. so we cannot restrict them like Do Not use single quotes.

Please provide some solution as soon as possible.

Thanks in advance. 

Hello everyone,
what does it mean: <INVALID OREF>zgetFile+8^User.Read.1
(getFile is my ClassMethod and Read.cls is my class)?
I just try to read/load a file.

In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:

• Git 101
• Git flow (development process)
• GitLab installation
• GitLab Workflow
• Continuous Delivery
• GitLab installation and configuration
• GitLab CI/CD
• Why containers?
• Containers infrastructure
• CD using containers
• CD using ICM

In this article, we'll build Continuous Delivery with InterSystems Cloud Manager. ICM is a cloud provisioning and deployment solution for applications based on InterSystems IRIS. It allows you to define the desired deployment configuration and ICM would provision it automatically. For more information take a look at First Look: ICM.

Hi Everybody!

We are pleased to invite you to the upcoming webinar "Sharding as the basis of Scaling in InterSystems IRIS Data Platform" on 24th of July at 10:00 (Moscow time)!

Hi everyone.

I have a cube with two dimensions, DimA and DimB, with the following structure:

DimA/H1/LevelA

DimA/H1/LevelC

DimB/H1/LevelB

DimB/H1/LevelC

LevelC is modeled in such way because its bound property (C) is group by properties A and B in transactional database, but A and B haven't relation.

I can use DeepSee REST API service /Info/FilterMembers/:datasource/:filterSpec specifying each dimension one filterSpec parameter and handle the results.

But, I would like to have the results for both dimension in only on service call.

Is that possible?

Lost the raid array on our server. We were able to recovery all the data from backup but now are running into road blocks getting the Cache database up and running. We are running version 5.0.7 which is quite old but works for our needs. Our most current road block it is getting CTTerm (Telnet) to connect with the database. After entering the user and password nothing happens beside the carriage return dropping down one more line in CTTerm.  If you are familiar with the older revs of Cache please feel free to contact me or provide input.  Any help or direction would be invaluable to us.

Hi, Community!

Here is the July and I'm pleased to update with new features on DC appeared with July release.

What's new? Bookmarks, better group/tag subscriptions, new filters and cosmetic fixes. See the details below.

Im using below code to display page number. But i only display as 1,2..etc. I need to display it as I,II,III..etc...

special="page-number"

Hello everyone

I have a problem with $ ZF (-1)

I need to delete file from windows folder example c: \ sys \ text.txt, when executing the w $ zf (-1, "c: \ sys \ text.txt") command, the file does not delete.
There is some other cache command that performs this task.

hugs

Davidson

Hi, I found some issues with $ZF(-100) whilst replacing our old $ZF(-1) calls following the security alert. They're easy enough to work around, just figured it might be useful to someone :)

There seems to be some inconsistency with how $ZF(-100) is functioning between Unix and Win, contrary to the documentation. For example, for a simple ‘output directory listing to file’  operation:

Windows:

set dev="dir.txt"

set com="dir"

set options(1)=""

set options(2)="e:\nbupg\webserver\"

w $ZF(-100,"/SHELL /STDERR=""NUL"" /STDOUT="_dev,com,.

I am trying to write a generic process that will take any incoming message but would like to know where it came from so in my code I would like to do something like this

If (Document.Source="some serviceorProcess").

Just to be clear in the route you get these features is there a way of accessing them in code

Often, the first time I start up Eclipse (Atelier plug-in), all of my local classes indicate "warning" as if they are out-of-sync. When I  try to synchronize, I get the following error:

Synchronization failed: [server is broken] java.lang.ClassNotFoundException: Provider org.glassfish.jersey.internal.RuntimeDelegateImpl could not be instantiated: java.lang.IllegalStateException: No generator was provided and there is no default generator registered

The only way to correct this is to shut down Eclipse and restart. Is there a resolution for this?

Hi,

When i try to configure my server connection in Atelier (Eclipse), i am getting the below exception.

java.lang.ClassNotFoundException: Provider org.glassfish.jersey.internal.RuntimeDelegateImpl could not be instantiated: java.lang.IllegalStateException: No generator was provided and there is no default generator registered

It was all working fine and i think that the only thing which i have done was installing some windows updates. Now when i try to configure the server configuration i started getting the above error, any suggestions to fix this?

Thanks,

Shameer 

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

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.

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.

Let's start with our (very basic) Persistent class for Widgets.  We have 4 properties to hold Name, Description, Price and current Quantity.

Hi everyone,

I am still learning the platform for a student project and have to do some streaming and data analysis next. Since for my case I have no "live api" I wanted to just stream json files and output the data as it comes in from the files. (basically to emulate a incoming data scenario)

So thanks to the documentation and community posts I have figured how to create a stream and read data from a JSON but since I'm also new to JSON I have some parsing problems. I don't know how to access subarrays/sub-objects via objectscript.

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!

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.

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!

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.

I am getting this error.

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

Hi guys,

I'm helping our client to pass a Chinese CHIMA FHIR certification, which requires to search  encounter by subject(Patient) name.

I noticed that in FHIR specification, chained parameters were included, as below:

2.21.1.4.13 Chained parameters 

In order to save a client from performing a series of search operations, reference parameters may be "chained" by appending them with a period (.) followed by the name of a search parameter defined for the target resource. This can be done recursively, following a logical path through a graph of related resources, separated by .

Hi Community!

Please welcome a new session recording from Global Summit 2017:

We Want More! - Solving Scalability

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?

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.

I found OnClose and OnTearDown events.

Can anybody give me a correct example to kill process started by JOB command?

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ópez, Posts,  147

Eduard Lebedyuk, Posts,  73

Daniel Kutac, Posts,  45

Pete Greskoff, Posts,  34

Top 10 Experts to Follow

Nicole Aaron, Answers,  +11

Robert Cemper, Answers,  +10

Eduard Lebedyuk, Answers,  +9

Vitaliy Serdtsev, Answers,  +7

Benjamin Spead, Answers,  +4

Francisco López, Answers,  +4

Evgeny Shvarov, Answers,  +3

Dmitry Maslennikov, Answers,  +3

Gilberto Junior, Answers,  +3

Timothy Leavitt, Answers,  +2