Error "Invalid SQL statment..." when sending

When sending, the process gets as far as "Centralized L_TmpV2 update/delete" and then throws an error

Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. 

This error is intermittent and seems to only happen for Homers. The next send generally goes through.

This is probably related to slow access when sending from home - it takes about 3x as long. There is nothing wrong with the actual statements, since it works most of the time, so the wording of the error is likely misleading.

• 2023-03-09 - error seems to be more common when sends are slow; adding some data to send logging to confirm.

Some troubleshooting

I have a hunch that this error may be related to a send failing for one collector and a second collector then also sending, leading to problems with the lock file. So, when the error happens, please have a look at Regional Server\​/output\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\/output and see if there is a second centralized_data file there with an extension .lccdb. See Lccmdb and ldb files for details. Please log here about what you find. Ttenbergen 10:41, 2024 November 30 (CST)

• SMW

• Cargo

• Categories

One specific cause: D_ID overflow

This error will happen if the D_ID generated by adding the Laptop identifier, Service/Location and Pat_ID has a length greater than 18. Example:

• H5_SOH_Geriatrics-11111 length: 24 failed
• H5_SOH_Geri-11111 length 17 ok

Error Log

Please include in your log if you were sending from home, and what time, and if this is after another send failed and before a reboot or the pull of a clean version, and other info you might have. \

• 2025-3-16 @0950 from work H5 laptop, tried and right away same error, stopped at checking for duplicates, copied down clean version, still giving same error
  • I sent H6laptop right after with no problems Lisa Kaita 09:55, 16 March 2025 (CDT)
• 2025-3-15 @2050 from home H5 laptop, tried 4 times copied down a clean version, no go, this is the laptop with the LAU project on it?? stops at checking for duplicates Lisa Kaita 20:53, 15 March 2025 (CDT)
• 2024-11-30 H5 error at 0700 from home using the test CCMDB (for AHC) copy to local didn't work
  • I would not expect copy to local to fix this, I am pretty sure it has to do with something being off at the destination or with the connection. Ttenbergen 01:32, 2024 December 1 (CST)
• 2024-11-21 H7 error at 1535 from office. tried 2x, then pulled a clean copy, still failed, and didn't have time to try rebooting.
• 2024-11-21 H4 error at 1454 - sending from office, tried 3x, invalid SQL message kept popping up. Didn't end up sending.
• 2024-11-13 H4 error at 1455 - sending from office, second send went through
• 2024-11-12 H8 error at 1452 - sending from work, second send went through.
• 2024-11-08 S9 error at 07:14 - sending from home, second send went through.
• 2023-08-03 S7 error at 08:13 - sending from home, second send went through.
• 2023-06-20 S8 started 0644, error message 0645, exit and reenter program, second send went through
• 2023-06-07 S5 sending from home, error at 0705, second send went through.
• 2023-06-07 S7 sending from home, error at 07:48. Second send went through.
• 2023-06-06 S9 sending from the office, error at 07:05, second send went through. Was sending both S7 & S9 at the same time.
• 2023-05-15 S9 sending from home, error at 08:04, exited, second send went through
• 2023-05-15 S7 sending from home, error at 07:18, exited, resend went through
• 2023-05-08 S9 sending from home, error at 07:58, exited, resend went through
• 2023-05-04 S9 send/error stopped at 0715; exited program, resend went through
• 2023-05-04, S5 laptop sending from home. Error at 0703; exited ccmdb, reentered and second send went through
• 2023-04-25, S7 laptop sending from office. Error message at 07:10, second send went through.
• 2023-04-25, S9 laptop sending from office. Error message at 07:05. Second send went through.
• April 20@0811, H3 laptop sending from office, error message at 0813, sent again at 0825 no problem
• April 17@1437 on H6 laptop at work, was also sending H5 laptop at the same time, error came up at central L_TmpV2 update/del, tried again and it went through, the H5 laptop had completed sending Lisa Kaita 14:39, 2023 April 17 (CDT)
• 2023-04-14 S9 start time 0716, error 0723, news and backup, restart 0730, complete at 0813
• 2023-04-14 S5 sending from home. Error at 0709; exited ccmdb, reentered and second send went through.
• 2023-04-12 S9 laptop, sending from office. Error on first send at 14:35, second send went through.
• 2023-04-11 S7 laptop, send from home. First send was a longer than usual send, received error at 07:25 which was at the 25 minute mark on the send. Exited and reentered ccmdb, Second send went through in 15 min.
• 2023-04-03 H5 laptop, at work, error message x2, copy to local.bat did not work, rebooted still didn't work, gave up try tomorrow update after reboot did another copy to local and it went through
  • I think we later realized that MS Access was hung on that PC because other stuff didn't work as well, and started to work after a reboot
• 2023-03-31 H6 laptop, send from home, error message x2, copy to local.bat third time went through
• 2023-03-15 S8 first send at 0657, ended by error at 0658, second send 0701, ended by error at 0708, news and backup, third send at 0712, ended by error at 0713, local to backup, fourth send ended by new error message" not enough space on disc", gave up
• 2023-03-15 S5 first send from home error at 0711, records set to "sent". During second send "network interruption" error. Third send went through.
• 2023-03-10 S5 first send from home around 0705, exited ccmdb, reentered and second send went through
• 2023-03-08 S8 first send from home at 0713, error at 0722 (not visible until 0734), second sending at 0734 went through
• 2023-03-06 S9 first send from home started 0714 ,error encountered, 0734 send successful
• 2023-02-09 Error encountered at 0700 during send from home on S5. Exited out of ccmdb and reentered, second send went through.
• 2023-02-07 Error encountered at 0700 during send from home on S5. Exited out of ccmdb and reentered, second send went through.
• 2023-02-7 07:55 - error at 07:30, sending from home. Reboot and second send went through.
• 2023-01-25 - recently people are reporting that they need to pull a clean version after they get this error. Others say that a re-boot fixes it. Could it be that this error comes up after an initial sending attempt fails? That would explain either of these repairs, ie something is hung.
• 2023-01-26 8:10 - Joanna, error before clean version, sent after clean version, onsite.
• 2022-04-14 08:27 - Brynn reported error
• 2022-04-14 08:28 - Steph reported error
• 2022-03-16 07:11 - Pam reported error
• 2021-11-18 08:34 - Steph reported error
• 2021-11-15 07:19 - Pam reported error