Hello,

I'm having a problem with %SQL.Statement.

I have a ClassMethod on Cache that I'm trying to access via - this.db.invoke_classmethod.

When I get to my %Prepare I get a <DYNAMIC LIBRARY LOAD> error. Upon checking cconsole.log I find the following...

05/25/17-09:45:35:224 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:45:35:224 (9876) 2 zlib unavailable
05/25/17-09:58:12:507 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:12:507 (9876) 2 zlib unavailable
05/25/17-09:58:12:585 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:12:585 (9876) 2 zlib unavailable
05/25/17-09:58:12:616 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:12:616 (9876) 2 zlib unavailable
05/25/17-09:58:23:663 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:23:663 (9876) 2 zlib unavailable
05/25/17-09:58:23:679 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:23:679 (9876) 2 zlib unavailable
05/25/17-09:58:23:741 (9876) 2 Error loading zlib1.dll: 126
05/25/17-09:58:23:741 (9876) 2 zlib unavailable

InterSystems is pleased to announce the availability of the following maintenance releases:

• Caché and Ensemble 2017.1.1
• HealthShare Health Connect v15.021 on core technology 2017.1.1

Caché and Ensemble are available on the same platforms as 2017.1.0, except as noted below

• The full list of corrections can be found in the release notes.
• The version number of the kits for these releases is 2017.1.1.111.0
• Oracle Solaris 10, 11 for SPARC-64 and Oracle Solaris 10, 11 for x86-64 are not yet approved.

HealthShare HealthConnect v15.021 on core technology 2017.1.1.111.

In my previous article, I gave an example of how to get the own image with InterSystems Caché. Now it's time to launch a project with container.

Check the new video on Developer Community YouTube Channel:

Mirroring - Architecting for Throughput 

In this video, learn how to provide high availability (HA) and disaster recovery (DR) in diverse architectures that demand high performance, including replication over long distances.

Enjoy!

Hi!

I'm saving object instance using RestForms.

RESTFormsUI calls %Save() for me, which is great. But I want to set the property CreationDate with the current date for every new record being inserted.

So  object callback implementation seems as a reasonable option. I did the following:

Method %OnBeforeSave(insert as %Boolean) As %Status [ Private, ServerOnly = 1 ] 
{

 if insert s ..CreationDate=$H

 q $$$OK

}

And it works fine.

But Documentation says I'd better use %OnAddToSaveSet()

What are you using for the callbacks in similar cases?

In Cache 2013.1.6.950.1 I have a ZEN dataGrid which works fine except if I use the mouse wheel to scroll through it.

If you use the mouse wheel (rather than the scroll bar) to scroll to the bottom of the grid and then click the checkbox against the bottom row it works the first time however if you then scroll back down the grid with the mouse wheel to the check box and uncheck it the check box will still be checked when you scroll back down to it and it only goes unchecked when you click in it a second time.  It works fine when the scroll bar is used.

What is Purpose of DeepSee and how to we mapping the Deepsee concepts with in Class file.Please give a simple program for how to we learn on Deep see.

I'd like to include a .inc file in a tag-based CSP page. The include file defines a bunch of macros that I want to use in CSP runtime expressions. Is there any way to do this?

The Data Platforms department here at InterSystems is gearing up for this year's crop of interns, and I for one am very excited to meet them all next week!

We've got folks from top technical colleges with diverse specialties from hard core engineers to pure computer scientists to mathematicians to business professionals. They come from countries around the world like Vietnam, China, and Finland and they all come with impressive backgrounds. We're sure they will do very well this summer.

Is it possible to use a Contains clause using the IntersectLookup function?

Hello,

I’m creating a REST API service but I need to convert my object in JSON.

The Class “A” is extended from another Class “B”:

Class message_B Extends Ens.Request
{

Property ClientId As %String(MAXLEN = "");

Property mesagge As %String(MAXLEN = "");

}

Class message_A Extends message_B
{
Property idDate As %String;

Property Datetime As %String;

Property time As %String;

​}

When I use:

set pRequest = ##Class(message_A).%New()
​do ##class(Ens.Util.JSON).ObjectToJSONStream(pRequest, .content)

This convert all properties  (A y B), but I want that only convert properties in A.

Hi, colleagues!

When you export the Caché ObjectScript code to VCS (Git, SVN, Perforce, etc) do you export the Storage schema for persistent classes?  If so, what are the Pro/Contra?

Thanks!

Hi -

In Management Portal I can view Processes and their details.

I have a long running job and would like to set the  "Client Application Details" -> "Info" indicator in my code so that I can monitor the process.

Does anyone know how I can set that string in my COS code?

TIA

Hi,

I have created a Business Service which uses the EnsLib.File.InboundAdapter. This service will call a business service which will create an acknowledgement file in a directory specified in the operation after loading the parsed file into some temporary tables.

In order to create the acknowledgement file, I need the original file name. In the OnProcessInput of the service, it receives a stream of file data, and I can't find a way to get hold of the file name.

