I have created store procedure using management portal.
how to alter or modify SP using SQL in management portal.
Please refer below screen.
.png)
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 1 days 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
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
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
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
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
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
Management Portal, ObjectScript, REST API, REST Services, SQL, Studio, Caché, Documentation, Online Learning, Worldwide Response Center (WRC)
Hi Guys,
Last answer 17 July 2019 Last comment 7 days ago
I have a list property that I query from the database to get the values contained in that list using $LISTFROMSTRING() when the list is returned the list values contain a rectangle like character similar to when you copy past something to the Terminal and it has a preceding space .The problem is I need to compare those values to other values and they do not match because of this value I have tried to use $EXTRACT(value,*W) and *P but this is not striping the preceding character how do I get rid of this character any ideas please.
Last answer 7 days ago Last comment 7 days ago
SQLCONNECT1 = tableUsers
SQLCONNECT2=tableLogEntries
select * from tableusers u, tablelogentries e where e.userid = u.userid
I keep getting the error References to an SQL Connection must constitute a whole subquery
Last answer 8 days ago
Hello All,
I need some help:
I would like to create Web Application using our ZEN with Cache DB so please guide me.
1.What is difference between zen page and zen application.
2.what is the difference between Client Method and server Method then where to use it.
Thanks.
Last answer 10 days ago Last comment 8 days ago
Hi
Is there any way to control what control sequence is sent to a device when a "write #" is executed?
I have an application that establishes a banner at the top of the terminal window and when we do a "write #" the banner disappears. I need to be able to recreate the banner line as part of the screen clear.
Thanks
Jenna
Last answer 9 days ago Last comment 10 days ago
Hi,
I am trying to use the LogicialToDate method in the %Library.FilemanDate class. In the class documentation it talks about the parameter STRICTDATA (see below). I would like to set the STRICTDATA to a 1 but I am not sure how to do that when using this method because the method does not reference this as a parameter to be passed into it. (see below).
How do I set the parameter?
Thanks
Last answer 10 days ago Last comment 10 days ago
I have created a custom container that contains medication adherence data. I want to know the best-practice way of querying the data for to display in a custom Zen page in the Clinical Viewer for a given loaded patient.
Let's say the custom class is called Hospital.Data.MedicationAdherenceData. Let's say the streamlet class is Hospital.SDA3.Streamlet.MedicationAdherenceData
Last answer 8 August 2019 Last comment 10 days ago
I got stuck with this for 2 days, please help me
Actually my logic is when I enter the input on the text field in browser, the entered input to be print on the next page but I am getting "Undefined". How to i do it.
Below is my code:
Last answer 12 days ago Last comment 12 days ago
Hi,
I had written one .net service for excel validation , after validation the data will be inserted in DB. I am getting value from an outbound message but the values are not inserting in DB. i have two classes one is for reading the value from excel and convert that into ensemble objects, here i am getting value. Another class for inserting the values from the ensemble objects but here i given a global variable for checking . It's shows global variable does not exist. I don't why it's not entering to 2nd class. Please give me the step by step explanation
Last answer 12 days ago Last comment 12 days ago
Hi! I am creating a Jasper Report using IRIS like DB, I've created my Data Adapter to connect with my DB configuring the JDBC connector and it works perfectly:
.png)
But when I try to create a report connecting to my DB I am getting this error:
.png)
This is the error in detail:
Last answer 13 days ago
I would like to allow some departmental user to view the ensemble portal. I want to make sure they are not allowed to do any changes (like stop and start interfaces from portal)
I have created one userbut limited with SQL privilages. But using this account, the portal view is not accessible.
It would be appreciated if anyone can adice me on this. I know this may be a silly question.
Regards,
Bava
Last answer 13 days ago
is there a script with MDX language that's works like the function ISCROSSFILTERED in DAX?
ISLEAF() doesn't work if I select more than one member in the slier.
Thank you for your help.
Last answer 8 August 2019 Last comment 13 days ago
Hello gentlemen,
here is my question: I would like to delete files one by one (not all at a time because I need to check somethinkg to delete it or not) in a defined folder but how can I handle it? I have used the extension :
Last answer 8 August 2019 Last comment 13 days ago
Just wondering if anyone knows if there is a way to get daily emails or alerts about changes to a cache database. I know that all of that information is contained within the journal files, just wondering if there is a way to bundle it up each day and send it off for auditing, etc.
Any solution where a plain-text/readable format of changes to the cache database could be sent or stored for review would solve the issue.
Thanks!
Last answer 8 August 2019
I want to debug my class method when call REST service using postman.
Last answer 8 August 2019 Last comment 8 August 2019
Hello,
There is a problem connecting clients through ODBC.
"ERROR [08S01] [Cache ODBC][State : 08S01][Native Code 459]
Connection via cconnect failed:
TCP connect() failed - exception satisfied select().
Reason: (10061, 0x274d) No connection could be made because the target machine actively refused it."
Error sometimes occurs. In cconsole.log there are only messages about high CPU usage.
ODBC and Cache version Cache for Windows (x86-64) 2013.1.4 (Build 801).
Any suggestions?
Last answer 8 August 2019 Last comment 8 June 2019