List Tools on Ribbon not visible when add more WebParts to List DataSheet view page

I have notice one weird issue when we add more WebParts to SharePoint List DataSheet View page. There are two known issues i found:

1. List View Selector goes off

2. List Tools goes off

Thanks to Alexander Bautz Using his script i am able to solve first issue. But still 2nd issue is present. I don’t know whether Microsoft aware of this issue or not. Not found any details regarding same on MSDN blogs.

Anyway, Below are the steps to reproduce the issue:

1. Create a new view for existing list. Select view type as DataSheet View.

2. If you focus on DataSheet view, you can see both View Selector and List Tools on Ribbon. (see figure 1)

3. Edit DataSheet view page and insert CEWP. Save the page.

4. Now notice both View selector and List Tools gone. In below image View selector is visible because of Alex script. (see figure 2)

Figure 1:

 

Figure 2:

 

Will update this post when i found some solution. If any reader face this same issue and have solution please blog me.

Thanks & Regards,

Rajan

Cannot update TFS workspace

Today i run into a TFS workspace issue. I was getting below error when i open TFS project in Visual Studio 2008:

“TF14091: you cannot perform this operation on workspace. domain/eid are not the owner of the workspace”

Issue cause: VS cache the login credentials for workspace. When we try login with current credentials still it take old credentials from cache.

Solution: Clear the cache and reload it. Follow below steps to do that:

Step 1: Open VS command prompt. (For VS 2008 workspace, open VS 2008 command prompt. If you try to use command prompt, command will not work.)

Step 2: Run below command to clear the local cache.

tf workspaces /remove:*

Step 3: Run below command to set the Owner for respective TFS server

tf workspaces /s:TFS_ServerName

Thats it!!! Now you can open VS and access TFS without any issues.

Bug in Commerce Server Catalog procedure ctlg_GetFTSQuery

I was facing below issue with Commerce Catalog search and while debugging i found that it’s a bug in ctlg_GetFTSQuery procedure. To fix this issue i modifed

IF @IsVirtualCatalog = 1 or  @SQLClause < 1

to

IF @IsVirtualCatalog = 1 or Len( @SQLClause) < 1

    Inner Exception
    ---------------
    Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
    Message : Conversion failed when converting the nvarchar value '[DefinitionName] = 'PartNumberProduct' AND ([IsVisible] = 1 )' to data type int.
    Source : .Net SqlClient Data Provider
    Help link : 
    Errors : System.Data.SqlClient.SqlErrorCollection
    Class : 16
    LineNumber : 29
    Number : 245
    Procedure : ctlg_GetFTSQuery
    Server : 
    State : 1

Disable Debug.Assert ui popup message setting

We add debug.assert to our code for debugging purpose. But sometime in a server with many sessions this pop-up message won’t come up and our application processing stuck there waiting for us to click on assert message. On way to find that assert message is login to server as a console. To disable permanently, add following setting to web.config or app.config file of your application to disable debug.assert pop-up message.

<system.diagnostics>
<assert assertuienabled=”false” />
</system.diagnostics>

Problem in adding external user with FBA

The forms-based authentication (FBA) provider supports authentication against credentials stored in Active Directory, in a database such as a SQL Server database, or in a Lightweight Directory Access Protocol (LDAP) data store such as Novell eDirectory, Novell Directory Services (NDS), or Sun ONE.

I had issue with form based authentication i get the below error when try to add new external user to SharePoint group.

The user or group '' is unknown.   at Microsoft.SharePoint.Utilities.SPUtility.FilterValidLoginName(String loginName, SPSite site) 
   at Microsoft.SharePoint.SPUserCollection.FilterConvertSPUserInfoArray(SPUserInfo[] userInfoArray) 
   at Microsoft.SharePoint.SPUserCollection.AddCollection(SPUserInfo[] addUsersInfo) 
   at Microsoft.SharePoint.ApplicationPages.AclInv.BtnOK_Click(Object sender, EventArgs e) 
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e) 
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) 
   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) 
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) 
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) 
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Most of time fix to this kind of issues is correct configuration of Authentication Providers in Central administration. Same worked for me too. I followed the below two links to resolve my problem:
http://msdn.microsoft.com/en-us/library/bb975136%28v=office.12%29.aspx#MOSS2007FBAPart1_Intro

http://technet.microsoft.com/en-us/library/cc262201%28office.12%29.aspx#section1

The website declined to show this webpage

I freshly installed SharePoint 2010 on my Windows 2008 server VM. Everything working fine, i installed few more softwares like Commerce Server, Team Foundation Server 2010. After that i tried to access my SharePoint Central administration page and problem started.  I continuous to get the  error “The website declined to show this webpage. Possible cause: The site require user to log in” when try to open central administration site. Even i verified the credential, that was fine. To troubleshoot i checked the following things:

1. AppPool and Central Service used for site should be running.

2. Verified the credentials under which app pool running.

All above was fine. I was wondering what is the issue. After so much tweaking i found that issue is with the app pool used to run Central Administration site. AppPool was running with .NET Framework version “No Managed Code”. Strange is all AppPool running with that framework version. I set the AppPool .NET Framework version to “V.2.0”, restarted the app pool and it started working. 🙂

