My Oracle Support Banner

Error when Running Database Cleanup Utility: User does not have permission to run DBCC updateusage for database (Doc ID 1075402.1)

Last updated on NOVEMBER 26, 2019

Applies to:

Primavera Portfolio Management - Version 6.0 and later
Information in this document applies to any platform.

Symptoms

The Database Cleanup utility fails with the following error:

<Trace Type="Error" Time="3/8/2010 6:11:51.052" Class="psException" Method="printException" Process="psDatabaseCleanup.exe (8128)" Client="" TransactionContext="3bf35140-f674-4656-a35d-1be0ff3fa258">Could not get database sizeUSERID: 1DEADLOCK DETECTED: False&ltException&gtSystem.Data.SqlClient.SqlException: User '<user name>' does not have permission to run DBCC updateusage for database '<database name>'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteRead

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.