ERROR: exception NovaDBCOMException : Query: get_user_account_settings
NovaBACKUP xSP / Remote Workforce
**ERROR: exception NovaDBCOMException : Query: get_user_account_settings
Error number: 80040e37
Native error number: 208
Error Description: Invalid object name 'UserBackupSets'.
thrown from Common\AccountDirectory.cpp (1257)
checkpointed at Common\AccountDirectory.cpp (1178)
thrown from NovaDBRecordSet.cpp (1660)
caused by exception COMException : Description: Invalid object name 'UserBackupSets'.
Error: 0x80040e37
Error Message: IDispatch error #3127
Source: Microsoft OLE DB Provider for SQL Server
To fix this error, use the following SQL database modifications:
(copy & paste it to the SQL Server Management Studio)
USE [BackupServer]
GO
/****** Object: StoredProcedure [dbo].[get_user_account_settings] Script Date: 07/30/2012 20:49:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Returns the User Account Settings
-- =============================================
ALTER PROCEDURE [dbo].[get_user_account_settings]
-- parameters for the stored procedure
@UserID numeric(38)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- get all default settings
SELECT
SettingName,
SettingValue
FROM
UserSettings
WHERE
TypeName ='default'
-- get group settings
UNION
SELECT
GS.SettingName,
COALESCE(DS.SettingValue, GS.SettingValue) SettingValue
FROM
Users U
INNERJOIN Groups G
ON U.GroupId = G.GroupId
-- inner join to get group settings
INNERJOIN UserSettings GS
ON (GS.TypeName ='group')
AND(GS.TypeId = G.GroupId)
-- left outer join to get default settings not defined for the specific group
LEFTOUTERJOIN UserSettings DS
ON (DS.TypeName ='default')
AND(DS.SettingName = GS.SettingName)
WHERE U.UserId=@UserID
-- get settings defined for the user, the user's group, and everyone (default)
-- default setting overrides group setting which overrides user setting
UNION
SELECT
US.SettingName,
COALESCE(DS.SettingValue, GS.SettingValue, US.SettingValue) SettingValue
FROM
Users U
INNERJOIN Groups G
ON U.GroupId = G.GroupId
-- inner join to get user settings
INNERJOIN UserSettings US
ON (US.TypeName ='user')
AND(US.TypeId = U.UserId)
-- left outer join to get group settings not defined for the specific user
LEFTOUTERJOIN UserSettings GS
ON (GS.TypeName ='group')
AND(GS.TypeId = G.GroupId)
AND(GS.SettingName = US.SettingName)
-- left outer join to get default settings not defined for the specific user or user's group
LEFTOUTERJOIN UserSettings DS
ON (DS.TypeName ='default')
AND(DS.SettingName = US.SettingName)
WHERE U.UserId=@UserID
/*
-- get backup sets and their filters
SELECT
BS.BackupSetName,
F.FilterName,
F.FilterType,
F.FilterPath,
F.FilterFile
FROM
UserBackupSets UBS
INNER JOIN BackupSets BS ON BS.BackupSetID = UBS.BackupSetID
INNER JOIN BackupSetFilters BSF ON BSF.BackupSetID = BS.BackupSetID
INNER JOIN Filters F ON F.FilterID = BSF.FilterID
WHERE (UBS.UserID = @UserID)
*/
END