SharePoint Portal Server 2003 SPS – Exception from HRESULT: 0x80041050

Oct 6, 2015 1:38 PM, - Posted by Tommy Segoro

INTRODUCTION

One Monday morning suddenly my client’s old SPS 2003 site no longer worked. It gave the error:

Exception from HRESULT: 0x80041050

The interesting thing is, some sub-sites are working fine. Trying to access the Site Settings and they’re fine too. So originally I thought that there must be something related to that particular page.

Intrigued, as I also thought that it was environmental related, I then restored the content database to SP 2007 environment. But same thing happened in 2007.

RESOLUTION

Came to find out that somehow 3 pages of the whole site (which happened to be the 3 most accessed pages by user) have been declared as containing virus. To check, run the following SQL query in SQL Server:

SELECT * FROM Docs WHERE
(VirusStatus > 0) and (VirusStatus is not null)

If it returns any results then those pages in the results will not be accessible by users.

To fix, run the following SQL Query:

UPDATE Docs SET VirusStatus = null WHERE
(VirusStatus > 0) and (VirusStatus is not null)

NOTE: For SharePoint 2007 the table is now called AllDocs instead of Docs.

And voila…site now comes back up.

Guerciotti Eureka SHM50 Team CCC Polsat Replica Review

Sep 27, 2015 3:15 PM, - Posted by Tommy Segoro

UPDATES

The Ursus Miura wheels have now arrived. So please click on this link for the review of the bike with the Miura wheels.

INTRODUCTION

I was riding Trek Madone 7 for about a year and a bit and was looking to get a new bike. Speaking to some people in the forums, there is actually not much difference between top-level frames from any brand. It all comes down to geometry and legs. Therefore, I wasn’t looking to spend crazy money anymore on the new bike. My criteria was:
– $5-6k max;
– Top level groupset specifically SRAM Red or Dura-Ace 9000 Mechanical;
– Mid-depth wheels 35-40mm max;
– Top-level frameset.

I’ve been looking around at the popular brands like Cannondale, Specialized, Pinarello, etc and unfortunately, with the combinations above, these brands are way outside of my price range. Either you get cheapo wheels with top-of-the-range (TOTR) groupset or you get mid-level frame with mid-level groupset and wheels. I have also been contemplating to get second hands but I realise that it’s not me. Throughout my past experience in buying/selling items (not just bikes) that I’ve never been happy with settling for second hands.

So my journey continued. As the saying goes, good things come to those who are patient. So I then somehow stumbled upon this brand: Guerciotti Eureka SHM50 offered by Bike Force Docklands. It’s supposed to be a $9k+ bike and they had a 1/2 price promotion running. Brand new, top-of-the-range frameset used by Team CCC Polsat, Dura-Ace 9000 Mechanical with Ursus Miura carbon wheels all for $5,500. Plus, it’s orange colour which corresponds to my business’ corporate branding (and if you notice, my Trek is also orange/black themed).

My eyes were caught to the advertisement and it get me started on my research. Unfortunately, there is somehow not much reviews on the brand let alone the Eureka SHM50 model. Lucky I already had the discussion with the people in the forums prior that all top-level frames – given we have the legs and good geometry fit – will help me producing a great performance. So long story short, I took the risk and made my purchase.

As per writing of this blog article, I have owned the bike for about 2 weeks now and have had a chance to take it to a long hill ride of 172km with 2243m elevation. This is my long review of the bike which hopefully adds a bit more information about the brand/model.

PS: I’m also preparing for Tasmania Cradle Mountain Peaks Challenge that happens in a month time at 1st of November and I’ll be using the bike for it.

PURCHASING EXPERIENCE

This is the first time for me to purchase my bike over-East. Normally I would buy from a local bike shop. I dealt with Mel (the manager) from Bike Force Docklands and have had a pleasurable experience. She and her team replied to all of my emails promptly. One of the people I dealt with initially Reuben resigned half-way and Mel took it over immediately. She replied to my emails and questions very promptly.

There were shipment delays from Italy of the clincher wheels that were supposed to come with the bike and Mel communicated it well to me. I also requested a cut-out saddle instead (which was not the saddle that came with the bike) and Mel was happily switching it over for me.

When the bike arrived in Perth, one of the bar-tape caps went missing. I contacted Mel and she sent a couple of new ones over.

The bike build was also perfect. All cables were cut neatly and most importantly there has never been any miss-shifts or anything like that since the day the bike arrived.

Overall, I’m very happy with the experience of dealing with Bike Force Docklands and would definitely recommend them to my friends.

BIKE SETUP

