InterSystems Caché is a multi-model DBMS and application server. See more details here.
Awhile back we had someone write some code to Log messages like we did in eGate but with Ensemble.
ClassMethod LogIt(pComponent As %String, pMsgIn As %String)
{
set vDIR="/ensemble/"_^OSUWMCInstance_"/logs/"
set fs=##class(%Stream.FileCharacter).%New()
set fs.Filename=vDIR_pComponent_".log"
do fs.MoveToEnd()
set vTM=$PIECE($ZDATETIME($HOROLOG)," ",2)
//$ZTIME($PIECE($H,",",2),1)
do fs.WriteLine(vTM_" : "_pMsgIn)
do fs.%Save()
set fs = "" // Close file
}
Hi All,
I use SQL function JSON_OBJECT to get data as a JSON object.
However, sometimes I get error with function JSON_OBJECT when values contain [, ], { or }.
Error:
[SQLCODE: <-400>:<Fatal error occurred>]
Unexpected error occurred in JSON_OBJECT() function execution of <JSON_OBJECT>.%FromJSON().Parsing error
For example,
Query: SELECT JSON_OBJECT('idSQL':id, 'content':content) FROM DocBook.block
For demonstration, I used Management Portal, System Explorer – SQL, Execute Query
This text was in Content:
If you are developing applications that use CSP or Zen, or potentially any of the other InterSystems web-related stuff that's built on top of CSP, then it's important to know how to keep one particular secret.
A central part of the CSP security architecture is a server-side session key. "Server-side" because its value should never be revealed to the client that is issuing the web requests. If it is revealed, a malicious client might be able to use it to bypass your security and make your server do things you don't want it to.
Hi All,
We can sent the file to FTP server using CMD prompt.
When trying send file using cache FTP. it automatically logged out.
While cache FTP access (read/write) FTP server it automatically logged out.
CODE:
InterSystems is pleased to announce the availability of the following maintenance releases:
Caché and Ensemble 2016.2.2 are available on the same platforms as 2016.2.1
Please let know how to invoke a java program from intersystems. Also let know how to expose / consume webservices / APIs from intersystems
Code coverage and performance optimization of code has come up a bunch of times already, so most of you should already be aware of the SYS.MONLBL utility. Often a visual approach to looking at code is much more intuitive than pure numbers, which is pretty much the whole point of this article series. This time we will take a slight excursion away from python and its tools and are going to explore generating heatmaps from ^%SYS.MONLBL reports.
Hi!
I'm trying to insert a relationship from a parent object instance to a child object instnace programmatically. Ie, i want to do:
Do parentObject.childRefProperty.Insert(chilDobject)
where childRefProperty is defined by a string. I feel this should be achievable with $PROPERTY and/or $METHOD or maybe something in $SYSTEM.OBJ.*, but can't quite figure it out. Anyone know?
Cheers :)
Chris
We finished our last lesson with our Widgets Direct page receiving a Welcome message as a property of a JSON object, which was unpacked and displayed on the page. However, we are on Lesson 3, and we still haven't had any talk of displaying widgets yet.
Let's change that. Widgets Direct are a leader in widget and widget accessories, so we clearly have numerous items to display. To transfer this, we will need to declare and return our first array. Let's go back to our REST.Dispatch class, and add this data to our Service.
Is there a way to do this? I found the way to store .gz files, but .zip files are different.
Hello,
I work with trigger and I need afeter update make INSERT into LogTable value of prorerty of saved class. This is what i have in this monent.
S className = ..%ClassName(1)
S cls=##class(%Dictionary.CompiledClass).%OpenId(className)
F i = 1:1:cls.Properties.Count() {
S prop = cls.Properties.GetAt(i)
S propName = prop.Name
S value={propName*N}
}
How Can I get value given "prop".
Thank you
I have a newbie question.
How can a Cache/MUMPS process identify itself to either a process or system.
I have an application running in two different processes and/or systems and want to make minor changes depending upon which process it is in.
What is the easist way to do that.
-thanks
On the back of my recent post on writing bug-less code I wanted to raise a few suggestions (to ISC) that would help prevent certain types of bugs at compile time. I've probably missed a few, but these are the main ones in my mind. Please contribute more suggestions.
Btw, these also serve as potential gotchas for new COS developers.
Cache Studio almost always crashes when I click rows in Call Stack view during debugging. Then Cache has to be restarted because last edited file remains locked.
Looks like I'm the only one who uses the debugger. Or is there a magic spell to make stack view working?
Cache 2016.1.1
Hello everyone.
I have some issue with trigger. I have class where I defined 3 triggers (UPDATE, INSERT, DELETE). These triggers are Foreach = row/object. In my currently task, I need overide this triggers in children class. is It possible to do it?
Thank you for your help.
Hi community members!
I'd like to know about what source control version is recommended to use with Caché / Ensemble. Can someone help me? If yes, there is some documentation to how to configure?
Thanks,
José Sampaio.
New WRC Customer Interface
Come check out the new WRC interface we have made available to supported customer.
Some of the new features available to you are:
Organization Dashboard – gives an overview of your organizations activity for this year
Bug / Enhancement (prodlog) History – you can now look at all the prodlogs your organization has entered. This table will show you the current status, planned version the fix should be in and the correction key for prodlogs that are fixed.
Does anyone know if Caché supports NTLM authorisation? And if so, how?
Many thankx!
I only recently noticed the presence of a local database named CACHE alongside the more familiar CACHESYS, CACHELIB, CACHETEMP and CACHEAUDIT.
A bit of digging through the documentation archive led me to conclude that the CACHE database arrived in 2010.2, where the release notes say:
Note the lack of an accent on the words I have highlighted.
In this recent post I highlighted the importance of a CSP session's Key property in enforcing the level of security your web application may be relying on, and in particular the need to keep the property value secret.
I need to import xlsx file into Cache. Could you prompt me which tools I can use for it. Thanks
Is it possible to export PRJ file without section BreakPoints and Target attribute? /diffexport does't help.
They just make noise when pushing into GIT
It's almost time to get your customers upgraded to new versions - are you worried about showing off your SQL Performance after upgrades? If you want to upgrade without worrying, then I have just the program for you!!! Check out this video from Global Summit 2016 featuring yours truly explaining how to upgrade a system without worrying about pesky SQL queries showing on your waistline!
https://www.youtube.com/watch?v=GfFPYfIoR_g
Unfortunately the video started after the Frozen Musical Sing-a-long, but it's 30 minutes of the most fun you'll have while learning tools and tips for Caché SQL!
I have classes A and B, B derived from A, A has method Abc.
From INT of class B I see that compiler copies implementation of Abc to class B, so that Abc exists both in A and B.
As result, when B invokes Abs, B.Abs() is executed instead of A.Abs(). In result debuger is not able to step into Abs and breakpoints in A.Abs never hit.
Why this happens and how can I avoid this?
Update:
OK, now I know the reason: compiler makes the copy if Abc has this line:
s cn=##Expression($$$quote(%classname))
In case of system exception (missing property, method etc) Cache Studio's debugger stops at the line throwing it. Unless the line is in try/catch block.
Is there a way to make it break also in try/catch case?
Cache 2016.1.1
There is a large file that needs to be processed, with over 500 000 rows. Each row needs to be verified for various data and then all the results collated and reported into a single report. What is the most efficient way to do this? I tried calling the processing function with Job , where each function jobbed off would report results to a different node of a common global. But the jobbed functions are not updating their respective rows even though I am passing the global name and root node. What is the most efficient way to process this large file? Any Cache/Ensemble ideas are appreciated.
Hi All,I got an error when i compile one class. the error was objects of class are (classname) instantiated in 1 processes.how can i recover the problem. my cache instance is Cache 5.0
I have done Python - Cache binding setup following the guide from http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…. I have also run test.py from sample3 folder and it able to run and complete successfully.
However, when I try to run the same test.py code via $zf, it gives error with exit code 1.
I've tried running help("intersys.pythonbind3") via $zf and also running from Cache terminal as follows:
which gives me the following output: