Question prashanth ponugoti · Mar 17, 2022

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

3
0 437
Question Roderick Julius · Mar 16, 2022

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!

2
0 992
Job Gemma MA · Mar 16, 2022

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.

0
0 600
InterSystems Official Stefan Wittmann · Feb 16, 2021

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
6
0 702
Question Vivek Nayak · Mar 8, 2022

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.Response) As %Status
{
Set tSC = $$$OKTry {
// Get the FHIR

3
0 367
Job ARUN SAMUGA · Mar 16, 2022

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

0
0 262
Question Andy Stobirski · Mar 15, 2022

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?

2
0 469
InterSystems Official Bob Kuszewski · Mar 15, 2022

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.
0
0 288
Announcement Derek Robinson · Mar 15, 2022

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.

0
0 260
Job Gary Holt · Mar 15, 2022

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.

Although this role is remote there may

0
0 392
Announcement Nermin Kibrislioglu Uysal · Mar 15, 2022

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.

0
0 288
Question Michael Lundberg · Mar 15, 2022

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.GetAt(1)

This constantly

3
0 490
Article Yuri Marx · Mar 15, 2022 4m read

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.

0
3 884
Question Niklas Thilmont · Mar 14, 2022

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.

9
0 371
Article Henrique Dias · Jan 13, 2022 4m read

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é Pereira , we decided to approach this contest

4
0 480
Question prashanth ponugoti · Mar 9, 2022

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?

Does VS CODE have any option to import cls files

2
0 980
Question Sylvain DUBOIS · Mar 9, 2022

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 ?

2
0 345
Question Joost Platenburg · Mar 13, 2022

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?

1
0 245
Article Elena E · Mar 14, 2022 4m read

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. Once signed in open the applications section in a profile menu:

Screenshot 2020-10-17 at 13 11 00

Then click on Add Application button:

Screenshot 2020-10-17 at 13 14 13

Setting up an

3
0 266
Question Wanbo Wang · Jul 31, 2021

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.

2
0 436
Question Kevin McGinn · Mar 10, 2022

I am in the process of creating a python report writer that includes the information contained in "License Usage" page of the management portal. I think I have a handle on the local values contained in the report using the %SYSTEM.License class I have those defined using these methods:

  Current License Units Used -     ->  LUConsumed

  Maximum License Units Used  --> LUMaxConsumed

 License Units Enforced               --> KeyEnforcedUnits

License Units Authorized            --> KeyLicenseUnits

Current Connections                   --> InstanceConnections

Maximum Connections              -->

5
0 392
Question Muhammad Waseem · Jun 30, 2021

Hi,

I am running InterSystems iris 2021.1 from the container and I have version 2020.1.1 is installed locally. While running studio locally I am getting below error message:

"Version mismatch. Studio version 2020.1.1 unable to connect to server version 2021.1
Upgrade to a later version of the client to resolve this error"

Looking Forward

Thanks

4
0 548
Announcement Evgenia Kurbanova · Mar 10, 2022

It's time to announce the Winners for February! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in February:

🥇 @Robert Cemperex Senior Sales Engineer from InterSystems, Austria

🥈 @Eduard LebedyukSales Engineer, InterSystems Corporation, Russia

🥉 @Benjamin De Boe, Product Manager, InterSystems Corporation, Belgium
 

 Learn more about the competition and our awesome winners below.

3
0 485