Monday, February 26, 2007

Error when running a FUD comparison with Windows Authentication






Error:
Exception of type Fusion.FusionSecurityException was thrown.
Version: ITSM 506 P3
Error Details:
---------- EXCEPTION >>
FusionSecurityExceptionMessage: Exception of type Fusion.FusionSecurityException was thrown.
Source: CompareBroker.CheckSecurity
TargetSite: Void CheckSecurity(Fusion.Api.IFusionApi, System.String, System.String)
StackTrace:
at Orion.DefinitionEditor.Broker.CompareBroker.CheckSecurity(IFusionApi iApiTarget, String strRightToCheck, String strErrorMessageName)

at Orion.DefinitionEditor.Broker.CompareBroker.DoCompare(IFusionApi& iApiTarget, FusionPrincipal& fpForTargetAPI, String strTragetDatabase, PlaceHolder[] arPHsToCheck, Boolean bDeepCompare)

at Orion.DefinitionEditor.UI.ExportCreateUpgradeCompare.DoCompare()
at Orion.DefinitionEditor.UI.ExportCreateUpgradeCompare.button1_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Conditions:
When running a comparison between 2 ITSM databases selecting the "Compare" button generates the above error.

Issue:
When the system validates against the target database (ie. the one selected during the FUD wizard not the one you originally logged in with) it uses Windows Authentication to connect to the database. If the user doesn't have sufficient rights to do the export the error is thrown and no Login is provided. This is the case even if the CTRL login option is used for the initial log in.

Work Around:
Increase the user with windows authentication to Administration rights.


1 comment:

Brian Graham said...

This was very helpful and got me out of a jam today!! Thank you, Thank You!!

To reiterate... The NT user name you are using to log onto windows needs to be in the administrator's security group in both ITSM databases your are attempting to compare.

I also had some trouble getting my user name to 'stay' in the administrators group after hitting 'Apply'. (it seemed to change back to it's previous group)...

I was finally able to achieve this by 'un-checking' windows authentication, changing my security group to administrators, setting the internal authentication, click apply, click close, re-open the user manager and then set the windows authentication again.

Thanks again!!

ITSM 5.0.7