SCCM console crashes when I try to run certain queries

I have just set up an SCCM SP1 R2 site. My server is running Server 2008 and SQL 2008 (so KB913538 and KB932303 do not apply). The site appears to be happy & healthy. All components are working, all my Site Status bubbles are green.

However, Running the following query (and certain other queries created with the wizard) will cause the SCCM admin console to crash:

select SMS_R_System.Name, SMS_R_System.LastLogonUserName from SMS_R_System

I get this error message:

"An error occured in ConfigMgr. The ConfigMgr console will continue to function, however you should save your work and restart the console. After restarting the console, verify that your last configurations have been applied."

If I click on the DETAILS button I see the following:

System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ConfigurationManagement.AdminConsole.ConsoleView.ConsoleFormViewControl.listView1_CacheVirtualItems(Object sender, CacheVirtualItemsEventArgs e)
at System.Windows.Forms.ListView.WmReflectNotify(Message& m)
at System.Windows.Forms.ListView.WndProc(Message& m)
at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Additionally, I see the following in the ADMINUI.LOG file

[3][11/24/2009 10:00:19 AM] :System.InvalidCastException\r\nSpecified cast is not valid.\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryPropertySingleItem.get_BooleanValue()\r\n
[3][11/24/2009 10:00:19 AM] :Microsoft.ConfigurationManagement.ManagementProvider.SmsConnectionException\r\nSpecified cast is not valid.\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryPropertySingleItem.get_BooleanValue()
at Microsoft.ConfigurationManagement.AdminConsole.CollectionMenuActions.LaunchUtilities.IsApproveMemberActionEnabled(Object sender, ScopeNode scopeNode, ActionDescription action, ResultObjectBase selectedResultObject)\r\nSpecified cast is not valid.
\r\nSystem.InvalidCastException\r\nSpecified cast is not valid.\r\n at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlQueryPropertySingleItem.get_BooleanValue()\r\n
[3][11/24/2009 10:26:23 AM] :Property: 'SiteCode'\r\nSystem.Management.ManagementException\r\nNot found \r\n at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.PropertyDataCollection.get_Item(String propertyName)
at Microsoft.ConfigurationManagement.ManagementProvider.WqlQueryEngine.WqlResultObjectBase.get_Item(String name)\r\nManagementException details:
[3][11/24/2009 11:01:12 AM] :An error occured in ConfigMgr. The ConfigMgr console will continue to function, however you should save your work and restart the console. After restarting the console, verify that your last configurations have been applied.

An error occured in ConfigMgr. The ConfigMgr console will continue to function, however you should save your work and restart the console. After restarting the console, verify that your last configurations have been applied.
at Microsoft.ConfigurationManagement.AdminConsole.ConsoleView.ConsoleFormViewControl.listView1_CacheVirtualItems(Object sender, CacheVirtualItemsEventArgs e)

After I close and restart the admin console I can run the query and it works. If I wait a while (more than ~30 minutes) and try to run the query again, the console will crash again.

Any ideas on how to narrow down this problem?

Thanks in advance,
Janet

November 24th, 2009 8:42pm

CSS would be the route to go for an issue like this.
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2009 12:15am

I have been having this exact same problem. I am also Server 08 and SQL 08, SCCM SP1 R2. I have been "living with it" and just restarting the admin console up until now but it sure is a pain. Please post the fix here if you find it. It is definitely not just you. MS should be able to recreate the problem if we can...
December 11th, 2009 7:00pm

I also am getting a SCCM sp1 console crash. It happens when I right-click on a object (package, client, advertisment, TS, etc...) on the right window pane of the console. Right-clicks on the left pane objects work fine. Here is the error:

System.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I am running Windows 7 Ultimate x64.
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2009 6:24pm

We just upgraded to SCCM SP2 and it fixed a lot of our problems with console crashing.
December 15th, 2009 11:30pm

I just upgraded to SP2 on Wednesday and, unfortunately, my console is still crashing.  It doesn't seem like there is any difference, after I restart the console I can run queries just fine for a while, then it crashes again...
Free Windows Admin Tool Kit Click here and download it now
December 18th, 2009 5:46pm

Next time it happens; or you could go look now, assuming the log file hasn't rolled, but look for <installed console location>\AdminUI\AdminUILog, the SMSAdminUI.log file .  It it's an error that could be captured, you might get a hint toward why it's crashing.
December 18th, 2009 7:35pm

Make sure you upgrade all the admin consoles to SP2 also. You must upgrade all consoles individually (other than the console on the primary site server).

