Cannot register notification services

Hi everyone,

It's going to drive me crazy. I don't know why I cannot register my notification service. I have got this error:

"The performance counter category could not be installed. Category Name: NS$CustomerInterfaceInstance:Vacuumer"

Additionnal information: "Cannot create Performance Category 'NS$CustomerInterfaceInstance:Vacuumer' because it already exists. (System)"

I tried to delete the notification, close SQL ServerManagement Studio, but I always have the same error.

I installed two times these same notifications in other computers and never seen that before. I tried to change the name of my instance because it seems that it doesn't delete something but I've got the same error with my former instance name NS$CustomerInterfaceInstance.

I don't understand anything, it's crazy!

Please help me, if you had the same problem or if you know how to fix it.

Thank you,

Aurelie.

CableOrganizer.com

Hi Aurelie -

To get back to where you want to be, that is to be able to create the instance, try unregistering the instance (even though it may not completely exist). You may have to use the NSCommandPrompt to do this if it doesn't appear in Management Studio.

Then delete the instance. As counter-intuitive as it may sound, it's possible to delete an instance (which occurs only within SQL Server) without unregistering it. If you do so, that leaves the registry entries, performance counters, and even the instance service in tact, and you cannot re-register an instance of the same name.

After deleting the instance, you can verify that the instance is truly removed by looking in the msdb system database in the NS90.NSInstanceInfo table. For more information about that, check here:
http://weblogs.sqlteam.com/joew/archive/2007/08/23/60305.aspx

After this, you should be able to create your instance again.

HTH...

Joe|||

Thank you so much Joe for your quick response.

I asked yesterday my manager to reboot the server and this morning everything was alright...

Some things are very weird....

Thank you anyway,

Aurelie.

Cannot install SSIS or Notification services

I'm trying to reinstall SQL Server 2005 STD but I cannot get Setup to install Integration Services or Notification Services. I looked in the log and this is what I found. Needless to say, it makes no sense to me. It seems that Setup is trying to find a missing source list for a certain product. I have no clue what that product is. I've spent endless hours trying to figure it out and I'm still drawing a blank. This is a printout of the log.

Integration services -
-
MSI (s) (F0:B0) [02:33:01:437]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (F0:B0) [02:33:02:188]: End dialog not enabled
MSI (s) (F0:B0) [02:33:02:188]: Original package ==> G:\Servers\Setup\SqlRun_DTS.msi
MSI (s) (F0:B0) [02:33:02:188]: Package we're running from ==> C:\WINDOWS\Installer\188966.msi
MSI (s) (F0:B0) [02:33:02:339]: APPCOMPAT: looking for appcompat database entry with ProductCode '{EE8CFFD9-6E29-4DC3-A967-7348D5F41F44}'.
MSI (s) (F0:B0) [02:33:02:339]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (F0:B0) [02:33:02:339]: MSCOREE already loaded, using loaded copy
MSI (s) (F0:B0) [02:33:02:379]: Couldn't find local patch ''. Looking for it at its source.
MSI (s) (F0:B0) [02:33:02:379]: Resolving Patch source.
MSI (s) (F0:B0) [02:33:02:379]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (F0:B0) [02:33:02:379]: User policy value 'DisableMedia' is 0
MSI (s) (F0:B0) [02:33:02:379]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (F0:B0) [02:33:02:379]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (F0:B0) [02:33:02:379]: SOURCEMGMT: Looking for sourcelist for product {8B7E2749-624E-4C61-92FC-2BC18307FF24}
MSI (s) (F0:B0) [02:33:02:379]: Note: 1: 1706 2: {8B7E2749-624E-4C61-92FC-2BC18307FF24} 3:
MSI (s) (F0:B0) [02:33:02:379]: SOURCEMGMT: Failed to resolve source
MSI (s) (F0:B0) [02:33:02:399]: Note: 1: 1708
MSI (s) (F0:B0) [02:33:02:399]: Note: 1: 2729
MSI (s) (F0:B0) [02:33:02:409]: Note: 1: 2729
MSI (s) (F0:B0) [02:33:02:409]: Product: Microsoft SQL Server 2005 Integration Services -- Installation failed.

