|
| | | Supreme Being
Group: WhatsUp Preview Program Members
Last Login: Yesterday @ 9:37:32 AM
Posts: 79, Visits: 42 |
| | Well? Any comments from support on the status of this 12.0.2 patch given the number of reports that end users had problems after installing it? Do we install it, or not? Jason |
| |
| | | 
Time Traveler
Group: Forum Members
Last Login: Today @ 4:45:13 AM
Posts: 348, Visits: 6,753 |
| | |
| | | Forum Newbie
Group: Forum Members
Last Login: 11/12/2008 3:58:28 PM
Posts: 2, Visits: 11 |
| CHECKCONSTRAINTS:
Error in table '[dbo].[PivorReportToCategory]': value '[nWebUserID = '2'' violates '[FK_PivutReportToCategory_nWebUserID]'.
For those of you seeing this error? Have you at some point in time deleted the "GUEST" user account? And then run an upgrade of WUG from a previous version to V12? The upgrade process adds entries into the PivotReportToCategory table for the GUEST user (UserID = 2). Don't think the new patch has anything to do with the above error. There is a foreign key constaint issue in the DB that was there before the patch was run - and the error is only showing up when trying to validate/compact the DB as part of the patch process. The fix for the above error would be to make sure that you do not have a user in the WebUser DB table with a nWebUserID = 2 (The Guest user). If you do not have a user with nWebUserID = 2, go to the PivotReportToCategory table and delete all rows where nWebUserID = 2 (Should be 6 rows.) Then try to validate your DB. PLESE REPLY TO THIS POST and let me know if this fixes your issue - and let me know if you did delete your guest user and that you did run an upgrade at some point afterwards. If I find that this was the case, I will look into changing the upgrade process to avoid these issues in the future. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 11/12/2008 3:58:28 PM
Posts: 2, Visits: 11 |
| | You can run this query in SQL Server management Studio to remove the orphaned nWebUserIDs that are in the PivotReportToCategory table: DELETE FROM [PivotReportToCategory] WHERE [nWebUserID] NOT IN (SELECT DISTINCT [nWebUserID] FROM [WebUser]) |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 8/13/2008 3:50:58 PM
Posts: 1, Visits: 2 |
| | Thanks, kmonahan! I too had the error: CHECKCONSTRAINTS:
Error in table '[dbo].[PivorReportToCategory]': value '[nWebUserID = '2'' violates '[FK_PivutReportToCategory_nWebUserID]' BEFORE and AFTER 12.0.2 patch installation and your instructions using SQL server mgt Studio worked. Ran DB validate and compact with no further issues. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 9/19/2008 4:08:34 PM
Posts: 2, Visits: 5 |
| | I am receiving the exact same error and it prevents me from being able to access Whatsup via HTTP. How can I correct this if I am running Whatsup on an XP machine and only have the SQL version supplied with Whatsups v12 Premium. I don't seem to have access to the SQL 2005 Studio as referenced in your earlier responses. THANKS in advance for your assistance |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 9/19/2008 4:08:34 PM
Posts: 2, Visits: 5 |
| | osql -E -D WhatsUp -Q "DELETE FROM PivotReportToCategory WHERE nWebUserID = 2" I used this command and it worked. The only problem is I still can't get access to WHATSUP using HTTP. It just goes to a dead page. I am not sure where to look next. Any ideas? |
| |
|
|