If that does not resolve it, then I'd suggest you open a case with CSS.
Free Windows Admin Tool Kit Click here and download it now
December 28th, 2009 4:23am

You have a software update for MMC errors, it doesn´t say anything about queries but you might have the below errors too?

This software update addresses several MMC errors that may occur when running the Configuration Manager console. This update should be applied if any of the following occur: Configuration Manager console stops responding when the host computer is low on available memory, context menu errors on console home pages, or inconsistent display after drag-and-drop operations do not succeed. More information about this update is available at: http://go.microsoft.com/fwlink/?LinkId=98349.

December 31st, 2009 11:53pm

it seems like that you are making a query which is running more than 1 or 2 min. such happens when you make a query do not provide currect output display name in General Tab of a query.
OR might have WMI provider memory error

Find the below error in adminUI.log
ErrorCode = 2152205056

if this is then fillow the below steps -

1. Run WBEMTest and connect to Root.

2. Click 'Open Instance', enter __ProviderHostQuotaConfiguration=@ and click OK.

3. Locate the MemoryPerHost property and double click it to bring up the editor.

4. Change the value to 402653184 and click Save Property. [Note: 402653184 is 384MB written in Bytes. So 384MB=393216KB=402653184B]

5. Locate the HandlesPerHost property, note the current value, set it to 8192 and click Save Property.

6. Click Save Object, exit WBEMTest and reboot the site server and test again.

Note : Make sure that you have saved the curren value some where.

if again it crash then post the log file as "Sherry Kissinger"  asked in previous post.

Free Windows Admin Tool Kit Click here and download it now
January 11th, 2010 1:49pm

Marking this as answered as no update from the original poster in many months now.
March 13th, 2010 9:48am

Wally,

are there any news concerning this issue? Meanwhile I can see this problem in every installation environment and the people ask what to do. The only workaround today is to use the console under W2K3 (e.g. via TS). The problem still occurs on everything based on Windows 7 / W2K8 and younger.

Thanks in advance for any reply, Wally.

Alex
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2010 3:42pm

We're still having the problem.  I made sure all consoles were installed with SP2.  None of the suggestions here has fixed the problem, I didn't update it because nothing has changed.

I am fighting a patch issue right now (have another open question about that in a different post).  When I get that straightened out I will post my AdminUILog as per Sherry's suggestion.  If you want to mark this answered for now thats fine.  I'll either post back here or open a new question.
March 15th, 2010 4:48pm

Have you tried running that query in the console while logged into the server using RDP? Does it crash there too, or are we just talking about clients?
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2010 9:05pm

It seems to happen pretty consistently when I am logged into the server using RDP.

I have noticed that it rarely happens when I am running the admin console from my workstation.

Since I usually run the admin console from my workstation I am just living with it, the only reason I would still like to find a fix is that we do occasionally need to RDP into the server to use the admin console. 

Thanks,
Janet

 

March 15th, 2010 9:46pm

The crash occurs on Windows 7 (32 and 64 Bit), Windows Vista, Windows Server 2008 (32 and 64 Bit), Windows Server 2008 R2 in english and in german version of SCCM 2007 SP2 R2. It  5 of 5 complete different infrastructure environment in 5 totally different enterprises.

Alex
Free Windows Admin Tool Kit Click here and download it now
March 15th, 2010 11:39pm

I just tried the query in my testlab (ConfigMgr 2007 SP2 R2 on Server 2008 R2) and it works fine and does not crash.
March 16th, 2010 11:10am

Torsten,

try to work with SCCM in a productive environment: create some dozens of Queries and Collections, work with software deployment like it is used to when a customer will invest in SCCM and you will get the same effect like Janet, me and all of the customers with this problem.

Nevertheless: I have this problem in test environment, too. With only some test machines and ony few queries.

I guess it is not a problem of SCCM. It smells like a problem with the MMC implemented in W7, W2K8.


Alex
Free Windows Admin Tool Kit Click here and download it now
March 17th, 2010 9:55am

try to work with SCCM in a productive environment [...] and you will get the same effect like Janet, me and all of the customers with this problem.
No, just tried that, too. The query returned >60k records and the console did not crash.
March 17th, 2010 11:26am

I had the same crash as MarcusM, resulting in an error with the details:

System.OverflowException: Arithmetic operation resulted in an overflow.
   at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I was finally able to consistently reproduce the error.  I have two monitors--the left one is vertical, the right one is horizontal.  The top of the left one extends above the top of the right one.  I usually put my ConfigMgr console in the left monitor.  Now, extend an imaginary line from the top of the right monitor over into the left monitor.  When the first line of data in the center pane of the Console is still above that line, and I right-click above that imaginary line, I get the console crash.  If I right-click below that imaginary line, it gives me the right-click menu one would expect.  This same behavior is true whether the Console is maximized or free-floating, as long as my right-click is above that line.  The behavior exists in Collections, Advertisements, Boot Images, etc.--I didn't test all the areas, but all the areas I tested exhibit the behavior.  Other MMC consoles (I tested AD) don't show the same behavior.

