Tag Archive for 'SharePoint'

How to trouble shoot SharePoint with “critical error”

MOSS 2007These days the MOSS site went down a couple time, every time there was the following error messages:

page has encountered a critical error. Contact your system administrator if this problem persists.

At first, we could reboot the database and application servers to let the problem go away. But rebooting is not the good choice. Finally I figured out it was not about the database.

Here is what I did to find the real issue behind the generic error message above.

Continue reading ‘How to trouble shoot SharePoint with “critical error”’

Related posts

Resolve Access Denied Error while creating new article page in SharePoint MOSS 2007

MOSS2007[1]A user with Full Control permission on the top site could not create an article page. The error message was Access Denied.  I tried different ways to resolve this issue, include put her Full Control permission directly on the top site and Page library, but still had the same issue. Then I assign Full Control, Approve and Contribute and all permission levels to her, I got the following error:

List does not exist

The page you selected contains a list that does not exist.
It may have been deleted by another user.

But this user can do everything else except the Create Page from the Site Action drop down. From the URL, you can see the Create Page is using /_layouts/CreatePage.aspx file which I believe is using publishing template

Continue reading ‘Resolve Access Denied Error while creating new article page in SharePoint MOSS 2007′

Related posts

How to change the Domain name URL for the SharePoint site

MOSS2007[1] We just launched a new Intranet web site powered by the SharePoint 2007 (MOSS 2007). Everything works fine except the URL. By default, the SharePoint services uses the computer name of the server. But we need a nice name like “http://intranet” as the new site name.

We created a new DNS record named “Intranet” and pointed it to the SharePoint server. But it only did the initial re-direction, and it came back to the default http://servername/Pages/default.aspx URL again.

Continue reading ‘How to change the Domain name URL for the SharePoint site’

Related posts

How to display SharePoint list from another site

There is no a straight way to add SharePoint list from another site to the web part page. Recently I found out a simple way to do so from Path to SharePoint blog.

1), Create a new Content Editor Web part on the page you are working on.

Continue reading ‘How to display SharePoint list from another site’

Related posts

How to refresh a SharePoint page automatically in 60 seconds

As I indicated in my previous post, I need to set up a SharePoint page with some frequently-updated lists. And I need this SharePoint page to be refreshed automatically every minute.

Here are some methods I tried.

Continue reading ‘How to refresh a SharePoint page automatically in 60 seconds’

Related posts

How to add weather and traffic information to SharePoint page

Recently I added some weather and traffic information to one of our SharePoint page, and would like to share the process here. Of course, you will have to select the right web service based on your location. I use Georgia state here as the example.

Normally to add external information to the SharePoint page, you can use RSS feeds, or the Javascript code snippet provided by the external web site.

Weather:

I selected accuweather.com not weather.com since weather.com has domain name restriction.

Here is simple steps to add weather on the SharePoint page.

Continue reading ‘How to add weather and traffic information to SharePoint page’

Related posts

How to open SharePoint link list item in a new window

In SharePoint 2007 (WSS 3.0), you can put any URLs in the Links List. But when you click any of these links, they will be opened in the same browser window instead of in a new window.

I checked the Internet, and found a couple of ways to open the links list in a new window. The first one was the simplest one as I am concerned. I implemented and it worked for me.

Continue reading ‘How to open SharePoint link list item in a new window’

Related posts

Post emails onto SharePoint list

Challenge:

We are using a service called Roam Secure Alert Network to notify subscribers about any news needs immediate attentions. These alerts can be posted through Web, Email and SMS. And the subscriber can receive  alerts with emails, phone text messages.

Recently we need an internal SharePoint web page to be developed to show all these alert messages. Since the Roam Secure system is not part of our system, and did not provide any RSS feeds due to secure concerns. We could not set up any data connection to retrieve these message from their system.

The simple way is to use the Incoming email feature of SharePoint to post these messages in a new list.

Continue reading ‘Post emails onto SharePoint list’

Related posts

Issues with creating Database Connections to Oracle in SharePoint Designer 2007 (Resolved)

Challenges:

I tried to connect to Oracle database in SharePoint (MOSS 2007). But got the following error when I tried to create a Database connections in Designer 2007.

1), Use custom connection string;
2), Select Microsoft .NET Framework Data Provider for Oracle as the Provider Name;
3) Post the below as the Connection String:

Password=<passwd>;User ID=<userID>; Data Source = <mydatasource>; Persist Security Info=True; Provider=OraOLEDB.Oracle;

4), It seemed the Oracle db can be connected, but could not find the root catalog since the "Initial Catalog=root;" was appended to the above connection string automatically.
5), and the error message is:

Server Error: An error occurred while retrieving the list of Tables from the root Database: The query you are trying to execute contains syntax errors.

