InterSystems Caché is a multi-model DBMS and application server. See more details here.
Hello All!
I'm brand new to HealthShare and trying to enable LDAP Authentication. When I run the authentication test, the base DN looks good and the search user is successfully authenticated. However, the user is still not found. We have a linux installation in Azure, and I'm connecting to a Windows AD server (provided both Azure and local hostnames). I'm using the full DN in the username field. For the "LDAP Unique search attribute" I've tried, CN, DN, and sAMAccountName.
Thanks for all replies in advance. We have a security vulnerability that we have to get rid of. We use Putty software to connect to cache as a terminal allowing several users to do maintenance work in cache. this uses telnet Plain text. I know that we can configure telnet to be encrypted using the super server service and I'm looking for software that can work like Putty as a terminal using encryption compatible with cache telnet encryption.
Hi There
I created function to manage string as requirement extract the first two letter of each word after space for example:
Text = "Review symptoms to report with patient"
After passed function it will be return "Resytorewipa"
ChangeFormat(desc)
set desc = "Review symptoms to report with patient"
q:$g(desc)=""
SET delim=" "
SET countdown=$LENGTH(desc,delim)
set i =1
for
{
q:i>countdown
set abbrv = $e($PIECE(desc,delim,i),1,2) // But if I put w abbrv I can get "Resytorewipa"
set i = i+1
}
w abbrv
However, at the end I got only abbrv=''pa" how to get data as requirement.
I am still new to cache objectscript and am trying to figure out how I would go about removing the escape characters from my JSON below. When I call the $toJSON method it's adding the "\" character in the file path.
{"FileStatus":"P","Path":"\/somepath\/test\/test123\/filename.txt","InterchangeOID":"100458"}
My Code:
set tJSONFile = {"FileStatus":pRequest.FileStatus,"Path":pRequest.Path,"InterchangeOID":pRequest.InterchangeOID}
set tJSONFile = tJSONFile.$toJSON()
Thanks.
I have a process that takes data from a CSV file (actually a record mapper object) and creates a nicely formatted JSON string I would love to send this along to a RESTful business operation. However no matter what I try, I continually get <INVALID OREF> errors when trying to populate the object that extends Ens.Request to give it the JSON string.
I can add strings, other objects, you name it - but stuffing a JSON formatted variable/object into another object I want to send someplace is proving to be an impossibility.
Does anyone have an example of sending an Ens.
I need to read the sourceClass attribute of the transform node in the Xdata block of a dtl.
given:
Class EXC.DTL.Lamont Extends Ens.DataTransformDTL [ DependsOn = (Sam.msg.lamont, Sam.lamontNext) ]
{
Parameter IGNOREMISSINGSOURCE = 1;
Parameter REPORTERRORS = 1;
Parameter TREATEMPTYREPEATINGFIELDASNULL = 0;
XData DTL [ XMLNamespace = "http://www.intersystems.com/dtl" ]
{
<transform sourceClass='Sam.msg.lamont' targetClass='Sam.RM.lamontNext' create='new' language='objectscript' >
<annotation>Sample transformationannotation>
<code>
I need to return the value 'Sam.msg.lamont' for the DTL.
I'm using callin to get global values.
Here's a simple function to get string value from global and return it:
int GetGlobalStr(char *global, CACHE_EXSTRP result)
{
int push = CACHEPUSHGLOBAL(strlen(global), global);
// narg Number of subscript expressions pushed onto the argument stack.
int narg = 0;
// flag - Indicates behavior when global reference is undefined:
// 0 — returns CACHE_ERUNDEF
// 1 — returns CACHE_SUCCESS but the return value is an empty string.
int flag = 1;
int get = CACHEGLOBALGET(narg, flag);
int pop = CACHEPOPEXSTR(result);
return ZF_SUCCESS;
}Hello everyone, I'm new to COS development. I'm trying to generate a simple XML file based on a query and save into my server. I'm looking for stuff to get it done, if anyone has a tutorial or a step-by-step post on how to do it. My difficulty is just in generating the XML file.
I have a need to dynamically create a web application definition in a namespace using ObjectScript. I am having trouble finding a cache class or routine that let's me do this.
Thanks
I have problem with Cache installed on a colleague's Windows 10 laptop. On the laptop, Cache was automatically configured to use IIS and this has worked fine with csp applications configured in the Management Portal.
Now this seems to have stopped working, and I can't work out why. In IIS, the web application seems to be in the correct place.
I have manually mapped the various file extensions to CSPms, as per the documentation, but any attempt to navigate to a csp page produces an 500 error, which tells me precisely nothing about why this is happening.
Dear team,
I am trying to experiment the Docker container in our development environment. I have successfully build an image and running the container. When I access the CSP portal home page ( http://<host-ip>:57772/csp/sys/%25CSP.Portal.Home.zen?$NAMESPACE=%25SYS), I am getting the following error:
I logged in to the running container (docker exec -it <container-id> sh), issued the command, 'ccontrol list' where the state says 'warn'.
I've tried this:
s status=msg.AttachFile("F:\MyDir","myFirstFile.pdf",1,.count)
s status=msg.AttachFile("F:\MyDir","mySecondFile.pdf",1,.count)
But it's not working at all...
Thank you in advance!
Class ICT.Experiments.A Extends %Persistent
{
Property Name As %String;
Property Collection As list Of ICT.Experiments.B;
Property Collection2 As array Of ICT.Experiments.C;
}
Class ICT.Experiments.B Extends %Persistent
{
Property Name As %String;
}
Class ICT.Experiments.C Extends %Persistent
{
Property Name As %String;
I have the classes above and I can select columns from the array collection by using two joins as follows:
SELECT
mainTable.ID, mainTable.Name, c.Name
FROM ICT_Experiments.A mainTable
LEFT JOIN ICT_Experiments.A_Collection2 arrayTable ON arrayTable.A = mainTable.
Hello all,
I am still learning CACHE and have below question.
In one of my ZEN method i am creating a table using
&sql(CREATE TABLE xxxxx(TNAMESPACE CHAR(100),TINTERFACE CHAR(100)))
Does any one knows how to concatenate a $USERNAME or any content of a variable to the name of table ?
&sql(CREATE TABLE xxxxx_$USERNAME(TNAMESPACE CHAR(100),TINTERFACE CHAR(100))) is not WORKING.
Thanks,
Jimmy Christian.
I have two classes:
Class Example.Parent Extends %PersistentProperty
Child Extends %Persistent
A parent can have many children. I want to query for parents and add children for each parent to my result.
Here is the code that I query with:
In the QueryParents method, while iterating through the result set, I trigger a new query for each parent to find the children. And at the end I return a JSON structure. Now, this works but it is not going to scale well when there are many records in the database.
Is there a better approach to doing this?
I have version 2017.2 installed.
Method : to download the FTP file from intersystem cache : If you have any question please drop a message :
ClassMethod FTPDownload(myFTP = "", myUserName = "", myPassword = "", sFileLocation = "", dLocation = "", noOfdownloadFile = 1, sourceFileDel = 0)
{
/*---------------------------------------------------------------------------------------------------------------------------
download the file according to the requirements : FTP
Method : Resuable
by : Sanjib Raj Pandey on 30/03/2018
downLoadFile = No of files or all files .
Hello,
I am trying to run a simple SELECT STATEMENT in USER NAMESPACE.
SELECT * FROM projectname.table
What is the syntax if i need to get data for a table in another namespace eg. SAMPLES., SYS
SELECT * FROM SAMPLES.projectname.table is not working.
Thanks in advance.
Jimmy Christian.
Wanted.
Cache experts from anywhere in the world who would take the opportunity to be sponsored to work in the UK.
Please send your CVs to recruitment@hulatech.com
What is the process in importing a role from one server to another server?
Let's say Server A is our main server that we maintain all of our resources / roles / users. We would like to get these over to Server B, Server C, Server D, etc.
It looks like when we import, there are tables and resources left in the destination servers that are not in the source server. It looks like whatever was in the destination server that was not part of the source server was not deleted from the import.
What is the proper way of exporting/importing a role so that this does not happen?
I managed to use CacheGlobalOrder to iterate over global and return the next subscript:
int GetGlobalStr(char *global, int subscript, CACHE_EXSTRP result)
{
int push = CACHEPUSHGLOBAL(strlen(global), global);
int pushS = CACHEPUSHINT(subscript);
// narg Number of subscript expressions pushed onto the argument stack.
int narg = 1;
// Direction for the $Order is 1 for forward, -1 for reverse.
int dir = 1;
// Indicates whether the data value, if there is one, should be returned.
int valueflag = 0;
int order = CACHEGLOBALORDER(narg, dir, valueflag);
int pop = CACHEPOPEXSTR(result);
//pop = CACHEPOPEXSTR(result);
return ZF_SUCCESS;
}Hi guys!
Portrait of Madame X, Gustave Caillebotte.
One of the features I like in InterSystems ObjectScript is how you can process array transformations in a specific method or a function.
Usually when we say "process an array" we assume a very straightforward algorithm which loops through an array and does something with its entries upon a certain rule.
The trick is how you transfer an array to work with into a function.
One of the nice approaches on how to pass the information about an array is using $Name and Indirection operator.
Below you can find a very simple example which illustrates the thing.
I have an xml that has non standard characters and I would like to transform it with xslt so that those characters render in the format &#nnn here is what I have so far any help appreciated
xslt
<!--?xml version="1.0"?-->
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output encoding="Windows-1252" indent="yes" omit-xml-declaration="yes" method="xml">
> <xsl:template match="/Recordset">
<recordset><xsl:apply-templates></xsl:apply-templates></recordset>
</xsl:template>
<xsl:template match="*|@*">
<xsl:copy>
<xsl:apply-templates select="@*">
<xsl:apply-templates>
</xsl:apply-templates></xsl:apply-templates></xsl:copy>
</xsl:template>
</xsl:output></xsl:transform>
Between Aix(backup) and Windows(recovery) , How to do this?
Continuing on from my last post, I am posting my succesful output for the Day 2 Part 1 below.
A full explanation of Day 2 part 1 can be found at: https://adventofcode.com/2018/day/2 and the input can be found
at: https://adventofcode.com/2018/day/2/input
A brief description of this exercise is that you receive a sequence of strings.
You have to count the if any duplicate or triplicate chars exist in the string. Multiples will exist, but if you find multiple ldupicates / triplicates you will count them once.
At the end of sequence of strings you have to SUM the no.
I needed to know programmatically if last ran failed or not.
After some exploring, here's the code:
ClassMethod isLastTestOk() As %Boolean
{
set in = ##class(%UnitTest.Result.TestInstance).%OpenId(^UnitTest.Result)
for i=1:1:in.TestSuites.Count() {
#dim suite As %UnitTest.Result.TestSuite
set suite = in.TestSuites.GetAt(i)
return:suite.Status=0 $$$NO
}
quit $$$YES
}Hello All,
There are few tools for SQL optimization available and even query builder has Show Plan to give us an estimation of the resources needed to execute.
For Methods - Is there anything similar ??
I would like to see a similar approach as to the time taken for method to execute.
Is Studio Debugger only option ??
I have a query that I would like to have refreshing at certain intervals lets say every 30 seconds with out refreshing the page content using the META TAGS
refreshes the whole page but I have a jquery function that will run at those intervals that I can use the problem is getting the jquery to call my COS function or is the way to do it with pure COS
<html>
<head>
<!--meta http-equiv="refresh" content="30"-->
<!-- Put your page Title here -->
<title> Cache Server Page </title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/
libs/jquery/1.3.0/jquery.min.js"></script>
<script type="text/javascript">
var auto_refresh = setInterval(
function ()
{
$('#load_tweets').load('#(..myquery())#').fadeIn("slow");
}, 10000); // refresh every 10000 milliseconds </script>
</head><body>
<div id="load_tweets"></div>
<script language="Cache" method="myquery" returntype="%Integer">&sql(select Count(*)INTO:COUNTER from Collection)
QUIT COUNTER
</Script>
</body>
</html>
After many sleepless nights it's a pleasure to announce the newer, better, moderner ObjectScript compiler which implemented pretty much everything you ever wanted to have in modern ObjectScript:
But we not only parse the modern ObjectScript syntax, we have implemented finally the long-standing request which we always dreamed about. Closures!
I have a wdsl soap request that now requires a header. Where do I modify the header to allow this new value to be sent?
<soapenv:Header>
<Headers xmlns="urn:epic-com.2013.Interconnect.Headers">
<Epic-Client-ID>12349fe5-2ff8-4b79-b723-e69efbabcdef</Epic-Client-ID>Thanks
Scott