Hi All,

We have a licensed version of Ensemble but for now, we use only the DB capabilities of Cache. As we create a custom Namespace, for e.g "Test", a new Ensemble Namespace is automically created by the system --"TestENS".

Is there any way where we can identify the system created ENS namespaces ?

Hi guys,
I ran into a strange (for me) situation, when I run same query but change the WHERE clause the plan is different and is not connected to the additional condition.
Query that doesn't use the necessary index:

Hi,

   I needs to send FileBinaryStream which stored in cahce DB to NodeJS.

Thanks

Hi Community,

The new video from Global summit 2019 is already on InterSystems Developers YouTube:

⏯ Adopting InterSystems IRIS

Hi all....

I couldn't find documentation on how to create a blob using the cache JDBC driver.
I found only one reading example:

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?…

The createBlob Method of the connection class was not implemented:

https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?…
 

Does anyone know how to create a blob without compromising the java heap space?

Can anyone tell me how to add a simple running total in Cache SQL.

I'm selecting a quantity in the first column and want a running total in the second:

9 ,   9

2 , 11

7 , 18

When dealing with a support issue of one of our Deltanji source control sites this week I learned that if you're using InterSystems versions earlier than 2018.1 on Unix-type platforms it's possible that a class you export in UDL format will subsequently fail to import. So I'm posting this information here in case it helps other folk.

When calling the below stored procedure using the management portal (Run Query) no data is being retrieve, but if it is directly executed management portal data will show.

"IN" does not work changing it to "=", "like" the stored procedure will work. Does any one know how to fix this ?

Pass values to code is  'AB','TS','SK','GM'

Query LoadData(code As %Library.String) As %SQLQuery [ SqlProc ]
{

SELECT STRING(Descrtiption,' (',Code,')') as Description,Code FROM Test.Codes 
WHERE Code  IN  (:portCode)
}

Hello everyone,

I want to introduce you my project.

There was a common task in my work to create documents, in which I need insert some information about person: full name, birth date, address and etc. I wrote the application to do it in the simplest way.

The idea is not brand new and was implemented in other languages. I wanted to make a similar tool for Cache Object Script. The concept is following.

You create a template document in LibreOffice or Microsoft Word using special semantics.

I am having trouble sending URL encoded payload to eFax in FormData. Does anyone have experience working with the eFax? Their support is not the greatest.

This is what I am trying to send

s rObj.ContentType="application/x-www-form-urlencoded"

d rObj.InsertFormData("id", "123456789")

d rObj.InsertFormData("xml", $zcvt(filestring,"O","URL"))

Any suggestion would be greatly appreciated. 

Hello!There is a class query “MemberStatusList” in the SYS.Mirror class that I would like to call from a .NET client application. I know that means that there is also a generated class method called MemberStatusListFunc. What is the best way if any exist to call them from a .NET application?Just see if anything responded I tried using something like…IRIS iris = IRIS.CreateIRIS(conn);var returnValue = iris.ClassMethodString("%SYSTEM.Mirror", "MemberStatusList", "NAMEOFTHEMIRROR")---That executes the method and returns the reference as a string to a %SQL.ClassQueryResultSet.Obviously I would

Hi,

I'm after feedback and comments on the sort of tools and approaches the wider InterSystems community uses for QA Testing applications written in Cache/Ensemble or IRIS.   I am aware of the %UnitTest package, and understand how that works... but:

- Do you use an alternative or framework built around this native Unit Testing tool ?

- What is your experience with %UnitTest if you use it ?

- Is there a tool you would recommend for your UI (I know this is not specifically an InterSystems' related question)

- What process do you use to routinely run tests on your application ? 

I was hoping for some input on the best way to deploy code to site with the following criteria:

 - No source code, only compiled code to be deployed.
 - Classes and Routines are part of the application.
 - Data and code reside in the same database.
 - Deployments might be partial updates  (i.e. cannot just send a complete CACHE.DAT).

At present the idea is just to export the .obj, any suggestions?

I am integrating with Front End using ODBC to the Caché tables.

I have a property of type %Library.Time in one of the Caché classes FrontEnd which is in C#, it is not possible in C# to represent only a Time type, it always has a date as well (DateTime type, no Time only in C#), but that is fine, should not be a problem, so for Time the date simply defaults to 1900/01/01. 

Now when this is sent to Caché it does not like it and I would like to understand why because this is causing us not to be able to use a Caché property of type TIME ever.

This is the error from Caché

Today, I was reading some source code, and encountered the following method signature:

Method SendRequestSync(pRequest As %Library.Persistent, ByRef pResponse As %Library.Persistent)

And I immediately thought, why is there a ByRef?

With the recent release of macOS 10.15, Apple has tightened its control mechanism , called Gatekeeper, so that it now requires executables to be notarized.  InterSystems products are not currently supported for use on macOS 10.15 and the executables have not been notarized.  (As a reminder, InterSystems products are supported on macOS as a development platform only.)

Hi,

NodeJs(v0.10.0) to Intersystems Cache2014( using cache0100.node)  network connection Not working .

This is error msg i'm getting

"{ ErrorMessage: 'Error loading Cache Library: _SYSTEMcache.dll; Error Code : 126 (The specified module could not be found.)',
  ErrorCode: 1009,
  ok: 0 } "

