Caché

Syndicate content 123 

Description

  

InterSystems Caché is a multi-model DBMS and application server

See more details here.

Documentation.

Download Caché Evaluation

I'm having trouble creating a view in cache with query like:

 

SELECT column1, column2, column 3
    FROM  table
    WHERE
        (column1, columnn 2) IN (SELECT c1, c2 FROM table2 GROUP BY c1)
    ORDER BY column1

 

I think the problem is in where clause, because it cannot take two columns .

 

the exact error: [SQLCODE: <-1>:<Invalid SQL statement>] [%msg: < ) expected, , found^ (column1,>]

 

Any idea on how to solve this?

 

Thank you.

Continue Reading
Natasa Klenovsek Arh's picture
Post by Natasa Klenovsek Arh 31 January 2017
Last answer 31 January 2017 Last comment 31 January 2017
0   0 0
2

answers
1

comments
29577

views

0

rating

I need to pass a parameter string that contains slashes to a REST call.

I tried URL encoding, or making URL map to accept query parameter instead of path parameter but apparently we only allow for path parameters.

I can come with several workarounds, but these involve some transformation at client and then on server, but I'd prefer a direct support.

Q1: is there any Cache specific trick to pass slashes in path parameters

Q2: are we going to support query parameters in REST?

something like this would help: 

Continue Reading
Daniel Kutac's picture
Post by Daniel Kutac 1 June 2016
Last answer 1 June 2016 Last comment 1 June 2016
0   0 0
3

answers
5

comments
13925

views

0

rating

WebSockets look to be supported reasonably well in Cache. I have yet to use them in production so I am wondering how well it has worked for other developers.

In particular what happens when the browser does not support WebSockets, or when a firewall blocks the connection.

Have you had to write your own long polling fall-back?

I've read the documentation and found this interesting article...

https://community.intersystems.com/post/asynchronous-websockets-quick-tutorial

Continue Reading
Sean Connelly's picture
Post by Sean Connelly 19 April 2017
Last answer 21 April 2017 Last comment 22 April 2017
0   0 0
5

answers
10

comments
9633

views

0

rating

This question came on the Ensemble in Healthcare email list. It's a great question. I'm working on an answer, but am posting it here to get any other input. I'll also address the option of using %CSP.REST.

Hello everyone,

 

Continue Reading
Joshua Goldman's picture
Post by Joshua Goldman 16 March 2016
Last answer 10 May 2016 Last comment 25 March 2016
+ 2   0 2
5

answers
7

comments
6803

views

+ 2

rating

I have been using the query below and it was working fine but now it's giving a SQL error. There were no changes made that could cause this to stop working. There is no Field 'APPLICATIONID' in the table.

QueueSQL=select distinct (convert(char(5),SkillsetID)+'='+Skillset) from iagentbySkillsetStat where ApplicationID > 10000
QueueMappingSQL=SELECT DISTINCT (convert(char(5),SkillsetID)+'='+Skillset), SkillsetID FROM iagentbySkillsetStat iagentbySkillsetStat WHERE (iagentbySkillsetStat.ApplicationID>10000)

DB- Intersystems Cache

Continue Reading
Neeraj Mehta's picture
Post by Neeraj Mehta 15 September 2016
Last answer 16 September 2016 Last comment 16 September 2016
0   0 1
2

answers
4

comments
2460

views

0

rating

Hello,

I'm working on integrating a Cache database into an existing .NET project of mine.  I'm trying to execute certain queries utilizing the Cache ODBC driver.  The first error I ran into was "[S1000] [Cache ODBC][State : S1000][Native Code 417] Access Denied".  The part that's throwing me for a loop though is that the application ran ~200 successful queries before I started getting that.  After some of those Access Denied errors, they turned into "[Cache ODBC][State : S1T00][Native Code 450] Request timed out due to user timeout".  This was all with the regular (2.5?) driver.

Continue Reading
Jeff Burdette's picture
Post by Jeff Burdette 20 November 2017
Last answer 21 November 2017 Last comment 22 November 2017
0   0 4
2

