Error "Invalid SQL statment..." when sending: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(Created page with "{{bug}} 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'...")
 
mNo edit summary
Line 2: Line 2:
When sending, the process gets as far as "Centralized L_TmpV2 update/delete" and then throws an error  
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'.  
  Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.  
This error is intermittent and seems to only happen for [[Homer]].
This error is intermittent and seems to only happen for [[Homer]]s. 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.  


== Error Log ==
== Error Log ==
2021-11-15 07:19 - Pam got error  
2021-11-15 07:19 - Pam reported error  


== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}

Revision as of 11:05, 2021 November 24

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.

Error Log

2021-11-15 07:19 - Pam reported error

Related articles

Related articles: