ERROR: exception NovaDBCOMException : Query: get_user_account_settings

NovaBACKUP xSP / Remote Workforce
Last Updated: Oct 18, 2012 04:32AM PDT

 

**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

 

NovaCare Status

NovaStor Support

Contact Us

  • E-Mail NovaStor Support

    Click Here to submit your case to the NovaStor Support Team.

  • Phone Support

    If you have NovaCare Support you can call our support line:

    US Support:
    Call +1(805) 409-3140
    Press 2 for Technical Support
    Monday through Friday
    8am - 5pm PST

    EMEA Support:
    Call +49 (40) 63809 - 989
    Monday through Friday
    9am - 5pm CET (GMT+1)

TeamViewer