Caché | InterSystems Developer Community

Question

Kishan Vaja · Jul 1, 2021

How to add time slot and theater in Cinema Application

I want to add time slot and category metadata to complete my cinema application.

I am following the documentation of the cinema application "https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=TWEB2_..." and in that,

I was trying to add theater and time slot. But I was not able to do that.

I was also trying to filter the records as per the ratings and category selection on the search bar. but this is showing some error.

#CSP #Caché

0 2

0 226

Question

Kevin McGinn · May 31, 2022

System impact of compacting to reclaim large space

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.

#Caché

0 2

0 315

Question

Anthony Benigni · Jan 26, 2023

Iris.dat and upload to iris community Edition

Have a iris.dat file that was zipped in axis but , now I unzipped it and can see the file in my c drive but when I go to iris management console to perform a new db to pull in the current iris.dat file , in the wizard I do not see the iris.dat file listed.

Need some help with getting it restore the Cache backup in my iris community edition.

thank you,

#Databases #Caché #InterSystems IRIS

0 2

0 293

Article

Mihoko Iijima · Nov 30, 2023 3m read

How to programmatically retrieve a list of user-created classes

InterSystems FAQ rubric

Class definitions created by users are stored in class definition classes. They can be used to obtain a list of class definitions from a program.

Note: Class definition classes refer to all classes contained in the %Dictionary package.

#Object Data Model #Tips & Tricks #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health

4 2

0 528

Question

Michael Davidovich · Apr 24, 2024

Line Terminators and File/Stream Classes - A Few Questions

Hello, I'm curious to see how other people deal with this: we have a text file that was created on someone's Windows machine and it was copied and pasted into a text file on someone's Mac machine. After some examination we realized that the line feeds were originally CRLF (for Windows) and when copied and pasted they were changed to LF (Mac). The diff program we used didn't pick up on this and the program we wrote to read the file was getting each line of the CRLF file and treating the whole file as one line for the LF file.

#ObjectScript #Caché #InterSystems IRIS

0 2

0 230

Question

Subramaniyan Ku... · Aug 22, 2024

We need one common method to persist data for all tables from C# rest api to InterSystems cache object script.

#.NET #REST API #Caché

0 2

0 124

Question

Greg Moua · Dec 12, 2024

Trouble with SSL configuration and %Net.HttpRequest object

Hi all,

I am trying to establish an HTTPS connection to a server using a %Net.HttpRequest object. I'm able to ping and curl the server via command line. The issue I am running into is that I am able to establish a connection, but something seems to be going wrong with verification from the server side. For example, if I use the CheckSSLCN method on the server, it returns this error message

ERROR #6155: Unable to verify SSL/TLS connected to correct system as no SSL certificate present for this socket. */

#SSL #Caché

1 2

1 211

Question

Satya Prasad Kalam · May 30

Production Validator - Case Study

We're planning to use Production Validator for validating our system upgrade (2016.2.3 to 2024.2) , and we are trying to understand what kind of benchmarking or performance metrics others have observed during similar efforts.

Specifically, we are looking for a case study or real-world example that includes details like:

#HealthShare #Caché #Ensemble #Health Connect #InterSystems IRIS

0 2

0 47

Question

Mike Kadow · Mar 21, 2016

Web Service & Client Service confusion

Please consider these two concepts:

Concept 1 - Web Service or Web Application or Server Side

Concept 2 - Client Service or Client Application or Client Side

Maybe I am just a Web/Zen newbie, if I am and you all understand this, I apologize. (no nasty remarks please)

The questions are numbered, if you wish to respond to an individual question please precede it by the question number.

Is there consistency in naming these concepts?

#Caché #Frontend

0 2

0 461

Question

Eduard Lebedyuk · Apr 10, 2016

Is it possible to call classmethod of a current class from method generator?

Here's my code (download):

