Excel 2007 Certification Test
I wasn't an experienced Excel user before beginning this effort. I had qualified as an "Advanced Excel User" under the Skillport Test, but I never considered their test to be an accurate measure of my ability. (It overstated my prowess.)
This is my first experience in MS Certification and I cannot believe the vast difference between the between the 3 study aids that I've purchased (Skillport Tutorial, MS Excel 2007 Tutorial, and Measure Up Certification Practice Test) and the 2 Certification Tests that I've taken so far.
I am scoring in the 90% on all the practice tests but the highest I've scored on the Cert Test was 463--my very first attempt!
The second time I took it, after studying MS Tutorial and Measure up, I actually went DOWN to 415! Which is absurd. I KNOW that I knew more about the program the 2nd time than I did the 1st time. And MS summarily dismissed my request for a hand-grading of my test.
On the MS Excel Pre Tests, I've scored 500, 659,and 545, on 8/1, 8/11, and 8/28, respectively.
I was going to take the Cert Test again today but after failing the PreTest last night, I'm spending the weekend studying the MS Tutorials again, focussing on the sections that I did the worst in (i.e., all of them).
What has the experience of other newcomers to Excel been when they try to get Certified and what have been the most useful tutorials and/or study methods?
I can't even figure out which button to push in order to post this doggone thing!
Reply:
I approached my first certification having practice enough in the lab. To my utmost surprise, I failed! On going back to review some of the questions which I had passed few days ago in my prep material; I discovered that all conditions must be met in order to pass certifications. It is no wonder why some experienced IT people find it difficult to pass certifications.
Since you have already tried most of the textbook recommendations to passing your exam, I recommend you attend a Microsoft Classroom training. You'll be tought by Microsoft Certified Trainers who have sat and passed this exam. Furthermore, you'll also have an advantage in class knowing what to look for from your past experience. Try to seat your exam few days after your training and let me know how it goes.
Good luck.
John Opabola CCSE,CCSA,MCSE,MCTS,MCDBA,CCSA,BCS,CITP,DCSE,MLSE,Network+,A+
------------------------------------
Training Need for certification
If yes what the process.
Regards,
http:www.hytechpro.com
HyTech Professionals, a software engineering services company, delivers quality software development
Reply:
There are many ways to go about this; I recently completed a Microsoft Small Business Server 2003 training susidised by Microsoft. The full training cost over €480 but Microsoft has subsidised this at €195.
I have copied below websites that offer details required to get you started. Feel free to contact your nearest Microsoft office if you need further information.
http://www.microsoft.com/learning/community/default.mspx
http://www.microsoft.com/learning/mcp/default.mspx
All thebest in your training and certifications.
John Opabola CCSE,CCSA,MCSE,MCTS,MCDBA,CCSA,BCS,CITP,DCSE,MLSE,Network+,A+
------------------------------------
ListItem fields available
http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spbuiltinfieldid_members.aspx
foreach(SPListItem item in docoList.Items) {
string createdBy = item[SPBuiltInFieldId.Created_x0020_By].toString();
}
Recover manually from SQL Server 2008 installation failure
Hi there,
I have experienced a serious problem during the installation of SQL Server 2008 Enterprise Edition on 32-bit Vista, which left the installation in a faulty state, neither allowing repair nor uninstall. The cause of the problem was that I installed the software on my laptop from a ISO image located on a file share on my workstation. The workstation went offline (well, I accidentially restarted it.. 
MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{F3494AB6-6900-41C6-AF57-823626827ED8}'. Error code: 1605.
Here is my solution:
As reinstallation of the OS is not an option (I don't reinstall 30+ software packages plus setup my work environment because of SQL Server!), an all hardcore suggestions in the newsgroups didn't do the trick, I analyzed the registry keys on a successful installation, i.e. my workstation. The following I found out:
1. Installation Codes and Product Codes
SQL Server 2008 consists of about 30 products registered in the Registry. Each product has a product code (a GUID) as well as a installation package code (also a GUID). For example the product CommonFiles has the product code
2E43F6A45E9061642B72A4624A886A9F
and the installation code:
{4A6F34E2-09E5-4616-B227-4A26A488A6F9}
2. How to Find Out Product Codes
Well, either you ran the installation and take the installation code from the error message and look it up in the registry, correct just this error and re-run the installation. If you did it right, the installation will go past the error, either successfully or with a new error 1605 for a different installation code.
Note: The error message contains the installation code. The product code is not communicated to you.
The second option is to look for through the subkeys of
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\RefCount
and make a list of all mentioned installation codes and search for the corresponding product codes in the registry. Under
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18
\Products\productcode\InstallProperties
the string value ModifyPath contains the installation code.
3. Product Code Usage in Registry
The product code can be found in a number of locations (as key):
HKLM\SOFTWARE\Classes\Installer\Features
HKLM\SOFTWARE\Classes\Installer\Products
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products
The installation code can be found (as key):
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
Note: There is also a mentioning of the product code in HKLM\SOFTWARE\Classes\Installer\UpgradeCodes. Although, I do not know if copying of these is required for a successful installation. (I did copy them.)
Note: Furthermore, the product code is mentioned in
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Components
I did not copy these.
4. Export and Import Keys
I exported all these the keys from the healthy installation and imported the keys into the faulty installation.
5. Copy MSI Files
I also found out, I need to copy the C:\Windows\Installer\*.msi files mentioned in LocalPackage string values for each of the products. I assume that these files are created by the Windows Installer to start the appropriate installation package.
And voilà! the installation runs through smoothly.
I hope I didn't forget anything essential. Of ocurse, this is only a roadmap, and there should be a tool that corrects the faulty installation, but I couldn't find any.
This is quite dangerous work on system and the registry, you must have calm hands and fingers!
Bjorn
Outlook 2007 read receipt being sent without prompting user
Set up: have outlook configured to download only the header information for subscribed folders
Control case: send yourself a message that requests a read receipt. read the message. it will prompt you if you want to send the receipt or not.
Steps to reproduce 'bug': send yourself a message that requests a read receipt. refresh your inbox so that you see the new message, which should have an icon in the Header Status column indicating only the header has been downloaded, not the entire message. right click on the folder and mark all as read. now read the message, then read another message and read the one you sent to yourself again (you may ge it to happen with on the first read of the message requesting a receipt, but i had to read it twice). execute a send/receive... read receipt has been sent without the system asking you if you want to send it!
Symantec Endpoint Protection Malfuntioning
Sorry if I posted this in the wrong area, And I would like it to be moved if so...
Any ways, 
of BlueScreen. I wanted to virus scan it, but it won't let me... I dunno if it has to deal with me on safe mode with networking, or what.
Reply:
Hi Lucas, to troubleshoot BSOD crash issues, we need to debug the crashed system dump. Unfortunately, debugging is beyond what we can do in the forum. A suggestion would be to contact Microsoft Customer Service and Support (CSS) via telephone so that a dedicated Support Professional can assist with your request. Please be advised that contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a look at the web site listed below:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607
or
https://support.microsoft.com/oas/default.aspx?ln=en-us&prid=11273&gprid=522131
If you want to scan virus, I suggest you try a free online virus scan on the following site:
Meanwhile, if you need more help with virus-related issues, please contact Microsoft Product Support Services. For information about Security updates, visit the Microsoft Virus Solution and Security Center for resources and tools to keep your PC safe and healthy. If you are having issues with installing the update itself, visit Support for Microsoft Update for resources and tools to keep your PC updated with the latest updates.
- Edited by Sabrina Shen Friday, April 6, 2012 3:56 AM PCSafety Center update
------------------------------------
SharePoint and MS Office department name
So I was wondering if anyone out there is in a similar kind of department and would have a good name, or if anyone had any good ideas for a name in general.
Thanks for any ideas!
Reply:
A few ideas:
- Information Worker Solutions & Training
- Technology Enablement Group
- Information Services Group
That's all I can think of right now :)
------------------------------------
Reply:
------------------------------------
Microsoft Windows
The early versions of Windows were often thought of as just graphical user interfaces, mostly because they ran on top of MS-DOS and used it for file system services.
=============================================
SamCar auctions
Reply:
After checking the issue, it seems this is a general Windows system issue. As this forum focuses on Windows SteadyState specific issues, this inquiry would best be posted to Windows newsgroup:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.windowsxp.general
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.windows.vista.general
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the newsgroups regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
------------------------------------
Shutdown message
Hello,
I'm using Windows Vista Business with steadystate 2.5 and i use a program called down psshutdown.exe by sysinternals. It worked perfectly with shared tools kit on xp pro but i'm getting an issue. When i run the same script on the same named computer (gates15) for example it does do the shutdown timer and does work but i can't view the message that displays though. I get this:
http://www.mc-npl.org/capture.jpg
You can only see the image when you click "Show me the message"
But before i click it, its in the Task bar blinking interactive service and it is minimized.
Question is:
How can i get it to actualyl display the message? Which option needs to be disabled?
Reply:
bump!
------------------------------------
Reply:
Hi, does the issue occur on administrator account or users with all restrictions disabled?
------------------------------------
Reply:
Ok update:
I clicked the show me why this happens and i get this message that i took a screenshot of:
http://www.mc-npl.org/trouble/screenshot.jpg
So i been messign with this program and i tried to run it in compatibility mode for windows xp sp2 but that didn't help it. Anyone know how to force windows to ignore those issues and just run the program?
------------------------------------
Reply:
O ya and this happens under administrative account as well that is fully unlocked. This is a compatibility issue
------------------------------------
Reply:
------------------------------------
Reply:
bump last time!
------------------------------------
Reply:
Hi, if this issue occurs on both restricted or non-restricted accounts, we can consider this is not caused by Windows SteadyState. You can temporarily disable SteadyState or uninstall it to check whether the issue still occurs.
------------------------------------
Reply:
Is there any place i can check or ask about this problem? It is also caused by regular windows.... I would think it would be supported here since it was supported with the windows 2000 kit that came out years ago
------------------------------------
Reply:
More information:
Interactive services dialog can be turned on and off via services manager.
How can i configure this service to not include a specific program such as psshutdown.exe or enable it so it is on a list of approved programs for example and just shows up fully instead of using interactive services dialog
------------------------------------
Reply:
Hi viper0402, I suggest you post the issue to Windows Vista newsgroup as this seems to be not related to Windows SteadyState.
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.windows.vista.general
Hope this helps!
------------------------------------
Zune4 later this year!
Zune4 Coming This Christmas!
Specifications:
Weight: 3.5 ounces (88 grams)
Single core peryn processor
32 - 64 Gig Flash Drive
3.9-inch color display
Range: Up to 350 feet
JPEG, TIF, WMV, BMP, PNG, FLV
AM/FM/CB
Headphone jack / AV output
RGB / VGA / ZuneVid / HD
Bluetooth
Wifi
Music, up to 64 hours (wireless off); video, up to 9 hours
IE 8 Mobile Built in
25% larger screen
Runs VistaMobile
As you can see, the iPod and iPod Touch are dead!
I told you we were worth waiting for!
Reply:
------------------------------------
Link responses
Working from a company computer I don't follow links to locations I'm not familiar with so I never get a chance to see these solutions to problems that catch my interest.
Maybe it's just returning from a long weekend, but I get really irritated when I see that there is an answer to a problem I'm interested in only to find a response of : "Try this" with 'this' being a link outside of the forum.
If the answer is to involved to post here it would be nice for the responder to at least state something to the effect and then tell us that an in depth answer can be found at a specific url.
David M. Nichols contract software engineer
- Moved by Peter Ritchie Tuesday, September 2, 2008 5:47 PM feedback about the site (Moved from Visual C# General to Suggestions and Feedback for the Forums)
Reply:
I think you have to divide this into three.
a) Writing a short text outlining the solution and then giving a link.
b) Writing the link to an existing article / FAQ item.
c) Writing a new (blog) item and then in the forum/newsgroup giving a link to that blog item.
c) is the one of the three that I completely despise (and it does happen). Even if the blog item does contain the solution, it's clear that the sole reason for doing it this way is to get people to access your site.
b) is what I often do myself. I have a large (WSS) FAQ site and I'm often referring to something I added there years earlier and have no doubt in the past answered in a newsgroup in full more times than I can remember. I see nothing wrong in this situation (and given the usual time pressures) in providing virtually just a URL.
a) is what I use if I have more time and the feeling there aren't a hundred more questions waiting and wanting answers.
Of course in addition to these three I mostly provide answers as text in the reply.
So you should consider the motives of the people who do this before you issue a carte blanc condemnation. These days most forum and newsgroup posts are read by people who do have Internet access. Shall we repliers answer 10 questions instead of 100 questions so that we can cope with the few who don't have INet access. That is the choice.
------------------------------------
Reply:
Thanks,
-Andrew
------------------------------------
Reply:
If the answer were phrased along the lines of "This question is answered in detail by the following thread: post link here" I would not hesitate to follow the link.
If a link is a tinyurl I will never follow it and if it goes to a location outside of msdn that I'm not familiar with I hesitate to follow that as well. I'm a dedicated paranoid when it comes to protecting my computer.
I guess I just take issue with responses that come across as nothing more than an abrupt brush-off. If I don't have the time or the inclination to answer a question I simply pass it by.
I think we are pretty much on the same page and having seen your name throughout the forums I would be inclined to follow a link provided in one of your responses.
David M. Nichols contract software engineer
------------------------------------
Forum broken?
Clicking on the "Windows Home Server" bread crumb on the Windows Home Server Software forum page goes to a blank "Forum Categories" page.
Reply:
"Where is the forum for..."
A forum to get advice on where the best place is to ask a question. NO TECHNICAL QUESTIONS WILL BE ANSWERED IN THIS FORUM.
http://forums.technet.microsoft.com/en-US/whatforum/threads/
John
------------------------------------
SQL 2008 Actual Execution Plan Output has something new
The Actual Execution plan output now has a comment in Green that shows the Missing Index impact . I think this information will really help us DBA's to quickly debug performance issues.
Thanks
Shilpi
Document Library: Incoming E Mails
Could someone kindly explain to me how the 'incoming e mails' for document libraries operate?
When you enable this service, does a temp exchange account get created on an exchange server?
What course of direction does the mail take, as soon as it leaves my sent items?
Thaks again
RockKnow
SharePoint Novice
Reply:
when you enable the incoming mail for DL (after get the Active Directory ready... and install an SMTP server on MOSS Farm), the workflow is this:
1) User Send a Mail to library listed in AD
2) Exchange recieve mail and store it
3) Moss start a sort of trigger and import the e-mail in library
for more information look at this:
http://www.combined-knowledge.com/Downloads/How%20to%20configure%20Email%20Enabled%20Lists%20in%20Moss2007%20RTM%20using%20Exchange%202003.pdf
Regards,
Francesco
www.sharepointinside.it
------------------------------------
Reply:
The flow is.
You send an email to SharePoint via any email client.
the email then gets routed to the IIS SMTP server on one of you Frontend servers and is stored in the DROP folder.
Sharepoint timer job runs every minute cheking the drop folder.
Sharepoint picks up the email and distributes it to the appropriate doc lib.
Exchange has nothing to do in this process. You don't even need Exchange.
Robert Stark MCTS - MOSS 2007 MCTS - WSS 3.0 ---www.thesharepointranch.com --- cas.excell.com
------------------------------------
Recreating user accounts with new SIDs on Win2008 may persist any legacy data in offline cache and prevent those accounts from doing redirected folders
The offline cache on some Vistas failed when i recreated some user accounts on Win2008 with the same logon name as previously (not same sid). Those users got access denied and was not able to create a redirected folder on the share untill the offline cache had been reinitialzed on their Vistas.
- Changed type David Shen Wednesday, September 3, 2008 6:12 AM comment
- Changed type David Shen Wednesday, September 3, 2008 6:12 AM comment
Reply:
Thank you very much for the information shared. As this is not a post for answer, we will change this issue type from "Question" to "General Discussion". It will help other community members to find your knowledge sharing easier.
If I misunderstood your concern, please feel free to change the type back to "Question". Thanks!
David Shen - MSFT
------------------------------------
"There was an error processing the request." (EW2 Forum)
This has been the response for the last two days whenever the Submit button is clicked. Not intermittently, but consistently replicable. It happens after first logging in; it happens later, it happens all the time.
After some experimentation I determined that ignoring the error message and returning to the forum one often (not always) finds that the reply was posted after all. (Which means that I still have to make a copy of the reply I spent 10-12 minutes composing before doing so, just in case.) However, our less experienced users don't know this, and we end up with six copies of the same reply, as they futilely click the Submit button repeatedly. This is pretty damned basic forum functionality. Think maybe someone could address this issue?
On another issue, for some reason, for the last two weeks, my Profile brings up a page in what appears to be Brazilian Portuguese. I am neither Brazilian nor Portuguese, and have never set my profile to indicate such. Nor, upon looking, could I find anywhere to change a setting in my profile to correct this. Anyone know how this might have happened? How about a direction as to where to look to correct the setting so that my profile is in American English? (NOTE: My Locations in my Windows Live profile "registered information" are already set to United States. Couldn't find a setting for language, though.)
[EDIT] OK, belay that last. I found the answer to the second issue above in this thread http://forums.expression.microsoft.com/en-US/reportabug/thread/d298d9a6-8934-4e8e-baa4-fcf4138484a1. Dunno why I had never seen those upper-right dropdowns as being such, but now I know how to fix the issue, and according to the referenced post, the issue of how it gets changed will be bugged.
cheers,
scott
- Edited by paladyn Sunday, August 24, 2008 7:16 PM ....
Reply:
------------------------------------
Reply:
I get the "There was an error processing the request" message _every_ time when I submit a post. This bug needs to be fixed ASAP. Anybody listening?
I can think of few elements of a forum's interface more critical to its operation than the ability to submit a reply without error. Seems the devs have a different sense of priorities.
cheers,
scott
------------------------------------
Reply:
1) One of my machines just sits there when I click submit... Now, I know this machine has cookie issues, and so it's likely related, but I haven't killed the cookies yet.
2) My other machine posts just fine. Everything is smooth.
3) Other people internally have tried the forums at different points and found everything runnig smoothly.
4) I'm not trying to be a smart alec, but it seems not to be erroring EVERY time for you, otherwise you wouldn't have gotten these posts up. Or are you getting errors, but the posts go thru anyways?
Thanks
Matt
Matt Fraser, STO Forums Software Developer
------------------------------------
Reply:
It sure is annoying, cleaning up all those duplicate posts and threads is punishingly boring work for a moderator. Not that I bother anymore. But yeah, that's core functionality that's broken. Giving us cookies that last for two weeks, like they used to, would be a fantastic workaround.
Hans Passant.
------------------------------------
Reply:
One of my machines is XP SP3, the other one is Vista SP1. I receive this "There was an error processing the request" message almost every time on _both_ machines. Despite the message, the post is accepted anyway; I have never lost a post. If I click the "Submit" button again because of the error message, my post is transmitted twice.
There are plenty of such duplicate posts, so it seems that many users experience this problem.
------------------------------------
Reply:
Hans Passant.
------------------------------------
Reply:
Does the error case happen on New Thread as well or just Reply? The main cases where a Thread/Message could go through but report an error are Alerts Subscription and Tagging. With a new thread it errors out on that, we'll redirect you to the new thread and give a little more specificity about the failure.
Christoph, could you try a new thread in Sanbox or somewhere and see if you get an error there as well?
Rob J, Forums Dev
------------------------------------
Reply:
So, here is my experience.
1) One of my machines just sits there when I click submit... Now, I know this machine has cookie issues, and so it's likely related, but I haven't killed the cookies yet.
2) My other machine posts just fine. Everything is smooth.
3) Other people internally have tried the forums at different points and found everything runnig smoothly.
4) I'm not trying to be a smart alec, but it seems not to be erroring EVERY time for you, otherwise you wouldn't have gotten these posts up. Or are you getting errors, but the posts go thru anyways?
Thanks
Matt
Matt Fraser, STO Forums Software Developer
Both of my machines, both XP SP2, one a desktop and the other a laptop, consistently exhibit this symptom. No other site has similar issues, nor any issues whatsoever that I have encountered.
"Other people internally," as you know, may not see the same issues as those accessing the forum from outside your ninedot, or tendot, or whatever unroutable internal domain you use.
Actually, I got those posts up in spite of the failure, not because it does not occur consistently. It only took a short while for me to realize that the messages usually did post, although I was left staring at an error message which said that it had not. And left staring at that error message, and my purportedly failed post, forever, unless I either clicked Back or the forum breadcrumb at the top of the page (my usual practice, since it takes 20-45 seconds or longer for the forum message list to update if I use the Back button, which is yet another issue).
Although the post usually actually gets posted, that is not universally the case. I have, therefore, gotten into the habit of automatically hitting Ctrl-A, Ctrl-C to copy my reply before returning to the forum. On several occasions I have been glad that I did so when I got back to the forum and discovered that the detailed response I had spent 10-15 minutes composing didn't survive the transition.
I see no small amount of irony in the fact that this issue does not seem to plague this forum at all, or at least I have never encountered it here. (This would, I should note, seem to argue against it being a cookie issue.) It occurs on a regular basis in the EW forum, and we are daily blessed with wading through dozens of duplicated posts from those who have not yet become aware of the "trick." You may only hear from we vociferous few, but that does not mean that the forum is not seriously, consistently broken.
cheers,
scott
------------------------------------
SQL Server 2008 Release Candidate 0
Brief Description
http://www.microsoft.com/downloads/details.aspx?FamilyId=35F53843-03F7-4ED5-8142-24A4C024CA05&displaylang=en
Reply:
Does this support TFS? If so, I can't see it. I only see connectivity to VSS.
Thanks,
Sebastien.
------------------------------------
Reply:
If you mean the Team Foundation Server, for SQL 2008 RC or CTPs, I think no, because they are not released versions.
For SQL 2008 RTM, TFS has sp1 here which supporting SQL 2008 as the document here:
Visual Studio 2008 Team Foundation Server Service Pack 1:
also another page may be helpful for you:
Hope this answers.
Dannol
------------------------------------
Installing Windows 2000 from usb stick (bios doesn't support booting from usb)
I have made a boot floppy containing these files:
- AUTOEXEC.BAT
- boot.ini
- CONFIG.SYS
- IO.SYS
- MSDOS.SYS
- NTDETECT.COM
- ntldr
- USBD.SYS
- USBEHCI.SYS
- USBHUB.SYS
- USBPORT.SYS
- USBSTOR.SYS
Configuration Manager 2007 management pack has been released
Configuration Manager 2007 can now be monitored with Operations Manager 2007, Microsoft released the management pack last week.
Below a list of some items that are monitored:
• Monitoring the starting and stopping of all Configuration Manager 2007 services, including critical dependent services like Windows Management Instrumentation (WMI), IIS Admin Service, World Wide Web Publishing Service, Windows Deployment Services Server, Trivial FTP Daemon, Background Intelligent Transfer Service (BITS) and Microsoft SQL Server™.
• Alerting the Configuration Manager 2007 administrator to critical Configuration Manager 2007 status messages.
• Monitoring backlogs of discovery data records (DDRs), software inventory, hardware inventory, status messages, state messages, and software metering on both primary site servers and management points.
• Monitoring outbox backlogs on site systems.
• Monitoring a component and site system role health.
• Monitoring collection evaluation, state message summarization, and site maintenance tasks, including site backup.
• Monitoring SMS Executive crash dumps.
• Monitoring general CPU, Memory, and Disk system resource usage. • Monitoring processing rates.
• Monitoring the performance trends of many Configuration Manager performance counters by using views and reports.
• Product knowledge content for all alerts and processing rules.
• Detecting all Configuration Manager 2007 computers, classes, and computer groups.
• Configuration Manager 2007 views.
• Reports displaying performance, availability, and configuration of Configuration Manager 2007 server groups. These linked reports leverage the enhanced reporting of Systems Center Operations Manager 2007 for performance, configuration, and availability trends.
• Tasks for executing Configuration Manager 2007 Administrator console applications.
• Computer State view containing the health of all Configuration Manager 2007 server roles and the Configuration Manager 2007 Client.
• Site Hierarchy and Site State views for displaying the health of sites in a hierarchy and the hierarchy itself.
• Service Discovery of important Configuration Manager 2007 server and Configuration Manager 2007 client information.
• Topology diagram of the Configuration Manager 2007 site hierarchy.
• Configuration Manager 2007 configurable alerting on distributed program execution failure through Configuration Manager 2007 program properties.
You can download the management pack here
Regards,
Jannes Alink
Reply:
------------------------------------
Reply:
------------------------------------
Reply:
I checked, and there are no plans for an updated management pack for SP1 or R2.
------------------------------------
8002 : An unexpected error has occurred. [and wrong content-type, too]
got this message while playing with BLOB stuff via REST today:
| <s:Error xmlns:s="http://schemas.microsoft.com/sitka/2008/03/"> |
| <s:Code>8002</s:Code> |
| <s:Message>An unexpected error has occurred. Please contact Technical Support with the request and request data.</s:Message> |
| </s:Error> |
here's my story:
- i uploaded (several) PNG files (using code similar to the that supplied in SSDS Primer).
- I then opened my browser and (after authenticating) viewed the files just fine.
- I then deleted the file my browser was viewing (using the Provision Client, FWIW)
- I then refreshed the browser (to see the 404 appear [grin])
- Instead I got an XML reply with the text above.
Ok, so that was kinda pathalogical, but I was testing...
- So, I then *refreshed* my browser a second time and got the following XML:
| <s:Error xmlns:s="http://schemas.microsoft.com/sitka/2008/03/"> |
| <s:Code>1001</s:Code> |
| <s:Message>Entity 'messages' cannot be found.</s:Message> |
| </s:Error> |
This last message makes more sense. I suspect my delete was 'still in flight' when I made the first refresh and something bonked the SSDS server for a sec. Not a big deal, but I'm passing it on.
Here's my final observation:
I expected to get a 404 from the server when the file does not exist. my sniff of the conversation shows I get the 404, but....
| HTTP/1.x 404 Entity 'messages' cannot be found. |
| Transfer-Encoding: chunked |
| Content-Type: application/x-ssds+xml |
| Vary: Accept |
| x-msft-request-id: e97b2c7a-b3a8-4daa-b6e5-2a994248ea68 |
| $MsftRequestUri: http://binaries.data.beta.mssds.com/v1/test1/messages |
| Date: Tue, 19 Aug 2008 03:04:49 GMT |
I *also* get a change of content-type. I asked for "image/png" and got "application/x-ssds+xml" in return. In the case of REST requests, I think it's important to *not* change the content-type or at least select a content-type that will not pop the "download" dialog for browsers (content-type:text/plain would work).
Mike Amundsen [http://amundsen.com/blog/]
Reply:
I've managed to provoke a 500 (Internal Server Error) by hammering the Service with concurrent requests which queried and deleted. So it looks like it should be possible to track this down. I created 500 BLOBs and then let this code rip on it:
| public void TestConcurrency() |
| { |
| XDocument xd = XDocument.Parse(TestRestQuery("")); |
| XNamespace sitkaNamespace = "http://schemas.microsoft.com/sitka/2008/03/"; |
| var q = (from |
| xe in xd.Root.Elements() |
| where |
| xe.Name.LocalName == "Entity" |
| select |
| new |
| { |
| Id = (String)( |
| from |
| xi in xe.Elements() |
| where |
| xi.Name.Namespace == sitkaNamespace |
| && xi.Name.LocalName == "Id" |
| select xi).FirstOrDefault() |
| }); |
| Parallel.ForEach(q, e => |
| { |
| Parallel.Invoke(() => TestRestEntityRetrieve(e.Id), |
| () => TestDelete(e.Id), |
| () => TestDelete(e.Id)); |
| }); |
| } |
--
Dan
------------------------------------
Reply:
yeah, that would do it<g>.
funny thing is that i was able to get the 500 a couple times with just POST|DELETE|GET right in a row. *usually* i got 404 on the last step, but more than once, i was able to cause the 500 (8002 in SSDS error codes).
not a show-stopper, but worth pointing out.
Mike Amundsen [http://amundsen.com/blog/]
------------------------------------
Reply:
I am looking into this. SSDS doens't have the concept of "InFlight Deletes" or inflight anything. When we return to you, the operation has been complete. Does the phrase immediate consistency ring a bell :)
This might be a bug. I am trying to repro.
-Dave
------------------------------------
Reply:
I am looking into your issue as well. I'll keep you posted if I find anything.
-Dave
------------------------------------
Reply:
let me know if you need me to try to repro anything.
thanks.
Mike Amundsen [http://amundsen.com/blog/]
------------------------------------
Reply:
It was pretty straight forward I created 500 Blob entites of ~22Kb each (a png, but probably not relevant), and then ran that parallel foreach over them, which has concurrent attempts to query and delete the same entity.
Unfortunately I'm off on vacation (till September) so won't be able to offer much help till then :-(
--
Dan
------------------------------------
Reply:
I posted a test app to feedback which duplicates the issue for me, feedback id is 365659.
It's pretty simple, it creates 500 records, queries them, and then attempts to query and delete them in parallel:
| XDocument xd = XDocument.Parse(TestRestQuery("")); |
| XNamespace sitkaNamespace = "http://schemas.microsoft.com/sitka/2008/03/"; |
| var q = (from |
| xe in xd.Root.Elements() |
| where |
| xe.Name.LocalName == "Picture" |
| select |
| new |
| { |
| Id = (String)( |
| from |
| xi in xe.Elements() |
| where |
| xi.Name.Namespace == sitkaNamespace |
| && xi.Name.LocalName == "Id" |
| select xi).FirstOrDefault() |
| }); |
| Parallel.ForEach(q, e => |
| { |
| Parallel.Invoke( () => TestRestEntityRetrieve(e.Id), |
| () => TestDelete(e.Id), |
| () => TestDelete(e.Id)); |
| }); |
------------------------------------
No comments:
Post a Comment