Customer wanted to remove Failed to clean up LiveUpdate downloaded content errors from DB with ludbfix tool.
After running ludbfix errors were not repaired.
In ludbfix.log there was an errror Resource governor for 'prepared statements' exceeded.
ludbfix.log
******************************************
java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Resource governor for 'prepared statements' exceeded
at ianywhere.ml.jdbcodbc.jdbc3.IConnection.nativePrepareStatement(Native Method)
at ianywhere.ml.jdbcodbc.jdbc3.IConnection.prepareStatement(IConnection.java:552)
at com.sygate.scm.tools.ludbfix.Main.updateBinaryFileDeleteFlag(Main.java:188)
at com.sygate.scm.tools.ludbfix.Main.doLuDbFix(Main.java:114)
at com.sygate.scm.tools.ludbfix.Main.main(Main.java:267)
*****************************************
Resource governors in Sybase DB need to be disabled during repair process.
To make ludbfix tool working you need to change max_cursor_count and max_statement_count values in DB.
1. Go to ISQL (%ProgramFiles%\Symantec\Symantec Endpoint Protection Manager\ASA\win32\dbisqlc.exe)
2. Run
3. Run ludbfix tool.
4. Go to ISQL and run
After this procedure you should not have Failed to clean up LiveUpdate downloaded content errors in SEPM console.