#Caché

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.

404 Not Found

{
"error": {
 "errors": [
  {
   "domain": "global",
   "reason": "notFound",
   "message": "Not Found"
  }
 ],
 "code": 404,
 "message": "Not Found"
 }
}

I want to do something like the above sample from a Google Storage JSON API. I have a call to Write obj.%ToJSON() followed by return ..ReportHttpStatusCode(..#HTTP404NOTFOUND) however the HTTP Status code is always 200.  If I remove the Write obj.%ToJSON() statement it returns a 404 status with no body. How do I return both?

Hi,

I have a working import routine, but I do get an error on properties based on another class

in this case [OrgType As ZenCrm.OrgType].

How do i set the correct reference?

Thanks

Unconferences have been described as “networking on steroids.” They are the ultimate peer-to-peer discussion experience, and have been a vital part of InterSystems Global Summit for the past few years.

To ensure that this year's Unconference at Global Summit is better than ever, we want to know what YOU want to discuss with peers and industry leaders. Please follow the link below to submit your Unconference topic for 2018! Feel free to submit as many as you would like. Keep in mind that topics should be technology-related and relevant to conversations your peers will also be interested in.

We are go to set up an odbc connection using data direct odbc on a linux redhat install, x86_64 gnu

I have downloaded the ODBC-2017.2.2.865.0-lnxrhx86.tar.gz and now need to set up the entry in the odbc

Problem is, what .so do I use??

./bin/cconnect.so
./bin/libodbc.so
./bin/libcacheodbcu.so
./bin/cgateu.so
./bin/libcacheodbciw.so
./bin/libcacheodbc35.so
./bin/libcacheodbcuw.so
./bin/libiodbc.so
./bin/libcacheodbcuw35.so
./bin/cgateiw.so
./bin/libcacheodbcu35.so
./bin/libcacheodbc.so
./bin/cgate.so
./bin/libcacheodbciw35.so
./bin/libcachedb.so
./dev/odbc/redist/unixodbc/libodbcinst.so

thanks

What I am impatient now is that after installing CACHÉ, CACHÉ Cube necessary for operating CACHÉ is installed as standard, and in Windows, if CACHÉ Cube's cube mark is displayed on the task bar, Although it is described in the case of Mac, there is no description on where the cube is located on the Mac + CACHÉ Cube is not found even in the PC.where is CACHÉ cube??????(CACHÉ Trial version)

I am trying to create a file from within a zen page but it keeps giving me a method does not exist error

in my page, i am taking the values and writing them to a file, when I do this :

 set filename= ##class(%Library.File).New("E:\test\file.txt") it gives me an error

Would appreciate some guidance on this.

Introduction

Any election is a highly mysterious process, and when you look at its results, the overall picture is not quite clear. I decided to put them, region by region, on the map of Moscow using InterSystems technologies that offer both storage and data analysis functionality. In this particular case, I used InterSystems Ensemble, a platform for application development and integration, but you can also build this solution using the multi-model InterSystems Caché DBMS, as well as InterSystems’ new product called IRIS Data Platform.

I'm testing out the new %CSP.REST way of creating an api and having a problem with a POST getting a 405 error.

I get data returned when I do a GET, so I don't think it's a configuration issue or a class issue.

I have no problem with %CSP.Page when creating a REST type method. So what am I missing?

Can someone give me some advice?

Thank you.

Hi All, I tried to execute the ##Class(%SYS.LDAP).Binds(LD,"",$lb(Username,Domain,Password),$$$LDAPAUTHNEGOTIATE) but this command is returning the value as 7 only instead of 0,7 is an "Authentication Method Not Supported",How to recover it and why this error message is occuring Please help me

So by queryString I mean name-value pairs passed  in as part of the URL. Currently my service works when called like this
http://{{SERVER}}:{{PORT}}/bsolabs/api/codemanagement/testcode/BIO/CRP

What would I need to change so I can call it like this?
http://{{SERVER}}:{{PORT}}/bsolabs/api/codemanagement/testcode?Discipline=BIO&TestCode=CRP

Hi All, I tried to execute the ##Class(%SYS.LDAP).Binds(LD,"",$lb(Username,Domain,Password),$$$LDAPAUTHNEGOTIATE) but this command is returning the value as 7 only instead of 0. Is there any method to find out the error using the returned value. Please help me

i would like to ask about the installation of CACHÉ.

is there a way to install from the internet?

please let me know if there is one.

macOS High Sierra 10.13.6

SQL gateway.

It is not "compiling" correct the properties(get; set;)  in the class, and generating 2 methods of :

GetuProperty and SetuProperty.

so it's not equivalent to standard  methods interface handling.

Regards,

Emanuel

Generally speaking, InterSystems products supported dynamic objects and JSON for a long while, but version 2016.2 came with a completely new implementation of these features, and the corresponding code was moved from the ObjectScript level to the kernel/C level, which made for a substantial performance boost in these areas. This article is about innovations in the new version and the migration process (including the ways of preserving backward compatibility).

Hi everyone

I have a datacombo that displayes value from a db table.

I would like to set one of this value as default value. How can I do that? Is there a way to say selected value given the text or the Id from the DB table?

Thanks a lot and kind regards

Milena

Hello,
   We are running cache version  2012.1.4
Is it possible to make an HTTP Post passing in JSON string?

Example:
I want to send this request to Authorize.net. How can I do this in cache object script?

URL:  https://apitest.authorize.net/xml/v1/request.

Is there a way to modify the CSP Server Access settings programmatically, instead of through the management portal?

Ive been asked to investigate Intersystems Cache' for a new software initiative and was hoping to be able to download a limited-use or dev license to kick the tires but I need it for a couple of specific OS builds.  AIX and Linux (CENTOS).  I don't see a place to download specific versions, other than Windows, various builds of Unix and that's about it.  Can someone give me some guidance on how to make sure I'm downloading the right item to build some test instances with?  

thank you in advance :)

tom

This is a FYI for anyone who has experienced the following error after upgrading an existing  instance to any product based on Caché 2017.2.2. In our case, the products are HealthShare HealthConnect for Redhat x64 and for Windows x86-64 but I believe it would be a common problem for any InterSystems product on any platform, if based on Caché 2017.2.2. After upgrading our development instance from 2016.2.2 to 2017.2.

We are trying to connect a RSS feed to a HealthShare PHR app, the RSS feed located here (link). Upon doing so I get a certificate  server mismatch error, so I tried testing this out in the terminal as follows to see why this would be happening:

I have a class (to be deployed) and I want to forbid anyone from extending it.

Is there any way to do that?

Hello,

    When working with class queries you have to define the ROWSPEC at the beginning (See below).

Instead of using Year1 or Year2 as the column name, how can I use the passed in fiscal year (xFiscalYear)

so Instead of using "Year1" as the column name I can call it something like:  "Jul"_xFiscalYear

Query GLReportYearToYearTrend(xFiscalYear As %String) As %Query(CONTAINID = 0, ROWSPEC = "GLCode:%String,Description:%String,Year1:%String,Year2:%String,JulChange:%String") [ SqlProc ]
{
}

I faced with the issue when WebSocket connection just fails without any errors if I send data with size 384 bytes and more (In binary mode the same). As I know by standard WebSockets frame does not have such limitation. Is there any way how to decrease it? This limitation too small, it is too difficult to fit this size and needs to send data much more often than I expected. Tested with Caché 2016.2, 2017.2 and IRIS 2018.1.