Question Mack Altman · Dec 27, 2016

Using global mapping for redirecting new entries into global

Currently, namespace Alpha is configured to use database AlphaDB as its global database. How would we go about having namespace Alpha configured to use database AlphaDB for its global database except where global ^Customers(CustomerId) has a CustomerId greater than 10M, which we would like to have it redirected to database BetaDB.

In other words, ^|"AlphaDB"|Customers contains all customers between 1 and 10,000,000; and ^|"BetaDB"|Customers contains all customers greater than 10,000,000. Any help would be appreciated.

#Caché #Databases #Globals #Mapping #Namespace
4
0 578
Question Aditi Goswami · Dec 28, 2016

Private Property

Hello,

I read the Cache Documentation where it describes Private Property as below:

Specifies that the property is private. Private properties can only be used by instance methods of this class (or its subclasses).
A private property is not displayed in the catalog information (accessed by using %Library.SQLCatalog) and is not returned by a SELECT * query. However, you can explicitly refer to and use a private property in an SQL query.
 
Can someone please explain how to explicitly refer or use the private property in an SQL query?
#Caché #SQL
7
0 762
Question Jonathan Ebbers · Dec 27, 2016

Annotating PDF files

I've been asked to annotate a PDF file (in Intersystems Cache).  That is, take in an existing PDF (printable form with areas for people to write in) and use Cache to update it (automatically fill the fields in).

Does Zen have the ability to set a starting/initial PDF?  I see the ability to define an XML format to write in, but that's not exactly what I need, because that will generate my "answers".

I'd like to overlay my "answers" on top of an original PDF.  Do you know how to do that?

 

 

Addendum:
After many hours of research, I came across the FOP.

#Caché #ZEN
1
0 728
Question Andrei Luiz Nenevê · Dec 19, 2016

Slow Loading of page Mojo

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.

#Caché #ZEN
6
0 473
Question Bill Wang · Dec 22, 2016

Computed property

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:

#Caché #Object Data Model
1
0 587
Question Aman Rana · Dec 22, 2016

Query related to schema message structure

Hi All,

I have below schema structure:

base:MSH~{~[~base:PID~[~{~base:NK1~}~]~[~base:PV1~[~base:PV2~]~]~]~{~[~base:ORC~]~base:OBR~[~{~base:NTE~}~]~base:TQS~[~{~[~{~OBX~}~]~[~{~base:NTE~}~]~}~]~}~}

Now there are few cases where source application is sending NTE segment after TQS segment

Is there any way of updating the schema to use the same NTE from OBXgrp, cause we dont want to update the code logic as its happening for few messages only.

#Ensemble
3
0 519
Article Fabian Haupt · Dec 22, 2016 8m read

On the importance of benchmarking your code

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).
#Caché #Caché #Ensemble #ObjectScript #Performance #Tips & Tricks
0
1 528
Question Evgeny Shvarov · Dec 14, 2016

Intergity test for cbk files

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!

#Caché #System Administration #Backup
2
0 509
Question Surendiran S · Dec 20, 2016

Reading PDF File in Zen

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

#Caché
3
0 838
Question Wolf Koelling · Dec 16, 2016

2017.1 Field test Windows installation problem

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.

#Field Tests #Caché #Microsoft Windows
5
0 654
Article Eduard Lebedyuk · Dec 19, 2016 3m read

Tips & Tricks - SQL queries management

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.
#Caché #Beginner #Caché #SQL
2
0 1602
Article Jonathan Levinson · Dec 19, 2016 1m read

Installing Python Binding on Windows

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
#Caché #Languages #Python #Caché
0
0 1320
Question Evgeny Shvarov · Dec 18, 2016

How to exclude substring(s) from a string

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?

#Caché #Code Snippet #ObjectScript
2
0 500
Article Michael Denhamson · Dec 16, 2016 2m read

Unhelpful error messages when %SuperServer SSL certificate expires.

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.
#Caché #Interoperability #.NET #SSL #Caché
0
0 1292
Question Paul Riker · Dec 13, 2016

How to reference a specific field in a DTL

I want to set the value in the second field of OBX-5, or OBX-5-2. My schema is not broken down to that granular level, so I can't just click OBX-5-2 to populate it. I tried a few variations without success.

target.{PIDgrpgrp().ORCgrp().OBXgrp(1).OBX:ObservationValue(1).2}

target.{PIDgrpgrp().ORCgrp().OBXgrp(1).OBX:ObservationValue(1)(2)}

target.{PIDgrpgrp().ORCgrp().OBXgrp(1).OBX:ObservationValue(1.2)}

 

Any ideas?

#Ensemble #DTL
4
0 982
Question Alok Saldanha · Nov 15, 2016

Create EnsLib.HL7.Message from %String or file?

For testing purposes, I would like to create an EnsLib.HL7.Message from either a %String or a file on disk and pass it into a function in a unit test (outside of an Ensemble context). EnsLib.HL7.Parser appears to do the necessary parsing, but it also sends the message via Ensemble service rather than returning it as a value. Is there a way to leverage the parsing outside of a Ensemble service? Alternatively, is there another way to create an EnsLib.HL7.Message?

#HealthShare #HL7
4
0 3541
Article John Murray · Dec 15, 2016 1m read

Version history for the production class

Last week I was onsite with a new customer of ours, implementing Deltanji to give them control of their development and deployment cycle. One particularly satisfying part of the visit was seeing their pleasure at how their production class now records its changes over time, allowing them to quickly diff the versions and see what configuration items have been added or what settings altered. ​

#Ensemble #Change Management #Tools #HealthShare #System Administration #Ensemble
0
0 462
Article Rob Tweed · May 12, 2016 6m read

Announcing EWD 3: Integrating the JavaScript, Node.js and Cache communities

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.

#Caché #Angular #Node.js #Open Source #React #Release #Tools
11
0 1890
Question Eduard Lebedyuk · Dec 14, 2016

How do I free licenses?

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:

 

#Caché #System Administration #Frontend
1
0 772
Question Sebastian Thiele · Dec 14, 2016

Login to csp application from remote system

Hi,

i have a csp application (namespace default) to which i like to login from remote. This is possible via

http://localhost:57772/csp/namespace/MyApp.MyPage.cls?CacheUserName=<us…;

So the credentials need to be in cleartext which is in fact a problem. The invocation is made within a lan so we don´t need to transport the credentials over the web. Anyway, a remote application likes to use that page (display and work with it) and is able to pass in different parameters. These parameters are encoded in a way I couldn´t figure out yet.

#Ensemble #Security
2
0 443
Announcement Bill McCormick · Aug 25, 2016

Caché 2016.2 and 2016.3 Field Test Programs

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.

#Caché #Compatibility #Release
11
0 1509
Question Peter Steiwer · Dec 12, 2016

Iterating through all properties of an object

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.
#Caché #InterSystems IRIS #Code Snippet #Object Data Model
6
1 3553