#Caché

Just wondering which table holds detail for SQL Gateway Connections.

 System > Configuration > SQL Gateway Connections

Hello all, I created a web service and I am trying to access it using SoapUI but I get this error:

<text>ERROR #5002: Cache error: &lt;PROTECT>zGetMsgClass+3^%SOAP.WebService.1 ^oddCOM("TestWeb.Service.TestWebSoap",85,"P",0,"soapAction","http://127.0.0.1/csp/dev5/Utils.TestWebService.testNow"),h:\dev5\</text>

It appears to be trying to make an entry in the ^oddCOM global, but is getting a PROTECT error. 

I also tried a .NET app where I added the service using the WSDL. In .NET I get "Internal Server Error" so I'm assuming it's the same error.

Any ideas welcome. 

Thanks, Malcolm.

I have a class to track data changes.
As it becomes slower and slower to find last changes I think I need an index.
The 2 classes are just simplified reality.
HowTo ?

and

I'm having trouble with a vb6 application attempting to connect to a Cache 2017 release. It uses the older Cacheobject.dll instead of ActiveX. The application currently works with a 2010 release of Cache. Is Cacheobject.dll supported in later releases?

I looked through documentation and posts and did not find an answer.

Thanks in advance for any response.

Hello,

Is there a way for Class Methods to be called from a CSP page before a user is authenticated, and without any session information?

Thanks!

I've been trying to interoperate with careevoltion using their backend-services.
Spec: http://docs.smarthealthit.org/authorization/backend-services/

This involves creating a JWT (JSON Web Token) that I have been unable to do using %OAuth2.JWT:ObjectToJWT.

I downloaded jwt.pfx and then ran the following openssl commands to create some pem files.

openssl pkcs12 -in jwt.pfx -out file.nokey.pem -nokeys
openssl pkcs12 -in jwt.pfx -out file.withkey.pem

openssl rsa -in file.withkey.pem -out file.key

cat file.nokey.pem file.key > file.combo.pem3

Recently DigitalOcean introduced new plans for droplets, but as existing droplets stayed on the old plans  I decided to use API to resize them automatically.  After reading tutorial, I wrote partial client for DigitalOcean API, which I would like to share today.

After creating a  ClassMethod for a routing rule is it possible to test an HL7 message within Studio rather than using Management portal?  It would make it easier to debug the custom function to see where the rule is failing.

New to Cache and CSP,

Hacking up Sample upload.csp and was wondering if you can get the drive letter and director (on a Windows system) on the file that is picked?

I cannot find anything on MIMEDATA, such as FileName, Size, MemSection, etc that can do this.

Another meothod that can accomplish this?

Hello, I am trying to get the Zen Print Server to work so that i can use the pdfprint mode in Zen Reports. Zen Reports will create pdfs just fine, so that part is working. And the printer works fine from other applications on this computer and I have verified the printer name a bunch of times.

This is Caché 2016.2 on Windows 10. I have tried this using Adobe 11.0 and Adobe DC. I have made and started a Zen Report Print Server with

Name = "ZenPrint"

Port = "4321"

and Ping Port = "4320"

which says it is running. When I run the report with a query string of

how do you substring only the year or month from current date

(I am new to this language) I have got a JSON request to handle in a web application which is in %CSP.Request object. But the request which I am going to handle is of type array of objects.
like,

Hi Guys,

I'm using the below code to Post JSON request to a REST API, but I'm getting "Failed to parse JSON request content." Error,

Hi All,

Background: I have my data in Globals on a Cache instance A and I SQL projected(Added SQL Storage) all my globals as Classes to do SQL Operation.

I am about to start writing my application code in Ensemble(Planning to use Business Service, process and Operation) , Now I wanted to do ECP connection between Ensemble instance and Cache instance to get data from Cache.

Questions

How to do ECP connection between two instances?

Does SQL projection of classes is really required or I can use the globals from Cache server.

Can anyone please share the link to learn the basics of ECP connection.

I'm trying to create an sal connections from one cache system to another. I've created the connection part  and I think that is working. When trying to link a table through the link table wizard, I'm getting an error "<MAXSTRING>zCreateOneLinkTable+52^%CSP.UI.SQL.LinkWizardResultPage1.

Is this due to my global block size in the new system not being large enough? It is currently set at 8192.

Thank you

Mike

Hi I'm new in cache ... How do i get the last date of the every month

Hi -

