Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Management Reporter 2012 Application Service fails to configure

Management Reporter 2012 Application Service fails to configure

View products that this article applies to.

Symptom

When you attempt to configure the application and process service for Management Reporter 2012, a red X appears on the application service.

This can also happen when you add a new integration to a new data mart database using the configuration console for Microsoft Management Reporter 2012. The creation of the data mart database fails.

When this happens, check the deployment log at C:\ProgramData\Microsoft Dynamics ERP\Management Reporter\Logs\Deployment-Date_Time.log. The following error message will be displayed in the log file:

 .Net SqlClient Data Provider: Msg 1807, Level 16, State 3, Line 1 Could not obtain exclusive lock on database 'model'. Retry the operation later.


↑ Back to the top

Cause

This issue can occur if there is a connection to the model database in Microsoft SQL Server. The Management Reporter application will not be able to gain an exclusive lock on the model database, causing the creation of the ManagementReporter database to fail. This can also occur when attempting to create a new ManagementReporterDM data mart database.

There are other applications that may keep a lock on the model database.


↑ Back to the top

Resolution

Use the following query in Microsoft SQL Server Management Studio where you are attempting to create the Management Reporter database, to find further details on the process with a connection to the model database:

select
 'Session ID' = sp.spid
 ,'Database Name' = db.name
 ,HostName = sp.hostname
 ,'Program Name' = sp.program_name
 ,'Login Name' = sp.loginame
 ,'Task Manager PID' = sp.hostprocess
 ,Status = sp.status from sys.sysprocesses sp
join sys.databases db on db.database_id = sp.dbid
where db.name = 'model'


With the results of the above query, review the HostName column using the steps below.

  1. Log onto the server in the hostname results and open Task Manager.
  2. Add the PID column in the Processes view.
    1. Server 2012: Right-click the Name column header and then select PID.
    2. Server 2008: Click View, click Select Columns... and then select PID. 



Compare the Task Manager PID results from the above query with the PID in Task Manager to gain additional information on the process.
Depending on the application running the process, stop the related service or close the program which is holding a lock on the model database.

For example, if the process holding a lock is stemming from SQL Management Studio, close the query window where the Model database is selected.

If the process holding the lock is stemming from an application, go to services on the server and stop the service for that application.


↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 3076964
Revision : 1
Created on : 1/7/2017
Published on : 7/6/2015
Exists online : False
Views : 300