Hi Everyone!

New webinar "Rest API Design and Development" is available now on  InterSystems Developers YouTube Channel:

I am trying to use current implementation of source Control for Cache Studio in Atelier, but UserAction = 3 "Run an EXE on the client" is not working. Basically Atelier is launching a "page" using the target as url.

Am I missing any settings in order to command Atelier to run a exe command instead?

Cache Version: Cache 2017.2.0.744.0

Platform: Windows 10

Hi,

A site has a Mirror set, and an Asynchronous DR.  The disk drives for each of the instances are local disks and the databases are large (>2 TB)

The current backup strategy is started off as using Cache Backup and is still the case today, but the size and time it take t do the backup is obviously prohibitive.

The External Backup procedure requires a Freeze/Thaw of the Cache environment, with a copy of the environment executing between these 2 steps, however, being on local disks, there seems to be no way to quickly copy off the OS files and cache databases in time.

Is is possible to install multiple copies of Eclipse/Atelier, and have each instance maintain it's own distinct list of server connections? I thought I had figured it out, uninstalled everything, and reinstalled without using bundle pools.  I think this keeps projects separate, along with allowing different Eclipse settings and plug-ins. After installing the second instance, no server connections from the first were showing in the second.

Hi all.

I have some problem with getting data from external source (PostgreSQL) via JDBC and load it in DeepSee and I resolved some problems while writing this question :)

So..Below I proved my steps of working:

1. Created SQL Gateway Connection
2. Created class for loading data via JDBC
   

   S Connection=##class(%Library.SQLGatewayConnection).%New()
   S sc=Connection.Connect("jdbcurl","user","pass",0)
   If $$$ISERR(sc) do $System.Status.DisplayError(sc) quit
   S sc=Connection.AllocateStatement(.Statment)
   S query="SELECT * FROM students"
   S sc=Connection.Prepare(Statment,query)
   S sc=Connection

Hi community,
I need to monitor Caché Intersystems with some custom indicators.
I started customizing the SNMP Mib. But I've been in a Zabbix event, all speakers use ODBC to monitor their database, Oracle, MySQL, PostgreSQL ...
What is the best way? Use ODBC or SNMP Custom Mib?
What are you guys using?

I am trying to create an iKnow domain programmatically like:

    Set dom = ##class(%iKnow.Domain).%New("TestDom")
    Do  dom.SetParameter("DefaultConfig", "MyConfiguration")
    Set sc = dom.%Save()

   ...

Although "MyConfiguration" sets the language to "ja", i.e. Japanese, it doesn't seem to be respected, and what I see on the top right pane in Knowledge Portal is related concepts, instead of proximity profiles, which I expect to see  in Japanese language mode.

Also resulting segmentation of sentences looks to be it is in English mode.

Can someone tell me how I can do this?

Hi,

There have been similar questions asked before, but a few years ago now. My problem is that when I create an application in plain CSP, a typical link to a page will look like this in the browser..

https://omnidata.com.au/csp/lcda/StudentList.csp?CSPCHD=001000010000EYn…

One user sent back a comment.. 'I'm not using your application as it is un-secure' .. based on the fact that the elements are spelled out in the URL.

Is there now some way of hiding the path and the .csp page in the URL?

Thanks in advance,

Rosti.

Good morning, employees

I'm having trouble compiling in studio, I already reported it to intersystems support, but it did not solve the problem.

when calling a method of a class by putting $, follows an example:

set obj = ## class (% AbstractObject). $ fromJSON (data)
ERROR: SearchCep.int (29) # 1011: Invalid name: '## class (% Library.AbstractObject) $ fromJSON (data)': Offset: 45 [SearchCep + 28 ^ SearchCep]

the studio compiles, and the application performs perfectly, but in the studio it presents error.
Someone has already encountered this type of error.

Following is a sample application.

I would like to remove the login requirement, such that when

the Terminal option on the Cache Cube is clicked, the session goes directly

to the mumps prompt.

Also, how can I change terminal user's login password.

In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:

• Git 101
• Git flow (development process)
• GitLab installation
• GitLab Workflow
• Continuous Delivery
• GitLab installation and configuration
• GitLab CI/CD
• Why containers?
• GitLab CI/CD using containers

In the first article, we covered Git basics, why a high-level understanding of Git concepts is important for modern software development, and how Git can be used to develop software.

In the second article, we covered GitLab Workflow - a complete software life cycle process and Continuous Delivery.

In the third article,  we covered GitLab installation and configuration and connecting your environments to GitLab

In the fourth article, we wrote a CD configuration.

In this article, let's talk about containers and how (and why) they can be used.

In the last post we scheduled 24-hour collections of performance metrics using pButtons. In this post we are going to be looking at a few of the key metrics that are being collected and how they relate to the underlying system hardware. We will also start to explore the relationship between Caché (or any of the InterSystems Data Platforms) metrics and system metrics. And how you can use these metrics to understand the daily beat rate of your systems and diagnose performance problems.

As an advanced alternative for REST calls, the new vue-qewd plugin for Vue.js allows easy integration with QEWDjs using WebSockets.

