All
Accepted answers
Ephraim Malane · Dec 28, 2021 go to post

Thank you for all, this really helped a lot.

I went with JDBC and managed to automate my worklist reporting.

Ephraim Malane · Apr 11, 2022 go to post

Thanks Michael,

It worked, so is there a way to put date range, say for example exporting records from 2022-03-01 to 2022-04-11?

Ephraim Malane · May 5, 2022 go to post

Thanks Ben,

Yes I did cut the actual logic,so I must Import this class under %SYS namespace right?

Ephraim Malane · May 12, 2022 go to post

Than you guys,I got it working however I am not able to load the file codes on the system.do you know how the structure should look like when uploading terminology codes file under Registry namespace?

Below is the error I am getting the below error

Ephraim Malane · May 19, 2022 go to post

Hi guys,

Is there a way to specify every month without saying last 30 days since other months have 30 days and February has 28 days? There is a requirement to schedule this task to run every month, I will appreciate it if I get some guidance on that

Ephraim Malane · May 23, 2022 go to post

Thanks Alex,

Please see the below and check if you can help

South African ID number

A South African ID number is a 13-digit number which is defined by the following format: YYMMDDSSSSCAZ.

  • The first 6 digits (YYMMDD) are based on your date of birth. 20 February 1992 is displayed as 920220.
  • The next 4 digits (SSSS) are used to define your gender.  Females are assigned numbers in the range 0000-4999 and males from 5000-9999.
  • The next digit (C) shows if you're an SA citizen status with 0 denoting that you were born a SA citizen and 1 denoting that you're a permanent resident.
  • The last digit (Z) is a checksum digit – used to check that the number sequence is accurate using a set formula called the Luhn algorithm.

The graphic below details the different sections of an ID number, based on the fictitious sequence 9202204720082

Ephraim Malane · Jul 15, 2022 go to post

Thanks Eduard,

From your response, even if I extend a cube with additional property and rebuild it won't affect the linkage definition data right?

Ephraim Malane · Aug 2, 2022 go to post

Hi Eduard,

I have enabled Data Quality Manager in our production environment and I am picking up a massive increase in memory utilization and CPU utilization. Database size keeps increasing,is it normal?

 

Logs

07/26/22-07:49:41:266 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:41:290 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:42:428 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:42:453 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:45:053 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:45:083 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:47:293 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:47:317 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:48:411 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:48:437 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:50:336 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:50:363 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:52:277 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:52:304 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:54:158 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:54:187 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:56:072 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 10 MB requested.
07/26/22-07:49:56:100 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 10 MB.
07/26/22-07:49:57:910 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 11 MB requested.
07/26/22-07:49:57:940 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 11 MB.
07/26/22-07:50:00:318 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 12 MB requested.
07/26/22-07:50:00:351 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 12 MB.
07/26/22-07:50:03:179 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 14 MB requested.
07/26/22-07:50:03:217 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 14 MB.
07/26/22-07:50:06:363 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 16 MB requested.
07/26/22-07:50:06:402 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 16 MB.
07/26/22-07:50:42:564 (2206) 0 [Database.SparseDBExpansion] Expanding capacity of sparse database /hs-patient/sys/healthshare/mgr/iristemp/ by 30 MB.
07/26/22-07:50:48:428 (2206) 0 [Database.SparseDBExpansion] Expanding capacity of sparse database /hs-patient/sys/healthshare/mgr/iristemp/ by 33 MB.
07/26/22-07:52:22:796 (2206) 0 [Database.SparseDBExpansion] Expanding capacity of sparse database /hs-patient/sys/healthshare/mgr/iristemp/ by 37 MB.
07/26/22-07:52:58:860 (2206) 0 [Database.SparseDBExpansion] Expanding capacity of sparse database /hs-patient/sys/healthshare/mgr/iristemp/ by 42 MB.
07/26/22-07:54:57:944 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 18 MB requested.
07/26/22-07:54:58:011 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 18 MB.
07/26/22-07:55:21:270 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 20 MB requested.
07/26/22-07:55:21:339 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 20 MB.
07/26/22-07:55:45:101 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 22 MB requested.
07/26/22-07:55:45:201 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 22 MB.
07/26/22-07:56:04:751 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 25 MB requested.
07/26/22-07:56:04:877 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 25 MB.
07/26/22-07:56:25:116 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 28 MB requested.
07/26/22-07:56:25:227 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 28 MB.
07/26/22-07:56:49:734 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 32 MB requested.
07/26/22-07:56:49:838 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 32 MB.
07/26/22-07:57:17:084 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 36 MB requested.
07/26/22-07:57:17:210 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 36 MB.
07/26/22-07:57:53:727 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 40 MB requested.
07/26/22-07:57:53:910 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 40 MB.
07/26/22-07:58:26:561 (2577) 2 [Utility.Event] [SYSTEM MONITOR] CPUusage Alert: CPUusage = 99, 99, 99 (Max value is 85).
07/26/22-07:58:35:865 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 45 MB requested.
07/26/22-07:58:36:028 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 45 MB.
07/26/22-07:59:19:415 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 51 MB requested.
07/26/22-07:59:19:639 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 51 MB.
07/26/22-07:59:19:976 (2198) 0 [Generic.Event] Journal log has been changed from edition 391 to 392
07/26/22-07:59:20:108 (2198) 0 [Generic.Event] INTERSYSTEMS IRIS JOURNALING SYSTEM MESSAGE
Automatic journal file roll to: /hs-patient/jrn/pri/MIRROR-CCMIRROR-20220726.002
07/26/22-08:00:09:356 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 57 MB requested.
07/26/22-08:00:09:775 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 57 MB.
07/26/22-08:00:58:380 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 64 MB requested.
07/26/22-08:00:58:601 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 64 MB.
07/26/22-08:01:55:805 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 72 MB requested.
07/26/22-08:01:56:059 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 72 MB.
07/26/22-08:02:58:897 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 81 MB requested.
07/26/22-08:02:59:235 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 81 MB.
07/26/22-08:04:10:325 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 91 MB requested.
07/26/22-08:04:10:650 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 91 MB.
07/26/22-08:05:27:012 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 103 MB requested.
07/26/22-08:05:27:366 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 103 MB.
07/26/22-08:06:52:593 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 116 MB requested.
07/26/22-08:06:53:083 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 116 MB.
07/26/22-08:08:27:578 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 130 MB requested.
07/26/22-08:08:28:020 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 130 MB.
07/26/22-08:10:13:484 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 146 MB requested.
07/26/22-08:10:13:962 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 146 MB.
07/26/22-08:11:59:242 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 165 MB requested.
07/26/22-08:11:59:812 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 165 MB.
07/26/22-08:15:46:891 (2206) 0 [Database.StartExpansion] Starting Expansion for database /hs-patient/db/HSPIPIDQ/. 185 MB requested.
07/26/22-08:15:47:500 (2206) 0 [Database.FullExpansion] Expansion completed for database /hs-patient/db/HSPIPIDQ/. Expanded by 185 MB.
Ephraim Malane · Aug 2, 2022 go to post

