New post

#Caché

41

  

InterSystems Caché is a multi-model DBMS and application server. See more details here.

Documentation.

Hey Community,

my Caché Version is 2013.1 and I can't update now.

I want to serialize a SQL Answer row into an Array filled with objects and then convert it to json.

Actually I use the following, which is very error prone when I have to do that often:

0 7
0 785

(We are in contact with IS support for this problem but I would like to ask Community too, perhaps somebody experienced this problem in the past)

Hello Community,

we need your help with Cache 2017.2 freezing on Linux machine.

Since we moved our primary production Cache from Windows to Linux in the begging of this year, we have experienced system freezing twice. Yesterday without any good reason Cache stopped to respond with the log shown below.

Questions:

0 5
0 1K

Hi All,

It must be the groundhog days but I can't solve something that I know I've done before. I have a legacy CSP page on a version of Cache without JSON and just pure Cache.

I need a CSP page that takes a .xlsx file, manipulates the file (in COS) and then returns a new manipulated file.

My CSP Page gets the file fine, the problem is then returning the response with the new file as an attachment. I don't want to pipe to a new csp page with a different content-type so was sure I can set %response.Headers etc to get the reply stream I want.

0 6
0 847
Question
· Jul 20, 2020
IDX Groupcast system from Cache'

Hello,

I posted in another thread a short while back regarding accessing (extracting) data from the Cache' database.

I am now told that the (healthcare) system is IDX Groupcast. The kick off project has not started yet but I would like to do some 'homework' and see the data model. I couldn't find too much about this in a Google search. Would anyone have a link or advise for doing some preliminaries? I am already versed in SQL server.

Thanks,

John Lisa

0 8
0 614

Hi,

Can anyone please explain me how to remove trailing squares from the text field (String). Trailing squares is a white space ?

I tried different things like Ltrim, Trim from sql query side and also from object scripting side something below.

If Address1 set Address1 = $ZSTRIP(Address1,"<>P,<>C,<>W")
If Address1 set Address1 = $ZSTRIP(Address1,"$C(9), $C(32), $C(160)")
If Address1 set Address1 = $ZSTRIP(Address1,"*W,*C")

Nothing works for me

Can anyone please help me to solve this

Thanks

0 5
0 796

Hi all,

I need some advice about JSON conversions and the outputs. I am being sent a JSON response from an API call and I am struggling to produce an output that I can use from it.

I have used the %FromJSON() method call to take the JSON stream source (pData) and convert it to a Dynamic object (object) but I am a little unsure as to how I can read the dynamic object and use it to extract the values from this and set the values as a property in another class.

The current coding I have for the conversion:

0 21
1 1K

Hi all,
By using VS code, I want to copy multiple files to local directory, then sync them to server, but I can't find where local directory is stored?
In Atelier IDE, I could open a view of server and can copy the code to the project, then code is saved in the local directory. When I copy multiple files to the local directory -> choose sync in Atelier -> the code will be synchronized to the server
How to do this from VS Code?
Thanks!

0 14
0 879
Question
· Nov 17, 2020
Terminal replacement

Hi

Has anyone found a good terminal emulator replacement for Cache Terminal?

We want one where the up arrow works to bring back the last command typed (without extraneous characters appearing at the beginning of the line) and be able to run D ^JOURNAL and have it display correctly.

I tried WebTerminal a couple of years back and but it didn't work properly with the journal. I've tried RoyalTS and that doesn't do up arrow or the journal correctly even though it's supposed to be emulating a VT400.

Any suggestions?

thanks

0 4
0 315

I am trying to connect to an external SFTP. They have our public key and I have the private key which is password protected. I have the credentials set to the sftp username and the password to the private key.

If I set the private key only, I get a username/password error connecting. If I set both the public and private key files, I get the error below:

ERROR #7510: SSH Error '-19': SSH Error [80101013]: Callback returned error [80101013] at Session.cpp:418,0

0 4
0 4.2K
Question
· Jan 10, 2021
Cashe-SQL cursor

the report generates statics for each ward and i want to divide specific ward 5c into two wards, the first 12 beds are for 5c - pediatric and the last 12 beds are for 5c-adults.

the report takes input from the user by selecting the wards so if the user chooses 5c, the report should show 2 wards.

the report declare cursor at the begining so how can i divide the ward.

0 2
0 298
Question
· Mar 9, 2021
Working with CSP files

i have a problem with CSP files, i can create a CSP file with termination ".csp" or ".CSP" and this configuration is case sensitive, but a CLS file, this configuration is not case sensitive. there is a way i can change this to the CSP file don't be case sensitive?

0 2
0 260
Question
· Apr 22, 2021
Cache code conversion tool

Hi,

I have a requirement to convert few screens having character based interface built in Cache to a web based interface in Java while still keeping Cache as the backend which means database will remain the same. Wanted to know if we have any tool in the market which can help doing that keeping in consideration that these screens in cache are using mumps code.

If we don't have any tool, would appreciate if someone shares their experience in the manual conversion as well.

0 6
0 382

Hi,

I'm getting thousands of errors like the ones below:

2021-05-03 14:11:44 [SQLCODE: <-400>:<Ocorreu um erro fatal>] [Cache Error: <<READ>Dispatch+14^%SYS.BINDSRV>] [Location: <ServerLoop>] [Client info: <Username: KIORAS, Node Name: 3IK0VLS5UU, IP Address: 192.168.1.223, Executable Name: EXTRService.exe, Internal Function: B0>] [%protocol: <52>] $Id: //ce/2018.1.2/kernel/common/src/aclass.c#1 $ 23468 104

0 1
0 638
Question
· May 14, 2021
Luhn Mod N in Cache?

Hi all

I'm trying to recreate this method below in Cache/IRIS.

https://en.wikipedia.org/wiki/Luhn_mod_N_algorithm ISO-7812-1 (LUHN-10)

I've been following the javascript example. It seems simple in theory but i'm struggling with which cache methods to pick.

$LENGTH, $System.SQL.FLOOR() - seem ok

$EXTRACT - I think for .charAt (though may need to correct base)

$FIND - for .indexOf

Any suggestion which would be the best ones for the job?

0 5
0 259
Question
· Jun 22, 2021
question

I am using .net to connect to the cache database via ODBC, OdbcConnection connection = new OdbcConnection(dbConnection); connection.Open(); This error is reported when the link is opened, how should this be solved? Thank you very much!

0 2
0 273

Hi,

I am running InterSystems iris 2021.1 from the container and I have version 2020.1.1 is installed locally. While running studio locally I am getting below error message:

"Version mismatch. Studio version 2020.1.1 unable to connect to server version 2021.1
Upgrade to a later version of the client to resolve this error"

Looking Forward

Thanks

0 4
0 490

Is there a way to get a report of how many messages are passing through a production? I am trying to gauge how many messages we process weekly, monthly, and yearly. Also, over specific months.

Would appreciate if someone can guide me on this

We use Cache for Windows 2017.1.3

0 7
0 377

Good morning everybody,

In Html sometimes we need to use entities code for don't have problems with browsers all over the world. Ex. 'á' is converted to code: '&aacute;' / 'é' is converted to '&eacute;'.

I have a question, how can i convert a string like my name to this type of code? Ex. "Flávio" will be "Fl&aacute;vio". I tried this way:

0 10
0 1K