Question

Alexander Grishkan · Sep 20, 2019

eFax

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")

#Caché

0 5

1 315

Question

Güvenal · Oct 22, 2019

How to call a class query from .NET client application

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")
---

#.NET #Caché

0 4

0 354

Question

Steve Pisani · Oct 19, 2019

Common Testing Frameworks.

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)

#Testing #Caché #Ensemble #InterSystems IRIS

0 4

0 538

Question

David Underhill · Oct 18, 2019

Deploying code to production site

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?

#Caché #InterSystems IRIS

0 2

0 367

Question

Elize VdRiet · Oct 16, 2019

Caché Cannot convert ODBC Time

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.

#Caché

0 3

0 493

Question

kandhan ramalingam · Oct 11, 2019

Cache NodeJs Network Connection

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){

#Node.js #Caché

0 8

0 272

Question

Kyle Shelton · Oct 15, 2019

Error #197 while creating a namespace

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.

#Caché

0 2

0 261

Question

Marcos Roberto · Oct 15, 2019

RewindJSON

Good Morning! How can I use the method Rewind() to read a file JSON?

#JSON #Caché

0 3

0 260

Question

Yone Moreno · Oct 13, 2019

Using class queries to select all rows and return an array: unexpected behaviour

We have in DB two books, first is loaned because it has the Friend ID, and the other is in the shelf.

I execute a class query to get all loaned books:

Query BooksLoaned() As %SQLQuery
{
SELECT *
FROM Library.Book
WHERE Friend IS NOT NULL
}

Which I have tested throught the portal:

#Code Snippet #SQL #Caché #Ensemble

0 6

0 355

Question

Jimmy Christian · Jun 17, 2019

REST Beginner Question

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

#Beginner #JSON #REST API #Caché

0 7

0 733

Question

Yone Moreno · Oct 13, 2019

What is inside a Package.Class and s not property, nor method nor parameter?

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:

#Code Snippet #ObjectScript #Caché #Ensemble

0 2

0 184

Question

Yone Moreno · Oct 11, 2019

Import a WSDL to generate SOAP Operations

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:

5319	The type of a property in a serial class cannot be recursive: %1

#SOAP #Caché

0 1

0 399

Question

Eamonn Fox · Oct 8, 2019

Electronic signature capture

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

#Caché

1 14

0 337

Question

Yang Jiao · Oct 9, 2019

Anyone familiar with class mapping of Antrim LAB/FIN systems?

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!

#Mapping #SQL #Caché

0 1

0 252

Question

Roberto Cahanap · Oct 7, 2019

Anyone ever use %Activate with Excel?

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:

#Caché

0 10

0 372

Question

James Hipp · Oct 7, 2019

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

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

#Databases #Caché

0 1

0 267

Question

Nicki Vallentgoed · Oct 7, 2019

&SQL and ORDER BY ID DESC

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?

#SQL #Caché

0 7

0 354

Question

Gabriel Porto · Oct 5, 2019

%ToJson not working

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

#JSON #ObjectScript #Caché

0 4

0 473

Question

Martin Karas · Oct 1, 2019

NoExtent and object references

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?

#Caché

0 6

0 245

Question

Ciaran Mooney · Sep 20, 2018

How to Open Terminal In Caché Mac OS

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:

#Caché #Terminal #ObjectScript

0 10

0 932

Question

sapna gera · Aug 7, 2017

Problem with Server side methods

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.

#Caché

1 3

0 817

Question

Karthikeyan Red... · Sep 27, 2019

Using ctrl-c during checking the list of databases

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. Below is my scenario

I use the below command to check the list of database

%SYS>do ^MSU

#Beginner #System Administration #Caché

0 3

0 267

Question

just fig · Sep 27, 2019

How can i go through the full result once?

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

#SQL #Caché

0 2

0 269

Question

Thembelani Mlalazi · Sep 25, 2019

Soap Service How to pass a Stream Response

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

#API #SOAP #Caché

0 5

0 621

Question

Josnei André Ts... · Sep 25, 2019

<STRINGSTACK> error converting a JSON

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

#Caché

1 2

0 428

Question

Kevin Chisholm · Sep 24, 2019

Can Studio Connect to Cache 2018.1

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

#Studio #Caché

0 4

0 292

Question

Gunwant Kapade · Sep 22, 2019

How to run REST API through browser

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

#REST API #Caché

0 11

0 759

Question

Daniel Buxton · Sep 22, 2019

Lost my journal files

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?

#Journaling #Caché

0 5

0 800

Question

Vikash Aravindh · Sep 20, 2019

The Foreground Process (DNS Connection) working Fine But the Background Process is not working.

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

Platform:
Windows Server 2008 R2 Standard.

database:
oracle in OraClient12Home1 (64-bit).

#Caché

0 2

0 302

Question

Rizmaan Marikar · Sep 22, 2019

Run a cache expression stored in a variable

Hi All,

I have a class method, this can be any cache expression to execute (usually a class / method and args) and and args stored in a variable, for example;

set aa = "##Class(Utils.Test).Run(1,2,3)"

do aa

I tried using $classmethod(class,method,args..), by extracting the values but sometimes there can be no arguments, or arguments such as ;

("2019-01-01","1,2,3,4")

which causes issues while running the $classmethod, (i am using $P to extract the Class, Method and args).

Is there any simpler way of doing this?

#ObjectScript #Caché

0 4

0 288