For several days my colleague Jerry Camel and I (keep your eye on Jerry's new blog) and I suffered from very odd behavior on an MIIS server we were building. Symptoms included the following:
-
SQL 2005 Management Studio - the app would take forever to launch and present the connect dialog; while this was happening there was no activity in SQL Profiler and little to no CPU utilization
-
Identity Manager -
-
Clicking tabs in IM would cause the cursor to hourglass and it would take several seconds at least to see a result
-
Starting a Synchronization would cause several records to throw extension-dll-timeouts (my timeout was set to 10 seconds) and then the rest of the run would seemingly run ok until Reference Reprocessing kicked in...
-
Reference Reprocessing would throw out of memory errors during every Identity Manager screen refresh cycle complaining that the step object details table could not be read
A look at the Application Event Log revealed the following MIIServer related error:
Event Type: Error
Event Source: MIIServer
Event Category: Server
Event ID: 6306
Date: 5/16/2007
Time: 3:04:51 PM
User: N/A
Computer: xxxx
Description:
The server encountered an unexpected error while performing an operation for the client.
"BAIL: MMS(432): mastate.cpp(8694): 0x8007000e (Not enough storage is available to complete this operation.): Error allocating memory
BAIL: MMS(432): server.cpp(5381): 0x8007000e (Not enough storage is available to complete this operation.)
BAIL: MMS(432): server.cpp(4275): 0x8007000e (Not enough storage is available to complete this operation.)
Microsoft Identity Integration Server 3.2.0559.0"
After much head bashing and hair pulling we found ourselves staring at the results of a 'netstat -a' query and trying to understand why the box was trying to reach a particular URL - http://crl.microsoft.com. A few searches later and we happened upon this posting:
Dan's Blog: SQL Server Management Studio Startup Time
As it turns out, this server had never been connected to a network that had internet access and therefore had never downloaded the Root Certificate updates from Microsoft. Further analysis of the Event Logs revealed many 'crypt32' errors indicating that the CRL could not be updated from Microsoft. While there may have been another method of forcing this update through other means, we opted for the quick and easy test on Dan's Blog which was to disable the "Check for publisher's certificate revocation" Advanced option in Internet Explorer. Disabling this option had an immediate effect - SQL Management Studio started immediately and MIIS Syncs processed error free - go figure.
Thanks to Dan for posting the original solution.