Automate 2023 patch 3
running LUM 1.0.23.0 - pushing a LUM Maintenance script to update an agent -- fails
The Script(6173) failed in the Then section at step 49. The reason: SQL Execute failed processing query
...
L49 F67 Sql (P1): INSERT IGNORE INTO plugin_p4l_lum_packages Values @SQLFILE@ T: 295.4009372
agent is running Ubuntu LTS 18.04
Let me know if I need to add anything else.
Thanks in advance!
Stacy
agent is failing to run LUM Maintenance service script
Re: agent is failing to run LUM Maintenance service script
If SQL is failing then there is either no data or malformed data.
The "Data" is kept in this variable "@SQLFILE@" Can you add a line to script that "script logs" the variable?
We need to see what @SQLFILE@ had inside it at the time of sql execution.
The "Data" is kept in this variable "@SQLFILE@" Can you add a line to script that "script logs" the variable?
We need to see what @SQLFILE@ had inside it at the time of sql execution.