go to post Ephraim Malane · Dec 6, 2022 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?
go to post Ephraim Malane · Dec 5, 2022 Thanks Tani, Database and journal filesystems seem to be okay..see below
go to post Ephraim Malane · Aug 2, 2022 Thanks Eduard, I will look into implementing an async reporting mirror for cubes. Regards,
go to post Ephraim Malane · Aug 2, 2022 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.
go to post Ephraim Malane · Jul 15, 2022 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?
go to post Ephraim Malane · May 23, 2022 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
go to post Ephraim Malane · May 19, 2022 Thank you so much Julian, This helps a lot, it is exactly what I am looking for.
go to post Ephraim Malane · May 19, 2022 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
go to post Ephraim Malane · May 13, 2022 Thanks David, that's exactly what I wanted and it worked. Much appreaciated
go to post Ephraim Malane · May 12, 2022 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
go to post Ephraim Malane · May 5, 2022 Thanks Ben, Yes I did cut the actual logic,so I must Import this class under %SYS namespace right?
go to post Ephraim Malane · Apr 11, 2022 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?
go to post Ephraim Malane · Dec 28, 2021 Thank you for all, this really helped a lot. I went with JDBC and managed to automate my worklist reporting.
