Support Forum

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

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.