1 Reply Latest reply on Dec 18, 2014 11:07 AM by Haaris Faizan

    Can't delete records in Web Reporter

    layer0

      Hello

       

      I have Web Reporter Version 5.2.1.01 connected to an external SQL Database configurated according to KB75055, but when i try to run a Maintenance task to delete summary or detailed records they results in status "Failed". There is something else we have to configure, to work it properly? I am sure that the database user has db_owner privileges on the Web reporter database.

       

      Reviewing the Server.log i view the followings messages:

       

      2014-12-17 10:16:58,193 INFO  [securecomputing.smartfilter.reportdbbuilder.RollUpInDb] Verifying rollup_tmp doesn't exist in schema.

      2014-12-17 10:16:58,193 ERROR [securecomputing.smartfilter.reportdbbuilder.RollUpInDb] The rollup_tmp table exists.  Attempt will be made to drop it from the schema

      2014-12-17 10:16:58,193 INFO  [securecomputing.smartfilter.reportdbbuilder.RollUpInDb] Dropping rollup_tmp table.

      2014-12-17 10:16:58,318 ERROR [securecomputing.smartfilter.reportdbbuilder.RollUpInDb] Attempt to Drop rollup table failed.

      java.sql.SQLException: The SELECT permission was denied on the object 'sysmail_profile', database 'msdb', schema 'dbo'.

          at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)

          at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)

          at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)

          at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:637)

          at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)

          at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)

          at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)

          at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1166)

          at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1119)

          at securecomputing.smartfilter.reportdbbuilder.RollUpInDb.dropRollupTmpTable(RollU pInDb.java:1658)

          at securecomputing.smartfilter.reportdbbuilder.RollUpInDb.deleteRecordsByPartition (RollUpInDb.java:819)

          at securecomputing.smartfilter.reportdbbuilder.RollUpInDb.deleteRecords(RollUpInDb .java:689)

          at securecomputing.smartfilter.reportdbbuilder.RollUpInDb.deleteFromBothTables(Rol lUpInDb.java:216)

          at securecomputing.smartfilter.reportdbbuilder.RollUp.deleteFromBothTables(RollUp. java:132)

          at securecomputing.smartfilter.server.project.reportdbbuilder.tasks.DatabaseMainte nanceTask.executeManualTask(DatabaseMaintenanceTask.java:872)

          at securecomputing.smartfilter.server.project.reportdbbuilder.tasks.DatabaseMainte nanceTask.runit(DatabaseMaintenanceTask.java:231)

          at securecomputing.smartfilter.server.project.ScheduledTask.run(ScheduledTask.java :67)

          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java: 886)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

          at java.lang.Thread.run(Thread.java:619)

      2014-12-17 10:16:58,318 ERROR [securecomputing.smartfilter.server.project.reportdbbuilder.tasks.DatabaseMaint enanceTask] Error running database maintenance: securecomputing.smartfilter.common.adminserver.AdminServerException$DbMaintAdmi nServerException: An unexpected error occurred.

      2014-12-17 10:16:58,318 INFO  [securecomputing.smartfilter.server.project.reportdbbuilder.tasks.DatabaseMaint enanceTask] Current Database maintenance status: FAILED

      2014-12-17 10:16:58,318 INFO  [securecomputing.smartfilter.server.project.reportdbbuilder.tasks.DatabaseMaint enanceTask] Updating Database maintenance status.


      Thanks