MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

How to Repair MySite Issues?

  Asked By: Angie    Date: Jun 21    Category: MOSS    Views: 3831

My upgrade project continues:

So, I've upgraded one of our SPS 2003 servers to MOSS 2007.

Since the upgrade I'm not entirely sure of what is going on with MySite.

If I click on the MySite in the upper right corner of the screen it
loads the current user's MySite page from MOSS 2007.

[The link is: //<server>//MySite/_Layouts/MySite.aspx]

However, if I click on the MyProfile tab at the top of the page, I get
an error:


An unexpected error has occurred.

Troubleshoot issues with Windows SharePoint Services."

[The link for that is:

Oddly, if I navigate on the left side of the page under that "MyProfile"
heading, and choose Details, or Links, or Colleagues, or Memberships, I
end up navigating to page that breadcrumbs to "Home > MySite (old) >
Edit Details" ETC...

[The link for that is:

The event viewer doesn't show anything interesting.

I don't see anything interesting in the Log files...

Does anyone know what would cause this issue, or how I can repair it?

I'd love to just kill off MySite and rebuild it, but how?



5 Answers Found

Answer #1    Answered By: Akshay Gupta     Answered On: Jun 21

In SPS03, were you using Shared Services?

Did you have a separate application hosting MySites?

In SharePoint Server 2007, if you go to your shared Service provider
admin page, you can change the location of the MySite host if you really
want to move them. The old ones are site collections so you could move
them if they contain data.

I have more questions for you than answers right now.

Answer #2    Answered By: Trinity Scott     Answered On: Jun 21

The answer is that the configuration of MySite under SPS 2003 is
whatever the default values would have been. Likewise, the upgrade  to
MOSS 2007 is also the default...

Does that give you any useful information?

Answer #3    Answered By: Constance Guerrero     Answered On: Jun 21

a little more information:

When I click on the MyProfile tab under MySite: The event viewer logs
the following error:

A runtime exception was detected. Details follow.

Message: Invalid object name 'AR_CacheCounters'.

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK
TRANSACTION statement is missing. Previous count = 0, current count = 1.

Source: Office SharePoint Server

Category: Office Server General

Event ID 7888

Techinal Details:

System.Data.SqlClient.SqlException: Invalid object name

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK
TRANSACTION statement is missing. Previous count = 0, current count = 1.

at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)

bject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
ds, RunBehavior runBehavior, String resetOptionsString)

cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result)

result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand

tractMaterializer.DistributedCacheInvalidate(Type metadataObjectType,
Boolean objectCache)


vider.SetSharedResourceProviderToUse(String sharedResourceProviderName)

tring sspName)

For more information, see Help and Support Center at

Answer #4    Answered By: Chandrabhan Konwar     Answered On: Jun 21

Ok, I got the MySite working.

I created a MySite as per this MS article:


I used "MySite" for step #1.

Now, when I navigate with the share point administrator's account, ALL
the functionality that I should see with MySite appears to be there.

What's interesting is that I can not create a MySite using a normal
user, as the screen just sits at "Create My Site" forever.

Anyone know what would cause this? So far as I know I've got the
account's being pulled in, and everyone should have access to create
their own MySite...

Here's the event log:

Event Type: Error

Event Source: Windows SharePoint Services 3

Event Category: Timer

Event ID: 6398

Date: 5/29/2007

Time: 12:05:00 PM

User: N/A

Computer: INTRANET


The Execute method of job definition
Microsoft.SharePoint.Search.Administration.SPSearchJobDefinition (ID
981f3bf5-f3f2-4d51-a15f-0cc24e89caa1) threw an exception. More
information is included below.

The specified account information is incorrect or not valid. Check that
the correct account and password are being used.

For more information, see Help and Support Center at

Answer #5    Answered By: Tina Owens     Answered On: Jun 21

Well, I have to admit that I've basically unfamiliar with MySite in SPS2003.
What I do know is that it was not being used in any active manner.

What is a little confusing is that in MOSS 2007 there is a "MySite (old)"
sub-page (or something) off the upgrade  MySite main page. This is a little
confusing to me.

What I'd rather do is just kill the current MySite config and then re-add a
MySite for everyone that is clearly a MOSS 2007 default MySite.

I will got the SSP and check the setting, then get back to you!

Didn't find what you were looking for? Find more on How to Repair MySite Issues? Or get search suggestion and latest updates.