I searched on the Internet, and was told there is a way to use BDC(Business Data Catalog). But I just need a simple way to show Oracle data on a SharePoint page. BDC connection is too much for me at this point.

Continue reading ‘Issues with creating Database Connections to Oracle in SharePoint Designer 2007 (Resolved)’

Related posts

How to pass InfoPath form fields to SharePoint workflow but hide from Document Library item properties

Challenge:

Create a form in InfoPath 2007 and implement a SharePoint Workflow to it for approval processes. In each step, a Status field in the InfoPat form should be updated automatically according to the change of workflow task status. So a different view in the InfoPath can be opened based on the Status field in the form.

But after the InfoPath was published to the SharePoint (MOSS 2007 with InfoPath Form Services turned on) as Document Library and Content type, the Status field could not be displayed when “Set Field value in Current item” action was selected in the workflow design. Even it was promoted to be available in the SharePoint document library.

Continue reading ‘How to pass InfoPath form fields to SharePoint workflow but hide from Document Library item properties’

Related posts

How to fix non working “Edit this task” button of SharePoint workflow notice in Outlook and InfoPath 2007

Challenge:

Set up a workflow for the InfoPath form in the MOSS 2007 and the workflow worked fine. The approval notice had been sent to the next person’s mailbox, but the Edit this task button on the toolbar of Outlook 2007 did not work. When you click it, nothing happened. You can click the infopath xml link in the message body and the infoPath form was opened. And the Edit this task button in the InfoPath 2007 message bar did not work either.

According to Kerry’s MOSS blog:

This is apparently related to Outlook 2007 using InfoPath to display the approve/reject form. This form contains a CLSID of {00000000-0000-0000-0000-000000000000}. This CLSID is apparently “kill bitted” on some systems and is prevented from being displayed.

Continue reading ‘How to fix non working “Edit this task” button of SharePoint workflow notice in Outlook and InfoPath 2007′

Related posts

[Updated] How to move task list item into sub-folders on sharepoint

MOSSThis post is an updated to the previous post of mine about the Task List item manipulations. Apparently the method I described in the previous post works only for different task lists, not for the sub-folders which belong to the same task list moved from.
When I tried to move the list items into a sub-folder inside the same task list on Manage Content and Structure page, and got the error below

“An error was encountered performing this operation.
Attempt to move url(s): http://site/Lists/Tasks/1_.000; failed. Please try again

Continue reading ‘[Updated] How to move task list item into sub-folders on sharepoint’

Related posts

How to log onto SharePoint server in IE and Firefox automatically without being asked Username and Password

Microsoft SharePoint Server 2007If you are hosting a SharePoint server on your own network within the same domain, you should be able to log onto the SharePoint team sites with your Windows credentials automatically in IE (Internet Explorer).

If not, just like it happened on some of my co-workers recently. The IE will ask you to enter Domain User Name and password whenever you hit the SharePoint team site or download documents from the SharePoint server. If you did not provide the correct logon credential, your IE browser screen will show the followings:

You are not authorized to view this page

You do not have permission to view this directory or page using the credentials that you supplied because your Web browser is sending a WWW-Authenticate header field that the Web server is not configured to accept.


Please try the following:

  • Contact the Web site administrator if you believe you should be able to view this directory or page.
  • Click the Refresh button to try again with different credentials.

HTTP Error 401.2 – Unauthorized: Access is denied due to server configuration.

That means the IE did not pass the user’s windows log in credentials automatically to the SharePoint sites based on the IE’s security settings.

Continue reading ‘How to log onto SharePoint server in IE and Firefox automatically without being asked Username and Password’

Related posts

How to move task list item into sub folders on SharePoint site

Microsoft SharePoint Server 2007Not like Document Library, the list in SharePoint does not have a Windows Explorer View which can allow you to easily move items around. This happened on me when i tried to move some created Task (action register) item to these newly added sub-folders. I could not easily found a way to do the moving like I did in other document library.

Almost gave up and tried to re-created all task items in the sub folders, i found out there is a work-around if you are the administrative on this SharePoint site.

Here is the How-to:

  1. Move mouse over to Site Actions.
  2. And click the Manage Site Content and Structure.
  3. On the Site Content and Structure window, you will see web page divided into two parts. The left part will have a tree-view of your site, and the right part will have item views. Now you start from the left side by expanding tree nodes and highlight the list document library you need to work on, and then you can:
  4. a. find each item you need to move, and click the drop down menu of each list item title, and select Move to…;

    b. Or if you need to move multiple items, you can check the check boxes of each item, and click Actions menu and select Move… option.
  5. A new window will be opened, and you can choose the new destination from there.

Good luck.

Related posts



Get Adobe Flash playerPlugin by wpburn.com wordpress themes