Our team is reworking an application to use REST services that use the same database as our current ZEN application. One of the new REST endpoints uses a query that ran very slowly when first implemented. After some analysis, we found that an index on one of the fields in the table greatly improved performance (a query that took 35 seconds was now taking a fraction of a second).
Hello, I have a task created in my task manager, calling my Business Service class, and it's working fine.
But I need to know the ID of the task, I searched within the class %SYS.Task.Definition and found nothing related.
Last answer 4 hours 33 min ago Last comment 1 days ago
I have created store procedure using management portal.
how to alter or modify SP using SQL in management portal.
Please refer below screen.
.png)
Last answer 6 hours 42 min ago
Hi Developers!
Here is a new release of InterSystems Open Exchange - InterSystems applications gallery!
What's new?
- Github Integration is improved;
- Better application update mechanism;
- UI/UX enhancements.
See the details below.
The .NET Core Identity model has an IPasswordHasher<> interface for for
- Hashing a password so that it can be stored in a database
- Verifying a provided plain-text password matches a previously stored hash.
I am getting invalid password errors during the login process when the .NET Core Identity model computes a hash from a plain text input and compares it to a password hash value I've returned from Caché. The default hashing algorithm is PBKDF2 with HMAC-SHA256, 128-bit salt, 256-bit subkey, and 10,000 iterations (detailed article on .NET Core Identity PasswordHasher). The algorithm Caché uses is probably different which may be why I am getting errors.
Last answer 1 days ago Last comment 12 hours 14 sec ago
I have set up a process to produce a daily file to be submitted to another system and this is working (using EnsLib.RecordMap.Operation.FileOperation). However, the file needs to have a header line added each time it is created so it can be processed by the down stream system. Looking though EnsLib.RecordMap.Operation.FileOperation and EnsLib.File.OutboundAdapter, I can't see where I can do this easily. Any suggestions?
Thanks
Last answer 2 days ago Last comment 14 hours 23 min ago
Has anyone used Cache \ DeepSee for graphical curve fitting and data reduction using Cubic Spline and/or 5 PL for complex curve fitting
Last answer 20 hours 21 min ago
Hi,
I am trying to create a new report on Trakcare. I created a class file and corresponding crystal report . It works fine and data is populating when I try to run on crystal environment. But when I make a setup on Trakcare and click on print option, I am getting an error on print history " VB error in tkCrystalJob] Error number[-2147417848] Method '~' of object '~' failed [at line 421]". If I click on print preview option its going to empty browser. Inorder to setup new report, already made set up on report manager and menu manager.
Last answer 1 days ago
Admin, Containerization, CSP, Dashboards, Docker, Monitoring, Caché, InterSystems IRIS, Open Exchange
Hi, everyone!
I want to share a personal project that started with a simple request at work:
Is it's possible to know how many Caché licenses we are using?
Reading other articles here in the community, I found this excellent article by David Loveluck
Last comment 1 days ago
Hello everyone,
After some work with IRIS we want to share our ToolBox-4-Iris with you.
What is this about?
The ToolBox-4-Iris is an API for IRIS with a collection of handy and useful tools - features that are not available in IRIS, but greatly simplify application development. To save time and effort on the "typical tools" that every developer needs. This includes additional classes, individual methods or even more efficient macros, which are described in the respective packages.
Content
Last comment 1 days ago
I'm a DBA and support Caché databases on AIX. I coded shell scripts for monitoring journaling status, databases size, license end date.
We recently got a new instance of Caché on Windows. I'm just curious to know whether anyone coded database monitoring scripts on Windows using PowerShell or any other scripting language.
If yes, please share the details.
Thanks & Regards,
Bharath Nunepalli.
Last answer 1 days ago Last comment 1 days ago
I have a colleague that is trying to eliminate any HL7 transactions that have admit date/time of midnight from going to an downstream system within a routing rule. I have tried several different iterations of code trying to figure this out just in the routing editor. Without having to write an object script function is this possible?
.png)
Last answer 1 days ago Last comment 2 days ago
Hi, I am trying to get my values into a mySQL DB but for some reason it doesnt seem to go into the DB. I do not get any errors. Would appreciate some guidance on this.
Last answer 1 days ago Last comment 1 days ago
Hi Community!
Sometimes I meet a method which accepts 10+ parameters.
And often I need only the 8th parameter to pass. And I call the method something like:
do ##class(Some.Feature).Method(,,,,,,,"flag")And I don't like this method when I call it like this cause, you know, often I just miss the number of commas and raise some other flag I wanted.
How do you avoid this situations?
If you meet such a code, how do you call it and sure that you didn't miss the number of ","?
What is a good number of parameters in a method and f you need to pass more parameters in a method what do you do?
Last answer 5 May 2019 Last comment 1 days ago
Hi Community!
Two more new videos are already on InterSystems Developers YouTube Channel:
1. Machine Learning - How it Works - Part 1
2. Machine Learning - How it Works - Part 2
I have global with binary data, structured like:
^a(1)=<binary>
^a(2)=<binary>
^a(n)=<binary>
What could be easiest way to read it via Stream interface? I.e. to pass an adapter to a function expecting Stream?
Last answer 9 days ago Last comment 1 days ago
Good morning!
I am developing a Java project (Spring Boot + Maven + Hibernate) but I've a big issue when I try to define the Hibernate Dialect org.hibernate.dialect.InterSystemsIRISDialect... that dialect is neither in the Hibernate library nor in the IRISDriver class com.intersystems.jdbc
How should I define the IRISDialect in my project?
Thank you in advance!
Last answer 17 June 2019 Last comment 2 days ago
Hi
I am trying to upload a file to a ftp site using following code.
Problem is file is getting upload but there is no data. Can you plz advise where I am getting lost.
Also my files are with big data, 2+ GB, as far as know this ftp upload will not effect on my cache.dat size. Plz correct if my understanding is not correct.
Last answer 2 days ago Last comment 8 days ago
Hi Developers!
InterSystems IRIS stores everything in globals and if we use ObjectScript classes to persist data class documents globals it uses in storage. But if you use globals for calculations, temporary storages, for special indexes or for some other purposes - how do you document it?
Possible options which come to my mind:
1. Macro
#define Array ^MyGlobalusage:
s $$$Array(1)=12. Class parameter
Parameter Array ="^MyGlobal";Usage:
Last answer 2 days ago Last comment 4 days ago
Hi All,
I am currently looking for a way of exporting a project from within studio that would actually create the subfolders associated with it. Is there an easy way of doing this. Thanks in advance?
Kind Regards,
Salma
Last answer 3 days ago Last comment 3 days ago
Hi ,
I would like to know if there is possibility to disconnect child from parent in Parent/child relation and move child to Other Parent?
Last answer 3 days ago
Hi Everyone!
We are pleased to invite you to the upcoming webinar "Master Data Management and Your Enterprise" on 3rd of September at 11:00 EDT!
Object Synchronization is a feature that has been around for a while, since Caché days, but I wanted to explore a bit more how it works. I've always thought that database automatic synchronization is complex by nature but, for some particular scenarios shouldn't be so hard. So I considered a very simple use case (OK, perhaps the typical one, I'm not discovering anything... but if it's common and it works, it's good 
).
Last comment 3 days ago
Hi all,
One of the most useful features for me in IRIS was the queue page. From there, I could see how the different elements (BS, BP & BO) from a production were behaving, thanks to the possibility of auto-refresh every second. Great thing.
But we have updated to 2019.1 and this possibility is gone... we need to refresh manually! So, is there any way to set a parameter somewhere to have the queues status refreshed automatically?
Thanks a lot.
Last answer 3 days ago
I have two local instances:
- IRIS for Windows (x86-64) 2018.1.2 (Build 626_3U) Wed Jun 12 2019 19:07:59 EDT
- IRIS for Windows (x86-64) 2019.1 (Build 510U) Thu Mar 14 2019 14:13:37 EDT
I'm using Java Gateway to talk to external system.
Both instances are using the same:
- jar
- generated class
- java version
They are calling the same method with this java signature:
Last answer 4 days ago
The DeclarativeCOS project is a heartfelt cry about programming in the COS language.
The purpose of the project is to draw attention of the public to improving the inner core of COS.
The idea of the project is the support of a laconic syntax for cycles and collections.
So what is this laconic something that I have come up with? Welcome to the examples below!
Examples
The key concept underlying the project is the declarative approach to writing code. You need to specify WHAT should be used and HOW.
Last comment 4 days ago
Hello,
I want to create a dashboard with a line graph that shows system availability over time. I used this code to create a Dashboard:
Set tItem = ##class(%DeepSee.UserLibrary.Link).%New()
Set tItem.fullName = "Availability"
Set tPage = "Availability.UI.CSVImport.zen"
Set tItem.href = $system.CSP.GetPortalApp($namespace,tPage)_tPage
Set tItem.title = "Availability"
Set tSC = tItem.%Save()
Last answer 7 days ago Last comment 4 days ago
Hi,
Is there any way to set environment variables in Linux from Cache?
I see a way to get an environment variable with: $system.Util.GetEnviron()
Essentially I am converting from VMS (DCL) to Linux.
In VMS we used $ZF(-1,"SETSYM") in Cache to a value and then interpreted that value in a DCL procedure.
Last answer 6 days ago
Hi
Sometimes I have Atelier gettinng stuck on background task "Updating server container".
This maxes out one of the cpu cores and I end up having to kill the process. This is on version 1.3.139.
Last comment 6 days ago
Hi, Is there a way to connect to a MYSQL ODBC? I tried using the SQL Connect class but getting an error.
Last answer 7 days ago Last comment 6 days ago