Any advice will be appreciated, thank you.

Since most of our customers moved to Caché 2015.1, some admins became abused with CPUPct warnings (sometimes alerts) in console log without other signs of lacking CPU power.
Documentation states that:

What does it really mean?
E.g., if total system CPU usage is 25%, and all running processes are of the same type (e.g, CSPSRV), would CPUPct be equal to 100%? If so, why this case should be a reason for alert?

Consider the below scenario:

1. HL7 Service -> Process

2. DTL makes a call to a webservice (Post) via a REST operation via SendRequestSync call.

        a. if the post is successful, end the DTL

        b. if the server that hosts the webservice is down, i would like to keep retrying with the same message and not lose any messages in the queue.

does a simple "quit 0" at the DTL will  rollback the message and will retry? please let me know how not to lose any messages if the webservice server is down.

Appreciate it.

We have multiple server and multiple namespace. 

I have a script having sql query  which fetch data from current  namespace of a server. 

If I want to run the same query on different server to fetch data, but I want to run that script on just one server for all server. 

Please let me know how can I proceed. 

I have a business service and I want to know when did the current business service job started.

Is there a way to get this information from Ensemble?

From a browser, an XMLHttpRequest to a CSP page on a different server will obviously hit the CORS security check.

To get around this I can set the Access-Control-Allow-Origin header on that particular CSP class.

However, setting any request headers on the XMLHttpRequest object will trigger a pre-flight OPTIONS request.

This OPTIONS request is not handled by the target CSP page and the Access-Control-Allow-Origin header is never set, triggering a CORS error.

I can see in the new REST class that it can get a handle on the OPTIONS request but standard CSP pages don't seem to get them.

I need a trick to display the cellTitle for just ONE column in a tablePane with a unique value.  Here are the issues:

1. OnDrawCell has access to the cell data for that row/column, in %query(pName),  but setting the cellTitle property to a column doesn't refresh the column object

2. Setting showValueInTooltip is good for the entire table, not just one cell

3. ** the column element does not evaluate zen expressions, so I can't say cellTitle="#(%query.Comment)#", for example.  That's the crux of the problem.

Hello.
I would like to know if there's a way to batch a certain amount of writes done inside a job and display it sequentially on the main process.
My idea is to prevent the main process from freezing while displaying the batched data. The main process's device could be

the terminal or the Studio output.

%Studio.Debugger does something close to that when printing the output from the debug target process.
$System.Event.Signal($zparent) doesn't signals the parent if a device is open. So I can't create the batch buffer along, because I can keep the buffering device open and notify the main process.

Which is tool/script use of Automating the Ensemble part? Is seleinium can be used. Please help me out on Automation testing

Hi all,

Sorry to bother

I have a Business Object with SOAP.OutboundAdapter and it gets the response from a WebApi.

Following the sample Creating REST Services and Clients with Ensemble - Developing a REST Operation, I've done the call and it retrieves a JSon with the information. The result is a JSon with a Base64 content (at least 15000 bytes)

I've put a trace to check the content  with $$$TRACE(tHttpResponse.Data.Read() I have a cut result (to 1200 character), so the JSonStreamToObject is not able to allocate the full result into a object.

The Art of Mapping Globals to Classes  (2 of 3)

If you are looking to breathe new life into an old MUMPS application follow these steps to map your globals to classes and expose all that beautiful data to Objects and SQL.

This example is going to cram in 4 or 5 different things beyond what was covered in Part 1 

All that is left after this is the Parent Child mapping example and then you will be on your way.

Same disclaimer:  If you can’t make heads or tails of your globals after reviewing these articles please contact the WRC and we will try to help you out:  Support@InterSystems.

How to define placeholder for dataCombo?

set dc.placeholder = "Some text"  doesn't work.

HI,

Please let us know the solution to the below error:

ERROR:#5388 - You do not have write permission on the database class . %SOAP.WebClient is in , so class lock cannot be obtained .

Thanks, Shobha

Hi All

I'm looking for some field experiences, lessons learned, or actual deployed solutions to the problem of replicating non-CACHE.DAT data in a mirrored Cache environment.  

Environment:

• Operating System is IBM AIX
• Hardware is IBM Power w/ virtualised storage
• Cache 2017.1
• 2x Production mirror members
• 1x DR mirror member

There are a number of different data types that we're looking at mirroring, and a number of identified solutions.

How to send HL7 messages using HTTP type in the business production??

How to send HL7 messages using HTTP type in the business production??

Hello,

Has anyone ever had issues using target class HS.SDA3.Container within a data transformation where the CareProvider values do not populate?

Basically I'm finding that XML stream output has all the SDA3 values I specify/map in the DTL except for the Appointment CareProvider data. I've mapped the values to another SDA field I know works and the correct value populates, so I know it's not an issue with the source value. I've also tried hardcoding the value and it still does not populate.