Just FYI, in case it helps someone.

--brian.

Free Windows Admin Tool Kit Click here and download it now
April 7th, 2010 3:10pm

Hi Brian,

 

I'm in a new project this week, complete different infrastructure and also installed SCCM 2007 SP2 R2. And I have the same problem again, no matter if I work with the console on W7 or on a dedicated TS or on the SCCM Site Server itself. The console crashes from time to time.

I really hope, that a big customer will have this issue to so that Microsoft will take a look in.

Alex

April 7th, 2010 9:48pm

I really hope, that a big customer will have this issue to so that Microsoft will take a look in.
Just call CSS and they will have a look at it, no matter of the size of a customer.
Free Windows Admin Tool Kit Click here and download it now
April 8th, 2010 9:49am

We have same issue as well.. it dosent crash all the time but crash sometime alot. If there is any hotfix or update availble please post here.

June 2nd, 2010 4:15pm

I have exact same error:

 

System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ConfigurationManagement.AdminConsole.ConsoleView.ConsoleFormViewControl.listView1_CacheVirtualItems(Object sender, CacheVirtualItemsEventArgs e)
   at System.Windows.Forms.ListView.WmReflectNotify(Message& m)
   at System.Windows.Forms.ListView.WndProc(Message& m)
   at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

When I try to run this query:

Select distinct SMS_G_System_SoftwareFile.FileVersion from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceID where SMS_G_System_SoftwareFile.FileName = "QMgr.dll" order by SMS_G_System_SoftwareFile.FileVersion

(Hopefully I didn't type any of that wrong...)

 

Only happens the first time I click on the query, until I close the admin console and click on it again then it happens again.  Happens every time.

 

Running console on Windows 2008 SP2 server.  Site is 2007 SP2 R2, and Admin Console also is SP2 R2.

 

Would suggest a moderator unmark the currently suggested answer from Wally as it seems many others are having this issue and that suggestion isn't the answer.

 

Thanks,

Terry

Free Windows Admin Tool Kit Click here and download it now
July 13th, 2010 8:54pm

Running console on Windows 2008 R2 server.  Site is 2007 SP2 R2, and Admin Console also is SP2 R2.

Same problem here

 

System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ConfigurationManagement.AdminConsole.ConsoleView.ConsoleFormViewControl.listView1_CacheVirtualItems(Object sender, CacheVirtualItemsEventArgs e)
   at System.Windows.Forms.ListView.WmReflectNotify(Message& m)
   at System.Windows.Forms.ListView.WndProc(Message& m)
   at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

January 18th, 2011 3:30pm

I have the same issue too and it's driving me mad. There's no consistency to it. One day queries will all work OK, the next day one or two will crash when you run them, the next day the queries run OK again. Aaaarrrggghhhh!! I have two primary servers both on 64 bit Windows Server 2008, one on SQL 2005 database one on SQl 2008 database. Both SCCm installs are SCCM 2007 SP1 with R2 update. I'm running Windows 7 on my laptop, but RDP to the servers and run the console on them (it's way too slow to run the console direct from my laptop).

Here's the exact message I see (same as the post above):

System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ConfigurationManagement.AdminConsole.ConsoleView.ConsoleFormViewControl.listView1_CacheVirtualItems(Object sender, CacheVirtualItemsEventArgs e)
   at System.Windows.Forms.ListView.WmReflectNotify(Message& m)
   at System.Windows.Forms.ListView.WndProc(Message& m)
   at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

If someone ever finds an answer please post it here!!

 

Free Windows Admin Tool Kit Click here and download it now
February 17th, 2011 4:46pm

I had the same crash as MarcusM, resulting in an error with the details:

System.OverflowException: Arithmetic operation resulted in an overflow.
   at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I was finally able to consistently reproduce the error.  I have two monitors--the left one is vertical, the right one is horizontal.  The top of the left one extends above the top of the right one.  I usually put my ConfigMgr console in the left monitor.  Now, extend an imaginary line from the top of the right monitor over into the left monitor.  When the first line of data in the center pane of the Console is still above that line, and I right-click above that imaginary line, I get the console crash.  If I right-click below that imaginary line, it gives me the right-click menu one would expect.  This same behavior is true whether the Console is maximized or free-floating, as long as my right-click is above that line.  The behavior exists in Collections, Advertisements, Boot Images, etc.--I didn't test all the areas, but all the areas I tested exhibit the behavior.  Other MMC consoles (I tested AD) don't show the same behavior.

