|
| |  Posted 3/14/2008 12:23:18 AM | |
| Forum Member
 
Group: Forum Members
Last Login: 3/26/2008 6:33:09 AM
Posts: 40, Visits: 41 |
| | Configure, Manage Users, <name> ... Check All Rights, gives the below "An error occured while attempting to update the default report favorite in the database. Error:An error occured while attempting to update the default report favorite in the database. Error:%1" |
| |
| | | Posted 3/14/2008 4:44:44 PM | |
| 
Time Traveler
Group: Administrators
Last Login: 9/5/2008 4:16:13 PM
Posts: 294, Visits: 785 |
| Hi Mick,
Does this happen for any user or only one specific user? Did you perform an upgrade or a clean install? What OS and browser are you using?
Thanks,
Jason |
| |
| | | Posted 3/17/2008 7:01:38 AM | |
| Forum Member
Group: Forum Members
Last Login: 3/26/2008 6:33:09 AM
Posts: 40, Visits: 41 |
| | I have tried to do it twice with new users, even though the error is displayed, the user is created. Upgrade from v11. OS 2003 SP2. Client OS = XPSP3RC Client Browser = IE7 |
| |
| | | Posted 3/17/2008 11:21:44 AM | |
|
Time Traveler
Group: Administrators
Last Login: 9/5/2008 4:16:13 PM
Posts: 294, Visits: 785 |
| Hi Mick,
This has been fixed and will be in the next build. If you've already upgraded you'll need to run the following commands against the database (can be run as one large procedure):
DECLARE @nPivotReportToCategoryID INT
SET @nPivotReportToCategoryID = (SELECT TOP 1 nPivotReportToCategoryID FROM PivotReportToCategory ORDER BY nPivotReportToCategoryID DESC)
IF (@nPivotReportToCategoryID < 10000)
BEGIN
DBCC CHECKIDENT ('PivotReportToCategory', RESEED, 10000)
END
ELSE
BEGIN
SET @nPivotReportToCategoryID = @nPivotReportToCategoryID + 1
DBCC CHECKIDENT ('PivotReportToCategory', RESEED, @nPivotReportToCategoryID)
END
GO
DECLARE @nDiagnosticID INT
SET @nDiagnosticID = (SELECT TOP 1 nDiagnosticID FROM Diagnostic ORDER BY nDiagnosticID DESC)
IF (@nDiagnosticID < 100000)
BEGIN
DBCC CHECKIDENT ('Diagnostic', RESEED, 100000)
END
ELSE
BEGIN
SET @nDiagnosticID = @nDiagnosticID + 1
DBCC CHECKIDENT ('Diagnostic', RESEED, @nDiagnosticID)
END
GO |
| |
| | | Posted 3/18/2008 12:36:13 AM | |
| Forum Member
Group: Forum Members
Last Login: 3/26/2008 6:33:09 AM
Posts: 40, Visits: 41 |
| | I've tested that, can now add users without error. Thanks |
| |
| | | Posted 3/18/2008 8:26:40 AM | |
|
Time Traveler
Group: Administrators
Last Login: 9/5/2008 4:16:13 PM
Posts: 294, Visits: 785 |
| Mick,
Thanks for testing it out!
Jason |
| |
| | | Posted 3/19/2008 8:11:42 AM | |
| Forum Newbie
Group: Forum Members
Last Login: Yesterday @ 9:01:41 PM
Posts: 7, Visits: 49 |
| | What's the risk to the database running that fix? I have the same error and I need it fixed ASAP but I don't have a test environment to try this out first. |
| |
| | | Posted 3/19/2008 9:00:25 AM | |
|
Time Traveler
Group: Administrators
Last Login: 9/5/2008 4:16:13 PM
Posts: 294, Visits: 785 |
| There's no risk really but backing up the DB before making changes is always a good idea.
Jason |
| |
|
|