here is my trigger:

CREATE TRIGGER "SQLUser".SYM_ON_U_FOR_SYM_CHNNL_125123 AFTER 
UPDATE
   ON "SQLUser"."sym_channel" REFERENCING OLD ROW AS OLD NEW ROW AS NEW FOR EACH ROW 
   DECLARE @var_row_data VARCHAR(16336);
WHEN
   (
      1 = 1 
      and 1 = 1
   )
   -- I will use OLD/NEW alias here set @var_row_data = ''; LANGUAGE sql insert into mytable (id, data) values(1, @var_row_data);

here is error message

Last answer 6 days ago
0   0 2
0

comments

42

views

0

rating

I want to have a generic PercentOfAll measure that can be used for any dimension of the cube. This PercentOfAll should act like Count, but instead of showing the number of rows in a cell, it will show the percentage  (100*number of rows for that member/all rows) .It should not matter what dimension is being viewed. Ex

There are a total of 100 rows in the source class.

For dimension columnA which returns value in  ColumnA column in source class, 10 rows contain "A" the rest contain "null". When viewed on the analyzer, with columnA as a row and PercentOfAll as a measure, the cells values should be:

"A"       10%

"null"  90%

 I can achieve this using an expression that would be specific to columnA dimension Ex columnA. CurrentMember/columnA.[All columnA].%All

But I do not want to have to define meausure for each and every dimension. I just want to have a measure that will be used for all dimensions. Ex

Last answer 7 days ago
+ 1   0 1
0

comments

35

views

+ 1

rating

I am building a cube based on a source class, which I  will call,  Family.Dad 

In the class definition for Family.Dad, there is a relationship, offspring  As Child  [ Cardinality = children, Inverse =  father]

In the class definition for Child, there is a relationship called father As Dad  [ Cardinality = parent, Inverse =  offspring]

In the actual data, a dad can have many children, but a child can only have 1 dad.

Using DeepSee, I am trying to analyze to answer questions such as how many dads have children called Joseph ( Ex dad.offspring.GetAt(x).Name) etc .

Last answer 14 April 2019 Last comment 7 days ago
0   0 1
63

views

0

rating

Is there a way to have a context property be available across 2 or 3 different business processes? For example if I am setting a value in a context property within one business process and want to use the same context property in a second business process, is this possible? Is this something that can be done with the "Context Superclass"?

Last answer 7 days ago Last comment 7 days ago
0   0 4
80

views

0

rating

Hey Community!

The latest webinar, recorded by InterSystems Sales Engineers @Sergey Lukyanchikov and @Eduard Lebedyuk, is already on DC YouTube Channel! Please welcome:

"Machine Learning Toolkit (Python, ObjectScript, Interoperability, Analytics) for InterSystems IRIS" 

 

Last comment 7 days ago
+ 1   1 2
119

views

+ 1

rating

Hello guys,

I have been playing around with the deployment tools from Ensemble (mostly based on this article https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...) , but so far the one thing I still couldn't figure out is how to release the fact that I deleted files/components from my source production and that will get reflected in my target production.

Basically the target production has got A, B, C and D. Source has got A and B, because C and D aren't needed anymore. How do I generate a deployment XML with these information and once I release in the target production, Healthshare will get rid of C and D?

I couldn't find any info in the above documentation, so any tips would be more than welcome.

I have come across a few bugs in the deployment tool in the past and I hope this isn't another one or a lack of the functionality I need

Last answer 7 days ago
0   0 2
0

comments

53

views

0

rating

Hi!

 

When I try to send a hl7 message via TCP / IP with SSL certificate, I get the following error:

ERROR <Ens>ErrTCPTerminatedReadTimeoutExpired: Tiempo de espera de lectura TCP (600) superado mientras se esperaba el terminador SegTerminatorAscii=13, on |TCP|35000|6596, datos recibidos =''

 

 

I have increased the response time to 10 minutes but still, I do not get to receive the message.

As I said in the remote system the process of negotiating the SSL certificate takes about 10 minutes and after that the message appears. I think it's too long. Is there any way to see more traces of the SSL certificate negotiation process in Ensemble?

 

Framing = MLLP

Last comment 7 days ago
0   0 2
0

answers

30

views

0

rating

When I try to open a DTL in the tabbed editor I always get this error:

You are using Internet Explorer 7. This version is obsolete and is not compatible with diagram editors. Please update Internet Explorer to a recent version.

My actual Internet Explorer is version 11.

I'm running Eclipse Photon.

  Atelier IDE    1.3.141    com.intersystems.atelier.feature.group    InterSystems Corporation

The same error occurred with Atelier 1.2 on Eclipse Oxygen. I've never been able to get this to work.

It seems hard to believe that no one has solved this problem, but I never found any solution at Developer Community. 

 

