#Caché

I would like to know if it is possible to backup a database via shellscript in Linux?

Thanks.

There are some classes in our code base that contain Methods only (no properties). I told my colleagues that converting them into the ClassMethods should improve performance as it would eliminate unnecessary OREF support at run-time. Some of them replied that it would be microseconds, so what is the reason to bother.

Is it possible to estimate the impact of OREF support of method calls at run-time? E.g., as a % of all CPU load. 

Hi all.

As part of my dysfunctional journey with FHIR, I'm looking at using the SDA3 within Healthshare to then convert to the HSFHIR format.

This is working surprisingly well, except I'm falling over when it comes to repeating fields within the SDA3 when creating the HS.SDA3.Patient object manually from within Cache.

If I take the Patient ID as an example - within a DTL, I can quite easily take an MRN and add that to the target PatientNumbers.(1).Number and then add an NHS number to the target PatientNumbers.(2).Number.

InterSystems is pleased to announce that  InterSystems Caché and Ensemble 2018 are now released!

New in these releases are features that improve security and operations, including:

· Key Management Interoperability Protocol (KMIP) support
· Microsoft Volume Shadow Copy (VSS) integration
· Integrated Windows Authentication support for HTTP
· SSH enhancements

Has anyone successfully executed s (INTSFREEZE and INSTATHAW) scripts in atelier tool?

We are having issues with FREEZE script whereas Thaw works fine.

Would appreciate any inputs!

Hi!

Did anyone try to serialize objects in Caché using Google Protocol Buffers? Your experience will be very helpful for me.

Thanks!

Hi all,

I want to export a production in one file, but it has some code in macros, include and class files. I'm exporting using portal (Classes / Select All / Export) but I need the same in macro's tab and copy the content in one file.

The following class method "test" contains code that can create a new class, create new properties for classes, or create new methods for classes. "test" runs all three of these processes once, and the code that performs each action is labelled by comments in the method:

ClassMethod test() As %Status
{
	set sc = $$$OK
// Create a class
set class = ##class(%ClassDefinition).%New("MyClass")
set class.Description = "This is my test class"_$c(13,10)_"testing %ClassDefinition"
set class.Super = "%Persistent"

// Create a property and add it
set property = ##class(%PropertyDefinition).%New("MyClass.MyProperty")
set property.Type = "%String"
set property.Description="This is a property"
set sc1 = class.Properties.Insert(property)
do:$$$ISERR(sc1) $system.Status.DisplayError(sc1)
set sc = $$$ADDSC(sc, sc1)

// Create a method and add it
set method = ##class(%MethodDefinition).%New("MyClass.MyMethod")
set method.ReturnType = "%Integer"
set method.FormalSpec = "x:%Integer,y:%Integer=10"
set method.Description = "Return product of x and y"
set method.CodeMode = "code"
set method.Code = " new result"_$c(13,10)_" set result=x*y"_$c(13,10)_" quit result"
set sc2 = class.Methods.Insert(method)
do:$$$ISERR(sc2) $system.Status.DisplayError(sc2)
set sc = $$$ADDSC(sc, sc2)

// Save the class definition
set sc3 = class.%Save()
do:$$$ISERR(sc3) $system.Status.DisplayError(sc3)
set sc = $$$ADDSC(sc, sc3)

return sc
}

Here's a link to the code on GitHub

Let's say I have something like this:

Query ClientList(BusinessType As %String) As %SQLQuery (CONTAINID = 1, ROWSPEC = "Name:%String(MAXLEN=100),AltName:%String(MAXLEN=100)") [ SqlProc ]

{...}

Is there a way I can specify the MAXLEN by a function or a calculated method?

Like maybe:

MAXLEN=#(..GetLengthName())#

Or is this something that has to be hardcoded in Studio?

Hi,

I am running terminal on Cache on a Mac High Sierria and going through the ObjectSript tutorials.

However there is no instruction on the Intersystems website as to how to open Studio.

Does anyone know how this is done?

Thanks