Just FYI, in case it helps someone.

--brian.

 

There are several issues in this thread that all appear to generate the same error message.

The quoted post solved the following issue for several of my clients: The SCCM console crashes seemly at random when running dual monitors.

April 6th, 2011 4:08pm

I had the same crash as MarcusM, resulting in an error with the details:

System.OverflowException: Arithmetic operation resulted in an overflow.
   at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

I was finally able to consistently reproduce the error.  I have two monitors--the left one is vertical, the right one is horizontal.  The top of the left one extends above the top of the right one.  I usually put my ConfigMgr console in the left monitor.  Now, extend an imaginary line from the top of the right monitor over into the left monitor.  When the first line of data in the center pane of the Console is still above that line, and I right-click above that imaginary line, I get the console crash.  If I right-click below that imaginary line, it gives me the right-click menu one would expect.  This same behavior is true whether the Console is maximized or free-floating, as long as my right-click is above that line.  The behavior exists in Collections, Advertisements, Boot Images, etc.--I didn't test all the areas, but all the areas I tested exhibit the behavior.  Other MMC consoles (I tested AD) don't show the same behavior.

Just FYI, in case it helps someone.

--brian.

 

There are several issues in this thread that all appear to generate the same error message.

The quoted post solved the following issue for several of my clients: The SCCM console crashes seemly at random when running dual mon

Free Windows Admin Tool Kit Click here and download it now
April 25th, 2011 11:06pm

i had 3 monitors (2 horiz on the left, 1 horiz on the right).  My console crashes only in the top left monitor...ARRRG.  everywhere else, right click works...its is as simple as that.

just wanted to THANK Brian for listing this, i sure i was going crazy, maybe its just friday.

so my question:

If the .NET 2.0 framework can't handle the x,y location of the right click on my 3rd monitor - when i move to SP2 R3 - will this be addressed??  Also, what kind of testing would miss such a simple scenario...don't the developers know how to use DBL instead of INT for capturing??

BONER!!

June 17th, 2011 7:24pm

Just upgraded my CCM Console to 2007 R3 SP2 on Win 7 Enterprise x64 SP1.

Still have the same issue when running on my second monitor.  Moving the console to the primary monitor fixes the issue.  Too bad my primary screen is a 1280x800 laptop panel :(

Are MS looking to fix this problem.  I would have thought running Consoles for MS products on an MS OS would be simple math.

Free Windows Admin Tool Kit Click here and download it now
July 28th, 2011 4:46am

Any idea of any kind of hotfix/patches for the problem???
March 30th, 2012 2:40pm

I have two monitors with different resolutions (something even three when the laptop display is enabled) and use the CM07 console on both of them all the time. I have never had the console crash (that I know of) due to monitor size or position issues.

What are the exact steps that you have used to duplicate this issue? Have you called CSS on this issue?


Free Windows Admin Tool Kit Click here and download it now
March 30th, 2012 3:08pm

I have exact same error:

System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ConfigurationManagement.AdminConsole.ConsoleView.ConsoleFormViewControl.listView1_CacheVirtualItems(Object sender, CacheVirtualItemsEventArgs e)
   at System.Windows.Forms.ListView.WmReflectNotify(Message& m)
   at System.Windows.Forms.ListView.WndProc(Message& m)
   at Microsoft.ConfigurationManagement.AdminConsole.Common.SmsListView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

When I try to run this query:

Select distinct SMS_G_System_SoftwareFile.FileVersion from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceID where SMS_G_System_SoftwareFile.FileName = "QMgr.dll" order by SMS_G_System_SoftwareFile.FileVersion

(Hopefully I didn't type any of that wrong...)

Only happens the first time I click on the query, until I close the admin console and click on it again then it happens again.  Happens every time.

Running console on Windows 2008 SP2 server.  Site is 2007 SP2 R2, and Admin Console also is SP2 R2.

Would suggest a moderator unmark the currently suggested answer from Wally as it seems many others are having this issue and that suggestion isn't the answer.

Thanks,

Terry


I am also having this same problem but we don't have dual monitors. However, if you look at the display properties, it says "Display: 1. (Mulitple Monitors) on ATI ES1000)"

Anyone ever find a fix for this?


EDIT: Well looks like I spoke too soon. I updated the driver for the ES1000 and now my problems are gone.
July 25th, 2013 12:32pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics