CCMDB Wiki

DSM Labs Consistency check.accdb: Difference between revisions

← Older edit
m Text replacement - "S:\MED\CCMED" to "S:\MED\MED_CCMED"
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:
The program  
The program  
:: '''X:\CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb'''
:: '''{{S:\MED\MED_CCMED}}CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb'''
generates request extracts and imports lab data as provided by DSM.  
generates request extracts and imports lab data as provided by DSM.  


Line 19: Line 19:
}}
}}
end of comment-->
end of comment-->
=== version 2023-09-27 ===
copied to server, notified Pagasa
* removed Trish from email and added Herman
=== version 2023-05-17 ===
not rolled yet
* removed re-connect for PHI, shouldn't be needed any more and was causing error.
=== version 2023-01-12 ===
copied to server
* updated [[created_AdmitDtTm query]] so it won't crash when there are nulls in all three dates
=== version 2022-11-03 ===
* added some labs to mappings as per email from Allan. [[User:Ttenbergen|Ttenbergen]] 10:22, 2022 November 3 (CDT)
=== version 2022-08-29 ===
copied to server [[User:Ttenbergen|Ttenbergen]] 15:48, 2022 August 29 (CDT)
* fixed error that was introduced into an SQL statement in the most recent update. [[User:Ttenbergen|Ttenbergen]] 15:48, 2022 August 29 (CDT)
** specifically, a previous change to query 1_C_requester_cc_maker had added a "where" clause to that query, and VBA code in Sub Export_requestor_file() was trying to add another where clause; changed that to "and" and it fixed it. [[User:Ttenbergen|Ttenbergen]] 12:11, 2022 August 31 (CDT)


=== version 2022-07-07 ===
=== version 2022-07-07 ===
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 10:29, 2022 July 7 (CDT)
copied to server [[User:Ttenbergen|Ttenbergen]] 11:49, 2022 July 12 (CDT)
* added queryRunner to get better error management for queries
* added queryRunner to get better error management for queries
* updated compact_runner that wasn't working at all
* updated compact_runner that wasn't working at all
Line 56: Line 76:


=== version 2020-05-06 ===
=== version 2020-05-06 ===
* added "DAO.DBEngine.SetOption dbmaxlocksperfile, 15000" to prevent out-of-diskspace error [http://www.accessrepairnrecovery.com/blog/fix-access-file-sharing-lock-count-exceeded-error]
* added "DAO.DBEngine.SetOption dbmaxlocksperfile, 15000" to prevent out-of-diskspace error [https://web.archive.org/web/20200224033850/http://www.accessrepairnrecovery.com/blog/fix-access-file-sharing-lock-count-exceeded-error] (archived version)
* changed query ''2_dedupe_appender_group'' to set DSM_TestCode to 0 rather than "not from group" for records arriving as test; this would have generated a hidden error all along but there would be no consequence to the data, this just cleans up that hidden error
* changed query ''2_dedupe_appender_group'' to set DSM_TestCode to 0 rather than "not from group" for records arriving as test; this would have generated a hidden error all along but there would be no consequence to the data, this just cleans up that hidden error


Retrieved from "https://ccmdb.kuality.ca/index.php?title=DSM_Labs_Consistency_check.accdb"