System resource exceeded: Difference between revisions

Line 56:

*Pagasa observed that this became a problem again around the same time we changed the schedule of [[PHI Loader.accdb]]. We discussed possible connections but could not think of anything causal. Just putting this down here in case someone else can think of the connection. Ttenbergen 15:34, 2019 September 12 (CDT)

***Pagasa and Tina had a look at STB_MEDD (Debbie’s) data, and it possibly seems to be a matter of there really being too many records. MS Access is reaching its limit. For testing I tried to send with the first half of your patients and with the second half, and each works. Of course that is not a solution, but it confirms that the volume is the issue. In the long term we need to find an alternative to MS access, and to bring down the backlog, but that won’t be quick.

== Solution approach: copy those parts centralized to local ==

2019-12-09: Copy those parts of of CFE L_Log that are needed by [[Query send_check_centralized_is_owner]] to local, do comparison, then delete them. This way the query doesn't need to run across the network.

== Solution approach: Purging some old data from centralized ==

@@ Line 56: / Line 56: @@
 *Pagasa observed that this became a problem again around the same time we changed the schedule of [[PHI Loader.accdb]]. We discussed possible connections but could not think of anything causal. Just putting this down here in case someone else can think of the connection. Ttenbergen 15:34, 2019 September 12 (CDT)
 ***Pagasa and Tina had a look at STB_MEDD (Debbie’s) data, and it possibly seems to be a matter of there really being too many records. MS Access is reaching its limit. For testing I tried to send with the first half of your patients and with the second half, and each works. Of course that is not a solution, but it confirms that the volume is the issue. In the long term we need to find an alternative to MS access, and to bring down the backlog, but that won’t be quick.
+== Solution approach: copy those parts centralized to local ==
+-12-09: Copy those parts of of CFE L_Log that are needed by [[Query send_check_centralized_is_owner]] to local, do comparison, then delete them. This way the query doesn't need to run across the network.
 == Solution approach: Purging some old data from centralized ==