ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
I get this message in the sqlserver log: "There is already an object named 'sqlsrv_cpu' in the database"
Article ID: 35044
Updated On:
Products
DX Unified Infrastructure Management (Nimsoft / UIM)
NIMSOFT PROBES
Issue/Introduction
Problem:
When you see "There is already an object named 'sqlsrv_cpu' in the database" message in the sqlserver problem log.
Environment:
- MS SQL Server 2000
- sqlserver probe version 4.20 and below
Cause:
If in the sqlserver.log you see the following entry:
Mar 1 05:37:57:187 [60644] sqlserver: Profile: pe400sc/server_cpu/Run Query - DB Provider: Code=0x80040e14 Source=Microsoft OLE DB Provider for SQL Server Description=There is already an object named 'sqlsrv_cpu' in the database.Description=There is already an object named 'sqlsrv_cpu' in the database.
Resolution:
Download and deploy sqlserver prove version 4.21 or above.
It contains the following fix: "Fixed an issue where sqlusr_cpu store procedure are not deleted after executing querys in case of SQL Server 2000"
Additional Information:
Environment
Release: CNMSPP99000-7.6-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component:
Component:
Feedback
Yes
No
Powered by
