I am trying to populate a table using the sql Data Import Wizard. The input file is a tab delimited text file. But the import keeps failing with a 104 error showing validation for the columns which use %Library.TimeStamp and %Boolean datatypes is failing. Yet when I insert values into the table through a SQL insert command, the values get saved correctly in the table.

For the TimeStamp format in the wizard form, I am choosing YYYY-MM-DD-HH:MI:SS because  there was no option for this format: YYYY-MM-DD HH:MM:SS. 

0 4
0 135

Running HealthConnect 2021.1 on RedHat Linux 8.4.

I've configured IRIS/HealthConnect with an external web server to support TLS encryption. It's installed on the same server as IRIS, but is a different instance and version of Apache httpd. That all works as expected.

I would also like to keep the "private" web server available, but I'm having an issue with using the fully-qualified domain name in the URL vs. just the hostname itself.

If I use http://servername:52773/csp/sys/UtilHome.csp to log on, all is well.

1 7
1 135

Hi guys!

I'd like to present you my new project: iris-analytics-notebook, a notebook approach to use IRIS analytics capabilities.

Project description

In past few years, notebooks tools like Jupyter are gaining popularity due its natural way to express ideias.

An almost unipresent tool for data scientists, notebook can also help to improve the impact of analytics tools for all sort of users.

2 0
0 135

Needing to know how to define a property that can either be sent in my response as 

"members": null,

or 

"members": [
                {
                    "dob": "1905-05-01",
                    "firstName": "BOB",
                    "middleName": "T",
                    "nameSuffix": "",
                    "genderCode": "M",
                    "lastName": "COLLINS",
                    "memberId": "123421741",
                    "relationship": "Subscriber"
                }
            ],

0 6
0 135

I have vendors asking for verification that messages for locations are coming through to them.  I can get generic ADT_A01 type of numbers in Activity.  I'd really like to get some good SQL queries that can give me a count of MSH.4s (for example) for a day for X Operation.  I'm not sure which table to look at for that information.

0 1
0 135

I need to do some nifty string manipulation on a source property. I will not be able to do it with the functions available(with the knowledge that I have of what is available). Could I call a ClassMethod to do this for me? This is what I want to do: The source property is "myemail@myemaildomain.co.uk". I need to add the text "test" to the beginning of that string. "testmyemail@myemaildomain.co.uk".

0 7
0 134

Hello everyone,

I am having a challenge with the IRIS community version in Docker with wsl2. Host machine is Win 11 and the IRIS/Ubuntu image is Ubuntu-20.04 from running 'wsl -l -v.

I am not able to reach the WebPortal in IRIS nor the Super User port. docker ps -a = containers.intersystems.com/intersystems/iris-community:2021.1.0.215.3   "/tini -- /iris-main"   3 weeks ago   Up 26 hours (healthy)   0.0.0.0:1972->1972/tcp, 2188/tcp, 53773/tcp, 0.0.0.0:52773->52773/tcp, 54773/tcp   iris

0 5
0 134

Monitoring IRIS through SAM (sam:1.0.0.115)

While I've used to make it work in the past, I'm not able any more to fix the already faced issue : "State: Unreachable"

Despite all the ip-addresses attempts (or hostname = host.docker.internal)  and while "/api/monitor/metrics" is running well...

 

Could someone provide good practices to make it work cleanly ?

 

 

0 13
0 133

Hello Community,

Thank you all for your continued feedback and support of our ad hoc reporting platform, VDM.  There's been some questions around setting up a non-ODBC connection for InterSystems platforms.  We published a new YouTube video showing the steps necessary to connect to InterSystems Caché and InterSystem IRIS with BridgeWorks VDM. 

 

2 0
3 133
Question
Adel Elsayed · Sep 22, 2021
embedded sql select locks

i noticed -by reading .INT files of one class- that some of embedded sql select statements code blocks translates into code that uses lock command.

 

even if i use %nolock in the select, still cursors and arrow referencing notations "->" have the same results.

0 4
0 133

Function as a service (FaaS) is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage application functionalities without the complexity of building and maintaining the infrastructure typically associated with developing and launching an app. Building an application following this model is one way of achieving a "serverless" architecture, and is typically used when building microservices applications.  

Wikipedia

FaaS is an extremely popular approach to running workloads in the cloud, allowing developers to focus on writing code.

This article will show you how to deploy InterSystems IRIS methods in a FaaS way.

6 4
1 133

Hi Developers!

We had a set of technology bonuses for the InterSystems IRIS Developer Tools contest.

And here is how projects collected it:

Project docker zpm Unit Testing Online Demo Code Quality Article on DC Video on YouTube Total Bonus
Nominal 2 2 2 3 2 2 3 16
Config-API 2 2 2   2 2   10
Server Manager for VSCode     2     2   4
Grafana Plugin for InterSystems 2   2     2   6
SSH for IRIS container 2         2 3 7
IntelliJ InterSystems     2         2
gj :: locate     2     2 3 7
helper-for-objectscript language extensions 2 2     2 2 3 11
IRIS REST Documentation 2       2     4
IRIS-easy ECP workbench 2 2     2 2 3 11
zpm-explorer 2 2 2 3 2 2 3 16
Git for IRIS 2 2       2   6
zapm-editor 2 2       2   6

0 9
0 132