answers
5

comments
2445

views

0

rating

I cannot connect to Cache from node.js  

I have installed in Windows 10 the following: CACHE 2016, node.js v 4.4.7 and  express .

-  where can I get cache.node? The link in the Intersystmes documentation  http://globalsdb.org/downloads/  doesn't work. I found cache0100.node and cache0120.node  in my Cache instance's  \bin directory. But I am not sure if I can use them or not.

 - how to install cache.node ? Where do I place it exactly? 

Can anyone recommend any tutorial or code example with installation instructions?

Continue Reading
Shavkat Shamukhamedov's picture
Post by Shavkat Shamukh... 2 August 2016
Last answer 10 September 2016 Last comment 4 July 2018
+ 1   1 8
4

answers
8

comments
2125

views

+ 1

rating

Hi

I have an Ensemble Application with many classes and relationships between those classes.

I need a tool that can connect to Cache/Ensemble and create a visual ERD from the class definitions within a particular Cache Namespace

MS-Access is one option but it does not automatically create the relationship connectors between classes

Any suggestions

Nigel Salm

Continue Reading
Nigel Salm's picture
Post by Nigel Salm 28 April 2017
Last answer 3 May 2017 Last comment 5 May 2017
0   0 7
4

answers
2

comments
2057

views

0

rating