I'm creating a custom report in Health Insight via SQL and one of the requirements says that I must include patients who are >= 13 years old (which is easy) but I also need to include patients who WILL be 13 years old as of December 31st of current year that the report is ran in.

I see that there is an Age column and an AgeInMonths column in HSAA.Patient. and of course a DOB column. I'm wondering if it is possible to do this purely using SQL (and SQL functions) or if I will have to incorporate a COS function to achieve this requirement.

Any suggestions?

Thanks,

Blake

Hi Guys,

I'm using Ensemble 2014 and have a code that Posts HttpRequest to a REST API and working fine, but don't know how to add Header to my request!?

I tried  Set Request.SetHeader("Source","Civicview") but it's bringing a Syntax error, any help pls?

Hi,

I'm having the following error visualizing a PDF report.

An invalid XML character (Unicode: 0x3) was found in the value of attribute "Reaction" and element is "Allergies".

Aug 18, 2017 10:50:29 AM org.apache.fop.apps.FopFactoryConfigurator configure

INFO: Default page-height set to: 11in

Aug 18, 2017 10:50:29 AM org.apache.fop.apps.FopFactoryConfigurator configure

INFO: Default page-width set to: 8.26in

Aug 18, 2017 10:50:30 AM org.apache.fop.cli.Main startFOP

SEVERE: Exception

Some of our interfaces use globals for lookups, but we are currently looking at putting a groups of (document) interfaces in a separate production with a shared ‘Default Database for Routines’ to reduce code duplication.

Hi Guys,

I've a working that sent Http request to a REST API and is working fine,

Set Body = ##class(%ZEN.proxyObject).%New()Set Body.ElectronicMailAddressT = "ElectronicMailAddressT"Set Body.TelephoneMinimalN = "TelephoneMinimalN"Set Request.ContentType = "application/json"Set Request.Https=1Set Request.SSLConfiguration="TLS"Set Status = ##class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(Request.EntityBody, Body)Set Status = Request.Post(,2)

but now I'm looking to basically add an array or data inside the body so that it looks like this:

Hello

I'm in the process of creating a TestClass which simulate a HTTP POST call to REST-based web services and while I am having success, I'm struggling on how to parse out the results to a JSON format

Here is down the code part which concerns parsing the HttpResponse.Data variable into JSON :

My questions are regarding ClassMethods with a private keyword tags.

When we use a wizard to add a new method, we are given a options to
select private checkbox to make it a private method as well as 
Class Method checkbox in the same time. 

1. What would be the reason and the case to select and use them both?   
2. Secondly, if there is such a case in already developed application is it
safe to remove the private tag from ClassMethod? Obviously if it's not a 
ClassMethod private tag cannot be removed as easily.

Thank you,

Hi,

I want to monitor some variables in my program.

So I do this "zb *varname", however, i don't really want to get break went the program touch "varname" every time.

I only want to get break when certain conditions are meet. For example, $d(varname(1,2,3)) >  0, then break.

Is there any way to achieve this?

Thanks.

Hello everyone,

What has been the best way for you to store and retrieve session information about a user for CSP projects? I can use these methods easily:

CSP Session Management

however I'd like to know if there's a better way to keep more permanent information, or should it all be kept in a class?

Additionally, using whatever method, what would be the best way to block user access to certain portions of the website or entire pages? Such as an admin section. With normal web development this wouldn't be too difficult, but I need help connecting this into CSP terms.

Thank you!

Hi Guys,

Basically I'm looking for a sample what I can send data in aJSON format to a a webservice using an http request pls?

I've found some documentation on %Net.HttpRequest but a sample on how to connect to a Webservice and send data to it would be really helpful?

Our clients are running Cache & Ensemble 2014 

Thanks

Hi,

I installed Cache2015. I went to %SYS namespace and d ^JOBEXAM it shows around 12 background jobs running. Can i know what is the purpose of that jobs?

Thanks, Selvakumar

I use zf(-2) to spawn a external a Java application in a *nix instance.

I would like to kill this process after some conditions met.

I would like to leverage $zf("kill ... ") but this requires its the pid of this child process.

So is there a way to acquire the pid for the child process when I create it ?

If not, how is the suggested way to kill this process?

Thanks.

I could launch a external process via $zf(-2).

However, this child process need to refer some shared libraries in RUNTIME,so I have to set up the proper paths to the environment variable LD_LIBRARY_PATH, is anyone know how to do this?

Thank for your help.