Cannot delete or remove reports added to the Favorites list in Web Viewer 12.1

Products

• Output Management Web Viewer

Issue/Introduction

Cannot delete or remove any reports saved in the Favorites list in r12.1. No DRAS authentication messages show any issues.

From the WVTRACE log: 

Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE permission was denied on the object 'SUBSCRIPTION_FAVORITE', database 'DVWEB2 ', schema 'dbo'.

 

Environment

Release : 12.1

Component : CA OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS

Cause

There is a restriction on the database. The user whose credentials are used to logon to SQL, does not have permission to delete items from tables.

Resolution

Speak with your database Administration to grant you modify/delete from the Tables.