#Caché

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

By update

AllTop

Question

Mohan Sujay · Nov 9, 2016

access php

Hi,

How to post and get data using php. I'm using a php external url. In the body in parsing the request as xml and when i execute this using fiddler it response the result as xml but when i consume it in classmethod it fails. I don't have a wsdl file how can i work it out?

#Beginner #Object Data Model #SOAP #Caché

0 2

0 434

Question

Mohan Sujay · Nov 7, 2016

web service

hi,

I have created a asp web service and it is hosted in our internal server. How can i consume that web service in cache class method? It is a soap web service with xml input and xml output. It works fine in all the browser.

#Object Data Model #SOAP #Caché

0 3

0 485

Question

Rajath Muthappa · Nov 8, 2016

&SQL in Cache Server Page

Hi,

I am using the &sql () tag to retrieve the value from the Cache DB.

below is the piece of code i am using:

script language="cache" method="retrieveDetail" arguments="pVariable" returntype="%String"
&sql( select columnA,
into :tempVariable1
from TABLE
where COLUMNC = pVariable

quit tempVariable1

i have to return the ColumnA value back to the calling procedure.

can i know how it can be done ? since i am getting an javascript error.

#CSP #Caché

1 4

0 378

Question

Eduard Lebedyuk · Nov 8, 2016

Why my ZEN report displays ok in xml mode but not xlsx excel

I have a following ZEN report:

#Caché #ZEN

0 2

0 367

Question

Ray Hitchins · Nov 7, 2016

Monospace output from Zen

Hi,

I have a problem which i think has a simple solution but which i and others haven't yet cracked. I want to display text output to a text box in monospaced font. At the moment the style sheet is shown below, I have tried various other options such as specifying a specific font such as Courier New. None of the browsers I have tried (Safari, Firefox on OSX, IE) display as monospace, although the last 2 come close. I wonder whether I need a <pre> tag, but I can't see how to do that in Zen.

Suggestions?

#Beginner #Caché

0 1

0 297

Question

Nikita Savchenko · Nov 5, 2016

How to log out from a web application?

Hello!

The question I have today is the next. Suppose I have this simple class describing the REST application:

#Caché #SOAP

0 8

0 1.3K

Question

Nikita Savchenko · Nov 2, 2016

Startup Tag^Routine property for UnknownUser

Hello community!

I am trying to set up Startup Tag^Routine field for the UnknownUser as follows:

And my simple routine is the next:

#Caché #Terminal #Access control #System Administration

2 6

0 703

Question

Laura Cavanaugh · Nov 4, 2016

Convert %ArrayOfDataTypes to array, and back again

Here's an easy one for you; before I spend another hour looking for the answer, how do you convert %ArrayOfDataTypes to an array (that could, say, fit into the %session.Data array, or maybe just some array named info()), and of course back again?

NS>s aodt=##class(%ArrayOfDataTypes).%New()

NS>w aodt.SetAt("lcavanaugh","username")
1
NS>w aodt.SetAt("organization","coolcompany")
1
NS>w ##class(%ArrayOfDataTypes).BuildValueArray(aodt,.array)

<LIST>zBuildValueArray+1^%Library.ArrayOfDataTypes.1

#Object Data Model #ObjectScript #Caché

1 3

0 965

Question

sansa stark · Nov 4, 2016

MakeDirectory

Hi All,
when I ran the Command to make a folder in particular directory its not working in terminal,but when i run the same command in studio output block it create the folder.
Used command:
S cmd="mkdir E:\DIRECTORY"
O cmd:"QR":10
Suggest Please.

#Object Data Model #Caché

0 4

0 541

Question

Tirthankar Bachhar · Oct 27, 2016

How to track the last modified by user name

Hi,

Is there any way to track the 'last modified by' cache user name and datetime of last modification for a class or routine definition [Track Last Code Changes]?

Thanks,

Tirthankar

#Object Data Model #Caché

0 10

0 922

Question

Jenna Poindexter · Oct 5, 2016

Using %Populate and Populate method

Hi-

I have created a class that extends %Persistent and %Populate and have set the various POPSPEC attributes of my properties to control how the properties are populated. However, when I compile the class and try to run the Populate() method it tells me the method isnt defined.

Here is the class definition:

#Object Data Model #Caché

0 2

0 944

Question

Sergio Fernandes · Nov 1, 2016

File size.

Hi everybody,

My name is Sérgio Fernandes and I'm from Brazil.

I need to get the size of file that the user wants to upload in my application.

I'm getting it name with %request.GetMineData("fileName").FileName, but not found it at Ensemble documentation how would i get the size of file.

My version is Ensemble 2013.1.6.950.0 and I'm doing it at csp.

Thaks

#Object Data Model #Caché

0 3

0 746

Question

Sabarinathan M · Nov 3, 2016

cmd command not working on terminal

I try to run the cmd command in the studio terminal, but i am getting the <NOTOPEN> Error.

Even ZF(-1) also not working. Any help, Please!!!

Note: i restart the Cache instance service with full privilege

Code:

Set Path="mkdir E:\Sample\New"

Open Path:"QR":10

Error:<NOTOPEN>

This command working on my PC, but on server throws error.

Many Thanks

#Caché #ObjectScript

0 3

0 1K

Question

Kryštof Matějka · Nov 2, 2016

html beautifier

Hello,

I'm sending http request through %Net.HttpRequest and I have html page in response. Is there any built-in tool for beautify html for printing in terminal?
Thanks.

#Terminal #ObjectScript #HTML #Caché

0 4

0 451

Question

Uri Shmueli · Nov 3, 2016

Simple Arithmetics

Can somebody explain this behaviour of Cache (and many other calculating machine as well) :

WRITE 1/3*12

WRITE 1/3*5

1.666666666666666667

W 1/3*18

5.999999999999999999

W 1/3*21

6.999999999999999999

W 1/3*24

7.999999999999999999

How can we make more occurate caculations in Cache ?

#Caché #ObjectScript

1 2

0 644

Question

sansa stark · Nov 2, 2016

File Creation

Hi All,

     How to create a .xlsx or .xls (Activate.Excel ) file using cache.

Thanks,
Sansa.S

#Caché

0 2

0 436

Question

Evgeny Shvarov · Oct 28, 2016

Max function for the set of parameters

There is an interesting discussion in the Russian forum going.

What is the best solution for the function which returns the max for the set of parameters?

From the listed solutions I like this one:

ClassMethod max(args...) {
  for i=1:1:args {  s max(+$g(args(i))) = i }
  s i="", max=$o(max(i),-1, i) Q $lb(max, i)
}

#ObjectScript #Caché

1 8

0 902

Question

Thomas Chericka · Oct 26, 2016

Source Control dialog box in Cache Studio - pre-Atelier! Cache 2016.1 version and below. Authenticate developer before commit...

Hi,

#Caché #SVN #Development Environment #Studio

0 5

0 459

Question

Christopher de Melim · Oct 31, 2016

Zen Excel Report

Hello Everyone.

Sorry if it is a dumb question, but I'm new.

First: I have to create a Excel MultipleSheet Report. That I'm fine with doing.. but they want me to give every Workbook that is created it's unique reportName, that is generated with the user input on the page. Is it possible to do so?

#Beginner #Caché

0 7

0 522

Question

Ricardo Paiva · Oct 5, 2016

Authorization (OAuth 2.0) failure due to mismatch server name (SSL Cert)

I am using OAuth2 Cache framework, acting as a client to an authorization server. My setup is based on this excellent previous post [Caché Open Authorization Framework (OAuth 2.0) implementation – part 1].

I'm facing ‘Authorization Server Error: Error Processing Response - No match between server name 'googleapis.com' and SSL certificate values google.com…’

It looks like I should set SSLCheckServerIdentity to false but I can’t figure out how. Has anyone had the same issue?

#OAuth2 #Access control #SSL #Caché

0 4

0 1.2K

Question

David Little · Oct 31, 2016

Mounting ECP Application Databases Read Only

Hey guys

We have a need to mount remote databases using ECP, but with the Application servers mounting some of the remote databases as Read Only. The Data servers will keep them R+W as normal.

#Databases #ECP #Access control #Caché

0 2

0 661

Question

Laura Cavanaugh · Nov 1, 2016

LogoutAll

Has anyone ever used the LogoutAll method in the %CSP.Session class successfully? I'm wondering what I need to do to use it.

Thanks,

Laura

#Security #Frontend #CSP #Caché

0 3

0 492

Question

William Proctor · Oct 31, 2016

password encryption

How can we make sure that the Cache userid passwords are encrypted on storage? We want to make sure that the Cache passwords cannot be decrypted - how can we ensure that?

#Caché #Security #Encryption #System Administration

0 6

0 1.5K

Question

Alan Nguyen · Nov 1, 2016

Cache Studio - Find in Files

Hi,

In Cache Studio under the View/Find in Files. Anyone knows how to search multiple words in the string? For example,

In my routines 1, it has "Patient Name Test Name Provider Address Status " and

In my routine 2 , it has "Patient Name Test Name Provider Address "

In my routines 3, it has "Patient Name Address "

When I search, I want to search all the routines, it has the words Provider and Status which I want it returns only routine 1 because it has both words "Provider and Status". Thank you very much for your help.

#Caché

1 1

0 735

Question

Kari Vatjus-Anttila · Oct 31, 2016

Importing XML to a Caché Object

Hi,

I'm new with writing Caché Objectscript so I need some assistance. I have XML which contains information like this:

<?xml version="1.0" encoding="UTF-8"?>
<session>
   <sessionId>124364</sessionId>
   <cabinet>demo</cabinet>
   <eventType>IN</eventType>
   <eventTime>20161006160154</eventTime>
   <login>test</login>
   <loginFirstName>test</loginFirstName>
   <loginLastName>test</loginLastName>
</session>

I have a class representing this object as follows:

#Beginner #XML #Caché

0 2

0 1.3K

Question

Manikandasubramani S · Nov 1, 2016

Ensemble - Namespace does not supported

Hi,
We have been upgrading our application to ensemble 2016.1.1. I have moved my data to a particular namespace which i have created and now in management portal i have been getting an error message "namespace does not support Ensemble". Please give solutions to resolve this issue.

Thanks and regards

#Caché #Namespace #Ensemble #Management Portal

1 2

0 1.4K

Question

Mohan Sujay · Oct 12, 2016

parsing xml to list of object issue

hi,

1. Created a class(test) and added a classmethod(checkdata).

2. Assigned a object with xml.

3. Created a new class for response and initialized in classmethod(checkdata).

4. Created a new class for request parsing with list of object parameter.