ERROR: exception NovaDBCOMException : Query: get_user_account_settings

NovaBACKUP xSP / Remote Workforce
Zuletzt Aktualisiert: Oct 18, 2012 04:32AM PDT
Der folgende Fehler kann im Zusammenspiel von NovaBACKUP xSP und Microsoft SQL Server auftreten:

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

​Um diesen Fehler zu beheben, führen Sie die folgenden Datenbankmodifikationen durch. (Führen Sie das Script im SQL Server Management Studio aus):​
 

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

Kontaktieren Sie uns

  • NovaStor E-Mail Support

    Klicken Sie hier um eine Supportanfrage an das NovaStor Support Team zu senden.

  • Telefon Support

    Wenn Sie NovaCare Premium besitzen, können Sie unsere Support Mitarbeiter auch direkt telefonisch erreichen:

    Telefon: +49 (40) 63809 - 989

    Montag bis Freitag
    09:00 – 17:00 CET (GMT+1)

TeamViewer