cancel
Showing results for 
Search instead for 
Did you mean: 
layer0
Level 7

Can't delete records in Web Reporter

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(RollUpInDb.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(RollUpInDb.java:216)

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

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

    at securecomputing.smartfilter.server.project.reportdbbuilder.tasks.DatabaseMaintenanceTask.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.DatabaseMaintenanceTask] Error running database maintenance: securecomputing.smartfilter.common.adminserver.AdminServerException$DbMaintAdminServerException: An unexpected error occurred.

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

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


Thanks

0 Kudos
1 Reply
haaris
Level 10

Re: Can't delete records in Web Reporter

From the log it seems that its a permission issue .

0 Kudos