InterSystems Developer Community is a community of 21,771 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

This is the first article of a series diving into visualization tools and analysis of time series data. Obviously we are most interested in looking at performance related data we can gather from the Caché family of products. However, as we'll see down the road, we are absolutely not limited to that. For now we are exploring python and the libraries/tools available within that ecosystem.

9 4
1 1.6K

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

0 1
0 320

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?

0 1
0 959
Question
· Mar 20, 2018
Bad regex? 
Set rm=##class(%Regex.Matcher).%New("[0-9]*","Word 123456")
Write rm.ReplaceAll(".")
.W.o.r.d. ..

Why??

0 4
0 368

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

0 13
0 542

I wanted to see some alerts that occur in my Productions in a Mobile Device, I came across Pushover.net recently that although has an upfront cost $5 you can send as many messages as you like after that, there is a 7 day free trial to check it out.

To Integrate this with a production I did the following.

Create an account and set up a device on https://pushover.net/

Record the following API Keys from the web site on the main page you will see

3 5
0 1.3K

Cache 2016.2.1.603 for windows)

I created a few classes and one class called jitPod.Api.toServer.additionalConsignments and realised even before I did any work,, that the word "Api" (note capital A) needed to be "api" (all lowercase)

it would not allow copying the class to the lowercase name because the directory already exists (i understand that)

so I exported the class to an XML, edited the xml to become lowercase "api" , deleted all the classes (and directory name) and re-imported the class.

0 19
0 796

Hi all,

I have an operation which uses the SQL outbound adapter to query a data source set up using a system DSN on the server which uses the Intersystems ODBC35 driver (this is a cache db hosted elsewhere).

Whenever Ensemble runs the following query:

SELECT lnkdid,
c_fastsearch_code,
c_drugfull
FROM JAC.drug_basic
WHERE c_drugfull LIKE 'Para%'

No data is returned, however running the same query via SQL Server Management Studio, all expected rows are returned.

Also if I run the following via Ensemble:

0 7
0 661
Question
· Mar 14, 2018
ZEN REPORTS and EXCEL

I have a ZEN report set up to generate a file for loading to into excel (see attached). Even though I have DEFAULTMODE set to "excel" the resulting output file that I get on one CACHE instance is .xml while on another it is .xls. This is even though I run the report from the two instances on the same PC. Can anyone suggest what I am doing wrong? The Cache version is "Cache for UNIX (IBM AIX for System Power System-64) 2013.1.6 (Build 950_1) Fri Jun 6 2014 17:43:51 EDT"

0 4
0 519
Question
· Mar 12, 2018
Compilation Status after Import

Is there a way to enumerate the compilation status of a package?

currently after deployment we are doing something like this to validate a successful load and compile of classes:

successful_compilation_count=`grep -a "Compilation finished successfully" output.log | wc -l`
successful_load_count=`grep -a "Load finished successfully" output.log | wc -l`

is there a method to do this where it is a little bit more elegant/dynamic without having to maintain counts for comparison ?

0 4
0 398

Hi Everyone!

New webinar "Enter a New Era with Atelier" is available now on InterSystems Developers YouTube:

https://www.youtube.com/embed/LXTlYFTRZgk
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 1
0 312

Hi, Community!

Check a new session recording from Global Summit 2017:

Pros and Cons of Virtual Environments

https://www.youtube.com/embed/87eG_zAbb9Y
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 369
Question
· Mar 13, 2018
DICOM to HL7

We have a case where a vendor can send us more information in the DICOM message rather than in the HL7 result message. In theory it should be possible to take a DICOM and convert it to HL7, stupid question is has anyone done it before? Does anyone have any good examples of a DTL they did to show me how to setup the message structures and translation?

Thanks

Scott Roth

The Ohio State University Wexner Medical Center

Scott.Roth@osumc.edu

0 2
0 1.1K

I came across How to import a tab separated text file into a SQL table programmatically?, which appears to indicate that I can pass the filename and all records will be imported. However, when I put use the Import method only a single record gets imported. However, all records are imported if I use the management console to import the file by selecting it and choosing the options.

Has anyone ran into this in the past?

0 3
0 694
Question
· Mar 13, 2018
idx and cache

I am new to cache. idx is a language for cache database? we have cache database on aix and planning to move to linux, but i was told only aix is supported since idx only works on aix. can someone help me to understand?

thank you very much.

Hope

0 3
0 776

Hi all,

I am new in Cache. I have to update a record with a long text field, for that, I am using ODBC but the issue is that it is returning an error when I execute the ODBC SQL statement because the field contains some commas, colon, double quotes, single quotes, and CR LF characters.

There is a way to escape this chars? I have seen I can save the field when I replace the single quotes with a double single quote (it's -> it''s) but I can not save the information when the field contains double quote chars. What about the other chars?

0 6
0 1.1K
Question
· Mar 8, 2018
WIDE CHAR error

Hello,

I'm getting <WIDE CHAR> error in one of my routines, I was thinking a corrupted data or disk out of space or no mount database but all seems to be OK?

I'm running Cache 2014.1.2 and the same routines and data works in our client main server with not problems but having the same copy in their backup server is generating <WIDE CHAR> error, some other reports works but this specific doesn't?

Thanks

0 3
0 827

Hi I currently have a requirement to upload microsoft documents from a client's PC to a cache database, at present the idea is to use javascript to open the file and convert it to a binary stream and then for cache csp to upload the binary stream to the database. Just wondered if anyone else had attempted this or are there better options !

Regards

Gary

0 10
0 1K
Question
· Mar 11, 2018
Atelier Server connection

When assigning the filter to the server explorer in Atelier to hide system classes, it works only in server explorer.

The same server explorer option linked to a given project does not appear to observe the filter setting from the server connection, and has no ability to assign filters at the project level. Is this an enhancement needed or am i missing the logical requirement?

Also when assigning a tag to this post, only Atelier 1.1 BETA comes up. I believe i am using the stable release of 1.1

0 3
0 384
Question
· Mar 8, 2018
Menu bar in Studio

While I'm working in Studio, every now and then, the menu bar gets "unglued" and becomes a window of its own outside of Studio.

Is there a setting that prevents this from happening?

Also, if I happen to close Studio while the menu bar is "loose", the menu bar remains missing when I open a new Studio Session.
Is there a way to get the menu bar back in such a situation?

0 5
0 611