I'm trying to learn how To use SQL in CACHE, so I hope I don't bore you with "Dumb" questions.... 

I'm getting "ERROR #6022: Gateway failed" message following this line of code. 

s sc=gc.Prepare(hstmt,pQuery) 

This line of code comes from an example I found in the documentation.  pQuery is the "Select" statement setting up the variables and tables I'm trying to pull information from. 

What does that error indicate? 

Thank you. 

Hi, Community!

We have a new release of Developer Community here!

What's new?

Better subscriptions, new notifications on answers, better performance, better member mentioning and public task tracker for DC.

See the details inside!

Hi-

Does anyone have an example of manipulating Zen tablePane columns programmatically?

Specifically, clearing out the columns and adding a new set of columns.

It would be helpful if you had both a server side and client side example.

Thanks

Documentation here lists the kinds of members a class definition may contain. In summary:

• Parameters
• Methods
• Properties
• Class queries
• XData blocks
• Projections
• (and some that are relevant only for persistent classes):
  • Storage definitions
  • Indices
  • Foreign keys
  • SQL triggers

Later in the same document, a section headed "Class Member Names" contains this warning:

So I'm interested to hear how other DC members handle this.

1. Do you comply (or at least attempt to comply) with this?
2. If so, do you use any tools or naming conventions to assist you?
3. Have you ever encountered "unexpected results" that were caused by a failu

I am working through trying to use ZAUTHENTICATE.mac and LDAP.mac to do Delegated sign on into Ensemble. In reading over the samples and the documentation, I am not clearly finding on how to set the Appropriate Role from the LDAP group I return. Can someone help explain this part to me? If I have a user sign on, and I return a "Group" from the Authentication, how do I get that to transform into the Role I need for Ensemble.

Thanks

Scott Roth

Cache for Windows (x86-64) 2015.1 (Build 429U) Fri Feb 13 2015 14:37:23 EST [HealthShare Modules:Core:12.07.3703 + Linkage Engine:13.04.3703]

Use case: Search an LDAP database from Caché over TLS using Mutual Authentication.

Extract from the %SYS.LDAP documentation:

Hi community ,

i work actually on the access token generation method , i want know where the generated access token are saved ?

My [OAuth2.AccessToken]  tabe is empty , it's logical?

thank's for helping .

Best regards

Hi, Community!

There would be a webinar in two days by analysts Steve Duplessie and Mike Leone from Enterprise Strategy Group and Joe Lichtenberg, director of marketing for Data Platforms at InterSystems. They will present their recent research on operational and analytics workloads on a unified data platform and discuss the top database deployments and infrastructure challenges that organizations are struggling with, including managing data growth and database size and meeting database performance requirements. And Joe Lichtenberg will introduce attendees to the company’s latest product, InterSystems IRIS Data Platform. Join!

Building Smarter, Faster, and Scalable Data-Rich Applications for Businesses that Operate in Real-Time

​

Hi Guys,

I would to know, I have a drop down list items in my applications. While, am clicking on the drop down bx, there are few numbers of listed items, while am doing mouse over action, I should display the entire text of selected item from that drop down list box, even am not selecting that item. I would like to know about the what is exact text it contains in Zen framework. 

If any lead would be appreciated. 

Thank you in advance. 

New Windows 10 Cache [ TRYCACHE] successfully installed - but unable to log onto the Management Portal . What "User Name" and "Password" are being asked for? No opportunity to specify the sources. Thanks.

Hi,

Is it possible to Save a base64 data string, representing a png, as a binary png file, In Cache?

When I search google , in general , not Cache specifically,  I see such articles:

https://stackoverflow.com/questions/11511511/how-to-save-a-png-image-se…

and this answer:

You need to extract the base64 image data from that string, decode it and then you can save it to disk, you don't need GD since it already is a png.

But I don't know how to implement that in Cache.

Regards,

Nael

I tried to learn DEEP SEE Analytics for our HealthShare "SAMPLES" Name Space. I followed our documentation and tried it. But my management portal analyzer and visual reporting fields are hidden. So Please help me for how do I use the deep see concepts and  provide some examples or demo.

Thanks ,

Ponnumani G.

Hi, 

Does HealthShare include functionality to inspect packets to and from the system?

If not, what tools do you use to do this when debugging interface issues?

A colleague suggested 'Wireshark', but I've not used it.

