search cancel

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

book

Article ID: 202142

calendar_today

Updated On:

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'.
 

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.

Environment

Release : 12.1

Component : CA OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS

Resolution

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