Skip to main content
Planview Customer Success Center

Changepoint_Archive Aged Entities fails when creating ArcDistribution database

Symptoms

The error message contains the following:

Source: Populate Distribution DB

Description: CREATE DATABASE permission denied in database 'master'

User does not have permission to alter database 'Changepoint_ArcDistribution', the database does not exist, or the database is not in a state that allows access checks.

Executing the query "EXEC ARC_CreateDistributionDB " failed with the following error: "Database 'Changepoint_ArcDistribution' does not exist. Make sure that the name is entered correctly.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Reason

The user configured in the archiving ini file does not have sufficient privileges, such as for creating databases, which are required because the job recreates the database ArcDistribution every time.

Resolution

In the ini file, configure a user with administrative rights, for example 'sa'.