 Â
InterSystems Caché is a multi-model DBMS and application server
Hi,Â
We recently moved our cache instance from windows 2012 to windows 2016 and when i try to now import % routines i'm getting the following errorÂ
Â
This is a fresh installation of cache and I've moved the cache.dat and csp pages across. It seems to work fine but can't import % routines which I need.Â
Has anyone experienced this and can help?Â
Thanks
Let's say we have a classÂ
AbcRequest extends Ens.Request, PropertiesBaseAbstractClass(has all my properties common to all request)
Prop1
Prop2 and so on
Â
Now in my Business OperationÂ
I want to make a json dynamically from this request.
Yes obviously I can do is
Â
Set requestDefinition = ##class(%Library.CompiledClass).%OpenId("MyCreateRequest")
Set JsonObject   = ##class(%DynamicObject).%New()     Â
      for i=1:1:requestDefinition.Properties.Count() { Â
         Set key         = requestDefinition.Properties.GetAt(i).Name
         Set value      = $property(pRequest,requestDefinition.Properties.GetAt(i).Name)
         Set JsonObject.key = value
     Â
      }
      Set requestString      = JsonObject.%ToJSON()
This makes a json {"key":""}
Â
Â
Â
Â
Good morning
I'm probably overlooking something very basic, but I'm running on Win2016 with Cache 2016.2 - All the work I am doing is in INT routines, but I'm making some calls to the Host File system using $ZF(-1).
I have a few mapped Network drives that are mapped in Windows, typically these are locations where I want to back up some files.
My process is quite simple:
1. Read data
2. Zip data files using RAR
3. Create folder on Network drive
4. Move RAR files to new network share.
I've tried a few different commands:
S LOC="G:\RAN\Backup1\",CMD="MD "_LOC,X=$ZF(-1,CMD)
S LOC="\\data1\data\RAN\Backup1\",CMD="MD "_LOC,X=$ZF(-1,CMD)
I'm unsure if its a limitation of Cache to do this sort of thing, or if I should created a BAT file and then kick off a Windows call to run the BAT file
Save the date !  14. Mai 2019
Location: as in the last years Hilton Garden Inn South Vienna, Wien.
I hope to meet you all there. :-)
      Â
Hi Community
I have created a simple package that allows the use of Cache with the Laravel Framework.
From my initial testing everything seems to be operating smoothly but I would like to appeal to the PHP users in the community to help me improve this package.
For those of you out there who have time and would be interested in this, please visit the repo at https://github.com/jeandormehl/laracache
Thanks in advance
I have an application using examples from the lottery example in samples name space how do I create a dynamically link based on the data displayed to add a record id to the link
the idea is to loop over the records displays fields and link to edit the shown data at the end of the record in a table format
Hi I've got a service setup to query a sql server via ODBC.
I've got all the parameters etc setup and everything is ok
My Query i
In my earlier article on Adopting Bitmaps I described the technique already.
Now you can find a code example also on Open Exchange.
I've seen a few password change posts, but I wasn't 100% sure it was the same process, so I am asking here. We periodically have to change the passwords for a few Cache user accounts across several servers. Is there a process/script to change these passwords without having to go into the web portal on each server? Thanks so much, and I apologize if this was covered in some of the other articles that I've run across. Just looking for the best method.
We can load a CCDA xml document into SDA3 object.
Once parsing SDA3 object, how do we determine from which XPATH from CCDA the specific SDA3 elements were mapped to.
Is there any way?
Hello,
Is there a way to implement Excel SLOPE and INTERCEPT statistical functions in Cache? Any help would be greatly appreciated.
Alex.
I am trying to convert a string to date but can not get it to work I have function that I would like to take in a date string and covert it to date object
here is the ezample so far can not get it to work any help appreciatedÂ
Â
set p="12/03/2019"
Â
w $System.SQL.TODATE(p,"YYYY-MM-DD")
Â
<ILLEGAL VALUE>todate+32^%qarfuncif I try this still get the wrong value returned
set p="12/03/2019"
w $ZDATE(p,3)
1841-01-12Â
I worked through the Community for proposals to provide end users
in an easy way with data formatted as EXCEL sheet.
There is an great article Tips & Tricks - SQL to Excel
there's an important message embedded: "EXCEL can interpret HTML tables and display them as usual"
Nice!
But the result is on your server and you are left alone to get it out to your remote user somewhere.
Could be a subject to be solved using REST or WebServices
Save the date!
Â
Â
Â
Â
Â
Â
Â
Â
Just in case this hasn't reached you (or your manager didn't pass it to you  
)
https://www.intersystems.com/de/news-events/events/veranstaltung/intersystems-dach-symposium-2019/
Hello all,
I am having some issues creating a docker image with a fresh cache installation. The error that I am getting right now is that gzip is required for a cache installation, but was not found in my system. Even though, this is shown as installed in the base centos 7 image. My host machine is Windows 10 using the latest docker version.
Here is my dockerfile, its simple:
FROM centos:latest
RUN yum update -y && yum -y upgrade
COPY ./cache-2017.1.3.317.0.18571-lnxrhx64.tar.gz .
RUN tar -zxf cache-2017.1.3.317.0.18571-lnxrhx64.tar.gz
RUN ISC_PACKAGE_INSTANCENAME="MyDatabase" \
     ISC_PACKAGE_INSTALLDIR="/usr/cachesys/" \
     ISC_PACKAGE_UNICODE="Y" \
     ISC_PACKAGE_CLIENT_COMPONENTS="" \
     ISC_PACKAGE_INITIAL_SECURITY="Minimal" \
    /cache-2017.1.3.317.0.18571-lnxrhx64/cinstall_silent
