Have you ever thought what could be a reason why some development environment (database, language) would eventually become popular? What part of this popularity could be explain as language quality? What by new and idioms approaches introduced by early language adopters? What is due to healthy ecosystem collaboration? What is due to some marketing genius?

When I was working for Intersystems as Sales Engineer in their Russian office, we have discussed these things many times: we have experimented with meetups, new forms of working with IT community; we have seeded and curated forums and commun

I have a user with %All, and a user with %Admin_Task.  The %All user can use SQL to view the %SYS_Task.HIstory table.  The user with %Admin_Task does not have the privileges to see the same table.

What priv (or privs) is (or are) needed to view the %SYS_Task.History table?  I just want to start with 'Select * from %SYS_Task.History'.

I've tried %Admin_Manage and %Admin_Operate.  I must be close.

Thanks,

Laura

Take this online course to learn the foundations of the Caché ObjectScript language especially as it relates to use in creating variables and objects in Caché. 

I want do to a "simple thing". Show a dynamic log of actions in the browser as we can see on Terminal. For that, I guess to make a simple CSP Page that show a new line every WRITE command is the thing I need.  

But how I refresh after each WRITE?

How I can refresh the content automatically?

I made a simple CSP Page and in method OnPage I do this test:

Don't work... because the browser show me only after the process finish.

I guess I should use another way... any help?

Recently I came across a very strong statement to the effect that InterSystems.Data.CacheClient.dll library works fast because it does not open a TCP/IP connection, instead it works in the same process as a database. It made me pause for quite some time. Firstly because .Net Managed Provider, which utilises this library, opens TCP/IP connection to the database (and it is stated in the documentation "Using .NET and the ADO.NET Managed Provider with Caché"). And secondly, because as far as I know only eXtreme applications attach themselves to the process. Besides, CacheClient for the most part j

So I know it's been a while, and I hate to let my adoring fans down... just not enough to actually start writing again.  But the wait is over and I'm back!  Now bask in my beautiful ginger words!

For this series, I am going to look at some common problems we see in the WRC and discuss some common solutions.  Of course, even if you find a solution here, you are always welcome to call in and expression you gratitude, or just hear my voice!

This week's common problem: "My query returns no data."

Now, supposedly you've checked that your query SHOULD return data.  That is, if you do a "SELECT * FROM M

How do i do the following:

Pass multiple values from one class to an excel report class using multiple tabs?

I want to request the data in the request class using a SQL statement changing values in the SQL statement, and then parse the values to the excel report to each sheet respectively.

How do I do it?

Dear colleagues,

a recent project came up with the question if it is possible to "restart Cache from inside", ie. using a COS-routine.

Thank you in advance and regdards

Markus

I thought I'd share some issues I had today with Zen development in a custom component. Say we have created a Zen composite component with a few javascript methods that modify its child components. In order to modify these components, we can use something like the following method:

In JavaScript methods on the client, this refers to the current component or page. The equivalent for expressions that are values of XML attributes is zenThis (see documentation).

How

Recently I started working with GitLab - GitHub self-hosted foss alternative. So far so good, liked the UI,  ease of administration, and available functionality (I was on Phabricator previously,  and still use it for repo mirroring).

GitLab has GitLab CI  (GitLab Continuous Integration) which looks promising (pluggable docker/vm/ds to run code) , but I wondered if someone uses it already and can share scripts for it?

Typically the thumbsup/thumbsdown icons are grayed out until you vote for one.  Then it is either red or green depending on which you selected.  I like this behavior.  However, on my own posts, the ones I cannot vote for, the indicators are both colored.  Since the visual queue has already been established that this indicates a selected vote, I think this should be changed.  Perhaps, since we cannot vote on our own posts, completely hide them.

Hi, Community!

We are fixing groups, tags and message types for the several last year's postings.

So that's why you are getting "strange" notifications now with no any new comment.

As a result, you'll get better tagging and for the DC articles and questions.

Anyway, you can turn off the "OnUpdate" notifications as it is described here.

I know this has been suggested before but I wanted to bring it up again.

It would be very nice if we could "accept" an answer to our questions which would result in the question showing "answered" in the index and possibly move the "accepted answer" to the top of the answer chain.

see: Stack Overflow or any other QA site

Hi Community!

In this release we turned off the digest mode for all the members (until it would be fixed) and fixed the Update notifications: now this settings can be found in the same place for all the members: Subscriptions/Content types tab.

Meet in this small release the new very valuable feature: marking answers as "true" answers.

If you are an author of the question now you can choose the right answer if there are more than one and mark it with the green checkbox. Like it is shown here:

If there are more than one answer, the "true" one will be shown topmost.

The question for the Community: wh

Hi, Community!

We have 2017 year on the calendar, so it's time to look back on 2016 and find some highlights.

Here is the set of Top-20 questions regarding InterSystems technology you posted in 2016.

Most viewed

Anyone using Visual Studio Code?, by John Murray  1062

Import/export data from InterSystems Caché, by Evgeny Shvarov  942