Hello, I am writing some cache code that will pick up a PDF file, Base64 encode the contents and then send on to a third party system within a Long String (via their API). I have been testing this and discovered that the PDFs do not open within the supplier system (I get an error saying that it hasn't been decoded correctly). I wanted to prove that the issue does not lie with the way that I have Base64 encoded it within Ensemble, and therefore as a test wanted to Encode the PDF stream, then decode the stream and write out to a new file.

Continue Reading
John Flippance's picture
Post by John Flippance 2 June 2017
Last answer 2 June 2017 Last comment 2 June 2017
0   0 6
3

answers
4

comments
2028

views

0

rating

Hi-

Im curious if there is any specific configuration that has to be done on an IIS web server to serve up RESTful web services.

I have a server that has IIS installed, with the CSP gateway.  a second server that has Cache installed on it.

I have configured a web application using the Cache System Management Portal for the web services that has a dispatch class pointing to my dispatch class.

I have created an application mapping in my CSP Gateway Management Portal on the web server such that url's with /webservices prefix are routed to my cache server.

Continue Reading
Kenneth Poindexter's picture
Post by Kenneth Poindexter 31 January 2017
Last answer 31 January 2017
0   0 1
1

answers
0

comments

1924

views

0

rating

Hi All -

I was wondering if the below query could be enhanced to automatically look back 24 hours from the current datetime the query is run. As is now I, of course, have to update the date range in the WHERE clause manually.

The query is just getting all MessageBodyClassNames, counting them and then doing an AVG on TimeCreated and TimeProcessed. Nothing too complex.

 

SELECT MessageBodyClassName, count(ID) as Count_Of_Messages, avg(datediff(ss, TimeCreated, TimeProcessed)) as avg_processing_time_in_seconds

FROM %PARALLEL Ens.MessageHeader

Continue Reading
Roger Beeman's picture
Post by Roger Beeman 20 April 2017
Last answer 20 April 2017
0   0 2
1

answers
0

comments

1641

views

0

rating

Greetings,

Is it possible to save Cache code into a file and then run it via command line?  

IE:  csession [ini] -U [ini] /path/cacheCodeFile.?

What I need to do is run a Cache script from the Linux command line.  The script will navigate data to produce a file and then it will exit back to the command line.

Thanks in advance for everyone's time.

Continue Reading
Russell Knight's picture
Post by Russell Knight 31 August 2017
Last answer 1 September 2017 Last comment 31 August 2017
0   0 2
1

answers
1

comments
1618

views

0

rating

Hy.

 

I set up cache in container, which is working fine. But when accessing managment portal the default user was alway Unknown user and no username or password were required. So i disabled the Unknow user in the Security section, but now i keep getting an error access denid. 

Continue Reading
Natasa Klenovsek Arh's picture
Post by Natasa Klenovsek Arh 12 January 2017
Last answer 12 January 2017 Last comment 14 July 2017
0   0 1
1

answers
8

comments
1609

views

0

rating

I setup a linked server to a cache database to query the data and when I try an query the data I get 

 

OLE DB provider 'MSDASQL' for linked server 'xxx' returned data that does not match expected data length for column '[MSDASQL].CSFAELIGVENCITY'. The (maximum) expected data length is 20, while the returned data length is 23.

 

Should I be using a different driver when setting up the DSN?
 

Continue Reading
Kyle Johnson's picture
Post by Kyle Johnson 29 December 2017
Last answer 29 December 2017 Last comment 25 January 2018
0   0 1
1

answers
1

comments
1463

views

0

rating

I believe the I have followed the instructions to attach a document to the body of a post request but nothing is being sent out in the files{} port of the request.  I can either get the stream in "data", not visible at all, or visible but no form data. Any help would be appreciated, below is what I have:

Continue Reading
Josh Barney's picture
Post by Josh Barney 24 March 2016
Last answer 24 March 2016 Last comment 24 March 2016
+ 1   0 4
1

answers
2

comments
1381

views

+ 1

rating

Some may think it's a strange / daft idea, but just today the Raspberry Pi folks have announced that they've now sold more than 10 million of them..and counting.  That's a huge potential marketplace, and a great platform for getting people to hear about Cache and try it out.  Given its focus on the education sector, another great way of getting heard about.

 

Continue Reading
Rob Tweed's picture
Post by Rob Tweed 8 September 2016
Last answer 20 October 2016 Last comment 3 October 2016
+ 5   0 5
3

answers
13

comments
1362

views

+ 5

rating

We are building a bunch of rest based services using Ens 2016.2 to serve our browser based application (Angular 4).

Two questions:

1. The initial authentication seems only work if credentials are placed in the url parameters.  Trying to use the Authorization header instead, the client code immediately complains about Access-Control-Allow-Origin. How can I resolve this?

 

2. After initial authentication, what is the proper way to send subsequent rest calls without having to include credential every time?

Continue Reading
Pasi Leino's picture
Post by Pasi Leino 11 April 2017
Last answer 12 April 2017 Last comment 24 April 2017
+ 2   0 6
4

answers
3

comments
1285

views

+ 2

rating

Hi,

I have a situation where I write a character stream to a file. The file content gets signed and the signature is sent to a service provider together with the file content.

The signing is done using openssl.

This works perfectly on a dev PC, which is runnning Windows and has a little-endian architecture.

The problem is as soon as I do this on the server, which has a big-endian architecture, the signed value is incorrect according to the service provider.

The content is signed using RSA SHA256 with PSS padding.

Continue Reading
Stefan Cronje's picture
Post by Stefan Cronje 17 July 2017
Last answer 17 July 2017 Last comment 18 July 2017
0   0 2
1

answers
7

comments
1266

views

0

rating

Does anyone have any experience with getting, unfortunately, an older version of Cache to authenticate via SMTP to send email? I have verified that the settings are set up properly on the mailbox as I have successfully sent an email from a LAMP server, which comes from the same IP address.

If you have any thoughts, I would greatly appreciate it.

 

This is the error I receive

ERROR #6034: SMTP server connection failed during MAIL FROM command: <READ>zSend+105^%Net.SMTP.1.

Continue Reading
Mack Altman III's picture
Post by Mack Altman III 26 May 2016
Last answer 26 August 2018 Last comment 25 August 2018
0   0 4
3

answers
3

comments
1108

views

0

rating

Can anyone provide some sample in ObjectScripts to import a tab separate txt file into a SQL table?  I checked the document, there are two available classes, %SQL.Import.Mgr and %SQL.Until.Procedures, which one is better choice?

Thanks

Continue Reading
Gaolai Peng's picture
Post by Gaolai Peng 18 September 2017
Last answer 15 December 2017 Last comment 15 December 2017
0   0 2
7

answers
6

comments
1071

views

0

rating