EXPOSE 57772 22 1972
ENTRYPOINT ["ccontrol", "start cache"]Â
This question is about calling AWS REST APIs. Based on:
http://docs.aws.amazon.com/general/latest/gr/sigv4_signing.html
AWS requires REST clients to call their APIs using Signature Version 4 which in case you don't know what I am talking about is a pain in the neck. Â Here comes the question:
Has anybody, by any chance implemented the v4 signing alg. in COS? If yes, would she or he have the kind heart to share?
Thanks,
Chris
Â
Â
InterSystems states that Caché supports at least three data models – relational, object and hierarchical (globals). On can work with data presented in relational model in a program written on C# the same way one works with any other relational DB. To work with data presented by object model in C# one needs to use .NET Managed Provider or some kind or ORM. And starting with version 2012.2 one can work directly with globals (or use direct access to hierarchical data) via Caché eXTreme for .NET.Â
Is it possible to mimic what selenium does like navigating to a site and logging in and filling out a form then logout in COS.I am trying to do that in COS using %Net.HttpRequest class or should I be using a different class the idea is to be able to call a web app login into it and fill out form and log out
Database systems have very specific backup requirements that in enterprise deployments require forethought and planning. For database systems, the operational goal of a backup solution is to create a copy of the data in a state that is equivalent to when application is shut down gracefully.  Application consistent backups meet these requirements and Caché provides a set of APIs that facilitate the integration with external solutions to achieve this level of backup consistency.
Hi guys,
  I'm trying to develop a  program calling Cache REST service twice with Cors. My Cache version is 20181.1.312.
  The REST service was implemented as below:
I have a DR Mirror  with a WIJ that is 5 times as large as the Primary Failover member. My Read-Write Reporting mirror WIJs are the same size as the Primary. I don't know why the DR WIJ i so large and would like to shrink it to the same size as the others. Any suggestions are welcome. Thanks!
Hi All,
 How to create Https request with Negotiate,NTLM Authentication in cache using %Net.HttpRequest package.
 I tried with basic authentication it is throwing >401 - Unauthorized: Access is denied due to invalid credentials.
Â
 can anyone please guide meÂ
Â
 Many Thanks !!
 Vicky
Caché 2018.1.2 and Ensemble 2018.1.2 maintenance releases are now available.   Â
Hi -
I'm having odd behaviors on my EC2 hosted IRIS Community instance.
When I configure a "custom login page" in the System Management Portal for my web application I'm seeing a few different behaviors that are under documented (and also undesired)
The old Caché documentation indicates that the custom login page could be a ".csp" file, but this seems to nor be the case (i kept getting "not found" errors, even though I could bring up the page directly from the url FOR the login.csp file. To get around this, I created an HTML file and then, at least, the login page could be found to be rendered
In recent discussion on CachéQuality I was (friendly) blamed for old syntax promotion and deliberate obfuscation of the code. Therefore I decided to clarify my point and shed some light on one of possible source of side effects that may unexpectedly occur with RETURN command with an argument.
How can a remote webserver be configured to access the application on a different application server ?
Example: customersdomain.com running on the customer's server, to access the csp application running on the service provider's own server ?
Hi there,
  I'm trying to develop a  program calling Cache REST service twice with Cors. The first is fetching some information of a patient with GET request, the second is using obtained information to call another REST service(implemented in the same class though) with POST to  perform other tasks.
