2 Replies Latest reply on Jun 16, 2015 8:13 AM by lubomir.cerny

    DBAdmin db purge error: PROCEDURE lf.ism_purge_host does not exist

    lubomir.cerny

      Hello folks,

      I had some issues updating policy with UDS signatures (Can not save). During this some strang policy names aka NULL are displayed. So I tried to purge and tune DB.

      During purge I got error PROCEDURE lf.ism_purge_host does not exist:

       

      Seems, DB has some strange issues in structure. Can I recover basic structure not touch IPS settings and policies ?

       

      Now purging host event...

      Please Wait While Host event data Are Purged

      Error Performing Purge: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExceptio

      n: PROCEDURE lf.ism_purge_host does not exist

      com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE lf.ism_purg

      e_host does not exist

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

       

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

       

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

      rce)

              at java.lang.reflect.Constructor.newInstance(Unknown Source)

              at com.mysql.jdbc.Util.handleNewInstance(Util.java:395)

              at com.mysql.jdbc.Util.getInstance(Util.java:370)

              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1037)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)

              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2703)

              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

      va:2139)

              at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1363)

       

              at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:904)

              at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCa

      llableStatement.java:3044)

              at com.intruvert.tools.databasetool.DatabaseTool$DBPurgeWorker.run(Datab

      aseTool.java:3620)

      .....com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE lf.ism

      _purge_host does not exist

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

       

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

       

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou

      rce)

              at java.lang.reflect.Constructor.newInstance(Unknown Source)

              at com.mysql.jdbc.Util.handleNewInstance(Util.java:395)

              at com.mysql.jdbc.Util.getInstance(Util.java:370)

              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1037)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)

              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2703)

              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja

      va:2139)

              at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1363)

       

              at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:904)

              at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCa

      llableStatement.java:3044)

              at com.intruvert.tools.databasetool.DatabaseTool$DBPurgeWorker.run(Datab

      aseTool.java:3620)