Ludbfix was unable to repair broken links - Resource governor for 'prepared statements' exceeded in ludbfix.log,

Products

• Endpoint Protection

Issue/Introduction

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)
*****************************************

Cause

Resource governors in Sybase DB need to be disabled during repair process.

Resolution

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 

• Set option public.max_cursor_count = 0;
• Set option public.max_statement_count = 0;

3. Run ludbfix tool.

4. Go to ISQL  and run

• Set option public.max_cursor_count = 50;
• Set option public.max_statement_count = 50;

After this procedure you should not have Failed to clean up LiveUpdate downloaded content errors in SEPM  console.