My Code ->

user.open({ip_address:"127.0.0.1",tcp_port:57772,username: "_SYSTEM",password: "SYS",namespace: "USER"},function(err,res){

    console.log("Error : ",err);console.log("Result : ",res);

    if(!err){

        user.close();

    }

});

But path connection working fine.

Thanks

Hello,
I am currently trying to create a namespace and I keep receiving error #197 when I try to create the database for it. My OS is Coentos 7.7, my cache version is 2016.2.3.903.6.18300 and here is a screenshot of the error. 

Hello,

I am taking some intro lessons in REST from the online courses. Below is a very simple code i wrote. But when i try to see the output by entering the url

http://localhost:57773/rest/coffeemakerapp/coffeemaker i get an error "

This page isn’t working

If the problem continues, contact the site owner.

HTTP ERROR 401

Thanks,

Jimmy

I  am reading the following code in ObjectScript:

GitHub repository
 

And there is a sentence which I am facing difficulties to understand:

    kill ^OPNLib.Game.CWLF(..World)

I know that kill removes variables, OPNLib.Game are the package and subpackage, and ..World is a property. However what does CWLF mean?

You could think that it is the class' name, but it is:

Class OPNLib.Game.ConwayLifeGame Extends %Persistent

The class name is ConwayLifeGame

Is CWLF an alias for the class name?

If yes where is it defined?

Because if we see all the definitions in the current class, we do not found CWLF:

I have the following message when I try to import a WSDL to generate a SOAP service:

ERROR #5319: The type of a property of a class series cannot be recurring: SeleneHL7Service.hl71.escapeType:escape
  > ERROR #5030: Error occurred while compiling SeleneHL7Service.hl71.escapeType class

I have found in the documentation:

What means?

How could fix it?

Hi,

Is anyone out there using Cache to capture electronic signatures? The device would have to be called from a telnet session.

Thanks in advance,

Eamonn Fox

Hi!

We are using Rest Service with inheritance of  %CSP.Rest, and we are having the following problem: when we receive 100 request from single IP adress - this creates 100 CSP sessions and takes 100 user licence for each request for few seconds. What can we do do about this? We've  set this parameter:

Parameter UseSession As Integer = 1;

Thank you in advance!

Hi, we are a veterinary lab and we use both the LAB and FIN systems of Antrim. Now we are looking to expose the data in a SQL/Object compatible way so we were wondering if same / similar things had been done by other community members already? If so, could you please share your approach / experience / gotchas with us and we are all ears. I can be reached at yang.jiao@antechmail.com . Thank you! 

Index to Articles

Published 2018-05-11 Last edit -

Hi All

I this article I detail some strategic issues that a new development UI will need to address - these are the ones that I can think of now - others may come to light during this journey.

See the webinar by Eduard Lebedyuk here from the last Global Summit describing  modern web development and Caché

And, as always, if I have missed something please comment....

I used the Activate wizard to create a package for Excel (Activate.Excel). There is a class in there that seems to be what we need to open a file:

Activate.Excel.Workbooks.

There is a method that  has an Open() command. I tried  using it but getting an invalid pointer error.

The  parameters are as follows:

Hi All!! 

I am currently recruiting a very exciting position to work for a leading Healthcare software provider who are on the lookout for an experienced InterSytems Cache/Ensemble Developer for a 4 month contract! 

This will be working on a leading Childrens Health Product and developing applications for the NHS, particularly working on a migration. 

We are looking for: 

• Proven Intersystems Cache/Ensemble development experience;
• Proven data migration experience

Get in touch for more info on Rose.Blackburn@transition-partners.co.uk

Thank you :-) 

Every developer has made the mistake of accidentally leaving temporary debug code in place when they meant to remove it after debugging is complete.  The great thing about writing in ObjectScript is that there is a way to make temporary code be truly temporary and automatically self-destruct!   This can also be done in such a way that the code has no change of making it into your source control stream, which can be helpful as well.

APM normally focuses on the activity of the application but gathering information about system usage gives you important background information that helps understand and manage the performance of your application so I am including the IRIS History Monitor in this series.

In this article I will briefly describe how you start the IRIS or Caché History Monitor to build a record of the system level activity to go with the application activity and performance information you gather. I will also give examples of SQL to access the information.

What is the IRIS or Caché History Monitor?

At LifeLabs, we are focused on our vision of building a healthier Canada!  We are the largest community diagnostics laboratory in Canada with over 350 collection centers, 21 laboratories and service over 19 million patients each year. As the Software developer, you will be concerned with all facets of the software development process.  You will be responsible for the design of application modules, maintain and deploy software applications to meet user and business needs.