– Frame: Guerciotti Eureka SHM50 with Team CCC Polsat colour
– Wheels: Campagnolo Shamal Ultra G3 – yes, I haven’t received the Miura wheels yet so I’m using the wheels that I put on my Trek Madone. This should hopefully give an as-close-to-apple-to-apple comparison with the Madone.
– Stem: 100mm Deda not sure which model
– Groupset: Dura-Ace Mechanical 9000 with Ultegra brakes instead of the Tektro
– Handlebar: Deda 42cm not sure which model
– Crankset: Dura-Ace with Rotor Q-Ring QXL chainrings 34/50
– Cassette: Dura Ace 9000 11-28
– Pedal: Crank Brothers Candy 2
– Tires: Michellin Pro 4 Endurance 23mm
– Total weight including rear and front lights and pedals: 7.5kg

RIDER PROFILE

– Gender: Male
– Height: 170cm
– Weight: 74.5kg
– Never race, currently preparing for Tasmania Cradle Mountain Peaks Challenge
– FTP: 220watts according to indoor trainer
– Commuting daily to work ~40km/day + long hill ride on Saturday or Sunday
– Total weekly distance: 200-350km

FIRST RIDE REVIEW

My first ride of the bike was commuting to work. And oh man, this bike is very stiff. I would say that this feels stiffer than my Madone. What I like about it also is the geometry which fits me a lot better. My position is a lot more aggressive than the Madone. I like the straight horizontal top-tube on the Eureka compared to the Madone that tilts up a bit more.

Am I faster? Absolutely not especially the rider hasn’t increased in power; but what the Eureka gives me is the ability for me to push more and provide more power to the crank. Spinning on the flat at 90-100rpm feels a lot easier than my Madone. Could this also be caused by the Rotor QXL chainrings? My Madone runs on SRAM Red round chainring. On my Madone, even though it has been dialed using the exact same Retul Fit measurement, I feel that riding quality isn’t as good.

Climbing and standing on the bike feels a lot better than my Madone. The Eureka feels “thinner” than the Madone. This is amplified especially during climbing and standing. With the Madone it feels a bit bulky. My Madone however is lighter than the Eureka. Madone’s build (including Speedplay Frog titanium pedals) is about 6.7kg. Seems like not much but during the climb I can definitely feel the difference.

The Eureka I notice puts the weight distribution more at the back while the Madone is more centered. So when climbing it may feel a little bit slow on the Eureka; and the heavier weight doesn’t help either. The Madone however feels bulkier so it can feel a bit sluggish, too. Therefore, in terms of climbing quality I still prefer the Eureka than the Madone.

Talking about comfort, Madone is indeed more comfortable than the Eureka. If Madone is 7/10 in terms of comfort, I will say the Eureka is 4-5/10. The Eureka is very efficient machine with no giveaway of comfort whatsoever. If you’re riding on chip-sealed road you will feel every bit of the vibration going through your arm. But on the positive side, the Eureka feels stiffer than the Madone hence giving you the sensation of wanting to give more power to the crank.

Most importantly for me, if you have read my review on Madone 7 on this article here, the Eureka frameset somehow is not much affected by the wind as the Madone! I can ride hands-free no problem while the Madone it’s just not possible. On the Madone, if you’re riding with one arm, you can feel the frame somehow is buffeted by the crosswind.

So in conclusion of my first ride impression on the Eureka, for a good all-rounder the Eureka is still the winner. Please keep reading if you’re interested in the long hill ride experience on the Eureka compared to the Madone.

LONG HILL RIDE REVIEW

So I have now taken both the Eureka and the Madone on the exact same routes:

– Madone – https://www.strava.com/activities/343521903
– Eureka – https://www.strava.com/activities/400260709

Both rides were done using the exact same wheels: Campagnolo Shamal.

Now, before I continue on, please be aware that I’m reviewing solely on the bike and not on the performance. On the Madone I was riding with a friend who was not as strong so I had to wait for him for a lot longer. Therefore, performance may be slow.

With the Eureka, I went for the ride on my own so I could stop and keep going as I liked without waiting for anyone. Therefore, performance may show that I was a lot faster.

The longer I ride the Eureka, the more I fall in love with it. I would say that this bike will stay in my stable for a long period of time. The geometry fits me the best. I’ve had various top-of-the-range bikes from S-Works TArmac, S-Works Roubaix, Giant TCR Advanced, Merida Reacto 909, etc and none of them fit me best like the Eureka. On the Eureka, I started to get sore neck and shoulder at the 8th hour of the ride while on the Madone from the 4th hour I started feeling it. You may say that if the bike is fit properly I wouldn’t get any sore neck. Trust me, I’ve done Retul Fit and both are dialed to my measurements. It’s me who is not flexible. However, on the Eureka at least I don’t suffer as early as the Madone.

