locked
problem MAP i SQL RRS feed

  • Question

  • Inventory (MAP) working but no results tail log below:

    usChanged|INF> Focus change detected.  Focus changed to 'System.Windows.Controls.MenuItem Header:Cancel processing Items.Count:0'
    <2013-04-05 14:25:34.07 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.OnWindowKeyboardFocusChanged|INF> Focus change detected.  Focus changed to 'System.Windows.Controls.MenuItem Header: Items.Count:2'
    <2013-04-05 14:25:34.07 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.OnWindowKeyboardFocusChanged|INF> Focus change detected.  Focus changed to 'System.Windows.Controls.MenuItem Header:View progress... Items.Count:0'
    <2013-04-05 14:25:34.13 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.OnWindowKeyboardFocusChanged|INF> Focus change detected.  Focus changed to 'System.Windows.Controls.MenuItem Header: Items.Count:2'
    <2013-04-05 14:25:36.18 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.OnWindowKeyboardFocusChanged|INF> Focus change detected.  Focus changed to 'System.Windows.Documents.Hyperlink'
    <2013-04-05 14:26:44.37 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.UpdateFocusedNodes|INF> No node is currently focused
    <2013-04-05 14:26:44.40 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.UpdateFocusedNodes|INF> Focused node is 'msscnav://root/Windows/Window'
    <2013-04-05 14:26:44.40 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.UpdateFocusedNodes|INF> No node is currently focused
    <2013-04-05 14:26:44.40 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.UpdateFocusedNodes|INF> Focused node is 'msscnav://root/Windows/Window'
    <2013-04-05 14:26:44.80 TID-1@ScuiFxTraceListener,I> <WindowFocusedNavigationNode.UpdateFocusedNodes|INF> Focused node is 'msscnav://root/Windows/Window/ConsoleDisplay/Server'
    <2013-04-05 14:29:44.78 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught InvalidOperationException trying to roll back the transaction: This SqlTransaction has completed; it is no longer usable.
    <2013-04-05 14:29:44.85 AssessInventoryWorker@DataAccessCore,W> DoWorkInTransaction<T>() - Caught a SQL transaction timeout exception. Will retry 2 more time(s). Retrying in 10000 milliseconds.
       |onSqlExceptionMessage = Caught SqlException running the stored procedure [Core_Assessment].[RemoveInactiveIpAddresses].
       |Exception message = Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Who have any idea for solution problem ?


    • Edited by pabis Friday, April 5, 2013 12:45 PM
    Friday, April 5, 2013 12:37 PM

All replies

  • It looks like the timeout in MAP is expiring before SQL can finish processing all of the inactive IP addresses and removing them from the database. This will happen when there is a large number of IP address range specified and the CPU/Memory resources on the machine aren't powerful enough. You can follow the directions in this TechNet Wiki article to increase the timeout and/or migrate MAP and the database to a more powerful machine.

    MAP Toolkit Survival Guide: http://social.technet.microsoft.com/wiki/contents/articles/1640.microsoft-assessment-and-planning-toolkit.aspx



    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. Please VOTE as HELPFUL if the post helps you. This can be beneficial to other community members reading the thread.

    Friday, April 5, 2013 6:11 PM
  • thanks, I will try to check this idea. 
    Monday, April 8, 2013 7:08 AM