R – Profile User DB error in WebPart

mosssharepointsharepoint-2007wss

EDIT: Modified title and added update.

UPDATE:
We no longer believe this is a 64bit vs 32bit problem. We have found that the only people that were seeing this, were people that were set in the farm policy as "full control." (Not acting as System Account) Once we tested regular users, we found none had the problem. Removing the "problem" users from the farm policy and adding them back, fixed all but one user(a fellow dev:)).

We started out our Farm with 2 32bit WFE's and a 32bit Application server. We have decided to add 64bit front ends to our farm, and for the most part, almost everything worked fine. The exception is a custom web part that accesses the user profile database. Works fine on 32bit front end, but we get the following error on the 64bit front end:

User Not Found: Could not load profile data from the database.

Description: An unhandled exception
occurred during the execution of the
current web request. Please review the
stack trace for more information about
the error and where it originated in
the code.

Exception Details:
Microsoft.Office.Server.UserProfiles.UserNotFoundException:
User Not Found: Could not load profile
data from the database.

Source Error:

An unhandled exception was generated
during the execution of the current
web request. Information regarding the
origin and location of the exception
can be identified using the exception
stack trace below.

Stack Trace:

[UserNotFoundException: User Not
Found: Could not load profile data
from the database.]
Microsoft.Office.Server.UserProfiles.UserProfile.Load(SqlDataReader
myReader, Boolean bFirstRead, Boolean
bWssId) +930
Microsoft.Office.Server.UserProfiles.UserProfile.Load(SqlDataReader
myReader) +64
Microsoft.Office.Server.UserProfiles.UserProfile.RetrieveUser(String
strAcct, Guid gAcct, Byte[] bSid,
Nullable`1 recordId, Boolean
doNotResolveToMasterAccount) +1507
Microsoft.Office.Server.UserProfiles.UserProfile..ctor(UserProfileManager
objManager, String strAcct, Boolean
doNotResolveToMasterAccount, Boolean
forceUserIsSelf) +584
Microsoft.Office.Server.UserProfiles.UserProfile..ctor(UserProfileManager
objManager, String strAcct) +80
Microsoft.Office.Server.UserProfiles.UserProfileManager.GetUserProfile(String
strAccountName) +205

Since the WFE is on the same farm, it should be looking at the same database.

Let me know if any more info is needed.

Any ideas would be appreciated!

Thanks.

Best Solution

"Word on the street" is you can't mix 32bit and 64bit servers on the same farm (with the exception of the database server).

http://technet.microsoft.com/en-us/library/cc261700.aspx says:

You can deploy an Office SharePoint Server 2007 farm on a mix of 32-bit and 64-bit servers, provided that you maintain architecture homogeneity at each topology layer. For example, you should not mix 32-bit and 64-bit Web front-end (WFE) servers, but you may use 64-bit database servers in a farm with 32-bit WFE servers and application servers.

So, you CAN mix 64bit and 32bit, but apparently not 32bit and 64bit WFEs. I'm not saying it's true, I'm saying that Technet says it's true. Technet is often more conservative, so uh, go ask your MVP guy.

Related Question