One of the benefits of Atelier is easy integration with source code management tools. Some Eclipse installations include the EGit plugin, or you can install it from the Eclipse marketplace. EGIt makes integration with Git and GitHub easy. Here are the steps I used to connect Atelier to a GitHub repository:

I've been writing ObjectScript for a long time and was a little surprised by this behavior so I'd like to understand what is going on.

I was doing a peer review on some source which had roughly the equivalent of the following line:

Set myRecord = ##class(MyObj.Record).%OpenId(id)
Set emailList = previousEmails_","_myRecord.RecordGroup.

Hi Community!

Please welcome the InterSystems Developer Community SubReddit!

Here you will find all the most interesting announcements from InterSystems Developer Community, i.e. useful articles, discussions, announcements and events.

A little about Reddit:

 —  is a social news aggregation, web content rating, and discussion website.

Is there something in Cache that is equivalent to partitioning a table in Oracle? I'm trying to break some big tables into groups so that the most frequently accessed data is faster to retrieve.

Here is some information on this concept from Oracle.

https://docs.oracle.com/cd/B28359_01/server.111/b32024/partition.htm

How to write all the alerts from Ens.Alert to a file instead of sending to an email? Any documentation available to implement this.

Can any one give  suggestion on creating extension for cache studio in windows.

Trying to save a message to memory from terminal.   The following is not working as I know I'm missing something.

Set HL7Msg=##class(EnsLib.HL7.Message).Identifier(XXXX)

Hi Everyone!

New session recording from Global Summit 2017 is already on InterSystems Developers YouTube:

Predicting Your Manhattan Cab Ride Fare

For many in today's interoperability landscape, REST reigns supreme. With the overabundance of tools and approaches to REST API development, what tools do you choose and what do you need to plan for before writing any code?

Now that you've learned how to create a REST API in the REST & Relaxation webinar, see how you can successfully make it big. Join @Eduard Lebedyuk, InterSystems Sales Engineer, for REST API Design and Development. You'll learn design patterns and considerations that allow you to build highly robust, adaptive, and consistent REST APIs.

I need to offer new users on our system a temporary password that is valid for only 48 hours.  This is different than a 60-day password expiration window for existing users' passwords (where a password needs to be changed every 60 days), and is different than a "user expiration date", where you can set a date where the user's account expires and is disabled on that date, and different than the inactivity expiration date where a user becomes active if his account is not used within, say, 30 days.

I tried to access Caché using ADO.NET. This works fine but when I want to use Entity Framework, I can't access the Caché Data Source.

I'm using Visual Studio 2017, and followed the procedure described in Caché documentation.

(This document has been written  regarding VS2013)

Did some meet the same problem ?

Thanks in advance.

Hi all,

Does anyone know if a process (which is using a license unit) does an OPEN or USE to send data (to a label printer as an example) through TCP, will result on license slot usage?

If so, will use a new connection of the currently used one by the process or will get a new slot? 

Kind regards

Currently, we are running 2014.1 on two different servers (OpenVMS, RHEL). The plan is to transition from OpenVMS to RHEL, but our Write Daemon is in a Troubled state on both servers.

On the OpenVMS server, we have a WIJ file that's 26G and can grow to 40G (size of database cache). Since it hasn't grown to 40G, we don't believe the size of the WIJ file to be the issue.

What else should we be looking at regarding the performance of the Write Daemon?

Set rm=##class(%Regex.Matcher).%New("[0-9]*","Word 123456")
Write rm.ReplaceAll(".")
.W.o.r.d. ..

Why??

I am trying to read data from MySQL Server 2012 to a stream  and I keep getting an error here is my code so far

ERROR

An error was received : ERROR <Ens>ErrException: <INVALID OREF>zGetBatchDetails+14^DDQTools.DQTGetBatchOpp.3 -- logged as '-' number - @' set sc=reStream.WriteLine(rec) '

< set tSC=$$$OK
 
  set ^tvalue=1
 
  set ^tvalue=$INCREMENT(^tvalue)
 
    #dim rs as EnsLib.SQL.GatewayResultSet
    #dim reStream as %Stream.GlobalCharacter
    if $$$ISERR(pRequest) quit pRequest
    set sc=.Adapter.ExecuteQuery(.rs,.GetTheSubmissionData(pRequest.pMonth, pRequest.

Hi Evgency,

Effectively I have widjet with pivot which include dates in from different cubes/dimensions, but exists the relation between the two cubes.

I'm showing below the MDX query from one pivot that uses the date "Fecha Creacion" that comes from cube "EVENTOSPOLICIALES" 

SELECT %LABEL([Measures].[%COUNT],"Cantidad de Encargos","") ON 0,
       NON EMPTY {[TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Arma],
                [TipoEventoPolicialD].[H1].[TipoEventoPolicial].&[Encargo de Especies],
                [TipoEventoPolicialD].[H1].[TipoEventoPolicial].

most of my jSON data is single words, but when it comes to sending chunks of a memo/email via JSON, that totally different

which is the correct conversion process to prepare data ready to insert into the data part of a JSON string so that all problem characters are converted

JSON of course crashes if you use the wrong format of quotes (single or double) and you ned up having to use &QUOT and \' to get around that but is there a simple call to something that will just take care of preparing the data from the JSON string both on the inward and outward part of JSON

kevin