When working with a large query executed though an ODBC connection what is the best way to allow the paging of the results at the client side. I have tried some methods using %VID and similar methods, but these really don't seem to work as the value returned is related to the ID of the data and not the position in the results set. What would be ideal is if the value seen in the management portal when you check of "Row Number" was available to external queries through ODBC. I have not seen a way to return this however. This would be similar to SQL server Last n and Skip n capabilities.
How are we doing THIS year versus the same period LAST year?
This is a common need in Business Intelligence. In fact, many design specifications for reports make use of a comparison between a selected period (year, quarter, etc) up to a certain date (for example November 15th, 2016) and a summary of the same information for the previous year (i.e. up to November 15th, 2015).
This post shows how to implement this in DeepSee.
I just received three subscription digest emails that seem to have come from the past. For example, one included this fragment:
But when I follow the link from the email the article date is much older:
Did the DC software have a glitch?
Hi all,
I've a problem with EnsLib.FTP.OutboundAdapter
I've configured this adapter using a SFTP connection, it has been working the first time but now its raising the following error message:
ERROR <Ens>ErrFTPPutFailed: FTP: error al colocar archivo '1600000107279008930.pdf' (mensaje='Error in SFTP Put('C:\stream\QhFaDm4L1Jrgbg.stream','mypath/1600000107279008930.pdf') ERROR #7500: Error SSH '-2146430933': SSH Error [8010102B]: Unable to send FXP_OPEN* [8010102b] at SFTP.cpp:539,0',código=0)
This is part of my code:
try {
set name = pRequest.FileName
set ..Adapter.FilePath Hi!
I want to optimize the cube and delete the measure. Is there any easy way to find pivots which use it?
Does anyone have any snippet regarding this?
Would be great to have "out of the box" dashboards which will show the dependencies of pivots vs measures and dimensions.
Hi All,
I am new to this technology and I have installed the trial version of cache 2016.1 with Normal security.
I was trying to develop the sample cinema application and mean while when I tried to view the csp webpage, it opens the browser and ask for login after logging in it shows Service Unavailable error instead of preview of webpage.
Could you guys suggest an answer to resolve this issue.
The 2017.1 FT keys expired on December 31st 2016. Can we have a new set?
There is no obvious way to provide feedback to the development community. In order to find the topic to find open discussions, I had to search for "feedback".
There should be links in standard places; without doing research these place probably include: menu, front page, footer.
This article is one of the series which introduces Eclipse to experienced Caché/ Ensemble/ HealthShare users. The goal is to open the perspective of a developer who was using Caché Studio for years and make Her/ Him see deeply into the Eclipse world – far beyond Atelier. In other words it is an Atelier (Eclipse IDE for InterSystems technology) beginner’s guide. This time the topic is: editing XML files using Atelier.
Question:
How do I get a list of files residing in a certain folder/directory, according to some wildcard/filter.
For example all '*.txt' files in 'C:\Temp'.
Answer:
In CACHE –
You can use the %Library.File's FileSet class query.
Here's some sample code using it (also attached):
run(pDir,pFileSpec)
Set tRS=##class(%ResultSet).%New("%Library.File:FileSet")
Set tSC=tRS.Execute(pDir,pFileSpec)
Write "Name",?30,"Date Modified",?53,"Type",!
Write "--------------------------------------------------------------------------",!
While tRS.Next() {
I'm currently re-engineering an application from CSP pages directly accessing COS Methods, to an Angular/Material front end accessing a REST DAL. Both the Angular front end and REST services are hosted from the same Caché instance and the same namespace, but the REST services have their own CSP application, with all calls being routed through a Dispatch class.
I've come across an architecture issue recently, and am trying to assess the options I have. At present, we encode a call to a class which takes in an OID and returns the Stream to the browser. In the current application, this reques
Hi
I am facing issue with cache database it is part of schneider PES software..the issue started with below:
and after some reinstallation i became not able even to install it.
receiving always message:
"could not locate installation directory" ....i can only select new instance ...
How i can remove all the registry and old cache instance to have new fresh installation.
the boss started using his new mac laptop, and now we are getting macintosh's own html escape characters being stored in the database especially in our text blocks, when we then print it we see things like don%u2019t instead of don't
so for example instead of the apostrophe we see %u2019 being stored. We've already noticed %u2018, %u2019, %u201C, %u201D, %2026
I'd like to replace the %u2019 with the nearest equivilent (especially when he starts to use left and right quote marks)
so how can I efficiently start to replace the
%u2019 with the apostrophe
%u2026 with the "..."
and there's bound t
Hello!
My group and I are currently doing a research project on natural language processing and iKnow plays a big role in this project. I am aware that the algorithms iKnow use aren't public, and I respect that.
My question is, are there any public documents/research that explains, at least part of, the algorthims iKnow uses and the motivations for using them?
Here is a concrete example: We are using GetSimilar() for many of our results and it works very well. As the documentation states we can choose to look att entites, crc, or cc and choose between the algorithms SIMSRCSIMPLE and SI
When deciphering an error message (<MAXSTRING>main+45^LBZNSJHCACUPLB), my understanding is the error offset is 45 lines from "main". If there are "go sub" entries within this 45 lines, do you count the lines in the "go sub" section or do you do a straight count of lines ignoring the "go sub" section?
Announcing the Custom Business Components learning path! This learning path is designed for software developers who need to build custom business components for their productions.
Hi all,
what reason for DBACK job process lock at time running full backup?
Hello community!
After reading a lot near InterSystems's Jobs and Terminal I/O documentation sections multiple times, I still does not understand one concept.
Maybe this question will be kind of incorrect, but please take it as is: is it possible to change the current device to be terminal device?
Let me explain what I want to achieve.
I have a jobbed process, which current/principle device is //./nul:6932, and which is spawned by TCP device |TCP|1972|936. And for the jobbed process I want almost-everything to behave exactly the same way as it behaves for Caché TERM. This particular thing ##class
Internally we use splunk for monitoring applications and network.
Does Ensemble have a way of exposing internal metrics and/or a way of exposing custom built metrics?
I've used Deepsee dashboards in the past to monitor Apache Tomcat/Apache Camel/hawtio using JMX rest calls. This is the other way around and ideally I'd like to expose metrics on:
- HL7v2 messages (broken down into types)
- Production performance
- Error and Warning.
Understand Ensemble 2016.2 includes Java 8 JVM and was wondering if the JMX route (plus hawtio) is the way to do this?
Intercepting logging and exposing that in a splunk friendl
hello
Cache telnet is running slowly on 64-bit, what could be the problem?
Hello!
I have detected an error in CACHE 2016.1.2, on both 32 and 64 platforms, when loading the autocad application, it fails. This did not happen in CACHE 2014.1.4.
Cache rendering of an old classic:
s enc="dQZ4nK1VzU7DMAy+I/EEveTcCWicpt3UU2VABTRA/AhBeYW+As/U7vE4VNhxypJuoAlhS1vixJ//"_
"06TNsy5p4TppzRKTNqtMXuXQjSSrdEPSEmmtK1uZssp1l0Z3nHJ9fEQroJURlQLHNE35WPYWx7N3"_
"YpJYkeRe4mQzkEKuGDwjkHTBP+9JW4oUsB+Y2CVj2JuttlkFAbhbfdIuRU/jhvZkryejtNok7UpO"_
"Moww3JbdcPifW8APosVi4Q9Otwck5LMojmKOojNnDUIXe0XEvnVrdaEeiF95H8BYgXG38o6i0Vpg"_
"lhSO00TVkN6VelRPaq1q9ehucnizrGopJ5TY+8zHzOBSPih8jjnLQWbyKSYy25Cpe+JXMTdM2dZS"_
"cbAu3YP42EQw4GOq1a16VjfEtWoCGHJdS5dAjkPoYgRTCsw8DG4MaSAw2G++KfA6So0v9xTJVmHD"_
"0UjTAeD4TQ7oRr1EMMbXm2N6IyO1AxtDLS2NCBqHiCIYX+9hLxGGtCxk2Me0D8Q5eknNcafHi, Community!
Please see the digest of Articles and Questions published in December 2016.
Most viewed
Declarative development in Caché 383
RESTForms - REST API for your classes 267
Licensing: Ubuntu and SUSE with 2017.1 and later 259
Merry XMas :) 250
Platform Compatibility: HP Open VMS 177
InterSystems Technologies on Amazon EC2: Reference Architecture 174
Atelier, The Productivity Boost Tool 170
InterSystems Developer Community Birthday! 167
Most voted
When an error occurs in your application, simply logging it might be enough. But for certain errors, you might want to send a notification to people right away. There are three ways to generate custom email notifications from InterSystems IRIS.
As stated, I have ZEN report, which I want to render in displayxlsx mode.
Currently it looks like this:
I want it to look like this:
Differences are:
- Bold header
- Cell width fitted to widest row or header
My report definition looks like this:
XData ReportDefinition [ XMLNamespace = "http://www.intersystems.com/zen/report/definition" ]
{
<report xmlns="http://www.intersystems.com/zen/report/definition"
name="MyReport"
sql="SELECT TOP 10 Name,DOB,Age FROM Sample.Person"
runtimeMode="0">
<group name="Person">
<attribute name="name" field="Name"/>
<attribute name="doHi all (and specifically Eduard L. ;)
The Ensemble Workflow REST API provided here:
https://github.com/intersystems-ru/EnsembleWorkflow
(and mentioned before in this Community, also as the basis of the Angular UI, also available in the same Git)
Has some very basic documentation as to how to work with the API (which also seems to be possibly a little out-dated as I think the /login URL is deprecated, for example).
Is there somewhere a more comprehensive documentation of this API?
Some of the API calls are quite simple and straightforward but others [specifically POST /tasks/:id] require in-depth kn
I am trying to create a query that returns the best and worst performing products for a given customer, based on this year's net sales versus last year's net sales, weighted by the total net sales for all of the products sold to this customer in the last two years.
I have created Last Year Net Sales (up to the last month end): AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-13]),measures.[Net Sales])
This year Net Sales: AGGREGATE(PERIODSTODATE([Invoice Date].[H1].[YEAR],[Invoice Date].[H1].[Month].[NOW-1]),measures.[Net Sales])
Percent change: ((AGGREGAT
I want to generate a list object of routines from the ^$ROUTINE global without directly reading the [^$ROUTINE] global.
E.G. I want to create an array/variable/object with names of all routines that start with "ABC" so that an application process can use each routine name as input for a subsequent process.
Hi guys.
Do You known If Caché has suport to Common Table Expressions (With queries)
By example: https://www.postgresql.org/docs/9.6/static/queries-with.html
I use DataGrip (JDBC client) to query Caché server via JDBC.
The problem I encountered, is that if I wait 10 or more minutes between queries I get an error:
[08S01][461] Communication link failure: Socket closed
To fix that I need to disconnect and connect to server again. Is there a JDBC timeout setting somewhere I can change?
