myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


.NET Framework error occurred during execution of user-defined routine or aggregate "xp_ClientHealth

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Vendor Forums] >> 1E Products >> .NET Framework error occurred during execution of user-defined routine or aggregate "xp_ClientHealth Page: [1]
Login
Message << Older Topic   Newer Topic >>
.NET Framework error occurred during execution of user-... - 11/18/2008 3:33:27 PM   
swood

 

Posts: 477
Score: 5
Joined: 12/6/2001
Status: offline 		Just noticed a slew of these in my SMS_COLLECTION_EVALUATOR logs. It appears that a string in a file may need to be fixed...

[42000][6522][Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "xp_ClientHealth":
System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Documents a


Please refer to your SMS documentation, SQL documentation, or the Microsoft Knowledge Base for further troubleshooting information.

I've tried break open the stored procedure but it looks to be locked.

Has anyone seen this before?

_____________________________

Sandy Wood
Network Admin
Orange County District Attorney
Post #: 1
RE: .NET Framework error occurred during execution of u... - 11/18/2008 3:50:46 PM   
ealdrich


Posts: 464
Score: 9
Joined: 6/1/2001
Status: offline 		Just got off the phone with Support... I'm concerned about the work done with you around 6th (in this space) and the custom work done then by Reto... Looks like maybe there's a pathing issue (see the ref to C:\Docs&Settings... in the log?)...

Unfortunately Reto is out of the office for the next two days, so having him follow up won't work for you this time... so, pls open a support case and the guys I just spoke to will have details ready as well for the person who picks this new case up for you in the morning (London time)...

_____________________________

Ed Aldrich | Solutions Engineer | 1E Inc
Mobile: (401) 924-2293
US/Canada Toll Free: (866) 592 4214
Ed.Aldrich@1e.com | www.1e.com
SMS MVP (2003-2007)
myITforum Advisory Council and Columnist
New England Area SMS User Group Facilitator

(in reply to swood)
Post #: 2
RE: .NET Framework error occurred during execution of u... - 11/18/2008 3:52:41 PM   
swood

 

Posts: 477
Score: 5
Joined: 12/6/2001
Status: offline 		Yes, I noticed that path oddity.....

I'll go ahead and submit a case with Support.

_____________________________

Sandy Wood
Network Admin
Orange County District Attorney

(in reply to ealdrich)
Post #: 3
RE: .NET Framework error occurred during execution of u... - 11/19/2008 3:44:28 AM   
regeter

 

Posts: 10
Score: 0
Joined: 10/26/2007
Status: offline 		Hi Sandy,

I don't think this is very serious issue. The Collections should still work, the Assembly is missing the path to the default log file.
You need to make sure that the path %ALLUSERSPROFILE%\Application Data\1E\WakeUpSvr exist on the SQL server if you want to have the logfile for the Computer Health Collections.
I am sorry that we missed this during our first case, it's mentioned in the script but I should have pointed it out.
Regards,
Reto

(in reply to swood)
Post #: 4
RE: .NET Framework error occurred during execution of u... - 11/19/2008 10:52:56 AM   
swood

 

Posts: 477
Score: 5
Joined: 12/6/2001
Status: offline 		Hello Reto,

I checked my SQL server and the WakeUpSvr folder was missing, only the old reference folder, SMSWakeUp50 folder was there. I went ahead and created the WakeUpSvr folder to enable the logfile creation.

In addition to this error message, I’ve noticed that although all my 1E Health collections are created, none of the WMI queries work. Further checking shows that none of the 1E views appear to be in the database. I’ve checked all the views for something like SMS_R_WAKEUP and it doesn’t appear that they are there. Do I need to somehow add them to my site server’s WMI store?

The SMS_COLLECTION_EVALUATOR log displays this for each 1E collection it tries to evaluate.


SMS Collection Evaluator failed to evalute some of the query rules for collection "Memory threshold exceeded" (DA000233).

Possible cause: Inventory or Resource classes referenced in the query do not exist at this site, resulting in a SQL error.
Solution: Review the immediately preceding status messages from this component about query rule failures. Enable the collection of the missing Inventory or Resource information at this site.

Possible cause: SQL Server problem.
Solution:
1. Review the immediately preceding status messages from this component about SQL Server errors.
2. Verify that this computer can reach the SQL Server computer.
3. Verify that SQL Server services are running.
4. Verify that SMS can access the SMS site database.
5. Verify that the SMS site database, transaction log, and tempdb are not full.
6. Verify that there are at least 50 SQL Server user connections, plus 5 for each SMS Administrator console.

If the problem persists, check the SQL Server error logs.

_____________________________

Sandy Wood
Network Admin
Orange County District Attorney

(in reply to regeter)
Post #: 5
Page:   [1]
All Forums >> [Vendor Forums] >> 1E Products >> .NET Framework error occurred during execution of user-defined routine or aggregate "xp_ClientHealth Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.469