New post

#Caché

41

  

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

Documentation.

I am attempting to pragmatically create a bunch of roles and then assign the appropriate resources to that role.

Currently, the only ways to add resources to a role are to:

1. Do through Management Portal

2. Go through ^SECURITY (add resource one at a time)

My Intention would be to do the following: do ^SECURITY Role Setup Edit Role When prompted for resources to add, be able to use *

0 2
0 319

I am glad to say that VSCode-ObjectScript reached 4000 installs. Thanks to all of you who use it in their work.

VSCode-ObjectScript is an extension for VSCode which allows you to develop InterSystems based applications on ObjectScript using the modern code editor developed by Microsoft. Choice #1 editor amongst all developers worldwide by Stackoverflow survey 2019.

Some short notes about how to install and configure it you can find here.

If you need any help with a migration process of your development team to VSCode, please contact us by info@caretdev.com.

Open Exchange app
4 3
0 319

Hi All,

We have few queries which are simple selects . For simplicity let's say there is a query that joins two tables and gets few columns and both tables have no indexes.

Select Tab1.Field1, Tab2.Field2
From Table1 Tab1
Join Table2 Tab2
On Tab2.FK = Tab1.PK

When we do query plan for this it shows approx 6 million, however if we make a simple adjustment to the query

0 5
0 319
Question
· Nov 7, 2016
Monospace output from Zen

Hi,

I have a problem which i think has a simple solution but which i and others haven't yet cracked. I want to display text output to a text box in monospaced font. At the moment the style sheet is shown below, I have tried various other options such as specifying a specific font such as Courier New. None of the browsers I have tried (Safari, Firefox on OSX, IE) display as monospace, although the last 2 come close. I wonder whether I need a <pre> tag, but I can't see how to do that in Zen.

Suggestions?

0 1
0 319
Question
· Jun 23, 2023
Dateconversion

Hi Community,

I need to convert date 1997-08-09 10:38:39.700000000 into this format 1997-08-09T10:38:39Z

I have tried using all date function $ZDH,$ZDT no luck can anyone help me to convert this into required format.

Thanks,

Smythee

1 5
0 318

Hello,

When i click on the menu to run the Data import wizard from MP, i receive following CSP error

<UNDEFINED>zOnPageHEAD+229^%cspapp.exp.utilsqleximwizardcontent.1 *schemaname : CSP Error

It is happening for all the namespaces. Looks like some permission issue. Same issue with Data Export wizard. Help to resolve this will be appreciated.

I am using

Cache for Windows (x86-64) 2017.2.2 (Build 865_0_18763U)

Thanks,

0 3
0 318

Activate Wizard by-pass

Cache-2016-1.2

1. how to bypass the Activate wizard ?, and run directly the Activate on: .NET x64 COM Assembly (.dll,.tlb)

with object script , something like :

D Activate^%CacheActivate("MyAssembly.tlb")

the MyAssembly.tlb , is ofcourse , a visible Element in activate Wizard table list

2. activate Wizard table list, sometimes throws an error #6101 ?

regards,

Emanuel

0 4
0 317

Have enabled LDAP for our numerous , Ensemble, IRIS and cache instances with many namespaces. All is working fine and the ldap logins work.

But have noticed that the first instance that the user logs into the namespace is assigned to that user, but when that user than logs into another instance the default namespace from the first login is still there and doesn't update to the new namespace.

So this doesn't effect the ldap login but is now effecting the terminal logins where the user is now getting access denied.

0 1
0 317

Hello, I am trying to get the Zen Print Server to work so that i can use the pdfprint mode in Zen Reports. Zen Reports will create pdfs just fine, so that part is working. And the printer works fine from other applications on this computer and I have verified the printer name a bunch of times.

This is Caché 2016.2 on Windows 10. I have tried this using Adobe 11.0 and Adobe DC. I have made and started a Zen Report Print Server with

Name = "ZenPrint"

Port = "4321"

and Ping Port = "4320"

0 4
0 317

Hello,

I need to create a util function that loops thru every character in the data, execute a $ASCII() against it. If it falls outside the realm of extended ASCII we toss it.

the function should receive a string, execute a for...loop across it's length and use $ASCII to evaluate the character. Also the function should return an output argument that indicates if the string is UTF8 valid or not.

could anyone help me with this?

0 1
0 317

Well I want to set the type of a piece in a global as a String, because when I use float numbers , the system parse them to numbers instead of use like strings and thats a little bit tricky with the sorts

Here is a code example:

ACB>s ^a("1.0012")=""// that is going to be stored as a number

ACB>s ^a("1.0011")="" // that is going to be stored as a number

ACB>s ^a("1.0010")="" // that is going to be stored as string

ACB>zw ^a

^a(1.0011)=""

^a(1.0012)=""

^a("1.0010")=""

0 2
0 317
Question
· Sep 5, 2022
Hl7 viewer component

Hi All

I'm building a ZEN page that will dispay HL7 from a database, and am currently displaying it an textarea.

Is the HL7 viewer that is displayed when HL7 message is selected in a visual trace available as an out of the box tool I can plug into a webpage?

Andy

0 2
0 316

I am working on a TrakCare JIRA issue that requires accessing class properties in a different installation of TrakCare on another machine. For instance, I need to compare the deprecated items in the current version of TrakCare to the deprecated items in a previous release. Is there anything in the built in classes that will allow me to do this, or is it something I'll need to do with a SQL stored procedure or something else I haven't thought of?

0 2
0 316
Question
· Aug 20, 2020
Programs and function cache

Hi,

Do you know if cache has programs and functions cache

I made a backup of my production base and when I use this function abouve I receve an error, but if I change any letter of the command the function go ok.

Didn´t work
SELECT $$JOB1^KMIGxDESIG() FROM DUAL

Work
sELECT $$JOB1^KMIGxDESIG() FROM DUAL

for this I.m using ODBC 64.

Thanks

0 1
0 316

Has anyone worked out a way to use LDAP to define the default namespace on multiple servers? I know that documentation says that intersystems-Namespace-xxx only supports one namespace, but how is this useful? Any workaround to say have intersystems-Namespace-server1-namespaceA and intersystems-Namespace-server2-namespaceB? Is it best practice to use the same "namespace" on every server?

Thanks!

0 1
0 315

I am trying to emulate a behavior we used to have on an older Cache' system, namely the ability to call "csession cache" from inside of .bash_profile.

On the older system, passwordless users were allowed, now password is required.

The desired behavior is to have user log into linux and go directly into our cache application, which is character-based.

I have tried this technique, without success:

csession cache < myfile.txt. where myfile.txt contains two lines, username on first line, password on second line.

0 2
0 315

I have a database with almost 1T of free space. I want to run the compaction process to reclaim and subsequently free that space. I am aware that this process is a background process but will the level of processing required to move this volume of space to the end of the file to allow for reclamation impact system usage while this process is running. Essentially, does this process run at a low priority and use processing as available. I am trying to determine if I should run this over a weekend or can this be run at any time.

0 2
0 315

Hello everyone,

InterSystems Certification has redesigned their IRIS System Administration certification exam, and we again need input from our community to help validate the topics. Here's your chance to have your say in what topics are covered on the InterSystems IRIS System Administration Specialist exam! And, yes, we'd like to hear from you Caché admins too!

Here's the exam title and the definition:

InterSystems IRIS System Administration Specialist

An IT Professional who:

0 0
1 315