I want to analyze the journal, but the journal seen in terminal seems to be incomplete.

So how to transform journal into complete plain text.

My installation package is C2010_1_6_952_0_11445_x64.exe.
 

Where can I find CSP file in  TRAKCARE. Seems i can find js file only but not CSP file in TRAKCARE T2017, may i know the path where store the CSP files? Many thanks.

Good afternoon everyone,

I hope you are well,

I am currently working on the below opportunity and if anyone here would like to hear more details please feel free to contact me on 01908 886 030 or teo.rusu@identifiglobal.com

or "Bonus Breakage"

In our last lesson, we added a relationship between 2 persistent classes.  We are clearly going to need to start creating REST Services to expose CRUD operations for each of these classes, but before we do that, we should really finish defining our linkages.  We added code to our Widget toJSON to spool off related Accessory data, so we should really do the reciprocal and allow Accessories to return all Widgets that are compatible.

Hello Guys,

Can you please guide me to create a RESTful API service in our cache (using intersystems cache kit) with CSP (Cache Server Pages ) object script.

I have already mentioned my project CacheBlocksExplorer recently in two articles

1. Internal Structure of Caché Database Blocks, Part 2
2. Internal Structure of Caché Database Blocks, Part 3

Now I would like to inform that this project can be easily run with docker.

Version for Caché and for InterSystems IRIS, now publicly available on docker hub.

Remember that you need the appropriate license key (for RedHat Linux) to be able to run this project.

Caché

Hi,

We maintain a few Zen reports that output in Excel format.

Recently we started to observe that some reports fail and return the following error.

CSP error occurred
Error: Error rendering: OS code =1Use $log=1 to check
ErrorNo: 5001

I have extracted the exception details from the log file

Hi,

Somewhat weird behaviour in testing values in a resulting query.

I have a table where I need to read through a list of data, and apply a charge for matching occurrences. However, only ONE charge for one set of data. I have applied a DISTINCT function to the query, but as I cannot get a completely unique set, the DISTINCT function does not de-duplicate all of the sets.

I have therefore attempted to look for a value that if it repeats for the one data set, I can choose to skip the function that applies the charge.

Hi,

I am trying to start cache form the Terminal window and I get the following error:

$ csession cache

Invalid ownership for ./cache

However looking at the permissions it appears I do have execution rights:

-r-xr-xr-x@ 1 root  cacheusr     24616 18 Sep 22:16 csession

Since I installed CACHÉ with mac, I can not use CACHÉ CUBE, so I put windows 10 in the virtualbox, installed CACHÉ and made cube usable. The problem is, When you press the cube mark, ·studio ·Terminal · Management Portal · Remote system access · Preferred connection server (F) [TRYCACHE 2] · Cache version management (b) · End (x) Inside of the above ·studio ·Terminal · Management Portal (P) Can not be selected.

Why?

The purpose of using CACHÉ is to refurbish existing projects.

Open the studio of CACHÉ,

When you click something, A dialog for server connection is displayed, Please select CACHÉ server from the list. Although it is described, if you select Local [127.0.0.1 [1972]],

User name _system password

Will be input. In this case, what should I enter a password? Is there a default password? Or do you set your own password?

The following code snippet includes a class method "test" that runs code to find a class based on the class's name. "test" takes one argument, which is the name of the table:

Class objectscript.findTable Extends %RegisteredObject
{
	classmethod test(name as %String="mytable")  
    {
			#Dim result as %ResultSet
			#Dim tName as %String
			#Dim contain as %Integer
		Set contain=0
		Set result = ##class(%ResultSet).%New("%Dictionary.ClassDefinition:Summary")
		Do result.Execute()

		While(result.Next()) 
		{
			Set tName=$get(result.Data("Name"))
			&sql(select position (:name in :tName) into :contain)
			Write:contain'=0 tName, " ... ", name, " (", contain,")", !
		}
	    Return $$$OK
 }
}

Here's a link to the code on GitHub

Hello Experts,

