Hi, is possible rewind results of %SQL.StatementResult?

I not find a solution.

Hi,

I have Healthshare/Ensemble version 2015.2.1.

I created Business Operation in my ENSDEMO namespace that will connect to an external REST endpoint to send data to this external REST Service.

I also created an http service in Home>Healthshare>Service Registry, under the Service Type: http. I entered the REST endpoint Name, Host, SSL Configuration, and URL.

In my ENSDEMO production, the Business Operation is using EnsLib.HTTP.OutboundAdpater and my custom Rest business operation class.In the Basic Settings, for HTTP Server, I entered #NameofRegistryService.

Hi!

How can I show a number of rows in a given DeepSee pivot?

Amongst the large fonts and chunky icons of Portal's pages, the Menu button in the top left corner is easily overlooked:

When clicked, it often produces the following menu:

When I remember it's there, I find the "View Console Log" option particularly handy.

I wrote "often" above because I've also noticed that the Menu contents change when I'm on a page within the Ensemble section of Portal:

Maybe the contents are context-sensitive elsewhere too and I just haven't noticed yet.

Learn how to configure alerts in a production.

Until recently I didn't pay much attention to Portal's home page:

If it's not showing when you initially launch Portal you can easily jump to it using the button / tab at the top of the left-hand column of options. And later during your session, get there via the Home link that will be visible at the top of every page.

On the Home page the "Recent" section is automatically maintained for you.

To use the "Favorites" section you need to tag your favorite pages. Suppose I want to add the production monitor page as a favorite. Here's how:

1. Navigate the menu to find the link for the page you want.

2.

User interfaces such as Portal often give us multiple ways of doing a task. Sometimes we stick with habits and don't realize that another way might save us time.

Here's one that I learned by watching someone else using Portal.

Use the Search box to get quickly to a page that may otherwise be several layers deep in the Portal hierarchy. For example, suppose I want to check the status of the ECP networking:

Clicking on a match doesn't take me direct to the page (or am I missing a trick here?). Instead it gives me this:

And now a click takes me to the page I want.