MSI (s) (F0:B0) [02:33:02:439]: MainEngineThread is returning 1612
The installation source for this product is not available. Verify that the source exists and that you can access it.
G:\Servers\Setup\SqlRun_DTS.msi
MSI (c) (B8:88) [02:33:02:439]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B8:88) [02:33:02:439]: MainEngineThread is returning 1612
=== Verbose logging stopped: 5/19/2006 2:33:02 ===

--
Notification services -
--
MSI (s) (F0:30) [02:33:07:566]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (F0:30) [02:33:08:087]: End dialog not enabled
MSI (s) (F0:30) [02:33:08:087]: Original package ==> G:\Servers\Setup\SqlRun_NS.msi
MSI (s) (F0:30) [02:33:08:087]: Package we're running from ==> C:\WINDOWS\Installer\18898f.msi
MSI (s) (F0:30) [02:33:08:167]: APPCOMPAT: looking for appcompat database entry with ProductCode '{37E9AD9F-3217-4229-B5A5-7A0C82364C6C}'.
MSI (s) (F0:30) [02:33:08:167]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (F0:30) [02:33:08:167]: MSCOREE already loaded, using loaded copy
MSI (s) (F0:30) [02:33:08:187]: Couldn't find local patch ''. Looking for it at its source.
MSI (s) (F0:30) [02:33:08:187]: Resolving Patch source.
MSI (s) (F0:30) [02:33:08:187]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (F0:30) [02:33:08:187]: User policy value 'DisableMedia' is 0
MSI (s) (F0:30) [02:33:08:187]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (F0:30) [02:33:08:187]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (F0:30) [02:33:08:187]: SOURCEMGMT: Looking for sourcelist for product {65A498A6-83B9-4B91-99EA-1BA88D73F0AA}
MSI (s) (F0:30) [02:33:08:187]: Note: 1: 1706 2: {65A498A6-83B9-4B91-99EA-1BA88D73F0AA} 3:
MSI (s) (F0:30) [02:33:08:187]: SOURCEMGMT: Failed to resolve source
MSI (s) (F0:30) [02:33:08:187]: Note: 1: 1708
MSI (s) (F0:30) [02:33:08:187]: Note: 1: 2729
MSI (s) (F0:30) [02:33:08:187]: Note: 1: 2729
MSI (s) (F0:30) [02:33:08:187]: Product: Microsoft SQL Server 2005 Notification Services -- Installation failed.

MSI (s) (F0:30) [02:33:08:197]: MainEngineThread is returning 1612
The installation source for this product is not available. Verify that the source exists and that you can access it.
G:\Servers\Setup\SqlRun_NS.msi
MSI (c) (B8:DC) [02:33:08:207]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (B8:DC) [02:33:08:207]: MainEngineThread is returning 1612

During your first install, the MSIs were cached to the specified location (G:\servers\setup\...). Apparently those files were subsequently deleted or perhaps the drive is no longer accessible. Are you reinstalling from the original media or are you using add/remove programs?|||

Paul, I noticed these lines in the error log.

Integration services -
-
MSI (s) (F0:B0) [02:33:02:188]: Original package ==> G:\Servers\Setup\SqlRun_DTS.msi
MSI (s) (F0:B0) [02:33:02:188]: Package we're running from ==> C:\WINDOWS\Installer\188966.msi
--
Notification services -
--
MSI (s) (F0:30) [02:33:08:087]: Original package ==> G:\Servers\Setup\SqlRun_NS.msi
MSI (s) (F0:30) [02:33:08:087]: Package we're running from ==> C:\WINDOWS\Installer\18898f.msi

However, I can't find the C:\WINDOWS\Installer folder on my computer. Is this significant?

|||

The c:\windows\installer folder is ordinarily hidden. To see it, go to Windows Explorer tools\folder options and under the view tab turn on both "Display the contents of system folders" and "Show hidden files and folders". Once you've done that, the folder and its contents should be visible.

Paul

Cannot get subscription email when including report, but can get it when just sending link

When I set up an email subscription for a report, I can get the email notification if I only include a link to the report, but get the generic "Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information." error message when I attempt to include the actual report in the email; either as "Web Archive," or PDF." When I consult the ReportServer log file, I do not see any sort of exception that would indicate the true source of the error.

