SharePoint Experts, Information Architects, Expert Witness

We provide consulting in a broad array of business and technology from architecture to design to deployment of global systems with a focus on surfacing data in the enterprise. Specialists in Microsoft, we are a premier provider of SharePoint Expertise (including 2016 and Office 365). We also provide Expert Witness/Legal Expert in eDiscovery, source discovery, patent infringement, piracy and more! We also have established SICG DLDS s.a. - our counterpart in Costa Rica that specializes in water systems (http://www.crwatersolutions.com) - Contact me direct: david_sterling@sterling-consulting.com or call 704-873-8846 x704.

Search This Blog

Wednesday, September 16, 2009

HOME FOR SALE! Mooresville, North Carolina

Currently selling a home and golf lots in Mooresville, North Carolina. Nestled inbetween the 4th and 6th holes of the Mallard Head Golf Course. Oustanding Schools, close to shopping and 1.5 miles to Lake Norman! 35 miles from downtown Charlotte.

3 Bedrooms (with oversized master suite), 2 full bath, custom built bar (seats 12), quality oak trim throughout - all appliances less than 1 year old.

For more information please go to : http://www.homeandpropertyforsale.com/

Contact me directly - david_sterling@sterling-consulting.com

Unable to open the Adventure Works Catalog with Default Site

I've heard of many cases in which using the Commerce Server default data (the Adventure Works Catalog) fails to load after a successful install and several solutions though I've not seen a post regarding Commerce Server 2009 with SharePoint which requires a different fix.

The symptom is demonstrated by error messages when you try to open the Adventure Works Catalog using the Catalog Manager; if you check the System Event Log, you'll see a message similar to this:

Failed to retrieve the AzMan Scope named CatalogScope_Adventure Works Catalog

The CS2009 fix for this is under Start > All Programs > Microsoft Commerce Server 2009 > Tools > Upgrade Wizard. Simply run this utility on the catalog and Viola!

Commerce Server Web Services Connection Failures - Authentication Errors

After installing and configuring Commerce Server 2009, you may encounter connection and permsissions errors when attempting to use the Catalog Manager, etc. While there can be several causes, a few tips:

No permission to connect/General Permissions Errors/Unable to connect to services under Default Site:

The setup documentation for Commerce isn't clear on the SharePoint integration; while it correctly tells you to add the users to the IIS_WPG group, it is necessary to add the same users to the WSS_WPG. The IIS_WPG (Internet Information Services Worker Process Group) is the default group used for running services for IIS/ASP.NET sites. WSS_WPG, added when SharePoint is installed, serves the same purpose but for SharePoint sites Only.

NOTE: One way to avoid the above problem completely is to put all of the Web Services into a single IIS site (provisioned through IIS, not SharePoint) then modify all of your connection strings to point to the new location.

Authentication Errors:

If you get authentication logged in the System Event log, it can indicate that permissions are wrong in the Authorization file for the service (i.e. CatalogAuthorizationStore.xml). You verify this using the azman.msc snap-in to view the settings. Per the documentation, the web service machine groups (CatalogWebSvcGroup, etc.) are added to the Administration Roles using azman.msc; however, in a domain environment, it is often necessary to add the specific Domain User accounts (i.e. \CatalogWebSvc) to the Administrator/Catalog Administrator Roles (same for Orders, Profiles and Marketing).

Tuesday, September 15, 2009

Pipelines: The PCF file 'c:\inetpub\wwwroot\CatalogWebService\pipelines\basket.pcf' does not exist

When deploying a commerce site, you might encounter the following error attempting to use the Catalog Web Service (Catalog Manager, Catalog and Inventory Schema Manager):


Pipelines: The PCF file 'c:\inetpub\wwwroot\CatalogWebService\pipelines\basket.pcf' does not exist

To correct:

1) First check the CSApp.ini files in each of the services to verify they are pointing to the right site and that the path defined is correct
2) Check web.config of the web services to verify the Site name specified is correct

Commerce Server Failed to start monitoring changes to '' because access is denied

A tip for those of you trying to configure Commerce Server 2009 under SharePoint.

After deploying a site then trying to access the Catalog Web Service (or other services), you may encounter the error:

Commerce Server Failed to start monitoring changes to '' because access is denied

The problem here is that the Web Service Accounts in Commerce do not have access to SharePoint - simply add them to the WSS_WPG group (Start > Administrative Tools > Computer Management > Local Users and Groups) in addition to the IIS_WPG as instructed in the documentation.