Kind regards, 

Stephen

Hi,

      Has anybody used /epic/prd/bin/runlevel with different options to bring up or shutdown the cache db. I cannot see any information about it in the manual.

Regards,

Anil

Hi, I am trying to execute a store procedure within an ensemble operation to connect to aMsSQL database and I am having problem to pass the input arguments... I have tried several things but only one seems to work and it is not the ideal solution.

This is the code that works...as you can see the parameter is added to the sql query...not the best solution but the only that works at the moment.

I have tried to call a store procedure that d

Hi All,

Does anybody has experience with Angular application and have implemented some solution in order to track and record pageviews?

We are interested in to know how to capture those pageviews information and call a Caché REST Api in order to store those data.

Thanks.

Hi, Community! 

Please welcome a new session recording from Global Summit 2017:

Migrating Apps to the Cloud : The Basics

I am trying to determine the write-access to a windows-directory, using the method %File.Writeable(). But, this method always returns the boolean "true", even when I have revoked the write-access of Healthshare-user in this directory.

Note:

1. When the same ensemble-service tries to write a file in this directory (which it says is "writeable"), it fails.
2. The method %File.Writeable(...) works perfectly in the case of files.

Any help is appreciated. Thanks in advance... :-)

Hi All,
      I need to route a file based on its type in Ensemble Production. But I don't want to write a Business Process code to achieve this. Am using FilePassThroughService to get a file.
     There are two FilePassthrough operations for different type of files. Is there anyway to achieve this using Business Process Rule itself?
      Also how to get the filename in Business Process Rule that comes from FilePassThroughService?

    Thanks in advance.

My question is actually about IDKEY since Primary Key is the common concept of SQL.

Why do we need IDKEY? In what kind of scenario, the IDKEY would be different from Primary Key?

Thanks.

Hi, 

I would like to set the report headerHeight dynamically based on a group records count.

Example:

If GroupA has 5 records then the headerHeight should be 50mm

If GroupA has 3 records then the headerHeight should be 30mm

Could you please advice the best approach to achieve this?

Thank you,

Rui

I would need to build a Complex Record Map and then transform that into xml. But not the whole batch to one xml file - instead every repetition in that Complex Record Map would become one xml file. 

For Simple Record Maps this is easy to do because there are different types of Business Services that handle every record either individually or all of them as one batch but there doesn't seem to be similar options for Complex Record Maps? Instead, there is only batchtype business services.

Why is that? And what would be the best approach to transforming complex record map to several xml documents?

Is there an API that would list classes within a given package? I can't find any. I do have a workaround that uses class index, but this query lists all classes available in the namespace and I have to filter those I want. But this is just unnecessary overhead.

If anyone has spotted such API, please let me know.

TIA!

Dan

Hello,

I am using CSP:search and would like to customize the appearance of pop-up search page with CSS.  Any help is appreciated.

Thanks.

Dave

There is an option in Studio (Environment-Advanced) to "Automatically reload documents when it has changed on the server and it has not been edited in Studio".  I want this flag on but every time the re-load happens it adds a blank line at the bottom of the routine.  Is there any way to stop that from happening?

Thanks.

Zen report can create PDF document (https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GRPT_xslfo_pdf_config ). Store your images in the table. Pass session id to the Zen report. Zen report will select images using SQL. The <img> element will insert images to the report:

<img width="100%" src="!@ImageName" contentHeight="scale-to-fit" contentWidth="#(..ImageWidth)#" style="position:absolute" content-type="image/jpg"/> 

Do the following (See the attachment image_to_pdf_using_zen_reports.doc for details):

1. Zen report settings to configure PDF report 
2. Create an image t

Currently to check if the class  is mapped I call:

ClassMethod IsClassMapped(class) As %Boolean

{
  set sc = $system.OBJ.GetClassList(.classes,"/system=0 /percent=0 /mapped=0")
  quit $data(classes(class))
}

And it works, but I'm interested if there is a simpler approach out there?

Hi

I am fairly new to Ensemble development.

I was wondering what is the best process of returning the resultset from a SQL outbound adapter to the BPL that had invoked it.

Thank you for your help.

Kind Regards,

Salma

We had multiple failures because of disk space on cache . IS there a script or tool to monitor disk space used by cache which can used by say patrol and  alert us. Thanks for your help in advance. I am looking for something to work on AIX