I have set the file security on the RSTempFiles folder to allow the IIS_WPG group to modify the folder, but when I looked into the RS config files, it looked as though SSRS wasn't configured to use temporary storage.

Any suggestions?

-Matthew

Noone has had any sort of similar issue as this? I find that hard to believe.

-Matthew

|||

You may also want to make sure that the IIS_WPG user has permissions within the report server to view the report you are trying to email. The problem I am having is that I am unable to send emails with the report to anyone outside of my active directory domain. So if I try to send it to someone @.hotmail.com i receive the following error:

The e-mail address of one or more recipients is not valid.

Cannot get notification after update

Hi,

I set up a notification service on a database update that works the first time I create it (with the instanceConfig.xml the ADF file, subscriptions, etc...) But when I update the instanceConfig.xml, I cannot get the notifications anymore, I don't understand why.

Does anyone know what happen or had the same problem?

Thank you,

Aurelie

I had the same (or, similar) problem.

In my case, it was caused by the fact that I added new elements into my classes in the adf file (subscription class, notification class, ect) where I thought they should belong.

The fact is, I should have added them at the END of each class, NOT somewhere in between the existing elements. When you rebuild your NS application, and your database tables' schemas are changed, somehow the app stops "understanding" the new schemas...

Sorry, English is not my native language, so it's a bit difficult for me to explain exactly what I mean...

Basically, if you add new elements to (or, remove old ones from) your NS files, AND you are sure that you have not missed the necessary modifications in any of the other parts of the program (such as modifying your SMI files, custom formatters - if you have any, etc.), the easiest way to make sure that your app will not be "broken" is to delete your NS database and recreate it again by going through the full cicle of building your NS app as you did the first time.

This way, you will be sure that the database objects will be created according to the latest schemas specified by you.

FYI: I actually went through a very time-consuming and kinda "painful" process of checking and modifying ALL of my NS-related files, and eventually I got it working again, but the next times I had to add new fields and/or delete the existing fields, I did it far simpler and faster (see above): delete the DBs, and recreate them afresh. Unless you already have your app running in production, I strongly recommend this simple approach.

|||Modifying certain classes in an SSNS application requires that the underlying tables be changed. Rather than attempting to modify the existing tables, the update process copies the existing table to an OLD table and creates an all new table for the modified class.

Look to see if you have any OLD tables in your SSNS database. You'll need to migrate the data manually to the new tables.

HTH...

Joe

Cannot get notification after update

Hi,

I set up a notification service on a database update that works the first time I create it (with the instanceConfig.xml the ADF file, subscriptions, etc...) But when I update the instanceConfig.xml, I cannot get the notifications anymore, I don't understand why.

Does anyone know what happen or had the same problem?

Thank you,

Aurelie

I had the same (or, similar) problem.

In my case, it was caused by the fact that I added new elements into my classes in the adf file (subscription class, notification class, ect) where I thought they should belong.

The fact is, I should have added them at the END of each class, NOT somewhere in between the existing elements. When you rebuild your NS application, and your database tables' schemas are changed, somehow the app stops "understanding" the new schemas...

Sorry, English is not my native language, so it's a bit difficult for me to explain exactly what I mean...

Basically, if you add new elements to (or, remove old ones from) your NS files, AND you are sure that you have not missed the necessary modifications in any of the other parts of the program (such as modifying your SMI files, custom formatters - if you have any, etc.), the easiest way to make sure that your app will not be "broken" is to delete your NS database and recreate it again by going through the full cicle of building your NS app as you did the first time.

This way, you will be sure that the database objects will be created according to the latest schemas specified by you.

FYI: I actually went through a very time-consuming and kinda "painful" process of checking and modifying ALL of my NS-related files, and eventually I got it working again, but the next times I had to add new fields and/or delete the existing fields, I did it far simpler and faster (see above): delete the DBs, and recreate them afresh. Unless you already have your app running in production, I strongly recommend this simple approach.

|||Modifying certain classes in an SSNS application requires that the underlying tables be changed. Rather than attempting to modify the existing tables, the update process copies the existing table to an OLD table and creates an all new table for the modified class.

Look to see if you have any OLD tables in your SSNS database. You'll need to migrate the data manually to the new tables.

HTH...

Joe