Thanks Eduard,

I will look into implementing an async reporting mirror for cubes.

Regards, 

Ephraim Malane · Dec 6, 2022 go to post

Hi guys,

I have found that the issue is on IRIS.DAT file database on  /hs-exchange/sys/healthshare/mgr/HSAUDIT.

This database only store database logs right? And how do I reduce the space in this db?

Ephraim Malane · Dec 6, 2022 go to post

Thank you so much Eduard,

I just want to check something, I noticed that on the list of databases, we have HSAUDIT AND IRISAUDIT database. I want to confirm if they are all saving audit data

Ephraim Malane · Jan 9, 2023 go to post

Thank you so much everyone,

I logged a tiket with WRC and managed to resolve the issue by restoring IRIS.DAT file from another instance

Regards,

Ephraim Malane

Ephraim Malane · Apr 11, 2023 go to post

Good day Marc,

I have been looking at HS_IHE_ATNA_Repository.Aggregation table and I see FHIRQUERY events and SEARCHPATIENT events to name a few. Which event name reads clinical viewer access?

Ephraim Malane · Jul 4, 2023 go to post

Thanks Jeffrey,

With the option of having a Business component with rules that will route to specific email addresses, can I create that Routing with rules pointing to the component that sends emails with this code? 

Ephraim Malane · Jul 5, 2023 go to post

Hi Jeffrey,

I have obtained an SMTP server and it is from brevo.com which uses API key or SMTP key to authenticate. How do I modify that User.Mail class to use API key or SMTP key instead of username and password?

Ephraim Malane · Jul 5, 2023 go to post

Thanks,

I requested for SMTP server and they gave me an SMTP server that is created from brevo.com and it uses api-key or smtp key to authenticate instead of user id and password but when I put that API key on password if fails.

Ephraim Malane · Jul 25, 2023 go to post

Thank you so much Luis, so is processing of this resource done automatically within healthshare or I will have to build DTLs and so on?

Ephraim Malane · Jul 25, 2023 go to post

I just checked it as correct Luis, it seems like the way DTLs are created on the system I must create a DTL for this resource.Do you have an example of this DTL that will handle AllergyIntolerance resource?

Ephraim Malane · Jul 31, 2023 go to post

I can see it sets target.Severity.Code, I can just update it with target.Severity.Description right?