SharePoint, .Net, SQL, MS BI, Collaboration and Gadgets

Central Administration is not working. When I access central administration, I received the “File Not Found. Troubleshoot issues with Windows SharePoint Services.”  message after I entered my credentials.
Checked the IIS, and the Application Pools for Central Administration as well Central Administration were started. Everything looks fine.  The content web site is working fine. Only the central administration is down.

From what I get from my colleague, in a lot of cases, the easiest way to resolve this issue is to reprovision CA. In other words, unprovision the CA using the config wizard or psconfig.exe and the reprovision it again using the same tools. (This is not the same as disconnect from the farm and if done correctly, will not affect the production of the regular sites).

* This issue happened on one of my colleague and thanks to Jukka who provide this solution.

I receive some problem from my colleague when designing an infopath-2007 form that uses managed code for custom event handling. Here is the error:

InfoPath cannot add the event handler.

To work with Visual Basic or C# code, Microsoft visual studio tools for Applications (VSTA) is reguired. The Microsoft .Net Framework 2.0 and Microsoft Core XML Services 6.0 must be installed prior to installing VSTA…..

He has installed everything that is required. (MSXML Parser 6.0 / VS-2005 / VSTA) but still facing this error. Here is the solution from “Faithful”:
Read the rest of this entry »

Is there any form of notification being sent to the submitter of the page?
Yes, default approval workflow does have the following email notification

1. Requesting approval email notification
2. Email notification to contributor regarding approved / rejected pages from the approval.

Here are the steps:

1. Outgoing email settings must be configured at the Central Admin à Operations. Without this, there won’t be any option to send notification email in the list setting.
2. User profile must be configured and imported, with user email information included.
3. Please create a new Task list when using default approval workflow, using existing “Workflow Task” list, email notification will not be send out.  If you are using existing workflow task list, on this list setting >  advanced setting > Send e-mail when ownership is assigned ? change it to NO and wait for 5 minutes then change it back to YES then you will be able to see those email notification. The other alternative is DO NOT USE the default “Workflow Tasks”, create a new “Tasks” list

*Special thanks to RC, Abi, SC and LJ.

This post is contributed by my colleague, Abi. I would like to share out here since it is very usefully.

If you have MOSS users in different AD domains, and for dunno wat reason you can’t seem to search these users in the MOSS’s PeoplePicker, run a stsadm command to add the information about the those domains where the user is located.
�
In summary:
“We went to SSP and clicked on User Profiles and Properties under the “User Profiles and My Sites” section and then clicked on View Import Connections and then added domain1.company.com to the Import Connections list and I started a full import. It completed in about an hour and imported users from the domain1 domain.
�
The problem we run into is that when I go to add them to a site to give them access, we are unable to find the users by using People Picker. We only find users from the domain0 domain which the moss server is on. ”
�
I found out that by default People Picker can only find people in the resource domain - the domain that MOSS servers are in. For other domains/forests, you’ll need to run the following command:
�
Stsadm.exe –o setproperty –pn peoplepicker-searchadforests –pv <list of forests or domains> -url <webapp>

Official MS site:

• http://technet.microsoft.com/en-us/library/cc263318.aspx

Some examples:

• http://blogs.msdn.com/joelo/archive/2007/01/18/multi-forest-cross-forest-people-picker-peoplepicker-searchadcustomquery.aspx  
• http://blogs.msdn.com/jingmeili/archive/2007/02/26/people-picker-in-moss-2007-can-t-find-people-in-non-default-domains.aspx

This post let you add another user to manage SharePoint SharedServices (SSP). http://msmvps.com/blogs/shane/archive/2007/08/06/give-a-user-access-to-the-ssp.aspx

* Thanks to Abi for her sharing on this post.

First, there is a long post describe how to setup this features. http://aidangarnish.net/blog/post/2007/09/Indexing-and-Searching-PDFs-in-MOSS-2007.aspx.

Here are some steps need to be aware of:

• To have PDF icon in the doc lib, you still need to manually copy and paste the pdf icon image into the TEMPLATE > IMAGES folder, and map the image file with the file type in the DOCICON.XML file (in TEMPLATE > XML folder).
• To crawl contents of PDF files, we need to install Adobe PDF IFilter 6.0 (download free).
• Add new file type (.pdf) in your search setting. The settings is under central admin > Shared Service Administration > Search Settings > File Types
  /ssp/admin/_layouts/managefiletypes.aspx

A feature that enable a field to pick a value from a SharePoint list, made available at CodePlex: http://www.codeplex.com/SP2007LookupFields I get this from my colleague, S.C. I would like to share out here and take it as my own bookmark as well.

I am currently working in a consultant company offers MS solution in my home country. We split in to several groups base on our skills and experience. Each of the group will focus on certain technology such as MS CRM, Axapta, Business Intelligence, SharePoint, .net development and etc. I am in the SharePoint and .net development team. Recently, I got chance to work in MS Business intelligence like SSAS, SSRS, BSM and the latest MS Performance Point Server 2007. Hence, I seldom post much articles on SharePoint. However, I got some colleagues actively working in SharePoint and always share their problem and solution among our team. So, I plan to put these useful posts in to this blog as well. Just to share out and for my own reference too. Check out the posts soon!

* Special thanks to SC, Abi, LJ and RC who share out their problem and solution. I will put in their full name if they agree to do so

I come across some problems in Reporting Services 2005 in SharePoint integration mode when using Navigation - Jump to URL. Here are some strange behaviors on the problem:

1. The link won’t work if you link to a page/item inside a SharePoint List.

2. The link is OK if you link to invalid page/item in a SharePoint List (invalid item name but valid path)

3. The link is OK if you link to other site like http://www.microsoft.com or http://www.ajaxworkspace.com

I tried googling around but can’t find any solid solution. But I found out that we can use JavaScript as a workaround to solve this issue. Replace your Jump to URL format from:

= “http://servername/sitename/documentlist/pagename.aspx”

With

= “javascript:window.location.href= ‘http://servername/sitename/documentlist/pagename.aspx ‘;”

It works for me!

P/s: Does anybody know where to find the restriction rules for error “Other restrictions apply. (rsInvalidItemPath)” in order to construct a valid URL path for reporting services?

Developing, deploying and managing event handlers in SharePoint 2007 is a pain. Luckly, some one aready built the tools to manage these problems. Thanks to my colleague, SC who found out this tools. The GUI tool allows you to point to a specific list/doclib/web which you want to hook your custom event handler to it. 

Do check out the tools here:
http://www.u2u.info/Blogs/Patrick/Lists/Posts/Post.aspx?ID=1547