How can I pass multiple parameters to an Ensemble REST service and return an authorization token as a response JSON message, by Joshua Goldman  917

How to install and configure Atelier?, by Ronaldo Nascimento  793

how to connect to the Cache database from node.js ?, by Sha

Hi, Community!

You published 499 articles regarding InterSystems technology in 2016.

Here are the most noticed and interesting articles of the year.

Introducing new JSON capabilities in Caché 2016.1, by Stefan Wittmann  2478

InterSystems Data Platforms and Performance Part 4 - Looking at Memory , by Murray Oldfield  1598

Writing better-performing loops in Caché ObjectScript, by Timothy Leavitt  1509

InterSystems Example Reference Architecture for Microsoft Azure Resource Manager (ARM), by Mark Bolinsky  1468

Class Queries in InterSystems Caché, by Eduard Lebedyuk  1441

Caché Class Explorer — exploring

Anyone know where I can find a higher quality version of the favicon used in the Ensemble production interface?

Does anybody know good interesting and detailed articles or maybe bookes about the binding of SSL сertificates?

Thank you.

Is there a way to have a Data Lookup table be automatically updated via a script or cache code? We have a file that is being created by our EMR, and we need to import it into Ensemble to update it. Just trying to see if we can automate this process.

Thanks

Scott Roth

Ohio State University Wexner Medical Center

I posted a question and someone replied with a comment.  
This comment  was marked as an answer, but the comment does not actually answer the question. 

How do I tell the system that the comment is not actually an answer and should not be marked as answered?  

Can the original post author decline an answer?  What is the  answer is incorrect?

Can the community vote on the best answer (like on other popular discussion boards)?  

Hi!

Today DC supports the notifications for the posts' updates. It means if someone changes the post text, title, group or tag you can be notified about that.

But this notifications just inform that there were updates, but do not show what exactly was changed in the post.

So through this, you can get the notifications for the posts from previous years without any reason what's happened.

I would suggest to turn off this types of notifications until we'll implement the details in notifications, what exactly was changed in the post and why did you get it. 

To turn off the update notifications go to yo

There are two tags with the same name "Web Services"

The same problem for tags: REST Services, Delegated and Monitoring.

All,

Totally new to Cache and Encryption.  Have a project requirement for SHA-512.  

Recently we have exercised this with a partner. It may be helpful for others as well.

The basic functionality is to connect to SAP through SAPJCo (Supporting SAPJCo 3.07+).

As a first step have a production with at least two items of the following type:

• EnsLib.JavaGateway.Service
• EnsLib.SAP.Operation

Configure the settings for the Java Gateway and the SAP Operation accordingly. And start the production.

Now the library sapjco3.jar needs to get imported to be used by further internal functionality.
Therefore start in a browser the webpage for simplified SAPJCo base installation

/csp/<your sapjco names

When working with a large query executed though an ODBC connection what is the best way to allow the paging of the results at the client side.  I have tried some methods using %VID and similar methods, but these really don't seem to work as the value returned is related to the ID of the data and not the position in the results set.  What would be ideal is if the value seen in the management portal when you check of "Row Number" was available to external queries through ODBC.  I have not seen a way to return this however.   This would be similar to SQL server Last n and Skip n capabilities.

How are we doing THIS year versus the same period LAST year? 
This is a common need in Business Intelligence. In fact, many design specifications for reports make use of a comparison between a selected period (year, quarter, etc) up to a certain date (for example November 15th, 2016) and a summary of the same information for the previous year (i.e. up to November 15th, 2015). 
This post shows how to implement this in DeepSee.

I just received three subscription digest emails that seem to have come from the past. For example, one included this fragment:

But when I follow the link from the email the article date is much older:

Did the DC software have a glitch?

Hi all,

I've a problem with EnsLib.FTP.OutboundAdapter

I've configured this adapter using a SFTP connection, it has been working the first time but now its raising the following error message:

ERROR <Ens>ErrFTPPutFailed: FTP: error al colocar archivo '1600000107279008930.pdf' (mensaje='Error in SFTP Put('C:\stream\QhFaDm4L1Jrgbg.stream','mypath/1600000107279008930.pdf') ERROR #7500: Error SSH '-2146430933': SSH Error [8010102B]: Unable to send FXP_OPEN* [8010102b] at SFTP.cpp:539,0',código=0)

This is part of my code:

    try {
        set name = pRequest.FileName
        set ..Adapter.FilePath 

Hi!

I want to optimize the cube and delete the measure. Is there any easy way to find pivots which use it?

Does anyone have any snippet regarding this?

Would be great to have "out of the box" dashboards which will show the dependencies of pivots vs measures and dimensions.

Hi All,

I am new to this technology and I have installed the trial version of cache 2016.1 with Normal security.

I was trying to develop the sample cinema application and mean while when I tried to view the csp webpage, it opens the browser and ask for login after logging in it shows Service Unavailable error instead of preview of webpage.

Could you guys suggest an answer to resolve this issue.