Monthly Archives: December 2012

SharePoint Not Prompting For Credentials

By Leave a comment

Ran into a case where SharePoint was remembering the client credentials–even though we’d never selected a “remember” box. The credentials were being remembered even after the browser had had all instances shut down.

This turned out to be a browser issue in my case. The domain *.domain.com was listed as a Trusted Site (Tools–>Internet Options–>Security–>Trusted Sites).

Removed that, deleted the saved passwords (Tools–>Internet Options–>Browsing History–>Delete–>Passwords) and closed all instances of IE.
Then, opened IE and was prompted for the login. Gave it. Closed IE and opened it again and was prompted for the login.
As an aside, before we figured this out, I also had to add some JavaScript to the master page to force the user to log out after a certain amount of time. Found this solution here:http://sharepoint.stackexchange.com/questions/29261/how-to-log-off-user-from-sharepoint-site-if-the-user-has-been-inactive-for-20-m

<scripttype=”text/javascript”>

function Timeout() {

var t = setTimeout(“RedirectToLogout()”, 20 * 60000);

}

function RedirectToLogout() {

    var path = “~/_layouts/SignOut.aspx”;

window.navigate(path);

}

Timeout();

</script>

Advertisement

ETL Module Execution failed: FIMAttributeTypeDIM

By Leave a comment

I was receiving the error at the end of this post when running the ETL script for FIM Reporting.

SCSM was reporting that the Load.Common module was failing. When I opened the job, the LoadDWDataMartFIMAttributeTypeDim module was in the failed state.

I have no idea what caused it but the (most likely unsupported) fix was to back up the DWDataMart and DWRepository databases. Then, I truncated the dbo.FIMAttributeTypeDim tables in both databases. (I also truncated the dbo.FIMAttributeTypeDim_bulkstg table in the DWDataMart db, but that might not have been necessary.)

I ran the ETL script again and didn’t get an error.

Event Viewer error:

ETL Module Execution failed:

ETL process type: Load

Batch ID: 15444

Module name: LoadDWDataMartFIMAttributeTypeDim

Message: Cannot insert duplicate key row in object ‘dbo.FIMAttributeTypeDim’ with unique index ‘IX_FIMAttributeTypeDim_FIMAttributeTypeName’.

The statement has been terminated.

Stack:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

Reading and removing a multivalued attribute in a FIM workflow

By Leave a comment

Our client would like users to be forced to re-register for their password reset questions when they have had their password reset from the portal.

I already had a custom workflow to reset the user’s password, but that was just reading single valued attributes. Reading the multi-valued “UniqueIdentifier” attribute was a new one to me.

Here’s the code to read the attribute:

List<Microsoft.ResourceManagement.WebServices.UniqueIdentifier> listAuthNWFRegistered = newList<Microsoft.ResourceManagement.WebServices.UniqueIdentifier>();

listAuthNWFRegistered = resource2[“AuthNWFRegistered”] as List<Microsoft.ResourceManagement.WebServices.UniqueIdentifier>;

foreach (Microsoft.ResourceManagement.WebServices.UniqueIdentifier val in listAuthNWFRegistered)

{

sAuthNWFRegisteredGuid = val.ToString().Replace(“urn:uuid:”, “”);

}

And  then, to remove the attribute, the UpdateRequestParameter is this:

new UpdateRequestParameter(“AuthNWFRegistered”, UpdateMode.Remove, sAuthNWFRegisteredGuid)