Caché

I have a lookup table and record batch Table I would like to do a count on the records stored in that batch by counting the number of records in that batch that have  a certain key on the responseKey column. This column keys are stored in the look up table for comparison. So I would like to do a join sql pivot that will use my keys stored in the lookup as columns and count as values

so far I have managed to do this but this is not efficient I would like to fire that sql once not on every count

0   0 2
0

answers

360

views

0

rating

Hello,

I would like to schedule the Database Compact and Freespace methods as legacy tasks.

Has anyone implemented this yet?
Is this even possible? 

The request for this is due to the fact that we have 3 interfaces in a namespace whose messages are deleted after 7 days. All other messages in this namespace should be kept for one year.
This leads to a certain fragmentation. Furthermore, the messages to be deleted are relatively large (MDM^T02 > 32MB), which in turn leads to a fast growth of the database size. 

How would you solve this problem?

0   0 3
0

answers

0

comments

124

views

0

rating

I need to redirect user to a url, which is 5000+ characters long.
To do that I set:

set %response.Redirect = url

However, in the browser I receive this header:

LOCATION: <First 3972 characters of the 'url' variable>

In WriteHTTPHeader method of %CSP.Response, where the LOCATION header is
written:

Write "Location: ", <Redirect>,!

After I added a buffer flush, after the above-mentioned line:

0   0 2
0

answers

194

views

0

rating

Hi everyone

I encountered this error while trying to access a web service (I send a test message with soap ui):

FEHLER #5002: Caché-Fehler: &lt;CLASS DOES NOT EXIST> {my method &class name} .1 *(No name)

I am not able to understand what goes wrong. If I look at the trace on messages in the ensemble message viewer there are no errors. The response message displayed in the trace looks like it is successful but in the SOAP UI tool I get the error message in the response.

Last comment 14 August 2018
0   0 2
0

answers

247

views

0

rating

Hey everyone, 

Here's my issue, I would like to develop a web application which use and send datas to TrakCare app, but I really don't know how to communicate with TrakCare's datas. 

With a little research, I think I could use "RESTForms" or "EnsembleWorkFlow" but I don't really get how...

Can somebody help me and tell me the way forward ?

Last comment 21 May 2018
0   0 2
0

answers

158

views

0

rating

Hi,

we have Angular solution and Cache server. We need to have separate users and sessions on same browser (laptop, table etc) for every user and for one user with many connections.

Thought this was resolved, but unfortunately not.

-----------------------------------------------------------------------------------------------------------------------

I got the code away from here, because it was some how ok.

The session on server mixed, but no any more, thanks our folk and local engineer's tools :)

Last comment 4 September 2018
0   0 1
0

answers

228

views

0

rating

Is there a group in or outside of this community for discussion of DTM issues? I am working on a conversion to Caché for a client but in the meantime, he is still live with his DTM system and a system management issue has arisen. The convo:

Client: Do you know how to increase the page limit in MUMPS DTM?  One version of my database I use for one customer is telling me I have reached my page limit.  I have increased the page limit in the database you are reviewing; so I figure there is a setting I am missing.

0   0 1
0

answers

0

comments

111

views

0

rating

hi

    I cannot connect to Caché sometimes,   the error message is 

            [Cache JDBC] Communication link failure: Communication error: Connection reset

   and I cannot access the management portal

so I plan to restart  Caché with "ccontrol stop cache", it prompted "unable to get access to pid table"

what's the problem?

thanks!

       

Last comment 17 May 2018
0   0 2
0

answers

625

views

0

rating

SQL gateway. 'Locking' problem.

while debugging, is there in Caché a command to 'unlock' the instance of a class ?

close class, and kill class is not enough.

same problem in %Activate link

for each debug I have to exit (Halt) the terminal, 

make debug in C#

coming back , and re-load again in Caché.

Regards,

Emanuel

0   0 1
0

answers

0

comments

97

views

0

rating

When using the link component on a ZEN page the default behavior is for the link to appear to the right of the tablepane row. Has anybody changed this behavior so the link appears to the left of the tablepane row? Thank you in advance for any and all feedback.

0   0 1
0

answers

0

comments

82

views

0

rating

I tried to access Caché using ADO.NET. This works fine but when I want to use Entity Framework, I can't access the Caché Data Source.

I'm using Visual Studio 2017, and followed the procedure described in Caché documentation.

(This document has been written  regarding VS2013)

Did some meet the same problem ?

Thanks in advance.

 

 

Last comment 21 March 2018
0   0 4
0

answers

365

views

0

rating

Application licensing enables InterSystems application partners to take advantage of Caché’s licensing capabilities for their own licensing purposes.

Caché manages customer application licenses just as it does Caché/Ensemble and InterSystems application licenses, maintaining usage counts and acquiring and returning user licenses as needed.

Application licenses consumed by a process or a CSP session are automatically released along with the Caché license consumed by the process or session when a process exits, halts or is deleted from the process table, or when a CSP session times out or is deleted.

More in docs.

Do you use this feature? If so, how?

I'm especially interested in license validation and general workflows?

0   0 1
0

answers

0

comments

131

views

0

rating

Is Cache the preferred database source for extracting data elements for use in Health Share Patient Index or is there a significant benefit in sourcing data from a warehouse, data mart, or MV? I realize that could be a loaded question with 100 other questions that may follow, however, if there is a known advantage to extracting data from a particular data storage type, the answer may highlight that point. 

0   0 2
0

answers

0

comments

161

views

0

rating

Problems encountered with Java Gateway

I am writing a framework for use on the Java Gateway. The role of the framework is:

1. Import the framework jar file into ensemble studio (test completed);
2. In the framework jar, handle the related functions of the remaining jar files (the rest of the jar files are written by colleagues).

The general idea is as follows:

Send: Ensemble Java Gateway -> Framework Jar -> Plugin Jar (colleagues write, processing data).
Returns: Plugin Jar (processed return data) ->Framework Jar->Ensemble Java Gateway.

Last comment 29 March 2018
0   0 3
0

answers

347

views

0

rating

Hi,

I have a problem with CSP Application Authentication, when the user input you correct password, however the message "Invalid password" returns.

This error returns just Cache password user type, for user delegated don't.

this error is momentary also, if you wait a moment, it stops.

Last comment 20 July 2018
0   0 2
0

answers

244

views

0

rating