It sounds strange though it's embarrassing.

I have a class with ClassMethods written in ISOS and Embedded Python.

The ClassMethods written in ISOS start in the Background as usual. No problems

But my 

ClassMethod setPy() [ Language = python ]
{
import iris, datetime, time
- - -

Just fails the JOB command with (even 15 sec) timeout and $ZC=0
This is not funny
My actual workaround:
I created a ClassMethod in ISOS, that does an elegant JobStart
and this ClassMethod only runs the Embedded Python ClassMethod.

SET ^||fruit(1)="apple",^||fruit(4)="banana",^||fruit(8)="cherry"
SET ^||fruit(1,1)="Macintosh",^||fruit(1,2)="Delicious",^||fruit(1,3)="Granny Smith"
SET ^||fruit(1,2,1)="Red Delicious",^||fruit(1,2,2)="Golden Delicious"
SET ^||fruit="Fruits"
ZWRITE ^||fruit

^||fruit="Fruits"
^||fruit(1)="apple"
^||fruit(1,1)="Macintosh"
^||fruit(1,2)="Delicious"
^||fruit(1,2,1)="Red Delicious"
^||fruit(1,2,2)="Golden Delicious"
^||fruit(1,3)="Granny Smith"
^||fruit(4)="banana"
^||fruit(8)="cherry"

How I do send the output of zwrite to $$$TRACE()?

In addition to the previously advertised Cache/Ensemble developer role we also have a requirement for a Cache/Ensemble Support Analyst at SystemC in the UK.

SystemC are looking for a talented and experienced Support Consultant to join our CarePlus team where you will have a pivotal role within the team, providing technical support to our customers.

Could anyone please explain why Caché has a %STARTSWITH function while it supports ANSI SQL "LIKE"?

thank you very much.

Hi Community,

I DTL I am assigning value to %TimeStamp type praport named BirthDate.

18001225  converted to 1800-12-25T00:00:00  but giving below error

ERROR #7208: Datatype value '1800-12-25T00:00:00' is not a valid timestamp format
> ERROR #5802: Datatype validation failed on property 'xxx.xxx.xxxx.xxxxx:BirthDate', with value equal to "1800-12-25T00:00:00"

20000612   converted to 2000-06-12T00:00:00  is not giving any error

Please help me to resolve this. 

* We did not define the variable type as %TimeStamp   , this persistence class created based on XSD.

Thanks 

Prashanth

I started to get the following error when trying to save HTML and js files after editing in VSCode. This used to work fine, csp still works too.

ERROR #16006: Document 'xxx.html' name is invalid
Is there now a setting that I am missing? I did check but saw nothing that was obviously wrong.

Hello,

Our team is looking for a way to export all of our Cache SQL tables into Microsoft SQL Server.  I have only found a method to export one table at a time into an ASCII file.  We have over 170 tables so this would be very tedious and time consuming.  Is there a way to directly export from Cache to SQL Server.  Alternatively is it possible to export the entire database in a single shot or even multiple tables to text files?

Thanks!

Job Title:             Support Engineer / Developer

Location:             Sydney, Australia

Salary:                 Salary negotiable depending on skills and experience

Job Type:            Permanent, Full time following 3 months probation

Integrated Software Solutions (ISS) is a software development company providing mainly laboratory health solutions for over 30 years to some of the most well respected hospitals/organisations around the world. Clients include laboratories in United Kingdom, United Arab Emirates, Canada and Australia.

The GA release is now published for the 1.5 version of the InterSystems API Manager (IAM).

The container for IAM, including all relevant artifacts to upgrade from earlier versions of IAM can be downloaded from the WRC Software Distribution site in the Components area.

The build number for this release is IAM 1.5.0.9-4.

InterSystems API Manager 1.5 makes it easier to manage your API traffic, integrate with your environment and onboard users of your APIs. It has many new capabilities, including:

• Improved User Experience
• Introducing new Developer Portal tools
• Support for Kafka connectivity

I had heard that sample classes are available somewhere.

Hi Team,

I got a 404 status code(fhirResponse.Status) in the below code while inserting patient resources. Other resources data are successfully inserted.

Class HS.FHIRServer.Interop.Operation Extends (Ens.BusinessOperation, HS.HC.Util.Trace.Helper)
{ Parameter SETTINGS As %String; XData MessageMap
{
<MapItems>
<MapItem MessageType="HS.FHIRServer.Interop.Request">
<Method>DispatchRequest</Method>
</MapItem>
</MapItems>
} Method DispatchRequest(pInteropRequest As HS.FHIRServer.Interop.Request, Output pInteropResponse As HS.FHIRServer.Interop.

We are urgently looking for senior Intersystems Cache resources with mapping capabilities. Interested candidates will be trained in "crash course" mode to help us build and test maps and work closely with our team in order to progress high quality maps into deployment. Ideally the candidates have a good degree of business analysis skills and are familiar with the order to cash process in supply chain -- the focus is on sales order automation.

Please reach out to arun.samuga@elemica.com if you are interested and if you qualify.

Thank you

Arun

Myself and the other Technology Architects often have to explain to customers and vendors Caché IO requirements and the way that Caché applications will use storage systems. The following tables are useful when explaining typical Caché IO profile and requirements for a transactional database application with customers and vendors.  The original tables were created by Mark Bolinsky.

In future posts I will be discussing more about storage IO so am also posting these tables now as a reference for those articles.

How do I use the LOAD DATA command as described here.

I have the following LOAD DATA statement:

LOAD DATA FROM FILE 'E://Temp/Values.txt'

into PARIS.UAGU_MNDOOUT1 (AHSU_ID, AHSU_UAG_ID)

Where do I run it? It doesn't work in the SQL Gateway, in the terminal, in an embedded SQL command.

What am I missing?

Hi Community, 

New video is already on InterSystems Developers YouTube:

⏯ Poor Man's Analytics with Rich SQL

The InterSystems Kubernetes Operation (IKO) version 3.3 is now available via the WRC download page and the InterSystems Container Registry.

IKO simplifies working with InterSystems IRIS or InterSystems IRIS for Health in Kubernetes by providing an easy-to-use irisCluster resource definition. See the documentation for a full list of features, including easy sharding, mirroring, and configuration of ECP.

IKO 3.3 Highlights:

• Support for 2021.2 and 2022.1 editions of InterSystems IRIS & IRIS for Health
• Support for Kuberentes 1.21
• Deploy common System Alerting and Monitoring (SAM) configurations as part of your irisCluster
• InterSystems API Manager (IAM) can now also be deployed and managed as part of the irisCluster
• Automatic tagging of mirror pair active side, so a service can always point to the active mirror member.

Hi all - we just released the second episode of Season 2 for our Data Points podcast by Learning Services. This episode features a conversation with @Shane Nowack about InterSystems certification exams. If you're interested in how exams are developed, what's new with current and future exams, and how you could get involved with beta testing or writing questions, check it out! For more information, head over to https://datapoints.intersystems.com.

A permanent job opportunity has arisen for a Cache/Ensemble developer at SystemC in the UK. We are looking for a talented and experienced Developer to join our CarePlus team where you will have the opportunity to utilise your experience and creativity within the product suite. 

You will be expected to work alongside the existing development team, customers, third parties and wider internal teams to support the product capabilities. As the product and company portfolio continues to develop there would also be opportunities to expand your technical skills.

Hello Everyone,

The Certification Team of InterSystems Learning Services has updated exam objectives for our HL7 Interface Specialist certification exam and we need input from our implementation community.  

How do I provide my input? We will present you with a list of job tasks, and you will rate them on their importance and other factors.  

How much effort is involved? It takes about 30-45 minutes to fill out the survey. You can be anonymous or identify yourself and ask us to get back to you. 

How can you access the survey? You can access the survey here  

Note: Your answers cannot be saved.

Hello

I have trouble capturing the value from a stored procedures output variable from an MS SQL Database.

In the database querywindow of MS SQL manager, the procedure is called as:
declare @return As varchar (100)
Execute TheProcedure @return. @return then contains string of content.

From HC I call the procedure:

set RetValue = ""
set Inparm = "@return"
set Outparm = ## class (% ListOfDataTypes).% New ()

SET SQLQuery = "exec TheProcedure ?"
(have also tried
"{call TheProcedure (?)}"

SET tSC = ..Adapter.ExecuteProcedure (, .Outparm, SQLQuery, "o *", Inparm)
set RetValue = outparm

This is the fourth part of the series of articles on migrating from the main databases on the market to InterSystems IRIS. In this part, the procedures for migrating from Microsoft SQL Server will be detailed. As described in previous articles, there are currently a few options to do the migration, but the two most popular options include the use of DBeaver (https://openexchange.intersystems.com/package/DBeaver) or SQLGateway. The first one will be demonstrated in this article, and the second one in an excellent article by Robert Cemper, DB Migration using SQLgateway (https://community.

Hey InterSystems Community!
This is probably far-fetched - is there a way to get notified/get a piece of code triggered whenever the state of a global changes?

Now what could I possibly want with that? Quite simple! I would like to forward the content of a global (in this case the "FSLog" global written by the FHIR implementation) while adding timestamps to it - to create some sort of file-based logging for it.

Hey community! How are you doing?

I hope to find everyone well, and a happy 2022 to all of you!

Over the years, I've been working on a lot of different projects, and I've been able to find a lot of interesting data.

But, most of the time, the dataset that I used to work with was the customer data. When I started to join the contest in the past couple of years, I began to look for specific web datasets.

I've curated a few data by myself, but I was thinking, "This dataset is enough to help others?"

So, discussing the ideas for this contest with @José.

Hi Community,

We are not using github or any source safe till now. We have ensemble hl7 interfaces (business services, processes, operations)available in production. Now we want to deploy these interfaces to a brand new cloud server with iris instance.

Here in current production we have studio access but new cloud server iris we have only vscode access.

I have exported all the classes from current production using  Studio and  I have exported xml file with me.

How to import this exported file into VS CODE to deploy classes in a new cloud server?

Is View Journal of Cache Management Portal the only way to search in Cache journals? I need a way to define several search conditions and Portal often breaks on http timeout.

Hello

I am running a script from a CMD command line using : C:\CacheSys\Bin\cterm.exe /console=cn_iptcp:127.0.0.1[23] myscript.SCR %CD%

The script should authorize something (or not) in the following lines of the GO.CMD

But How can i return an information from inside the script to the GO.CMD script ?

Any idea ?

LS,

Probably due to my MacBook M1, but when I try to push the IKO (step 3 in the install) to the hub, I get the following error message:

The push refers to repository [docker.io/library/kubernetes-operator]
6515fe38e1f1: Preparing
f562a1750889: Preparing
denied: requested access to the resource is denied

Is this indeed because of my MacBook architecture or is there a different reason?

Publishing process

You can publish your own application on Open Exchange and it will be listed in an Applications Gallery. The publishing process is a set of following steps:

1. Register on Open Exchange
2. Create the application description
3. Submit the application for approval
4. Done! Please find below the detailed description.

To publish an application first you need to sign in to Open Exchange. You can do this using your Developer Community account or create a new account here.

Is there any open source tool like Power BI or Tableau that works well with IRIS? Thx!

Hi everyone, I met this Jenkins build problem when commit to P4.

ERROR #5001: GUID reference(s) missing from stream websys/TranslationType/questionnaire.QCNXXCVD.Edit/68D7225A-DE63-11EB-AF4C-005056B66BA0.xml; 35551C28-0C38-11EB-A1C8-005056B66BA0

So how can I solve this problem. Would anybody help me? Thanks.