Forum Discussion

TraceyBunyard's avatar
TraceyBunyard
Level 5
5 years ago

NSS throwing SQL errors in the SQL log after upgrading from NSS 8.1.1 to NSS 8.1.2

Product seems working fine, but this error appears up to 12 times per second in the SQL ERROR log:

Error Message

The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-xxxxxx-xxxxx-xxxxx-xxxxxxxxxxxx]' running on queue 'NSSBE_01.dbo.SqlQueryNotificationService-xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' output the following: 'Could not find stored procedure 'dbo.SqlQueryNotificationStoredProcedure-xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'.'

NetBackup Self Service
NSS
  • TraceyBunyard's avatar
    TraceyBunyard
    5 years ago

    This has been logged as a bug but in the meantime, you can do the following to mitigate:

     Run the following query against the NSS Portal database to get a list of service queues:

    select * from sys.service_queues​

    Then compare those results to the available stored procedures listed in Management Studio here (also in the portal DB):

    Programmability > Stored Procedures > SqlQueryNotificationStoredProcedure-[alphanumeric sequence]

    If you cannot find a particular listed stored procedure within the results of your query, it can be deleted manually from the stored procedure list within Management Studio.  Check every listed stored procedure and delete where necessary.

  • TraceyBunyard's avatar
    TraceyBunyard
    Level 5
    5 years ago

    This has been logged as a bug but in the meantime, you can do the following to mitigate:

     Run the following query against the NSS Portal database to get a list of service queues:

    select * from sys.service_queues​

    Then compare those results to the available stored procedures listed in Management Studio here (also in the portal DB):

    Programmability > Stored Procedures > SqlQueryNotificationStoredProcedure-[alphanumeric sequence]

    If you cannot find a particular listed stored procedure within the results of your query, it can be deleted manually from the stored procedure list within Management Studio.  Check every listed stored procedure and delete where necessary.