#Caché

Hi. I am learning create Rest service  with Cache. From this repo. https://github.com/intersystems-ru/REST

I created new web application from Web Applications  section in Management Portal. Such as screenshot.  In browser  call http://127.0.0.1:57772/rest/test . But got  "Service Unavailable" 503 response.  Could you please help?

This might be more of a math problem than a Caché question.
I have a SQL query that joins two tables. I want to assign a unique ID to each row of the product table.

1. I could append the GUIDs of the rows in the two tables, but there are a number of clients that expect a maximum length of 50 on this unique ID. Two GUIDs appended make 72 characters.
2. I could append the two GUIDs and then truncate the result, but now I'm worried about collision.

What's the chance of collision if I append the GUIDs and truncate the result to 50 characters? Is there a good way to solve this without updating the clients?

I am trying to write an application that will take some information on the database make a call to the Google API distance matrix and get the information to use with rest of the application without using the ensemble part of the development is this possible and how can I do my communication with the  API from a cache class thanks in  advance

We have noticed in the course of the last 18 days our CACHE.dat has grown by 20 GB. Is there a way we can break down the data in CACHE.dat to see what could be growing in size?

Let me state it another way.....Is there a way to see what space an Operation/Service/Process is taking up within a certain Production?

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

As I was going though and trying to figure out why our CACHE.dat has increased in size over the past 18 days, I found that EnsLib_HL7.Message is still retaining messages dating back to 2014 even though we have our purge set to 10 days. Has anyone else experienced this?

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

Hello,

I have a property which I need to move from one class definition to another as follows:

Old definition:

Class SCHED.SchedEntry
{
  
  Property Experiment as %String;

  Property ScanSlot as list of TracerEntry;

}

Class SCHED.TracerEntry
{
  
  Property Tracer As %String

}

I want to move the Experiment property to the TracerEntry class so that there is a different Experiment allowed for each ScanSlot, like this:

Class SCHED.SchedEntry 
{

  Property ScanSlot as list of TracerEntry;

}

Class SCHED.TracerEntry 
{

  Property Tracer As %String;

  Property Experiment

Looking at the documentation expalining the use of client side menus, including the drop down menu.

I was messing around trying to get the "Open", once clicked, to use javascript to open windows file explorer to open/pick a file.

I've got it to partially work... Using keystrokes Ctrl-O will open the file explorer yet clicking on the drop down's File/Open does nothing.

Not sure what I'm doing wrong here.

NOTE:  I had commented out the two &html lines in the Testing Method... and doing a Ctrl-O still work.

Why?

/// Created using the page template: DefaultClass PublisherDB.NewClass1 Extends %ZEN.Co

In part of this post in 2016 @Eduard Lebedyuk asked if anyone knew what is meant by an "expanded class", as referred to in the text that appears when we run the ShowQualifiers classmethod of %SYSTEM.OBJ thus:

SAMPLES>DO $system.OBJ.ShowQualifiers()
...
            Name: /checkuptodate
    Description: Skip classes or expanded classes that are up-to-date.

We will be transitioning from a server running HP OpenVMS to one running RHEL 7. The main question some of the team had was what would be the best method for moving the globals to the new system.

Also, I was wondering if any others have transitioned from OpenVMS to RHEL. If so, were there any kinks that we should be aware of prior to transition?

Does anyone know where the default port comes from when installing a new instance on Windows Server 2012 R2?

It constantly picks up the wrong default which is already running on the server (probably swapped over after installation)  and the install fails and rolls back.

I installed again and this time without rollback but still allocated the wrong port so at least was able to manually update the cpf and then start the instance.

Would like a simpler solution to the issue and assume they are traversing some windows registry entry that may need updating.

Hi community ,

i use postman for testing my request , i need to extract access token from it (i put it inside the "Get url" using post man before sending my request).

i use the GetAccessTokenFromRequest of (%SYS.OAuth2.AccessToken) class , but in my rest code party , when i send request from post man , i can't extract my access token, it's empty.

can please give me help?

thank you

I have a query would run very long time and I get always timeout error from SMP.

Thank for your help.

Hello to all my fellow Cache Developers/Experts: 

My question has to do with how I would go about changing the image file size when loading (saving) an image file (i.e. JPG, BMP, GIF, PNG, etc...) to a Cache Database Table. 

Here is my business scenario: 

• The user will save various image files (could be different types, such as JPG, PNG, BMP, GIF) to an operating system directory. 
• Then our application has a background job that monitors the image directory and will load (save) the image into a Cache Database Table into a property of data type %Stream.GlobalBinary. 
• Then when a client report is

Hi,

My doubt is about the SQL Query in Caché:

I don't want to take all results from the table and orgainze them manually, for example: I have a table with 50 records, but I only want to select 10 records, being from tenth until the twentieth and this without knowing their IDs.

So, how can I do this, without losing performance, there is any way?

NOTE: In other SQL languages I can do, for example, SELECT * FROM extbl Limit 10 OFFSET 10

Thanks,

Andrei L. Nenevê

Hi

Is it possible to include the ≥ or ≤ in a ZEN select component?  i.e. 

<select id="condition" label="Condition" valueList="&lt;,&gt;,=,≤,≥" displayList="&lt;,&gt;,=,≤,≥"/>

I have tried ≥ and ≤ but these also do not work.  If I inspect the options in the browser and edit with these characters they display correctly but just not when loaded in the zen page.

Cheers

Iain

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

I then ran some node code to create the private

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

"?$MODE=pdfprint&$PRINTSERVER=4321&$PRINTTIME

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,

[
  {
    "Name": "bat"
  },
  {
    "Name": "Cat"
  },
  {
    "Name": "rat"
  },
  {
    "Name": "mat"
  },
  {
    "Name": "hat"
  },
  {
    "Name": "chat"
  },
  {
    "Name": "please"
  },
  {
    "Name": "help"
  },
  {
    "Name": "me"
  },
  {
    "Name": "in"
  },
  {
    "Name": "getting"
  },
  {
    "Name": "the"
  },
  {
    "Name": "value"
  },
  {

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,

 ​Set Body = ##class(%ZEN.proxyObject).%New()Set Body.ElectronicMailAddressT = "ElectronicMailAddressT"Set Body.TelephoneMinimalN = "TelephoneMinimalN"Set Body.AustralianBusinessNumberId = "AustralianBusinessNumberId"Set Body.OrganisationDetailsOrganisationBranchC = "OrganisationDetailsOrganisationBranchC"Set Body.DetailsOrganisationalNameT = "DetailsOrganisationalNameT"Set Body.PersonUnstructuredNameFullNameT = "PersonUnstructuredNameFullNameT"

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