Both rides took at least 8 hours to complete. With the Madone it took a bit longer due to me waiting for me friend. Yeah, the whole ride was about 1 hour and 18 minutes in difference. But if you look at the heart rate and power output, it was about the same.

My initial review on the Eureka remains. The bike is not as comfortable as the Madone. The route I did was 90% chip-sealed road so the vibration was more amplified on the Eureka. However, as mentioned earlier, with the Eureka I was able to put down more power. And for the same route I was faster on the Eureka simply because the bike geometry and my body positioning allows me to put down more power. I truly felt it on the day that I must have got some PRs along the way simply because I felt faster compare to my Madone.

I haven’t mentioned anything on descending. I have to say the Madone feels more stable on the descend compared to Eureka. And if I freewheel on both, the Madone would have been faster. I’m sure of it. The Eureka however, allows me to put down more power on the crank. I don’t know if it’s the chainring but on Madone I spent more time freewheeling while on the Eureka I wanted to just keep spinning and spinning. As you can see on both rides, I was faster on the descend purely because of this reason. My legs just wanted to spin more on the Eureka. I truly give credit to the geometry of the bike.

Climbing especially on a long one feels slower and slightly heavier on the Eureka. But the bike feels “thinner” than the Madone so if you’re standing a lot (which I am) it actually feels better. Am I any faster? Well, if you look at the stats I was indeed faster on my Eureka. But this could be because I was waiting for my friend while I was riding on my Madone. I should give Madone a go on a solo ride with the exact same route to really know the performance difference. In the meantime however, I can say that Madone feels lighter but bulkier on climbs while the Eureka is the other way around. My point is, I don’t feel that riding Eureka decreases my climbing performance.

CONCLUSION

As a conclusion, for an all-rounder bike, I still prefer the Eureka compared to the Madone. The main thing for me is how I can put down more power – hence I can be faster – on the Eureka compared to the Madone. Yes the Eureka may not be the lightest bike around, but the performance gain you’re getting is way more than the Madone. And as I mentioned earlier, this bike will most likely stay in my stable for a long time. My long-time search for “The One” has kind of stopped here.

PS: I can’t wait to ride it with the Ursus wheels and see if they will increase the performance.

PHOTOS

MSCRMMonitoringRuntime and MSCRMKeyGenerator Issue

Feb 19, 2015 12:06 PM, - Posted by Tommy Segoro

INTRODUCTION

A CRM 2013 application has been running for more than a year and out of nowhere user can’t get into CRM from the browser.

Then upon checking the Event Viewer, they’re getting the following every 1-5 minutes:

==