View GAC assemblies in Windows Explorer

Follow below steps to enable windows explorer view for GAC assemblies:

1. Disable the namespace extension. To do that rename the Shfusion.dll to Shfusion_Old.dll which is located in the %windir%\Microsoft.NET\Framework\vx.x.xxxx folder (e.g. v2.0.50727)
2. Open %windir%\assembly folder. This time you will get the windows explorer view.
3. Rename the Shfusion_Old.dll to Shfusion.dll to enable the namespace extension. Now open %windir%\assembly you will get the standard view.

Cheers !!!

Unspecified error when try to open commerce order web service

While setting up my commerce web services, i ran into this issue when tried to open order web service.

“System.Runtime.InteropServices.COMException (0x80004005): Unspecified error   at Microsoft.CommerceServer.Interop.Profiles.ProfileServiceClass.Initialize(String sConfigStore, String sCatalog   at Microsoft.CommerceServer.Runtime.Profiles.ProfileContext..ctor(String profileServiceConnectionString, String providerConnectionString, String bdaoConnectionString, DebugContext debugContext)”

After so much of googling i found that problem is with the connection strings for the profiles resource on the site. I did following steps to fix this issue:

Step 1: Open Commerce Server Manager

Step 2: Expand CommerceServerManager–>Global Resources–>Profiles(Your Site)–>Profile Catalog–>Data Sources

Step 3: Correct the connection string for each data source

Resource file error on accessing SharePoint pages having commerce WebParts

Sometime we get following error when try to access SharePoint pages containing commerce WebParts. This happen due to missing resource file referred by commerce WebPart in SharePoint page. I followed below two steps to fix this issue:

Step 1: Check commerce server feature and commerce server WebPart resources feature are active on web application.

Step 2: Copy the App_GlobalResources file from working commerce application and paste it in your new commerce application.

Server Error in ‘/’ Application.

---

Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure “Resources.SearchResources.resources” was correctly embedded or linked into assembly “App_GlobalResources.6iidicff” at compile time, or that all the satellite assemblies required are loadable and fully signed.

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: System.Resources.MissingManifestResourceException: Could not find any resources appropriate for the specified culture or the neutral culture.  Make sure “Resources.SearchResources.resources” was correctly embedded or linked into assembly “App_GlobalResources.6iidicff” at compile time, or that all the satellite assemblies required are loadable and fully signed.

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:

 

[MissingManifestResourceException: Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "Resources.SearchResources.resources" was correctly embedded or linked into assembly "App_GlobalResources.6iidicff" at compile time, or that all the satellite assemblies required are loadable and fully signed.] System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +7680590 System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +583 System.Resources.ResourceManager.InternalGetResourceSet(CultureInfo culture, Boolean createIfNotExists, Boolean tryParents) +583 System.Resources.ResourceManager.GetObject(String name, CultureInfo culture, Boolean wrapUnmanagedMemStream) +47 System.Resources.ResourceManager.GetObject(String name, CultureInfo culture) +11 System.Web.Compilation.BaseResXResourceProvider.GetObject(String resourceKey, CultureInfo culture) +80 System.Web.Compilation.ResourceExpressionBuilder.GetResourceObject(IResourceProvider resourceProvider, String resourceKey, CultureInfo culture, Type objType, String propName) +21 System.Web.Compilation.ResourceExpressionBuilder.GetGlobalResourceObject(String classKey, String resourceKey, Type objType, String propName, CultureInfo culture) +28 System.Web.HttpContext.GetGlobalResourceObject(String classKey, String resourceKey, CultureInfo culture) +12

CS 2009 issue – An item with the same key has already been added.

I ran into this issue while setting up CS 2009 on my local box. Funny thing is, this issue is fixed just by reactivating Commerce Server feature. I think recreate the channel configuration list and refresh the dictionary which add default channel name.

Event Type:    Error
Event Source:    SharePoint Commerce Services Exceptions
Event Category:    None
Event ID:    0
Date:        7/20/2011
Time:        6:41:36 PM
User:        N/A
Computer:    
Description:
An exception of type 'System.ArgumentException' occurred and was caught.
------------------------------------------------------------------------
07/20/2011 18:41:36
Type : System.ArgumentException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : An item with the same key has already been added.
Source : mscorlib
Help link :
ParamName :
Data : System.Collections.ListDictionaryInternal
TargetSite : Void ThrowArgumentException(System.ExceptionResource)
Stack Trace :    at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at Microsoft.Commerce.Application.Common.Configuration.ServiceConfiguration.CreateDictionary(String channelName)
   at Microsoft.Commerce.Application.Common.Configuration.ServiceConfiguration.GetSiteName(String channel)
   at Microsoft.Commerce.Broker.OperationService.InitializeOperationContext(CommerceRequest request)
   at Microsoft.Commerce.Broker.OperationService.ProcessRequest(CommerceRequest request)

Additional Info:

MachineName :
TimeStamp : 7/20/2011 1:11:36 PM
FullName : Microsoft.Commerce.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
AppDomainName :
ThreadIdentity :
WindowsIdentity : ServerName\Administrator