0
0

Written by

Ashok Kumar T
Senior Software Engineer
Follow
Question Ashok Kumar T · Jul 13, 2024

FHIR SQL Builder Access Issues

#HealthShare #InterSystems IRIS for Health #Health Connect #FHIR #REST API #SQL

Hello Community,

I'm unable see the FHIR SQL builder /csp/fhirsql and /csp/fhirsql/api/ui  endpoints in web application to access the FHIR SQL builder. I'm using community edition 2024.1 and it contains the "FHIR SQL Builder".

Product version: IRIS 2024.1
$ZV: IRIS for Windows (x86-64) 2024.1 (Build 267.2) Tue Apr 30 2024 16:42:56 EDT
Discussion (0)0
Log in or sign up to continue

Comments

Tani Frankel · Jul 14, 2024

Hi Ashok,

Sorry for the silly question, but just to double check - did you deploy IRIS or IRIS for Health?
 

0
Ashok Kumar T  Jul 14, 2024 to Tani Frankel

Hello Tani,

No problem, It's actually a valid question. I downloaded and installed InterSystems IRIS for Health. I had created FHIR resource repositories as well. But I'm unable to see the FHIR SQL endpoints

USER>write $ZV
IRIS for Windows (x86-64) 2024.1 (Build 267.2) Tue Apr 30 2024 16:42:56 EDT
USER>Write ##Class(%ZHSLIB.HealthShareMgr).IsIRISHealthInstance()
1
0
Tani Frankel  Jul 15, 2024 to Ashok Kumar T

Can you share the contents of the HS.Util.Installer.HSSYS-0.log file (it should be under the mgr directory of the IRIS installation).

For example if it includes a line such as:

2024-05-01 13:58:46.077 HS.HealthConnect.FHIRSQL.Upgrade.V2:InstallOnce-HSSYS-1 Configured FHIRSQL Application endpoints
 

Similarly also in ensinstall.log, with a line like this:

HS.HealthConnect.FHIRSQL.Upgrade.V2:InstallOnce-HSSYS-1 Configured FHIRSQL Application endpoints

0
Ashok Kumar T  Jul 15, 2024 to Tani Frankel

Here is the details from the HS.Util.Installer.HSSYS-0.log file. I don't see "HS.HealthConnect.FHIRSQL.Upgrade.V2:InstallOnce-HSSYS-1 Configured FHIRSQL Application endpoints". Anyway I could able to see the FHIR endpoints in  2024.1 (build 267.2)  in other machine. However I'm unable to connect the page http://hostname:portnumber/csp/fhirsql/index.html#/


2024-07-13 20:20:08.984 HS.Util.Installer.ConfigItem:CreateDatabaseAndNamespace About to Create Database hssys
2024-07-13 20:20:09.120 HS.Util.Installer.ConfigItem:CreateDatabaseAndNamespace Created IRIS.DAT in c:\intersystems\irishealth\mgr\hssys
2024-07-13 20:20:09.189 HS.Util.Installer.ConfigItem:CreateDatabaseAndNamespace Made Namespace hssys
2024-07-13 20:20:11.169 HS.Util.Installer.ConfigItem:MapIPM Added package mapping: %IPM from HSLIB to HSSYS
2024-07-13 20:20:35.475 HS.Util.Installer.ConfigItem:CreateWebApplicationForRESTServices Created web application for REST Services: /api/healthshare-rest/hssys

And I did not see "HS.HealthConnect.FHIRSQL.Upgrade.V2:InstallOnce-HSSYS-1 Configured FHIRSQL Application endpoints"  and anything  related to FHIR SQL API in ensinstall.log  as well. I found some error message

     Starting HealthShare Foundation Security Upgrade
      Adding %HSAdmin_InstallationManagement to %EnsRole_Developer and EnsRole_Administrator roles
Created additional Security Roles and Resources
Created web applications for HSLIB
HS.Util.Installer.ConfigItem:CreateWebApplicationForRESTServices Created web application for REST Services: /api/healthshare-rest/hssys
Created web applications for HSSYS
Created web applications for HSCUSTOM
      + Installed component HSLIB Failed ERROR #5002: ObjectScript error: <WIDE CHAR>AddSchemaType+150^%XML.Schema.1
Installation failed: ERROR #5002: ObjectScript error: <WIDE CHAR>AddSchemaType+150^%XML.Schema.1
 

Thanks!

0
Tani Frankel  Jul 15, 2024 to Ashok Kumar T

For the machine you got the <WIDE CHAR> error for - did you install 8bit or Unicode?

Your $ZV without the 'U' after the build number, suggests 8bit. I would recommend you install Unicode (8bit support is there more for customers who have legacy 8bit databases).

For the machine you do see the web applications, but can't browse to the page - 

Did you enable the Web Applications?

(https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.U…)

Are you getting an error when you browse there? (you can check the Browser Debugger just in case)

Might it be an authentication/authorization issue? (you can check the IRIS Audit, making sure you have Login Failure and/or Protect events enabled)

0
Ashok Kumar T  Jul 16, 2024 to Tani Frankel

Thanks a lot @Tani Frankel 

I reinstalled the instance as unicode system and the  <WIDE CHAR> error is gone. I could able to see the couple of endpoints in web app and  access the fhir sql home page without any issues. 
So, How can I resolve this same issue in the 8 bit legacy system. Do you think this is an serious issue in 8 bit? 

Regards,

Ashok.

0
Robert Cemper  Jul 16, 2024 to Ashok Kumar T

According to docs 

processing 8-bit on a unicode install should be possible

Character Width Setting 

,,,, while a Unicode instance can process both 8-bit and 16-bit data.

It's anyhow a tricky exercise 

0
Robert Cemper  Jul 16, 2024 to Ashok Kumar T

I just gave it a try:

  • an 8-bit DB works with code and globals without problem on a UNICODE  (16bit) installation
  • I didn't try CSP pages
  • in ns %SYS you have a utility ^GBLOCKCOPY converting a 8bit DB to a new 16bit DB  for a DB conversion
0