InterSystems Caché is a multi-model DBMS and application server. See more details here.
Hi All,
I need to build a search using a lot of filters, what's the best way to implement my sql requests.
1 sql request per property, or only one "big" sql request ?
what's the disadvantage of using lot of indexes ? Thank you
KR,
Amine
There does not seem to be any separation between the error code and error text in a %Status object. For custom errors, I simply want to display the message and not Error #5001: Some error text.
In one of the projects, when we have ECP with 10 ECP application servers, from time to time we faced the issue when our journals fail to purge, due to open transactions. While we have about 100-150 GB journal files per day, it quite quickly became a big issue, and with mirroring a very big issue. Mostly we just rebooted our ECP Data server, so it searches rollbacks any transactions, but such process is too long, may steal a few hours. I did not find any way, how to get the list of the open transactions from one place from ECP Data Server. We just migrated our Data server to 2018.1.
Hi All,
I'm having an issue where I try to use SOAPUI for a mockup offline service, my issue is when I have the mockup service running in the background and try to send a request from cache I keep getting the following error: "ERROR #6454: No supported policy alternative in configuration".
I've tried to follow the common guidelines for resolving this issue but no luck.
So if there is maybe a nice article explaining how to send a proper request to the mockup service and then getting the response(which will be hardcoded values I've set).
Regards,
If a picture is worth a thousand words, what's a video worth? Certainly more than typing a post.
Please check out my "Coding talks" on InterSystems Developers YouTube:
1. Analysing InterSystems IRIS System Performance with Yape. Part 1: Installing Yape
Running Yape in a container.
2. Yape Container SQLite iostat InterSystems
Extracting and plotting pButtons data including timeframes and iostat.
Can anyone clarify to me about the differences between these two classes?
People in this topic https://community.intersystems.com/post/using-class-queries-sqlstatement-versus-libraryresultset stated that %SQL.Statement (I am assuming they mean to talk about %SQL.StatementResult) is newer than %Library.ResultSet. But I don't really know what are the advantages of %SQL.Statement over %Library.ResultSet as the people in the topic somehow didn't mention them.
Currently I have a case and it seems like the %SQL.
What if you could serialize/deserialize objects in whatever format: JSON, XML, CSV,...; attending different criteria: export/import some properties and not others, transform values in this or that way before exporting/importing,...; and all of this without having to change the class definition? Wouldn't that be great??
Well, perhaps it's a goal too ambitious to reach 100% but, exploring this idea, I've developed a bunch of classes that I thought it was good to share. If you want to test, change, modify or improve the code, or just take a look at it, you can do it here. There you'll find a more detailed explanation (see Readme.md)
I am new to Intersystems cache COS scripts (cache is a client system). ThoughCOS scripts basically appear to be straight forward, I am having issues with the logon credentials. From what I have found in the documentation, the first 2 lines of the script contain the U/P. When running the script, the username is picked up correctly but the password is not. Granted, having U/P in a script is not ideal but will suffice as a matter of learning if I can figure out the formatting/syntax required. Any help on this would be appreciated.
Kevin McGinn
Where can i get the latest odbc providers from SQL Server 2012/2016?
I see some posts on line to an ftp site out there but I am unsuccessful at getting access to it. I have a version loaded on my server but get errors when querying cache'.
"[Cache ODBC][State : 22005][Native Code 22005]"
Any help would be appreciated.
the one we have might be version 2014.01.05851 64 bit (would that make sense?)
Hi,
I would like to know if it is possible to use windows command line , instead of Intersystems Terminal , to connect to Caché and do objectscript commands or SQL requests as a client.
Thank you for your help
I have a simple python script to pull table information from cache 2018.1.2 which is on a windows 10 machine. I get no results though the same query in the management portal works correctly:
import os
import sys
import intersys.pythonbind3 as ipyb
import numpy as np
# Connect to the Cache' database
url = "localhost[1972]:%SYS"
user = "xxxx"
password = "zzzzz"
accessKey = (url, user, password)
def main(accessKey):
tbList = []
# Get the connection and database handles
conn = ipyb.connection()
conn.connect_now(accessKey[0],accessKey[1],accessKey[2], None)
database = ipyb.
Hello,
I am wondering if it is possible to access properties of a class from within a routine that has been called. See the below example:
Class TestClass Extends %RegisteredObject
{
Property Data As %ListOfDataTypes;
Method Query(parameter As %String)
{
d runTag^ExampleRoutine(parameter)
q
}
}
And then I have a routine:
ExampleRoutine
runTag(parameter)
;I want to add some information to the Data property in the class here.
q
Let's say I start with a date range of '1-5-2019' to '5-25-2019' that occurs on one row. I'd like to ultimately have this show as 5 rows in Crystal Reports as shown below
Result
1-5-2019 1-31-2019
2-1-2019 2-28-2019
3-1-2019 3-31-2019
4-1-2019 4-30-2019
5-1-2019 5-25-2019
I found a result that worked in T-SQL, but I'm not sure how to translate it to Cache SQL. The T-SQL code is
select dateadd(d,N.number,d.begindate) adate, data
from data d
join Numbers N ON number between 0 and datediff(d, begindate, enddate)
This code fetches a row for every day between the begin date and end date.
In T-SQL, I can create a recursive CTE to create a subquery or a view that will hold a whole lot of numbers. Is there a way to do this in Cache SQL? I'd like the numbers from 0 to 10000 if possible.
Thanks!
Do you have any clue how to create a list of messages in studio ?
Example :
I can define one message that is called DoctorInfoMsg such as
Property UserName As %String;
Property ListOfPatients As list Of %String;
How to define a list of PKGNotification.InDoctorInfo messages ?
How to get UserName of the first message?
Ladies and gentlemen, good news for our town.
It finally happened - M was put in the cell.
And feels great there. Maybe it not a prison but an Excel cell.
Being there, he leads the whole M-gang. As well as conditional formatting in EXCEL.
Close integration of excel with the database provides a new convenient design tool.
Interactive reports, input forms, diagrams are generated only by m-commands in cells, without classical programming.
More detailed on https://github.com/mx-alex/MX
We will monitor the development of the situation and answer your questions.
best wishes
Alex
There is a special Query for reporting, it takes one cell of Excel. Example :
?$$omQuery 113^oPeat | Country Country:Province Date Product:Date Date:Product:-zr | tn EURO | zrzr| | if Date'<%XD81,Date'>%XD82 | set zrzr=zr,EURO=summa
The omQuery sets the structure and content of the required documents as well as filters and data processing procedures.
In one request, up to 9 reports are created, with subtotals by group.
Our company is in the process of converting our software for use in Intersystems IRIS and one of the major sections of the software makes use of a custom statically-linked C library using the $ZF("function-name") functionality. During this, I found out that the process for setting up the C library to be used within the database platform has changed significantly between Cache and IRIS.
Hello,
I have a class I'm working on that is extending a base class that contains the %GetComponentByID method and a section of the new code I'm writing uses %GetComponentByID but when I attempt to compile the class I'm getting an error that says the method doesn't exist.
Am I missing something to be able to include the GetComponent method in an extended class?
try{
....
....
....
Set tSC = method_invocation()
If $$$ISERR(tSC) {
Quit tSC
}
....
....
....
}On compiling the above, I get an error saying "QUIT argument not allowed : 'tSC' ".
Hi
I'm trying to create a form on a csp page, with input elements binding to data using the cspbind attribute.
All is working fine when i use string literal as in
cspbind="UserName"But trying to set the attribute to runtime expression doesn't work for me, i.e:
cspbind= #(..EscapeHTML(query1.GetData(col)))# The same rt expression produce the desired string when used in other elements, i.e:
<p> #(..EscapeHTML(query1.GetData(col)))# </p> -> will produce 'UserName' on page.
Are there any known limitations for this attribute?
I'm using version:
Cache for Windows (x86-64) 2015.2 (Build 664
Thanks
Hello,
We have the following code:
{
set ..MTOMRequired = 1 set ..SecurityOut.actor = "http://www.gobiernodecanarias.org/Platino/Authentication/1.0"
set ..SecurityOut.mustUnderstand = "1"
set ..SecurityNamespace = "http://docs.oasis-open.
First,
Forgive me if this is a rather low-level question - I am a physician informaticist who is learning cache/mumps for the first time. I am sure this probably relates to some setting but I can't find a similar issue anywhere.
When I create a list, and then try and return that list - I get a bunch of symbols back along with my results, or sometimes I just get symbols.
I pasted a screenshot below. Thank is advance for the help!
Anthony
Conversion Sequence step 4 (see table below)
Over the last few months, we have made changes to InterSystems IRIS to make it easier for you to move from Caché/Ensemble (C/E) to InterSystems IRIS. The most significant adjustments are the re-introduction of non-Unicode databases and the in-place conversion. InterSystems IRIS now fully supports non-Unicode databases with all the functionally that already exists with Caché. The in-place conversion supports an upgradelike process to install InterSystems IRIS right on top of your existing C/E deployments.
I was searching for the most simple way to connect from visual studio code to my local instance via terminal without having to change any window.
I know this can also be achieved via telnet but seems a bit overhead if you're in your local machine.
For me the simplest sollution is to open a terminal window in VS Code, navigate to the /bin folder of your instance installation and run .\csession.
Hello! This article continues the article "Making Prometheus Monitoring for InterSystems Caché". We will take a look at one way of visualizing the results of the work of the ^mgstat tool. This tool provides the statistics of Caché performance, and specifically the number of calls for globals and routines (local and over ECP), the length of the write daemon’s queue, the number of blocks saved to the disk and read from it, amount of ECP traffic and more. ^mgstat can be launched separately (interactively or by a job), and in parallel with another performance measurement tool, ^pButtons.
Currently, when we want to write data to a file that will be viewed in Excel, we parse the data in tab deliminated format to the file and name it with .xls at the end. That is sent to end users via email. They get a warning that the data is not formatted properly (it's not really an Excel file after all) but it does display somewhat correctly as the tabs are understood (this does not work if we deliminated with commas however).
How can we format the file for Excel?
Hi,
I am using a record map and when the less than symbol < is sent the record mapping fails. How can I escape this character so the record map will not fail.
Hi all,
i‘m traying to run a sql LIKE Query on an attribute datatype LONGVARCHAR.
I also try allready with the SUBSTRING(Attribute,1,...), when i run the query, the resultat is empty without errors.
The Query:
select text from table
where text like ‘%abc%‘
many thx for help
BR
Darko
With ^%SYSMONMGR, there are some brunches that I never found a way to quit out, like shows as the following example: do ^%SYSMONMGR --> Manage Health Monitor --> View Alert Records ...
Does anyone know the answer? thank you very much.
%SYS>do ^%SYSMONMGR
Option? 6
Option? 2 Sensor (