We've been noticing that we're getting this (https://community.intersystems.com/post/cach%C3%A9-sql-error-odbc) error more frequently and having to constantly purge cached queries in order to resolve it. Is there a way to avoid the issue in the first place?

thanks!

Hi All, When i try to run the CSP from Studio it shows "Server Availability Error" and management portal and documents also throw a same error.how to recover it.

  The following code in .Net using  CacheObject.dll  version 2016.1.2.206 com library

                  ConnectionString  =  "cn_iptcp:10.56.135.160[1972]:PHDEMO:PHSYSADM:***********" 

                  b = factory.Connect(ConnectionString  )
                  objCacheObject =  factory.Static("CacheObjectConnection")     
                  clist  = factory.GetConnectionList()

  for the above code, b is true and clist is  Local,cn_iptcp:127.0.0.1[1972]: 

Why isn't the 10.56.135.160 in the connection list? Next the program runs a function written an early version of Cache.

After I installed HealthShare, there are some items missing in my local instance. For example, I don’t have Delivery Management, Terminology Management. Under the Relationship Registry, I only have Patient Relationships, but Patient-Clinician Relationships, Relationship Definition and Move Patient-Clinician Relationships are missing. Can anyone help me out here?

IO devices can be assigned to a mnemonic space using, for example:

u device::"^%X364"

Is there a method that will return the assigned mnemonic space for the current device?

I can infer it by attempting to write to the device using a non existent write /mnemonic and then inspecting the error returned, but this is rather messy and could potentially affect the status of the device.  For example:

USER>u 0::"^BAR"
USER>w /foo
<NOLINE>^BAR
USER 2d0>

Is there a method or system variable that will give me this information in a cleaner manner?

Thanks

George
www.georgejames.com

What is the difference between $case and $select?.Where places to use $case and $select?

Hi Community!

We are launching the new channel of InterSystems Technology content for you. Please welcome InterSystems Developers YouTube Channel!

What the content you will find there:

• Community Tools and Solutions for Developers - screencasts, promoting different 3rd party solutions for developers.
• Webinars - will contain webinars content made by InterSystems engineers.
• InterSystems Events - live broadcastings and reviews from different InterSystems events for developers.
• video.intersystems.com playlist - featured technical videos from http://video.intersystems.com library.

See how it looks:

I have a web application with html, css, js files (no ZEN/CSP).

Problem: after I update them on a server, Caché still servers old and cached version (browser Cache is disabled).

There is a manual cache purge in Gateway Settings, of course, but is there an automatic solution?

I'll be okay with disabling cache server-wide, but an application-wide solution would be better.

I don't want to host web app on a separate web server.

Here's my web app config:

For reasons that I won't go into here, I need to run Cache Terminal in Linux using Wine.

It starts up ok, but when I try to establish a connection to a remote server I get the following error:

Ctermsecure Read Error
Could not obtain terminal server client name.
Reason: (10035, 0x2733) unknown error

If I launch CTerm.exe from a command line then I get the following:

~/.wine/drive_c/InterSystems/Cache/bin $ wine CTerm.exe
fixme:imm:ImmReleaseContext (0x4c0354, 0x1bbdb0): stub
fixme:ver:GetCurrentPackageId (0x32f430 (nil)): stub
fixme:wtsapi:WTSQuerySessionInformationA Stub (nil) 0xffffffff 10

In last week's discussion we created a simple graph based on the data input from one file. Now, as we all know, sometimes we have multiple different datafiles to parse and correlate. So this week we are going to load additional perfmon data and learn how to plot that into the same graph. Since we might want to use our generated graphs in reports or on a webpage, we'll also look into ways to export the generated graphs.

Loading windows perfmon data

The perfmon data extracted from standard pbuttons report is a bit of a peculiar data format.On first glance it is a pretty straightforward csv file.

I created a new class DSW.Addons.htmlViewer:

Class DSW.Addons.htmlViewer Extends %DeepSee.Component.Portlet.abstractPortlet
{

Property Data As %String;

ClassMethod %OnGetPortletSettings(Output pInfo As %List, ByRef pSettings) As %Status
{
    Kill pInfo
    Set pInfo(1) = $lb("Data", , , "Data", "Data setting")
    Quit $$$OK
}
}

It's a ZEN component and DeepSee portlet. It's immediately available in the namespace I created it in. DSW package is mapped to %ALL and to Samples, but if I try to create a widget with this portlet I get ZEN class not found error.

I need to go to SAMPLES

Hi

I created a jdbc connection in the Caché 2010.2.3  with SQLServer 2008R2.

The connection to this DB works correctly. (Conection Sucess)

I try to perform table binding but this connection, even though it is successful, does not load my tables and schemas.

I did the same test on Caché 2015 , with same jar drivers files and works perfectly!

Any idea?

Caché 2010.2.3

Red Hat Enterprise Linux Server release 6.2 (Santiago)

java version "1.7.0_09"

Caché 2015

Red Hat Enterprise Linux Server release 6.2 (Santiago)

java version "1.7.0_09"

Hi,

I am trying to submit a post using mime attachment. Is there any sample available?

Regards,

MT

It's amlost fixed!

But it still hijacks my right click.

I have the following query which tells me how many documents were retrieved for each customer, but it only works for the "on-demand" customers:

All the other PatientFacility's show up as "Documents".  In an effort to break those down too, I first parsed the DocumentUniqueId value from the XML contained in the Criteria colu

Currently it's not possible to post a question/article without a tag.

When your post is about something that no tag exists for, you can't post it.

Let's allow tag-less posts. otherwise people just select random tags

If I were trying to access an index of a global variable, what time complexity would this operation have? My understanding of languages like Java/C++ is that arrays are stored as blocks of memory so that x[15] would have a lookup time complexity of O(1) because it just goes to (address of the array + 15) and retrieves the value stored there.

How does this work in Cache where the index of a variable isn't necessarily an integer value? If I were to have a variable like the following:

x("Adam") = "Red"

x("George") = "Blue"

x("Bryan") = "Green"

etc...

Would the lookup operation scale with the size of

https://www.stackoverflowbusiness.com/enterprise

A customer wants to process D93A edifact files, orders and invoice. Does anyone have .SEF files available or know how to get them, so we can easily process them with Ensemble? Otherwise we would either have to write a parser for the two message types, or create a SEF file.

Any advice is welcome on this,

Marcel

Performing LUT table maintenance through Portal impacted Business Service HL7 message processing for one of our inbound feeds causing a message to fail.  We are on Healthshare 2014.1.3.  Is this a known issue, or is there a right way to modify table?

We know there are numerous ways to backup cache/ensemble with VMware, but we are not in a state to do that and can't do shadowing because the lack of resources. Anyways how can i backup cache to a drive mounted as network share.

Hi, Community!

Over 600 different authors posted anything on Developer Community in 2016. 

Developer Community contains some brilliant pieces of content because of you. Thank you!

With one of the latest DC releases we introduced "Member Follow" functionality, so you can open any members' page, follow him and be subscribed to all his new posts and comments.

Just to give you ideas who to follow in 2017 here is top 10 authors in 2016 for several nominations ;)

All the nominations do not include postings within Developer Community tag or group.

Top 10 Contributors 

Authors who posted the most articles

This is the second part of my long post about package managers in operating systems and language distributions. Now, hopefully, we have managed to convince you that convenient package manager and rich 3^rd party code repository is one key factor in establishing of a vibrant and fast growing ecosystem. (Another possible reason for ecosystem success is the consistent language design, but it will be topic for another day.)

In this second part we plan to discuss the practical aspects of creating a package manager in general and their projection to the Caché database environment.

Let assume we want