The current active key (KeyType : CrmWRPCTokenKey) is expired.  This may indicate that a key is not being regenerated correctly.  Current Active Key : CrmKey(Id:c9643987-c39a-e411-80d6-005056ba6cbc, ScaleGroupId:00000000-0000-0000-0000-000000000000, KeyType:CrmWRPCTokenKey, Expired:True, ValidOn:01/13/2015 01:28:52, ExpiresOn:02/15/2015 01:28:52, CreatedOn:01/13/2015 01:28:52, CreatedBy:DOMAIN\PRODASYNC.  Key Setting : CrmKeySetting(Id:a25534e8-f95d-4885-9b90-91894176bba3, KeyType:CrmWRPCTokenKey, KeyLength:128, KeyGenerationInterval:720, KeyTimeToLive:792, CryptoTimeToLive:72, Algorithm:HMACSHA256, ArchiveLength:1, Enabled:True, ActiveKeys:[ScaleGroupId=00000000-0000-0000-0000-000000000000,ActiveKeyId=c9743987-c39a-e411-80d6-005056ba6cbc])

==

Monitoring runtime failed: Machine: CRM2013VM: Exception: The type initializer for ‘Microsoft.Crm.Monitoring.Engine.MonitoringRuntime’ threw an exception.
   at Microsoft.Crm.Monitoring.Engine.MonitoringRuntime.RetrieveServerRolesForMachine(String machineName)
   at Microsoft.Crm.Monitoring.Engine.MonitoringRuntime..ctor(TestFrequency testFrequency)

InnerException Type:System.TypeInitializationException
The type initializer for ‘Microsoft.Crm.Monitoring.MonitoringSettings’ threw an exception.
   at Microsoft.Crm.Monitoring.MonitoringSettings.get_MaxExecuteTestAttempts()
   at Microsoft.Crm.Monitoring.ResultTracker..ctor()
   at Microsoft.Crm.Monitoring.Engine.MonitoringRuntime..cctor()

InnerException Type:System.TypeInitializationException
Login failed for user ‘DOMAIN\ProdMonitoring’.
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
   at Microsoft.Crm.CrmDbConnection.Open()
   at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
   at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache()
   at Microsoft.Crm.SharedDatabase.DatabaseService.Initialize(String tableName)
   at Microsoft.Crm.SharedDatabase.DatabaseService.RetrieveInternal(String tableName, String[] columns, PropertyBag[] conditions, Nullable`1 top, IList`1 orderBy, IDictionary collectionToFill)
   at Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
   at Microsoft.Crm.ServerLocatorService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
   at Microsoft.Crm.Monitoring.MonitoringSettings..cctor()

InnerException Type:System.Data.SqlClient.SqlException
.

==

RESOLUTION

I checked with the ICT Team to ensure that passwords for service accounts didn’t change nor they expire nor locked. Everything looked green from their side.

So what I did to resolve the issue was the following:

– Restart Microsoft Dynamics CRM Asynchronous Processing Service

– Restart Microsoft Dynamics CRM Asynchronous Processing Service (maintenance)

– Open command prompt and run the following:
C:\Program Files\Microsoft Dynamics CRM\tools\Microsoft.Crm.Tools.WRPCKeyRenewal.exe /R

– Restart Microsoft Dynamics CRM Monitoring Service

– IISRESET

And done. I no longer get any errors in Event Viewer and users can now access CRM again.

Hope this helps,

Tommy

Shimano Dura-Ace 9000 C24 Clincher Wheelset Review

Dec 23, 2014 4:43 PM, - Posted by Tommy Segoro

INTRODUCTION

Because of one reason and another I have now sold my Enve 3.4. Click here for its review. The Enve to date (prior me purchasing the C24) has been the best wheelset I’ve ever tried. It’s nimble, stiff and “invisible” ie. It feels slow but when you check your speed, you’re actually going faster than you think you are. I replaced my Enve with the Shimano Dura-Ace 9000 C24 clincher wheelset and saved the remaining cash. I have now owned the C24 for about 2 weeks (to the date of writing this article) and last Saturday I took them to a long hill ride. The ride was supposed to be 170km with 2200m of climbing but my legs were no longer responsive near the end so unfortunately, I had to end the ride early at 150km and 1900m of climbing. It had nothing to do with the wheels but all to do with my fitness. But anyway, without further ado, let me summarise the C24. I will then explain the details later.

The Strava link to the ride is here.

RIDER PROFILE

Height: 170cm
Riding type: Commuting daily, weekend short or long hill rides. Never race.
Riding frequency: Commuting 40km 5 days a week. Short hill (~80km) or long hill (~130-150km) on either Saturday or Sunday.
Weight: 70-73.5kg (depending on season).
Strength: 200watt @ 160bpm.
Starting cycling: October 2010.
Bike: Trek Madone 7 2014 53.5cm top-tube.
Total bike weight (with bottle cages and pedals): 6.6kg

QUICK SUMMARY

What I like the most from the C24 is its stiffness and low spokes count. The fact that it’s only 24mm depth, it’s very-very minimally affected at all by crosswind (which is very important during descend). Whether you stand or seated during climbs, the wheels don’t flex at all. Every pedal stroke moves you forward (or should I say: upward during climbs). The low spokes count allow the wheels to roll better in crosswind. The Enve has more spokes and a little bit harder to roll on strong crosswind. Here in Perth you are facing 15-37kmh crosswind almost everyday. In a nutshell, for Perth condition the C24 is probably the best wheelset I’ve ever owned.

DETAILED REVIEW

Price
Price of C24 is excellent. For value you simply can’t beat this wheelset. I bought it of Pro Bike Kit with extra 10% discount voucher that was sent to my mailbox! In the end I paid AUD$797 for the wheelset while other websites list the wheelset for AUD$900+. Even Wiggle was listing the wheelset at $850 and they were out of stock on the day I bought them.

Also, with Pro Bike Kit any purchase you make above $330 qualifies you for a FREE tracked shipping package which has been great. I could check my parcel delivery status everyday. Item was shipped in less than 12 hours from the time I ordered and delivery time took about 2 weeks. They shipped my C24 from Belgium. Please note that even though they have an Australian website, their merchant service is still overseas (same as Wiggle and Cycling Express) meaning that if you pay using your credit card, there can be a 3% surcharge. I suggest you apply for credit card that has free overseas purchase surcharge such as 28 Degrees.

Stiffness
The C24 is definitely stiff. I felt that it is as stiff as the Enve during both climbs and sprinting. Whether you are standing or seated, the wheels definitely deliver. They push you forward (and upward).

Rolling
The Dura-Ace hub just rolls forever. There is no feeling of resistance whatsoever. Comparing this to the Enve’s Chris King R45 however I need to say that the Chris King rolls (and sounds) better. The Dura-Ace is a lot quieter compared to the CK. But nevertheless, the Dura-Ace hub is still one of the top-of-the-range hubs out there which you will not be dissatisfied about.

The low spokes count (16 front and 20 rear) also contributes to the lack of rolling resistance. It slices through the wind better. People say that it is harder to maintain a higher speed on the shallower wheelset but that’s not the case with me. I can command the same if not higher speed than the Enve simply because I can roll easier with it. With the daily crosswind I get in Perth, a deeper wheelset such as the Enve causes greater resistance; and I find it a bit harder to ride at a faster cadence on the deeper wheelset when the crosswind hits.

Comfort
The C24 soaks up vibration slightly better than the Enve. I don’t know by how much but all I can tell you is this, I did a 150km ride that took about 7-8 hours on both the Enve and the C24 (see the Strava link on this article for the C24 or on the Enve review article for the ride with Enve), and during the ride I needed to rest my hands several times during the ride with Enve due to the numbness I get from the vibration. On C24, that just didn’t happen at all. All the other setup eg. handlebar, saddles, etc are all the same on both rides. So I can assume that C24 is a lot more comfortable than the Enve.

Near my office there is a stretch of brick paving on the road and the C24 rattles a bit less compared to the Enve.

Climbing
Climbing feels a bit snappier than the Enve. Even though the weight is quiet similar between the two (C24 and Enve), but somehow the C24 feels lighter during climbing. I still suspect that it’s the crosswind that affects the deeper wheelset, causes it harder to roll.

Near my house there is a 3km stretch of 5-7%. On the Enve I had to switch down to 34×16-17 while on the C24 I can stay at 50×22-25.

Descending
During descend this wheel just rolls excellently. I ended up catching my mates all the time during the descend and while all of us free-wheeled, I was somehow quicker than them. The wheels turn with precision, wherever you want to go, wherever you point your steering to, the wheels will just go with you.

Braking
Braking is a lot better than the Enve since it’s alloy. Also, as mentioned in the Enve review article, Enve’s default brake pads just suck! I would change them to SwissStop Black Prince had the warranty not been avoided should we use other brake pads than the ones Enve supplies. While on the C24 I’m just using stock-standard alloy brake pads and performance has been superb.

I’m yet to test the C24 in the wet but since it’s summer at the moment, there hasn’t been any rain since I bought the C24. Will keep you updated with the brake performance on the wet.

Installing Tires
The internal width of this rim is 15.5cm and I had no trouble whatsoever installing tires on this rim. Same with the Enve, installing tires will not cause any blisters on your hands. They just slide in nicely. I have tried to install both Hutchinson Fusion 3 and Michelin Pro 4 Endurance and I could install both without much effort whatsoever.

SUMMARY

As a summary, you can’t go wrong with this wheelset. It’s good value, stiff, climb superbly, light, descend and brake well. What else do you expect? Comparing to other websites Pro Bike Kit still gives the best price on the C24.

SharePoint 2010 2013 Search Component is Offline

Nov 4, 2014 4:09 PM, - Posted by Tommy Segoro

INTRODUCTION

I am running a 3 server farm environment: 1 Central Admin (CA) and 2 Web Front Ends (WFE). I set the following search components on each of the VMs:
– CA: Admin, crawler, content processing, analytics processing, query processing, index partition
– WFE 1: content processing, analytics processing, query processing, index partition
– WFE 2: content processing, analytics processing, query processing, index partition

I only use CA to do the crawling so that WFE performance is not affected when crawler runs.

Upon maintaining my SharePoint farm, on the Search Service Application administration page I saw some error (red cross) and warning (yellow triangle) icons under these components on both WFEs: content processing, analytics processing, query processing, index partition.

The cause of the issue is unclear.

RESOLUTION

To fix the issue, I ran the following Powershell script:

$svr = Get-SPEnterpriseSearchServiceInstance -Identity "SERVERNAME"
Start-SPEnterpriseSearchServiceInstance -Identity $svr

Then I run Full Crawl.

Status is all now healthy (green tick) for all those offline components.

NOTE: After running the Powershell script above you may see the other components turn green except Index Partition. It is still in “Warning” mode. Only until Full Crawl is run did it turn back to green.

Hope this helps,

Tommy