Last answer 8 days ago Last comment 8 May 2019
+ 2   0 3
76

views

+ 2

rating

Hi! I'm Andreas, the developer of Caché Monitor.
Caché Monitor is a database tool with special feature for InterSystems Caché. Since today also with support for InterSystems IRIS!
A public pre release is available for download: https://www.cachemonitor.de/cache-monitor-beta-releases/

 

Please give it a try!  Feedback (email preferred) is always very welcome!

Thanks for your time!

 

Andreas

+ 2   0 2
0

comments

76

views

+ 2

rating

First, my $ZVERSION:

Cache for OpenVMS/ALPHA V7.x (Alpha) 2010.1.6 (Build 952_2 + Adhoc 17754) 3-JAN-2018 14:32:54.07

Second, my issue:

I believe my current villain is “incremental compiling.” I was able to compare early compile output with later compile output:

Compilation started on 04/10/2019 10:46:32 with qualifiers 'cuk'
Compiling class UnitTests.Task3496 incremental compile detected
Compiling routine UnitTests.Task3496.2
Compilation finished successfully in 0.800s.

... several compiles later...

Compilation started on 04/10/2019 13:35:33 with qualifiers 'cuk'
Compiling class UnitTests.Task3496
Compiling routine UnitTests.Task3496.1
Compilation finished successfully in 0.999s.

The problem that I am having today is that the %STACK is showing my code executing code that has been commented out

Last answer 9 days ago Last comment 8 days ago
0   0 2
68

views

0

rating

I am trying to create a URL for Spoke Mobile to page users when our email system is down and we can't use the normal email alerts.

I was directed to http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=EHTTP_outbound and tried to create something.  The best I got was a response from the webpage that told me there was an error.

I want to be able to have a default pager number when we don't have an oncall schedule and grab information from Ens.AlertMessage.

 

I thought this would work

Last answer 9 days ago Last comment 9 days ago
0   0 3
66

views

0

rating

Hey Community!

It's time again for good tidings for you! 

For the first time, InterSystems will be part of the WeAreDevelopers World Congress in Berlin, Germany, which brings together developers, IT experts and digital innovators to discuss and shape the future of application development.

From 6 to 7 June, we’re ready to welcome you at our booth #A5 and show you how InterSystems technologies enable intelligent interoperability and accelerate the creation of powerful, data-driven applications.

