Question Oliver Wilms · Sep 11, 2022 BuildKit does not work in Online demo Hello, Community, I tried to deploy online demo for interoperability-test app. I see it errored because BuildKit is not available. Can the Docker be configured to support BuildKit? #Docker #Open Exchange 0 3 0 173
Article Oliver Wilms · Sep 11, 2022 2m read About interoperability-test app for unittesting interfaces in productions I cloned iris-interoperability-template for my app interoperability-test. I wanted to develop an app to test interfaces in Interoperability productions. #Contest #REST API #Ensemble #InterSystems IRIS Open Exchange app 3 1 1 347
Question Oliver Wilms · Aug 12, 2022 Password requirements Many password requirements can be enforced using a password validation routine which is available to implement in System Management Portal. But how about this one: Check that at least 50% of the characters changed from old password to new password. We need to have access to the old password to check this, currently password validation routine only gets the new password. #Access control #Authentication #InterSystems IRIS 0 1 0 310
Article Oliver Wilms · Jul 25, 2022 3m read Python for test-data Hello, I became aware of Python in the early 2000s when I started automating tasks. Some of our processes utilized python scripts. I never figured it out very well, and we decided to do away with Python because nobody on our team was familiar with it. #Embedded Python #Python #InterSystems IRIS Open Exchange app 4 0 0 217
Question Oliver Wilms · Jul 12, 2022 IRIS as a backend database for Java application Hello, I work on deploying IRIS using Kubernetes operator and Red Hat OpenShift. I encouraged another team working on Java application to consider using IRIS as database. My team deployed IRIS cluster using two mirrored data pods for the other team. The other team asked me for the connection information. To learn how to use Java with IRIS, I attempted to deploy two apps from Open Exchange: https://openexchange.intersystems.com/package/CRUD-GLOBALS-IRISNATIVEAPI... #Application Server #Java #JDBC #InterSystems IRIS 2 1 0 262
Article Oliver Wilms · Jul 10, 2022 1m read The inspiration for interoperability-manager As I was thinking what I could develop for InterSystems Full Stack Contest, I saw this post: #CSP #REST API #Ensemble #InterSystems IRIS Open Exchange app 0 0 0 253
Question Oliver Wilms · Jul 10, 2022 login failure I am still working on iris-for-money app: https://github.com/oliverwilms/iris-for-money Account.csp posts a rest call with _SYSTEM username and the password. xhttp.open("POST", "/restapi/sql/" + query, true,"_SYSTEM","SYS");xhttp.send(); /restapi web application has Password Authentication Method enabled. SYS is the correct password for _SYSTEM user. I do not understand why I see login failure in Audit database. #Authentication #CSP #REST API #InterSystems IRIS #Open Exchange 0 1 0 292
Question Oliver Wilms · Jul 9, 2022 ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation I am working on iris-for-money app: https://github.com/oliverwilms/iris-for-money Account.csp posts a rest call with _SYSTEM username and the password. xhttp.open("POST", "/restapi/sql/" + query, true,"_SYSTEM","SYS");xhttp.send(); The error is logged in Riches.REST for this line: Set tSC = tStatement.%Prepare(pQuery) #Authentication #REST API #InterSystems IRIS 0 3 0 821
Article Oliver Wilms · May 30, 2022 1m read Custom monitoring page for IRIS Interoperability production InterSystems Production Monitor is a page in Management Portal to display monitoring information for the current running production. I like the page as it comes, but one size does not fit all. On May 13, 2022 I read this post on Developer Community: #Contest #Monitoring #Ensemble #InterSystems IRIS Open Exchange app 2 2 1 431
Article Oliver Wilms · May 30, 2022 1m read Receive mail messages in IRIS Interoperability Production IRIS Interoperability formerly known as Ensemble comes with many built in adapters. It does not have a service or adapter to receive mail. I have written email service to receive mail messages via SMTP which can be passed to email operation. #Contest #Ensemble #InterSystems IRIS #Open Exchange Open Exchange app 0 0 0 248
Article Oliver Wilms · May 30, 2022 1m read About test-data app My team works on an IRIS interoperability solution which is running on Red Hat OpenShift container platform. I want to test how many messages can be processed by the running webgateway pods and compute pods with data being stored in the mirrored data pods. #Contest #InterSystems IRIS #Open Exchange Open Exchange app 1 0 0 260
Question Oliver Wilms · Apr 29, 2022 PoolSize System Default Setting Hello, I tried to define Pool Size in System Default Settings, but it is not being used. I see I am not the first to try this without success: Define PoolSize as system default value | InterSystems Developer Community Any suggestions? #Business Operation #InterSystems IRIS 0 3 0 400
Article Oliver Wilms · Apr 8, 2022 1m read Why another money app for Globals Contest? I wanted to join the InterSystems Globals contest. I have worked with InterSystems globals more than twenty years and I consider myself an expert. I developed another money app for globals contest because I needed it. What I had created previously was not really that useful for me. #Open Exchange Open Exchange app 0 0 0 181
Article Oliver Wilms · Jan 16, 2022 2m read Add Pivot Definition for dataset-finance in Online Demo I participate in InterSystems Datasets Contest. I created dataset-finance and analyze-dataset-finance apps along with Online Demo. The username is _SYSTEM and password is SYS. I created an online demo with a pretty dashboard here: #Tips & Tricks #InterSystems IRIS BI (DeepSee) 1 0 0 188
Question Oliver Wilms · Jan 8, 2022 SQL LOAD DATA date values I have csv date file with date values like this "4/10/2021" for April 10, 2021. I defined a table with this property: Property TranDate As %Library.Date. I capture error [SQLCODE: <-104>:<Field validation failed in INSERT, or value failed to convert in DisplayToLogical or OdbcToLogical>] [Location: <ServerLoop>] [%msg: <Field 'dc_data_finance.transact.TranDate' (value '4/10/2021') failed validation Field ... I do not really want to change TranDate to %String. How can I import "4/10/2021" into %Date property? #Data Import and Export #SQL #InterSystems IRIS 0 10 0 505
Article Oliver Wilms · Jan 8, 2022 2m read dataset-finance: trying to map columns to properties I have a csv file with 13 columns. The header row is: #SQL #InterSystems IRIS 0 1 0 224
Article Oliver Wilms · Jan 8, 2022 2m read dataset-finance and my first experience with SQL LOAD DATA I read under Topics and Rules of InterSystems Datasets Contest: #SQL #InterSystems IRIS 0 2 0 225
Article Oliver Wilms · Dec 24, 2021 4m read InterSystems SQL Outbound Adapter - How fast can it go? One of my colleagues had developed an interface in Health Connect (HealthShare 2019.1) to add large amounts of data to an external SQL Server database. The data comes from many text files with delimited rows and data for one table per file. There is a business process to read a file line by line and send an Insert Request to an operation. #Performance #SQL #Health Connect #HealthShare 4 0 0 299
Question Oliver Wilms · Oct 21, 2021 Ensemble Data Lookup Tables - SQL query Hello, I wonder if we can run SQL queries to find data in Lookup tables? #SQL #Ensemble 0 1 0 514
Article Oliver Wilms · Oct 17, 2021 3m read Interoperability, RecordMap CSV Wizard, and Money I work as an Integration Engineer for United States Department of Veterans Affairs (VA). I work on a Health Connect production which processes many RecordMap files. I do not fully understand RecordMaps and I wanted to develop an application for the Interoperability contest where I could learn more about working with RecordMaps. I browsed InterSystems documentation for inspiration on how to start. I was happy to find CSV Record Wizard. #Business Process (BPL) #Containerization #Contest #CSV #Interoperability #InterSystems Package Manager (IPM) #REST API #Health Connect #InterSystems IRIS #Open Exchange Open Exchange app 0 0 0 403