Wednesday, August 5, 2009

Adding the Rich Text/HTML Editor control to a Web Part

You might have tried this but had limited success (see warning below) however it is really quite easy to add this control to a web part...just do the following:

In your Web Part project, add a reference to the SharePoint Publishing DLL - in your project, right click on References then under the .NET tab, locate "Microsoft COntent Publishing and Management"

Next, add the using statements in the code:

using Microsoft.SharePoint.Publishing;
using Microsoft.SharePoint.Publishing.WebControls;

Next, define the control you want to create:

Microsoft.SharePoint.Publishing.WebControls.HtmlEditor DescriptionEditorField = new HtmlEditor();

(note because of the Using, you don't need the full namespace but I showed it here for reference)


Next, in the OnLoad method, define and add the control to the web part:

//
//-----------------------------
// DescriptionEditorField
//-----------------------------
//
DescriptionEditorField.ID = "DescriptionEditorField";
DescriptionEditorField.ToolTip = "Description Field";
DescriptionEditorField.PopupEditorMode = true;
DescriptionEditorField.AllowHtmlSourceEditing = true;
DescriptionEditorField.UseIntranetMode = true;
DescriptionEditorField.DisableCustomStyles = false;
DescriptionEditorField.DisableBasicFormattingButtons = false;
DescriptionEditorField.EnableExtensions = false;
DescriptionEditorField.DefaultAssetLocation = "/";
DescriptionEditorField.DefaultAssetImageLocation = "/";
//
this.Controls.Add(DescriptionEditorField);
//

NOTE 1: You MUST use the Popup mode for this to work correcting in a Web Part! If set to "false", it will display but you will not be able to edit.

NOTE 2: For this to work correctly, be SURE that base.Render(writer); is NOT in the Render method (if it is, the control will render twice!)

In the Render method, you can render the control as:

DescriptionEditorField.RenderControl(writer);

WARNING:

When using certain controls (like the Menu Control), it may require that HtmlEditor controls BE RENDERED EVEN IF NOT USED. The effect if you do not, is that you get a JavaScript error on the page indicating it cannot find the control. To prevent this, you can simply check to determine if you want to render or not and if not, set the visibility to false:

DescriptionEditorField.Visible = false;


Happy Coding!!!

Sunday, February 15, 2009

Errors in SharePoint Search

Error in SharePoint search...

You may get an error similar to this:

Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (5fef29c9-308d-4817-bee0-13e39773b7da).
Reason: Object ea615eb7-2b01-4f8c-8db2-ebb2aa357519 not found.

To fix this, you will have to recreate (create a new) SSP; move all applications to point to the new SSP then delete the old one.

Note: After doing so, you must open SQL and under Tasks, remove the SSP Job:

SSPName_Configuration_Job_DeleteExpiredSessions

(Where SSPName is the name SSP you deleted)

If you don't you will start seeing Failure Audit errors in the event log:
Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT: ]

Monday, February 9, 2009

MOSS and Windows 2008, Event IDs 6875, 7888 and 4965

If you have just installed MOSS on Windows 2008 and have a problem creating Publishing Sites (the create never finishes), check your event log - if you see Events 6875, 7888 and 4965 these indicate permissions problems, etc.

As it turns out, the fix is simply to update the MOSS Farm Account as follows:

Login to one of the servers in the farm, open a command window and change to the SharePoint hive directory:

cd c:\program files\common files\microsoft shared\web server extensions\12\bin

Run the STSADM Command to update the account info:

stsadm -o updatefarmcredentials -userlogin acctname -password acctpassword

Then run an IISReset /noforce

If you have only a single server setup (or standalone server instance), you are done - if in a farm, login to each of the remaining servers and repeat the above adding the "-local" switch:

stsadm -o updatefarmcredentials -userlogin acctname -password acctpassword -local

Tuesday, January 13, 2009

Cannot write to the Event Log from SharePoint or .NET Application

You may find when working with posting events to the Event Log that they fail - this can happen when using SICG's SharePoint Helper as well as any .NET application you happen to be building.

The problem is that (depending on the system settings), the ASPNET account does not have the correct permissions - to correct:

Open the Registry Editor (regedit), locate the following entry:

HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/EventLog

Right click on this and grant the ASPNET account Full Control.