Class Utils.Generators [ Abstract ]
{

ClassMethod B()
{
    s ^a = 1
}

ClassMethod A() [ CodeMode = objectgenerator, GenerateAfter = B, PlaceAfter = B ]
{
    k ^a
    do ..B()
}

Now, obviously for it to work I need method B compiled and ready to use before compiling method A().

I test it with the following code:

#Compiler #Object Data Model #Caché

0 2

0 969

Question

Derek Day · May 10, 2016

File I/O: Exclusive Writes without blocking Readers

I have some logging code that outputs task status information to a log file. I would like to make the log available for reading while it is open for writing. The file is opened using the "L" option (Lock):

Open tLogFile:"WASL" Set tLogOpen=1

#ObjectScript #Caché

0 2

0 402

Question

Steve Pisani · May 25, 2016

Web applications, and architecture/security related questions

Hi,

Assume an architecture where an ECP Database Server is connected to by one or more ECP Application Servers inside a firewall.The application server hosts the web application that web users connect to.

The Web servers are outside the firewall, and, (using the CSP gateway/server mechanism) issue requests over the SuperServer port and into the application server.

I know that the traffic between the Web Server and the ECP application server can be encrypted using HTTPS, and access to the CSPServer on the Application server is username/password secured.

#Security #Frontend #Caché

1 2

0 4.7K

Question

Chip Gore · Jun 21, 2016

Is there an Embedded SQL Cursor "rewind"?

Hi -

I'm trying to rewind a cursor back to the first row after looping part of the way through the implied result set, but I'm not finding a way to make this happen, is there some such iterator variable or directive that I can leverage to accomplish this?

I could code around it by pulling identifiers and/or values into a local array, and then hand code up an iterator over my local results copy, but this feels like a "redesigning of a wheel" approach, and I thought I would check before I start down this path.

Thanks

#SQL #Caché

0 2

0 535

Article

Tani Frankel · Aug 29, 2016 5m read

My growing journals - how do I minimize this?

Following my previous post, some urged me to get to the point – ok, so I found my "star" journaling globals, the ones that take up the most space – but how do I avoid this? How do I minimize the journal's size?

[DISCLAIMER: Some might still be disappointed after this post as well but wait till the next one... ]

#Journaling #System Administration #Caché

6 2

0 1.7K

Question

sansa stark · Sep 15, 2016

Help

Hi All,Cache is not starting ,I checked the cconsole log it is showing the below error.
The following parameters are missing from section [Journal]: '2,12' at line 143,but i checked in last cpf file,
In cpf file consist of that particular line
[Journal]
AlternateDirectory=C:\InterSystems\CACHE16\mgr\journal\
BackupsBeforePurge=2
CurrentDirectory=C:\InterSystems\CACHE16\mgr\journal\
DaysBeforePurge=2
FileSizeLimit=1024
FreezeOnError=0
JournalFilePrefix=
JournalcspSession=0

#System Administration #Caché

0 2

0 402

Question

Sebastian Thiele · Nov 11, 2016

Adding parameter to ZEN dataCombo at runtime from server

Hi,

I try to programmatically create a parameter for a dataCombo ZEN Component (which is in turn created on the server side at runtime).

Set tParm = ##class(%ZEN.Auxiliary.parameter).%New()
Set tParm.id = "pRegion#"_pExamContainerCount, tParm.name = "pRegion#"_pExamContainerCount

#ZEN #Caché

0 2

0 433

Question

david clifte · Nov 18, 2016

How to set a beutiful name for settings field in BusinessOperation

I saw in: http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=... How to add a Setting to a Host, BO , BS or BP. But, how to set a beautiful name for a setting? Ex for properties: Property foo As %String; Property bar As %String; Parameter SETTINGS = "foo,bar"; I'd like something like: "A foo property" "A bar Property"

#Caché #Ensemble

0 2

0 362

Question

Fred Gustafsson · Feb 3, 2017

Server sync is way too slow

Is it just me or is the sync mechanism way too slow and too trigger happy to be used for large projects? It keeps "Caching for server connection" which takes a good five minutes!

Has it been tested with a large number of classes and CPSs? I have about 2000 of each.

#Caché

0 2

0 542

Question

Rafael Vergani · Mar 21, 2017

Journal file I/O error

One of my journal spaces has status "IOER" in MSM MUMPS.

I think this is happend during system freeze.

I never seeing a journal file status like that. I did not find anything about it in the intersystems documentation.

I can simply delete the damaged file, but I'd like to know how to prevent this from happening.

Anyone have some idea about it?

My MSM-UNIX Version is 4.4.0.

Thanks

#Journaling #Caché

0 2

0 391

Question

Massimo Sebastiani · Mar 30, 2017

Is it possible to modify the values of an insertion during a trigger ?

Hello, we have a few hundreds of triggers to port from Oracle to Cachè for a migration project, and many of them have to change (for example, normalize a value, null it, etc) the value which is being inserted.

The documentation says "You cannot set {fieldname*N} in trigger code." , so we're unlucky.

Is there a good workaround for this ?

SqlComputeOnChange doesn't seem the best way, but I'm not totally sure: for example normalization and validation could have a better place somewhere else than a trigger.

#Caché #ObjectScript #SQL

1 2

0 415

Question

Laura Cavanaugh · May 17, 2017

Need a trick to display cellTitle for just one column in tablePane

I need a trick to display the cellTitle for just ONE column in a tablePane with a unique value. Here are the issues:

1. OnDrawCell has access to the cell data for that row/column, in %query(pName), but setting the cellTitle property to a column doesn't refresh the column object

2. Setting showValueInTooltip is good for the entire table, not just one cell

3. ** the column element does not evaluate zen expressions, so I can't say cellTitle="#(%query.Comment)#", for example. That's the crux of the problem.

#HTML #ZEN #Caché

0 2

0 538

Question

Kishan Ravindran · May 27, 2017

Deepsee

I need to know where i can have good understanding about Deepsee in cache and please provider some example code referring to Deepsee as i am beginner in it. what purpose is it used for ?

#Beginner #Caché #InterSystems IRIS BI (DeepSee)

0 2

0 327

Question

kavin kumar · Jul 21, 2017

$Case or $Select?

What is a major difference between $case and $select?

#Beginner #ObjectScript #Caché

0 2

0 635

Question

Anil Mathew · Sep 12, 2017

Suppress xsi:type in SOAP Client

I have an xml file that it send over a SOAP client. The following is the soap log.

How do I get rid of the namespace "s0:" from the SOAP Body

#Caché #XML

0 2

0 1.1K

Question

Alex Kogan · Nov 28, 2017

Is there a way to Run a Unit Test against Private method

Hello,

I was wondering if there is a way to maybe temporarily alter the [Private] tag dynamically or any other way to run a Unit test against class method, which has been labeled as [Private]?

I mean, I understand there is a workaround to create a non private class method inside this class, which will in turn call this private method and run a Unit test on the non private method, but I am looking for a way to do this without altering the original class.

Thank you,

Alex

#Beginner #Caché

0 2

0 392

Question

Ponnumani Gurusamy · Dec 8, 2017

What Are The Types of Global Persistence Data Structures?

I have seen three different type of data structure.

1.^a -> it is global

2. a^ - > It is tree

3. a| -> I don't know what it is.

if any one know as please share your knowledge.

#Beginner #Caché

0 2

0 509

Question

Jason Koan · May 2, 2018

Creating a Pop-Up box with with "Yes" and "No" buttons using CSP.

Hello all,

I'm attempting to create a pop-up box with "Yes" and "No" for the buttons. I currently have a JavaScript confirm box but it has "OK" and "Cancel" as the response buttons. I have read that JQuery is a way to do, but is there a possibility of doing this with CSP instead of JQuery?

Thanks

#Caché #JavaScript #CSP

0 2

0 1.8K

Question

Dinesh M · Jun 20, 2018

%Development permission issue

Hi All,

On button click from my zen page am calling the $System.SQL.ShowPlan() to calculate the cost of the SQL query.

In Cache` 2016.2 I faced a problem , when the logged in user didn't have the %development resource(<PROTECT> error).

But in Cache` 2017.2 it's working without the %development resource.

Is there any changes done on this area in the versions above 2016.2.

Thanks,

Dinesh

#Caché

0 2

0 304

Question

Dmitry Maslennikov · Nov 12, 2018

Managing with heavy databases

Let's say you have about 100TB of data in multiple CACHE.DAT. The biggest one is about 30TB but mostly more than 1TB. You have limited time for maintenance during a day, and it is only a few hours at night. You have to check Integrity as much often as possible. And of course backup it.

How would you do it?

#Backup #Databases #System Administration #Caché

0 2

0 481

Question

Pravin Barton · Nov 20, 2018

How to XML project a Boolean/Integer property as an empty element

For each instance of an XML-enabled class I want to control whether a property is projected as an empty element or not projected at all. With string properties, I can set the value as $c(0) for an empty element, or an empty string for no projection. But it looks like this isn't consistent for properties with type %Boolean or %Integer. With booleans $c(0) gets projected as "false". With integers $c(0) stays as a zero-width space in the XML output (which gives me a SAX parser error if I try to read it).

Is there a way to do this that works for all datatype properties?

#Object Data Model #XML #Caché

0 2

0 639