Service Task Manager-Helpdesk Notifications

Open discussion about our Asset Navigator application

Service Task Manager-Helpdesk Notifications

Postby bearnav on Sun Apr 13, 2008 6:49 pm

I am currently running Asset Navigator 4.5.3 Enterprise edition and I am having issues with the service task manager, particularly with adding ticket notifications to the helpdesk. I have recently created a new database and moved the Asset Navigator data from a Windows 2000 Server running SQL 2000 to a Windows 2003 Server running SQL 2000 also. After importing the database from the other server everything seems to work fine, but the service task manager. It is almost like the module for the helpdesk ticket notification service task module is missing. I get the error below each time I try to configure the ticket notifications for the helpdesk.

The Specified @category_name ('AN41_HelpDesk_Tickets_Notification') does not exist

any ideas?? I do not want to have to recreate my data. Thanks,
bearnav
Newbie
 
Posts: 1
Joined: Sun Apr 13, 2008 1:35 pm

Postby moroz on Tue Apr 15, 2008 6:15 pm

This request has been recently processed via the normal support channel (email to support@alloy-software.com), quote:

When Asset Navigator creates a new database it also adds three new records to the syscategories table in the msdb database (a special database for keeping miscellaneous system info). These categories are used by Service Manager Tasks. If the account that you use to create the database does not have enough rights there is a chance that those three records won't be created.

I recommend you the following workaround.

1. Create an MS SQL user with enough permissions to run system stored procedures and modify tables in the msdb database (or run the stapes below as SQL Server Admin).
2. Run Anit /newdb to create a new database. At this step the new categories should be created. The categories are shared between all databases.
3. Login into your production database and make sure that the issue is no longer reproducible. Delete the extra database.
moroz
Alloy Software
 
Posts: 749
Joined: Wed Aug 28, 2002 9:31 am


Return to Asset Navigator 4 Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron