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

 Class demo.CoffeeMakerRestServer %CSP.REST

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

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

The class name is ConwayLifeGame

Is CWLF an alias for the class name?

If yes where is it defined?

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:

Method Open(Filename As %String, UpdateLinks As %Activate.Variant, ReadOnly As %Activate.Variant, Format As %Activate.Variant, Password As %Activate.Variant, WriteResPassword As %Activate.Variant, IgnoreReadOnlyRecmmndd As %Activate.Variant, Origin As %Activate.

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.

The secret to this lies in making use of the "Intermediate code" (.INT) which is generated when you compile classes (.CLS), routine code (.MAC) or CSP pages (.CSP).

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.

Is there a way to estimate compaction / truncation sizes? For a DB when trying to reclaim disk space.

Basically, is there some utility or CLI command that would allow us to estimate if it is worth the effort of compacting a large database or not.
 

Thanks

Hello again and welcome to the next tutorial on this series: Part 5 - Errors. Here we are going to learn how Frontier handles unexpected errors and how we can force them.

I know &SQL returns only one result but is 

&SQL(SELECT ID FROM Cinema.Film ORDER BY ID DESC)

and

&SQL(SELECT TOP 1 ID FROM Cinema.Film ORDER BY ID DESC)

the same in terms of processing required?

%ToJson doesn't work in 2015 release of cache, How to transform a object to json in this release ? 

Hello,

lets have two  abstract %Persistent classes A,B with NoExtent keyword (storing data in separate globals for each subclass).

Class A Extends %Persistent [Abstract, NoExtent]

{

}

Class B Extends %Persistent [Abstract, NoExtent]

{

     Property Aref As A;

}

Let B class reference the A class. Since the A class has no extent the reference wont work in subclasses. It wont be even usable in SQL.  Is it possible to solve this problem? Whats the recommended way to deal with references/relationships using NoExtent?

HI,

I am a newbie so excuse my basic questions.

I have installed Caché on Mac Os High Sierra 10.13.6 and have started the ObjectScript tutorial but I cannot open Terminal in Caché.

The instructions provided on the tutorial don't appear to be for Mac OS as there is no cube icon:

n order to begin practicing using ObjectScript, you need to start the Terminal. Click the Caché cube iconin the task bar and select Terminal from the menu. This brings up the terminal window, and you can see from the prompt that we are in the USER namespace.

I have been trying to pass a %Global  character stream back on a Soap Response has anyone one out there done it before please help with guide lines on how to achieve this thanks in advance just some working sample code and will take it from there thanks again

getting "The value of the property 'cspHttpServerMethod' is null or undefined, not a Function object" error while executing the csp page. All the server side methods stop working at this time although javascript functions still work but until the point where a server side method is getting called. Any clues why we get such error.

A permanent job opportunity has arisen for a Caché/Ensemble developer with at least 5 years experience. My client is a specialist resource provisioner of developers for high profile clients in the finance,  healthcare, retail, distribution and credit business that are mainly based in central London. My client is looking for a highly-motivated individual who thrives in an environment where problems are open-ended.

This week I am going to look at CPU, one of the primary hardware food groups :) A customer asked me to advise on the following scenario; Their production servers are approaching end of life and its time for a hardware refresh. They are also thinking of consolidating servers by virtualising and want to right-size capacity either bare-metal or virtualized. Today we will look at CPU, in later posts I will explain the approach for right-sizing other key food groups - memory and IO.

Hi ,

I am new to cache and I want to check with the experts to see if using the ctrl-c option while checking the list of databases is valid one or will it cause any issues.

When i use  ##class(%SQL.Statement).%New() -> .%Execute() and then  .%Next() to go through the result set, i could only go through part of the result. And then, i have to call  .%NextResult() to go through the next part of the result. BUT, the  .%Display() could show all of the result.

How can i go through the full result once,like .%Display()? Or how should i do to go through the full result? Is there anyone can help me? Waitting!!!

Good afternoon,

I'm trying to convert to JSON, but the error <STRINGSTACK> is displayed when I run the command below:

Do ObjJson.Write(ObjSource.%ToJSON())

Does anyone know how I can solve?

Thanks,

Josnei

Hi,

I am wondering if there is a version of Studio which connects to Cache 2018.1 or do I have to use Ateleir?

Thanks, Kevin

Hello friends,

I am trying to create REST API in Cache. I am getting a response from postman but when I tried to launch the same URL on the browser, I am getting service unavailable error.

This is my URL http://localhost:57772/widgetsdirect/rest/Gunwant

Any help is greatly appreciated.

Thanks and Regards, Gunwant Kapade

I had my journal files all on one disk which died :( 

The database files are all fine, but I having issues.  Can I bypass the need for the journal files?

Environment: cache version : Cache for Windows (*86-64) 2015.1 (Build 429).

Platform: Windows Server 2008 R2 Standard.

database: oracle in OraClient12Home1 (64-bit).

We Configured cache and odbc in above environment. And we checked ODBC connection, it also working fine. And then we tried to connect the ODBC through the background but it's ending with gateway failed error. And again we tried the same process in foreground, it's working fine and also we got the data from the database. we checked the license key and cache privileges,all are good.