Schedule your individual meeting with InterSystems @ WeAreDevelopers in Berlin by quickly filing out the form on our event page [https://dach.intersystems.de/WeAreDevelopers2019] – the first three applicants will receive a FREE ticket!

+ 1   0 1
0

comments

65

views

+ 1

rating

Hi Community!  

Check the second Developer Community Video of the week:

Docker Containers: Essential Knowledge

 

Last comment 9 days ago
+ 1   0 5
279

views

+ 1

rating

I am attempting to use Node.js to perform a simple query against the database using some identifying information to get the ID. This is what I am attempting to do:

 

var irisobj = require('iris');
var myData = new irisobj.IRIS();
var result = myData.open({ path:"C:/InterSystems/IRIS/Mgr",
                       username: "USERNAME",
                       password: "PASSWORD",
                       namespace: "YOURNAMESPACE"
            }
        );

var result = myData.invoke_classmethod({class: "%SYSTEM.SQL", method: "Execute", arguments: ["SELECT TOP 1 ID FROM SOMETABLE"]});
console.log(result);

myData.close();

Why doesn't this work???

Last answer 10 days ago Last comment 10 days ago
0   0 2
71

views

0

rating

The preview release of InterSystems IRIS 2019.2 is now  available - give it a try!

 

Container images are available via the WRC's preview download site.

The build number for these releases is 2019.2.0.100.0.

 

InterSystems IRIS Data Platform 2019.2  is the first CD (continuous delivery) release of InterSystems IRIS.  It has many new capabilities including:

Last comment 11 days ago
+ 3   0 2
180

views

+ 3

rating

Hi

I am working with a Caché system with a Python binding and big datasets in health care. I am using the Python library Pandas and Jupyter notebook for data manipulation and often special modules for different projects, including different versions of Python. To keep the environments separated, I have been testing Docker, but I am at loss on how to install the Python binding. Has anyone any experience with this? Or better yet, a Docker image that has the binding installed?

I am also considering that Docker might not be the suitable for this situation and I am grateful for any thoughts on this.

Last answer 8 May 2019 Last comment 11 days ago
0   0 3
121

views

0

rating

Hi Community!

We're pleased to announce that that InterSystems IRIS Community Edition is available on the Docker Store! InterSystems IRIS Community Edition is the no-cost developer edition designed to lower the barriers to entry to get started with IRIS. Now that it is listed on the Docker Store, running an IRIS Community instance is as easy as -

docker run -d -p 52773:52773 store/intersystems/iris:2019.1.0.511.0-community

 

For more on running IRIS in containers check out our Documentation or one of the many Community posts on the topic!

 

Last comment 12 days ago
+ 8   2 6
471

views

+ 8

rating

Have some free text fields in your application that you wish you could search efficiently?  Tried using some methods before but found out that they just cannot match the performance needs of your customers?  Do I have one weird trick that will solve all your problems?  Don’t you already know!?  All I do is bring great solutions to your performance pitfalls!

As usual, if you want the TL;DR (too long; didn’t read) version, skip to the end.  Just know you are hurting my feelings.

If you open up your version of Sample.Company in the SAMPLES namespace of a recent (2015.1 or later) Caché/Ensemble/HealthShare version you will see a Mission field that is pseudo-randomly generated text.  Suppose we want to search this text field.  For the purpose of this exercise, I generated about 256,246 companies – feel free to populate some on your own and follow along.  Well you might run the following query

Last comment 12 days ago
+ 19   1 3
1225

views

+ 19

rating

Hi! I've been fiddling with linked tables to get data from other servers, and I encountered a problem that I'm curious about. Maybe I'm not using these tools as intended or there's more going on, so I'm asking here.

I'm running a query on linked table A, something simple like this:

select name from A where id = 5983658923646

And I get this error:

[SQLCODE: <-400>:<Fatal error occurred>]

  [%msg: <>]

If id, or anything comparison, is something smaller like 4345, it works just fine. It's only when the where reaches a certain length, not just id, that it fails.

After switching Dialects from CACHE to MSSQL, it works! Does anyone know the reason for this? Is the linked table connection using something the cache dialect doesn't understand

Last answer 8 May 2019 Last comment 12 days ago
0   0 3
66

views

0

rating

Hi!

I was trying to create a query that can be exposed as a stored procedure (function actually) that would return a resultset with a random number of columns. 

Unfortunately, it seems that unless I specify the ROWSPEC annotation on the Query method, I won't get any columns exposed. I was hoping to implement QueryNameGetInfo method and specify the names and number of columns I would be returning dynamically. But it seems that GetInfo information is simply ignored.

Here is my code

Last answer 8 May 2019 Last comment 12 days ago
0   0 3
87

views

0

rating

Hi community.

I need to get the parent classname of a class, but I don't find how to do it.

 

I have a class Parent  (MyLibrary.ParentClass) and two classes inherited from the parent class

MyLibrary.ParentClass

       ├─── MyLibrary.ChilcClass01
       │
       ├─── MyLibrary.ChildClass02

I have a Business Process that entry class is MyLibrary.ParentClass. If I'm calling with any child class (i.e. MyLibrary.ChildClass01) it works, then I'm using the method $Classname(request) to get the name of the class and redirecto to other process.

But I want to check that the request is a class inherited from MyLibrary.ParentClass. How to do it?

 

Best regards,

Francisco López

Last answer 12 days ago Last comment 12 days ago
0   0 2
69

views

0

rating

Unix:  I'm trying to switch to using the $ZF(-100 function in place of $ZF(-1.   I have it working for a simple, single, cmd, but can't figure out how to pass a piped sequence.  Maybe this just isn't allowed?

For example:

S sc=$ZF(-1,"ps -Af | grep username")

works, but I can't figure out how to format this for the $ZF(-100 function.

???

Thanks

Last answer 13 days ago Last comment 12 days ago
0   0 3
100

views

0

rating

Hello,

We're having troubles with working over Telnet on Caché Unicode with WRQ Reflection.

We can't input extended characters (é,à,Ø,...), DELETE-key doesn't work, ...

Has anyone a solution for working with WRQ Reflection or a decent alternative ?

We tried Putty and Caché-terminal but these are not sufficent.

 

Regards,

Kurt Hofman.

Last answer 13 days ago Last comment 12 days ago
0   0 4
113

views

0

rating

The preview release of IRIS for Health 2019.2 is now  available - give it a try!

 

Container images are available via the WRC's preview download site.

The build number for these releases is 2019.2.0.100.0.

 

InterSystems IRIS for Health  2019.2  is the first CD (continuous delivery) release of IRIS for Health.  It has many new capabilities including:

0   0 1
0

comments

103

views

0

rating

I am following the ESB tutorial(https://learning.intersystems.com/course/view.php?id=77) and using my local system(2014.1.5) windows 7.  I click the button on SoapUI for the Weather piece (http://127.0.0.1:57774/esb/soap/Weather/GlobalWeather.asmx) and get the response of   <text>ERROR &lt;Ens&gt;ErrBusinessDispatchNameNotRegistered: Business dispatch name &apos;EnsLib.SOAP.GenericService&apos; is not registered to run</text>

checked the Event Log

Last answer 4 February 2017 Last comment 6 February 2017
0   0 3
562

views

0

rating