Question
· 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

0 2
0 392

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.

1 2
0 415

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.

0 2
0 539

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

0 2
0 392
Question
· 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

0 2
0 304

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?

0 2
0 639
Question
· Jan 22, 2019
SQL select to a list

I need to select my result into a list and be able to loop through the list when query finished any help appreciated here is where I am

##sql(SELECT %ID INTO :IDArray() FROM MergeHyland.TypeTwoDimesionCollection WHERE GUID = :Key AND EndDate IS NULL)
for I=1;1:$LISTLENGTH(IDArray)

{

w $Data(IDArray),i

 


}

0 2
0 1.5K

I need to copy a bunch of globals from some crufty old databases to spanking clean brand new ones. GBLOCKCOPY has this cool feature that lets you create a batch of global names to copy and save the list in a batch. You can then execute the batch and go take a nap.

I like naps.

I need to do this for a number of old-new database pairs, but it's the same global names every time. Is there a way to export the batch configuration created the first time and import it to another environment/namespace? These databases will be spread across multiple hosts.

Thanks!

0 2
0 356

Hi All,

We have a licensed version of Ensemble but for now, we use only the DB capabilities of Cache. As we create a custom Namespace, for e.g "Test", a new Ensemble Namespace is automically created by the system --"TestENS".

Is there any way where we can identify the system created ENS namespaces ?

0 2
0 351
Question
· Jul 28, 2020
Explicit FTPS in Cache

We use the %Net.FtpSession class to perform FTPS file transfers. This has worked fine with Implcit FTPS servers but crashes when trying to connect to an Explicit FTPS server. Explicit FTPS has a slightly diffferent negotiation in the intitial connection and different ports.

Has anyone gotten Explicit FTPS working with the Cache classes?

0 2
0 559
Discussion
· Nov 10, 2020
Why change?

I have already asked a question about migrating an Oracle database to Caché, and I was promptly answered. Now, I have one more question, however it is more conceptual. In general, any tool defends its benefits, and looking at Caché's, among many, there is a lot of talk about speed. The question is, if I already have a database, and at the moment, its performance is not a problem, I would like to know what else could influence the change of this database? Remembering that it is functional and without any apparent problem.

8 2
1 280
Question
· Apr 12, 2021
Cache Systems Backup

Please how can I schedule a call with InterSystems admin? We have a need to back up our cache DB server in azure using recovery services vault/snapshot. We Have come up with several designs but we need expert advice from InterSystems’ s team or anybody here in the community. I have been asked to contact an InterSystems admin for support but I don't know how to schedule a meetings since they don't have teams presence with our company.

0 2
0 274

I have some code in a mac routine that use indentation and the "." character :

 IF condition1 DO
     .WRITE YCR,...
     .WRITE YCR,...
     .WRITE YCR,...

I would like to add a try / catch block between the write statements.
I can't refactor the whole code and use indentation with curly braces instead (there is too much code, not written by me)

I have tried the following but it does not work (it compiles, but code stop running right before the try keyword)

0 2
0 350
Question
· Jul 2, 2021
Use of $ZUTIL(12)

As you know the $ZUTIL method is deprecated and I'd like to replace this calls for the corresponding ones.

In my case I'm looking to replase $ZUTIL(12) by ##class(%Library.File).NormalizeDirectory("")

0 2
0 392
Question
· Sep 1, 2021
Querying a task

How do I programatically query a task set up in the task manager? I need to know the code being executed.

Thanks

0 2
0 212

I have a terminal script that queries sys.process' and then parses the results writing to a logfile. As part of the processing of the results, each row of the result set includes an element from the static string. But I am not clear on the scoping of the static string. The write statement sees the static string as undefined. What I want is something to the affect:

set statStr = "aa|bb|.."

set sqlStatement = xxx

set tState = ##class(%SQL.Statement).%New()

set qStat = tState.%Prepare(< sql statement> )

0 2
0 252