I am working on SOAP WSDL, where I am getting below error, I could not figure out where the error is hitting in code. Error says,

"ERROR #6248: SOAP response is a SOAP fault: faultcode=Client faultstring=Badly formed SOAP Message faultactor= detail= <error xmlns="http://www.intersystems.com/trak/ws"> <text>ERROR #5002: Cache error: &lt;METHOD DOES NOT EXIST&gt;zXMLNew+1^Custom.ENXX.Integration.WebService.Schema.DemogData.1 *%New,Custom.ENXX.Integration.WebService.Schema.DemogData</text> </error>"

I installed the evaluation version of CACHÉ.

There is a CACHÉ launcher (gray), If you click it you can not select the terminal.

What is the cause of this?

First, set the preferred connection server · Server name IP address · Port: 1972 Telnet port: 23 · Web server port: 57772 · Web server ip adress CSP server instance ·comment Authentication method Password or kerberos

Does it become like the terminal can be used if setting it?

Please reply.

Hi All,

Is anyone using Veritas NetBackup 8.1 to backup Caché database? DB is on Linux 7.4 on host running VMware ESXI 6. Size of DB is about 1.5TB. Any advice on integrating with freeze/thaw.

Happy pro provide more info if needed.

Thanks in advance, Ashish

This code snippet determines the day of the week associated with a date. The class method "test" takes a date as a string in "mm/dd/yyyy" format, and returns an integer corresponding to a day of the week:

Class cartertiernan.getDayfromDate Extends %RegisteredObject
{
	classmethod test(date) as %Integer {
		//Set date = $ZDATE(date) //  Looks like: mm/dd/yyyy
    Set monthList = $LISTBUILD(0,3,3,6,1,4,6,2,5,0,3,5) // (Jan,Feb,Mar,Apr,...)
    Set centuryList = $LISTBUILD(6,4,2,0) // first two digits divisiable by 4, then subsequent centuries. EX (2000, 2100, 2200, 2300)
    Set dayList = $LISTBUILD("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday") // Index goes from 0-6
     
    Set day = $PIECE(date,"/",2) // get the day 
    Set monthVal = $LIST(monthList,($PIECE( date,"/",1 ))) // get the month value
    Set first2DigsYear = $PIECE( date,"/",3 ) \ 100 // get the last 2 digits of the year
    Set last2DigsYear = $PIECE( date,"/",3 ) # 100 // get the first 2 digits of the year
     
    // Used for DEBUG perpouses
    /*write !,"day: ",day
    write !,"Month: ",monthVal
    write !,"last2: ",last2DigsYear
    write !,"first2: ",first2DigsYear
    write !,"cen Val: ",$LIST(centuryList,(first2DigsYear # 4) + 1),!!*/
     
    // Look here for formula explination (its the "Basic method for mental calculation")
    // http://en.wikipedia.org/wiki/Determination_of_the_day_of_the_week
    Set dayOfWeekVal = ( day + monthVal + last2DigsYear + (last2DigsYear\4) + $LIST(centuryList,(first2DigsYear # 4) + 1 ) ) # 7
 
    Quit dayOfWeekVal
}
}

Here's a link to the code on GitHub

(originally posted to CODE by Carter Tiernan, 6/18/14)

Hi community members!

Please, I'm looking for any references or experiences using InterSystems technologies with MQTT (Message Queuing Telemetry Transport) protocol .

Thanks in advance!

I installed an evaluation version of Caché now.

The Windows version of the Caché client component kit is required to manage and operate Linux or Mac machines with Caché installed. The Windows version of the Caché kit includes client components. Although it is written,

How can I get the Windows version of the Caché client component kit? If you do not use the Caché client component kit, you can not use CACHÉ on Mac, right?

Is it better to install windows os on virtualbox and use Caché?

Please answer.

I would like to make the EnsQueue class visible to the Intersystems ODBC client.   It appears it must be included in the SQL-visible classes first.

Hi All, Can any one please tell how to get the Windows SID number using Caché Command.