Thursday, December 22, 2005

SharePoint Services Errors for BizTalk

Error 1:


While configuring the databases used by Windows SharePoint Services
, might receive the following error,
Line 1: Incorrect syntax near 'COLLATE'. (Error code: 170).

Solution: Provide the SQL Server Access rights to the BTSService, to do this go to security, logins and add the BTSService (User) which is member of administrator, and add to the all the server roles.


Error 2:

templatepick.aspx - page not found

When you create a new top level site under a parent site in sharepoint, it brings up the page saying it has been created successfully, when we click on the sites URL to specifiy the template it should display the default template selection wizard, but instead we might receive a page not found error.

Solution: If you want to delete the following sub site under sites, click on Documents and Lists, under Sites, delete the above site and recreate it, still problem occurs delete the root sites and recreate.

Error 3:

The "WSSLib" adapter is suspending an outbound message going to destination URL:"http://localhost/sites/SomeException/Exceptions". Details:"The request failed with HTTP status 404: Not Found.".

Solution: This means that you haven’t put the WSSWebServices.dll in to the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\ISAPI\BIN folder and WSSDocLibService.asmx in to the C:\Program Files\Common Files\Microsoft Shared\web server extensions\60\ISAPI folder, hence it was not able to find these files, so the following exception occurred.

Note: Kindly check your internal path using the IIS manager,WebSites/_vti_bin, right click and view the properties, capture the local path located under virtual directory tab you should be able to find the folder path location.

Error 4:

When ever we click on Upgrade a server or virtual server’ in SharePoint site, we might get the annoying help file,

"To upgrade your server to Microsoft Windows SharePoint Services, run Setupsts.exe. Running Setupsts.exe upgrades your server and the default virtual server. If you have additional virtual servers to upgrade, you can upgrade each virtual server individually by using the upgrade operation with the Stsadm.exe command-line tool."

Solution: Prohibit the FrontPage from the IIS and remove it from add/remove program, then reset the IIS.
Try to open the site again and this time, You should see the following response, Virtual Server Successfully Extended, This would allow us to browse to the next level in the sites,
You can open the home page for your new Web site in your browser by using a link on the confirmation page. You can continue to extend other virtual servers or configure Self-Service Site Creation so users can create their own sites.

Error 5:

“1057 while trying to query service SPTimer."

Solution:

Make sure you enter the user name as "domain\user name" or "machine name\user name;" otherwise, you get the following error: "System Error 1057 while trying to query service SPTimer,


Installing SharePoint:

Solution:
To Install Install Windows SharePoint Services without installing MSDE,
basically need to do the following,
C:\Program Files\STS2Setup_1033>setupsts.exe remotesql=yes

for more info, Kindly go to the following sites

http://weblogs.asp.net/jan/archive/2004/02/03/66544.aspx

http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsc01.mspx
http://www.codeguru.com/Csharp/.NET/net_asp/miscellaneous/article.php/c8569/