InterSystems Caché is a multi-model DBMS and application server. See more details here.
Hi,
I have a Zen Mojo application that haves a tree menu, in this menu I'm loading all records from database (about 1500) and the page is very slow, about 2 seconds to load, I don't know how to get faster.
Hi,
I have 3 classes defined to model the team/team-member/employee relationship, where each employee can belong to multiple teams, each team can have multiple employees, and one and only one team member is a team leader:
I was benchmarking the populate utils when I noticed something strange. Consider this simple benchmarking method:
ClassMethod runBench(count As %Integer = 300000)
{
s types=["name","ssn","company","title","phone","city","street","zip","mission","state","color","product","string","integer","float"]
//s types=["name","ssn"]
s iter=types.%GetIterator()
while iter.%GetNext(.key,.value){
s start=$P($ZTS,",",2)
s opt={}
s opt.type=value
for i=1:1:count{
s res=##class(DataGen.Generator).Hi, Community!
We have our internal backup system which produces *.cbk files for Full, Incremental and Cumulative backup modes.
Does anyone have an automation procedure to restore this files on some target testing system, check the integrity and mark the files as "restorable"?
Please, share?
Thank you in advance!
Hi Frnds, I am beginner of Cache. I know how to copy from a text file to text file. But i'm facing problem while reading PDF directly using Files concepts. Please provide some solution for copying content from PDF to TXT file.
Thanks
Hi,
I have a ZEN page class with the following annotation. What I try to accomplish is to display data from Object of Type MyPckg.Message. Each Message shall be displayed in a component of type <html>. The outline is somekind the following.
Does anybody else have problems installing the Caché 2017.1 FT for Win_x64?
I'm getting an error "Unable to execute the required file: The following system error has occurred: The system cannot find the file specified. (2)"
This is happening with the very latest version (build 726) and the previous one ( build 720), whereas the builds before were fine.
I've uninstalled Caché to see whether it was an upgrade vs clean install problem but it makes no difference.
If you have a lot of SQL queries to external systems (or even internal dynamic ones), you can encounter something like this:
Set SQL = "SELECT "_
"c.cid AS Id,"_
"c.nid AS Nid, "_
"FROM_UNIXTIME(c.created) AS Created,"_
"c.uid AS Uid,"_
"IFNULL(vv.average,0) AS AvgVote,"_
"IFNULL(vv.amount,0) AS VotesAmount,"_
"body.To install the Python binding on Windows one must follow the instructions in the following:
https://blogs.msdn.microsoft.com/pythonengineering/2016/04/11/unable-to…
The reason is that ActiveState Python version 2.7.X is built with Visual Studio 2008 and Microsoft provides Visual Studio 2008, which one must install, so that Python C extensions can be built.
Also, if one still sees the "error "error: Unable to find vcvarsall.bat" message at the Visual Studio 2008 command prompt, then one needs to do the following:
pip install --upgrade setuptools
Hi, community!
Consider you need to exclude substring(s) from a string.
I did it with the following snippet:
/// excludes all the substrings from the string
ClassMethod ExcludeSubstring(substr,str as %String) As %String
{
while ($L(str,substr)>1) {
set str=$Piece(str,substr)_$Piece(str,substr,2,*)
}
quit str
}So, for example:
USER> set str=”ExcludemeGoodstringExcludemeExcludemeGoodstring” w ##class(User.Utils).ExcludeSubstring(“Excludeme”,str) GoodstringGoodstring
Is this the optimal approach or I reinvented the wheel?
So, I played with row level security and was unable to find a way to get to work it dynamically. I want to determine if the user can access the row in runtime based on a state of external system, but it seems that row level access is calculated during INSERT/UPDATE and stored in %RLI index. Is there a way to achieve runtime access calculation?
I have posted to aid others in diagnosing problem with SSL/TLS connections to superserver port from .NET client executable.
The cache instance this appeared on is quite old - 2011 - so I do not know if Intersystems have added a better error message in a later version
The actual fault was due to the certificate in the %SuperServer SSL/TLS configuration having expired.
The unhelpful message that appeared in the .NET client included the following partial stack trace.
*** CacheException.
Hello,
Is there some way to reproduce the SQL GROUP_CONCAT(http://sql.sh/fonctions/group_concat) with the Caché DB ?
Those of you who keep an eye on developments in the mainstream of IT will be aware that a major upheaval has been occurring over the last 5 or so years, in which JavaScript has exploded in popularity and importance. Largely as a result of its server-side incarnation - Node.js - it has broken free of just being the scripting language that you use in web browser, to becoming the world's most popular language and enterprise technology of choice.
As soon as I started playing about with Node.
I have a server with public web application with Unauthenticated access and there seems to be a problem that CSP session ends, but associated license persists for some time (hours). If several users log in, we can hit license limit and all the other users get 503 Service unavailable error.
We are currently debugging it and moving to authenticated web applications, but is there a way to free these licenses quickly?
Here's how it looks like in SMP:
This announcement is to inform clients about changes in our 2016.2 and 2016.3 field test programs.
The 2016.2 field test has been extended in order to address important syntax changes related to JSON. Simply stated, the JSON syntax introduced in 2016.1 had several inconsistencies that we did not want to perpetuate. This is now addressed and the updated 2016.2 field test will be published today. Concurrently, the syntax changes and guidance for developers will be posted on the Developer Community shortly. JSON is critically important to our Caché roadmap.
Is there a better way to iterate through all properties of an object than the following? Perhaps without needing to open a definition of the class but directly against the object?
SAMPLES>set t=##class(HoleFoods.Transaction).%OpenId(1)
SAMPLES>set def=##class(%Dictionary.ClassDefinition).%OpenId("HoleFoods.Transaction")
SAMPLES>for i=1:1:def.Properties.Count() { w def.Properties.GetAt(i).Name_":"_$property(t,def.Properties.GetAt(i).Name),! }
Actual:0
AmountOfSale:4.I see that there is an "Insert Special Character" option from the text editor where "é" can be selected, but would it be possible to create a "Caché" button that inserts the word "Caché"? I can see cases where mixing these words can be confusing. An even more important reason would be searching. If the word "Cache" is used instead of "Caché" in many places, it may be difficult to find information about the "Cache".
If a "Caché" button existed, it may encourage the correct spelling to be used. I am not sure if this is a real problem, but I see the possibility of it happening.
Is there any way that I can check the native type of an object script variable? (similar to the typeof check in javascript)
I see that the DynamicArray class uses the type of the variable for its output, I would like to do something similar when I receive a value as an argument to my method.
USER>s var1 = 123 //No quotes, number type
USER>s var2 = "123" //quotes, string type
//DynamicArray can tell the difference
USER>s arr = []
USER>d arr.%Push(var1)
USER>d arr.%Push(var2)
USER>w arr.%ToJSON()
[123,"123"] //first value is output without quotes, second value is quoted
Hi all,
While i connet telnet for particular user it call (%sys namepace ^Test routine).
In that rotine i switch namespace but the termial was closed(sessio disconnected).
How i can acces the user namespace afer switching namespace ?
Thanks,
sansa.
Hello All,
we have recently upgraded our network humming along 10gb across the board and we're curious as to how or if it is ok to backup cache over smb or to another network drive of that sort. instead of writing directly to local disk. (vmware environment)
How can I prevent large number truncation when using the DynamicObject and DynamicArray classes to create JSON in objectscript and then parsing the result in javascript. Are there any global settings that configure the output when using these classes?
I am looking at converting to the new DynamicObject and DynamicArray classes to build JSON. Our current (homegrown) JSON library forces string representation of numbers too long because of errors we were seeing with long numbers being truncated on the client, I am hoping to accomplish the same with the new classes.
One of the great availability and scaling features of Caché is Enterprise Cache Protocol (ECP). With consideration during application development distributed processing using ECP allows a scale out architecture for Caché applications. Application processing can scale to very high rates from a single application server to the processing power of up to 255 application servers with no application changes.
ECP was used widely for many years in TrakCare deployments I was involved in. A decade ago a 'big' x86 server from one of the major vendors might only have a total of eight cores.
Hi,
Thanks for your time.
Plain $ZF(-1) and $ZF(-2) calls from Cache Studio or Terminal have stopped launching the OS shell from Win10.
cmd (Windows Command Prompt) should be launched.
Configuration:
Windows 10 Anniversary Update, Ensemble 2016.2.0.585.0 Developer Edition x64
Is this common? I have enabled both %Developer role and a Cache CallOut privilege for all users that operate in this scenario.
In Terminal, W $ZF(-1) prints -1, W $ZF(-2) prints -1
In Studio, W $ZF(-1) hangs the IDE, W $ZF(-2) prints 0
In all four cases, cmd (Windows Command Prompt) is not launched!
Any ideas, anybody?
As web application gets more complex, more technologies are involved into the application development. Once it gets deployed in large scale the configuration gets more complex too. For sure one of the most difficult part of the story is the security. In a complex solution when independent servers are feeding single web pages with contents, it is indeed challenging to keep the integrity of such system. HTML5 introduced a (weak) security constraint, the Cross Origin Resource Sharing (CORS). This article tells how to enable CORS for CSP/ ZEN applications.
Beginning with the next release after 2017.1, InterSystems products will no longer be offered on macOS (OS X) as a Server platform. This platform has been re-classified and will be available as a Development platform in future releases.
Hello folks,
We have recently upgraded the cache (5.x) to cache 2016. All are working perfectly. But i am struggling in Telnet.
Working Good,
when i connect to telnet it automatically gets the username(for example when we give the system ip addr(148.168.2.50), the ip address is taken as username) and directly goto the Password field in Telnet on old cache (5.x).
Now my problem is,
I can't get the same from my new upgrade instance 2016. When i connect to telnet it directly goes to username field but not to password field.
What is the problem ?
Hi all,
Which routine use to get username and password (telnet) ?
cache version :Cache for Windows NT (Intel) 5.0.21 (Build 6408) Tue Jan 3 2006 13:28:20 EST
Thanks,
sansa.
Hello. When you export and then import a table of data, is the import smart enough to figure out if a row already exists in the new namespace, and if so update the row rather than just save/add the row?
For example, we have a table in DEV, and the same table in QA. The DEV table has more fields than QA. When we moved up the class, the field definitions went with the table into QA, so now the table definition is the same in both.
We need to export the data from DEV and import it into QA, but file each row in QA as an existing row, and just update its data.
All replies are appreciated. We have put our first client into our production cache database and we are looking at what kind of regular maintenance is needed. We were questioning whether we should defrag the database files using windows defrag program and whether we need to run the defrag for Globals regularly? Should we be doing these routinely , occasionally or not at all?