Hi,

I'm trying to execute a function in a  loop using studio but I'm having an error; "ODBC driver for sql server Invalid precision value"

Any help please?

Example :

for i=1:1:2{

...

SET expression1 = "exec [po_dm].[dbo].[UP_ED_TE_IT] @P__TE_IT_ID = ?, @P__TE_ID = ?, @P__TE_RA_ID = ? ,@P__TE_VAL = ?, @P__LOW_REF = ?, @P__HIGH_REF = ?, @P__LOW_CRI= ?, @P__HIGH_CRI=? "  

set pars(1) = -1
set pars(2) ="A"
set pars(3)= "A"
set pars(4)="B"
set pars(5)="C"
set pars(6)="D"
set pars(7)="E"

set pars(8)="F"

set pars = 8
set status = ..Adapter.ExecuteUpdateParmArray(.tRe, expression

Hi All,

I’m trying to create custom studio template (Menu Tool -> Template ->Template), Please suggest the way to create template.

Note: i'm using ENSEMBLE 2015.

Thanks,

Mohan

Hi Community!

New video "Deploying Shards Using InterSystems Cloud Manager" is available now on  InterSystems Developers YouTube:

Hi everyone

I encountered this error while trying to access a web service (I send a test message with soap ui):

FEHLER #5002: Caché-Fehler: <CLASS DOES NOT EXIST> {my method &class name} .1 *(No name)

I am not able to understand what goes wrong. If I look at the trace on messages in the ensemble message viewer there are no errors. The response message displayed in the trace looks like it is successful but in the SOAP UI tool I get the error message in the response.

Do you have any suggestions?

Thanks a lot and kind regards

Milena

Hi

I need to query my messages and filter by a XML node.  

In the message viewer it would be Critetion Type = 'VDoc Property Path' and class = 'Enslib.Edi.XML.Document'.

At the moment my query looks like this

SELECT *

FROM EnsLib_EDI_XML.Document

where doctype = 'avc:mydoctype'

I need then to look for 'HeadNode:SubNodeValue'

Anyone who could help me out with this?

Thank you

Hi,

Not sure if is possible, but I am trying to find the way to show in the log the username of whoever enable a specific service. The idea is that a service is normally disabled..if someone enable it, the username will be reported to the log...

I have tried with $username but it only return "_Ensemble" when running from ensemble although it works in Studio.

Thanks

I have finished my 4th book about Caché and MUMPS. This will probably be my last.

I am deeply grateful and humbled for all the help I have received from this group and the WW Response Center.

You all have something very special going here. 

Unlike most groups like this, you help those who are struggling to get started, that is unique.

Never lose the attitude of graciously helping the beginner. 

=================================================================================

Following is the book cover, available on Amazon or Smile.

Hi Community:

Just an FYI, our super early bird rate for Global Summit registration saves you $650, but it expires tomorrow, Friday, August 10. 

Here is the link to register: https://www.eventsforce.net/devcon/frontend/reg/thome.csp?pageID=60628&eventID=68

Is Terminal access to the InterSystems IRIS Experience sandbox available?

Hi,

I'm trying to find the faster way to get the data from a class, and I find it very slow compared to traditional globals. So, I hope some of you can bring some light to me :-)

I have thousands of registers in a class, and to access it quickly I'm going with $o at the index. From there, I get the values using $listget().

Hi ISC Community!

I'm pleased to announce new release of Caché Web Terminal 3.1.4.

What's new:

1. Drag'n'drop to Studio installation: just import xml in any namespace.

2. After import and comilation access your web terminal app on URL  server:port/terminal/.

F.e. localhost:57772/terminal/       

Slash is mandatory.

3. No need to use %CACHELIB anymore - please feel free to update your Caché and continue using CWT.

Download release here.

Source code for view and contribute here.

Post your issues here.  Want to add your own features - fork it!

Featured screencast   (previos version).

Enjoy!

Hi Everyone!

Very soon, almost every product and application will include artificial intelligence (AI).

On the afternoon of Wednesday, October 3, at the Global Summit 2018  in San Antonio we’re pulling together experts from InterSystems and from the front lines of the AI industry to discuss the current and future state-of-the-art for AI solutions. 

Learn more about our Post-Summit Symposium: Artificial Intelligence and Machine Learning.

Hi, Community!

Continuous Delivery is a software engineering approach in which teams produce software in short cycles, ensuring that the software can be reliably released at any time. It aims at building, testing, and releasing software faster and more frequently. The approach helps reduce the cost, time, and risk of delivering changes by allowing for more incremental updates to applications in production.

Join us at 07:00 UTC, April 24th for a webinar with a live demo "Git flows and Continuous Delivery" by @Eduard Lebedyuk 

The language of the webinar is Russian.

Also, see the related articles on DC.

Hello community,

I am pleased to announce version 1.1 of this project. Now Russian 

Hi Community!

Great News: Marketing  got a confirmation this week that a leader in AI innovation will be the keynote speaker at a special AI event to be held at the Global Summit on Monday night.

See the details below.

In a single server environment, it is rather easy to create a transaction consistent backup.

Simplified:
You find (or force a specific point in time with no open transactions.
Freeze your server, take a snapshot and you are done.

Can anyone tell me what controls the contents of the Facility column of the Encounters tab in the clinical viewer of Healthshare? I am ADT messages to populate the columns and have been unable to change the displayed value.

Might this be a TrakCare modification?

Thanks,

LG

Hi everyone

I am new to the bpl diagram. I would like to add an if statement that checks whatever an object is null or not.

I guess that: condition='response.Content != null' would not be ok...

I tried to search for this information in the documentation but I didn't find any help.

Do you have any suggestions?

Thanks and best regards

Milena

Hi Everybody!

The previous webinar rescheduled due to technical issues.

We are pleased to invite you again to the live webinar "It’s Machine Learning, Not Rocket Science!" on 31st of July at 11:00 a.m. EDT!

Good afternoon everyone,

I hope you are well,

I am currently working on the below opportunity and if anyone here would like to hear more details please feel free to contact me on 01908 886 030 or teo.rusu@identifiglobal.com

Met with the client yesterday, beautiful office in Waterloo London, latest tech available with many benefits including working from home 2 days/w as well!

Intersystems Caché Senior Software Engineer

London

Salary up to £75,000 (negotiable  for the right candidate)

An exciting Software as a Service company creating enterprise software used by 33,000+ people globally.

Hello,every body. 

I am having a problem when using atelier. I found that the web front-end related files (such as csp, css, js, etc.) will change in format when they are synced to the server.

For example:

The original format of the js file may be UTF-8. However, when I edited and saved in atelier, the file version format on the server became ANSI. I tried to configure the environment in eclipse, but it doesn't seem to work.

E.g:

Because the file contains Chinese characters, this has a significant impact on the actual use.

So, what should I do to solve this problem. Thank you in advance.

Hi, every time I launch Atelier for the first time after my PC boot, it reports an error when trying to connect to a server.

Restarting Eclipse solves the issue and it no more manifests until next PC reboot.

Does anyone know how to avoid this issue? I run Windows 10, Java JRE 8

The following code snippet is a REGEX that validates characters that are not in English, as well as English characters. The class method "test" takes an email address and validates it based on this additional criteria:

Hi Everyone!

Enjoy a new video on InterSystems Developers YouTube Channel:

Elements of Sharding

Hi I am getting below error while upgrading cache instance. Please suggest.

Error: ERROR #70: *** Error while formatting volume because ERROR #18: failed creating a new volume initializing CACHETEMP, /*****/databases/cachetemp/ - Shutting down the system An error was detected during Cache startup. ** Startup aborted **

Are you thinking of attending the Solution Developers Conference at Global Summit 2018? 

Time is running out to get your super early bird discount and save over $650 (USD) off the regular conference rate.    Your registration includes admission to all sessions, social activities, the Sunday welcome reception, breakfasts and lunches for all three days of the conference, evening  the social events and a post-summit symposium on artificial intelligence and machine learning.

Learn more about the Solution Developer Conference and register today.

WRC Status Updates

We continue to make improvements to the WRC Direct application in order to better serve all of our clients.  We have launched an improved user interface, which provides insight into ad hoc corrections and resolution of defects. Recently we’ve improved the email delivery of WRC status updates.

All emails about WRC requests will have the same format:

• The first part of the email will show the last action and the advisor’s name. You will easily be able to learn the current state without reading through the entire message.

Hi, Community!

I'm pleased to update you with the DC new features came with August release. 

In August we have Answer-to-Comment conversion, better posts moderation and new design tweaks.

Hey folks,

I am new to IRIS and cloud platforms. I've done the InterSystems IRIS Experience on the learning site and read a lot of the online documentation. What I am unable to figure out is which type of package or option you will use on the cloud provider.

AWS for example, has AWS EC2, Elastic Beanstalk and some other products geared towards Docker containers.
Azure has Kubernetes and some other options.

Is IRIS and Docker deployed using the "Docker" products of the cloud providers, or should one get VM's on which CentOS is installed and Docker on top of that?

Hello there,

I have some problem with inserting date to table using dynamic sql.

I have Country class. This table has relationship with class Continent as parent and child. In addition I have another statistic class where property Country has type of Country class. I get ID such as "1||1" next I execute dynamic sql INSERT INTO Stats(Country) VALUES("_CountryId_"). Then I select Stats table and see that value of Country column is "11") As a result a can't get Country object.

Please advice solution of this problem

Thank you