Unable to process Create message - Profile Syncronisation in SharePoint 2010

Recently, when I am working for One of my Project, faced the issue with the user profile synchronization for SharePoint 2010.I followed the below steps to Trouble shoot the issue.

   Issue: Unable to add user properties for user profile connection. Getting “Unable to process Create message” error.

          No Error’s in the event log, ULS Logs and FIM

 Steps taken to troubleshoot the issue:

 note: Before following the steps please take a backup of your Profile and Sync DB.

           Follow the below TechNet article to Reset profile synchronization’: 

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

 Rebooted the APP sever after the reset and added the Farm account on Sync DB as DBO owner on SQL server.

Started the profile synchronization service on APP server.

Ensure the profile service started successfully without any errors.

Checked the User profile application and found that the profiles connection got removed automatically (Expected behavior after the Reset Sync Instance).

Created a new profile connection successfully without any error (Unable to process Create message )

 After that I am able to edit/modify/update the profile connection without any error

Installing Office Web Apps for SharePoint 2010

Recently, we got the request from one of our Client that, They need Office WEB APP Components Installed. I followed the below instruction to achieve this.So,thought to share with all.

Definition:

Office Web Apps was first introduced with SharePoint.  Office Web Apps is an online version of Microsoft Word, Excel, PowerPoint and One Note allowing users to access these applications and their respective documents from any Internet connection and most notable web browsers.  For those running SharePoint 2010, you can deploy Office Web Apps onto your SharePoint farm providing your users with the same functionality as the online version of Office Web Apps.  Deploying Office Web Apps on your SharePoint farms will add the following service applications;

·         Word Viewing Service Application

·         Excel Calculation Service

·         PowerPoint Service Application

will be extending my step by step SharePoint 2010 configuration articles and by the end of this post you will be able to open and edit Office documents from within your web browser without the requirement of having Microsoft Office installed locally.  This is a huge productivity gain for those that might be accessing their SharePoint sites from an Office is usually not available.

Installation:

You will need to download Office Web Apps from the Microsoft Download Site.   Let’s begin by launching the setup.exe and entering our product key;

                                

Accept the licensing terms.

                                  

Click Continue

Choose a file location for installation.  Ensure you select a drive with adequate free space for your Data partition which stores the Office Web Apps search index files.

                                            

Click Install Now

Upon successful installation, you will be greeted with the “Run Configuration Wizard” window.  We will immediately run the configuration wizard by leaving the checkbox ticked and clicking close.  You can also achieve the same by running PSConfig.  Both methods will register the Office Web Apps services.

                   

 

Click Close to Run the SharePoint Configuration Wizard.
                                                   

Click Next and click Yes to acknowledging the restart of the IIS, SharePoint Administration and Timer Services.

                                                 

              

 

Click Next

Click Finish to acknowledge the successful configuration.

                                 

You will then receive the below Central Administration screen regarding configuring your SharePoint farm.  Because we have been configuring each service application one by one as needed (best practice) we will click cancel and proceed to activate the Office Web Apps services individually.

Provisioning the Office Web Apps Service Applications

Let’s begin by starting the relevant Office Web Apps services located under Central Administration / System Settings / Manage services on server.

Scroll down until you locate all of the Office Web Apps specific services, namely Excel Calculation Services, PowerPoint Service and Word Viewing Service.  Click Start for each respective service.

       

Let’s now navigate to Central Administration / Application Management / Manage service applications.

Click on New / Word View Service

Enter the following details to complete the creation of the Word Viewing Service Application.  Ensure that you select “SharePoint Web Services System” from the Use existing application pool option.
     

Click OK

Your service application will then proceed with the creation process and will be listed with our previously provisioned service applications.

                                

You can now further provision the “Excel Services Application” and “PowerPoint Service Application” in the same manner following the above steps.  Please note that there isn’t a separate service application for OneNote.

Activating Office Web Apps:

Depending on where you want the feature activated, you will venture to your Site Collection(s) and activate each one individually or you can utilise PowerShell to activate multiple site collections at once within a single script.

From within your SharePoint Site, click on Site Actions / Site Settings.

Under Site Collection Administration, click on Site Collection Features.

Navigate down the page until you find Office Web Apps and click on Activate.
                  

You should now be able to open a Microsoft Word document from a document library on your SharePoint site and it should launch within the browser by default.

To ensure the best experience possible for your end users, you should install Silverlight.  The below warning will be will be displayed if Silverlight is not detected.
By default, your browser will open the document in view mode and it’s only until you click on Edit in Browser that you will receive the Office Web Apps editing toolbar.

Noted Things:

•  Installing Office Web Apps will change the default behavior when opening documents from open in client application to open in browser.
•       When installing on a SharePoint farm (i.e not a standalone installation), you will need to install Office Web Apps on every server.
•         Current list of supported browsers include Internet Explorer 7 and 8, Firefox 3.X, Google Chrome and Safari 4.X.

Resources:

MS Article   : http://technet.microsoft.com/en-us/library/ee855124.aspx

MOSS 2007 User Profile AD Sync Issue

MOSS 2007 User Profile AD Sync Issue

I face the issue When working on User Profile Sync, Resolved the issue By performing the below steps. so Thought to Share.

       Background:

•  User Profile Import Schedule was not running as per configured Schedules
•  We have to manually run the Incremental crawl which pulled the users from different ADs.
• Profile Synchronization, Quick Profile Synchronization Jobs were running successfully.
• There were totally 90000 profiles, pulled from different domains.

  Problem:

•  Imported User profile details (changes) were not getting published to the web applications.
•  We were able to see the changes in SSP database in “UserProfileValue“table.
• On the other hand when we removed the user from site and added him back the changes are reflected in the web application.

        Resolution:
                               ·         Ran following commands to get rid of this issue

           stsadm -o sync -listolddatabases 

         
Resulted in number of GUIDs, so ran following command to delete those GUIDs
stsadm -o sync -deleteolddatabases 
 
And then        
stsadm -o sync

 
To check connection between AD and MOSS ran following command     
stsadm -o getproperty -propertyname peoplepicker-searchadforests

 
If its resulted in NO, then we have to set connection between AD and MOSS using following command
stsadm –o setproperty –pn peoplepicker-searchadforests –pv 

      After that rechecked behavior using stsadm -o sync -listolddatabases and did not get any GUIDs and after that ran Full import which resolved the issues 

      I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

                       

How to Auto forward Emails from Outlook to SharePoint Document Library:

Before in My earlier Organization, we wanted to auto forward outlook emails to one of SharePoint document library. I followed the below steps to achieve this.

Ø  Make sure Target Doc Lib contains Email address and it’s working

Ø  Then go to Outlook and click on New > Contact

Ø  Add Email address of that document library into the Outlook Contacts.

Ø  Save it and now create a rule from Outlook > Tools > Rules and Alerts > New Rule

Ø  Select “Start from a blank rule” option.

Ø  Select Check messages when they arrive > Next

Ø  Select “Condition” for which you want to forward emails to Doc Lib in step 2.

Ø  Then select action “forwards it to people or distribution list” and click on people or distribution list

Ø  Select “Outlook Address book” from Address Book drop down and you will getSharePoint Document Library email address as a contact > Add it

Ø  Click on Next > Finish

   Ø  Now send an email with that condition to check rule.

Please Comment if you need any Assistance.

Export a Discussion topic List item (SharePoint 2007) to excel or PDF

Here is  some  ways  to achieve this GOAL

When you reply to a discussion it changes to Flat view and redirected to flat.aspx page.

So to export discussion topic in excel you have to manually change the URL from flat.aspx to allitems.aspx.

I.e. to enable export to spreadsheet option URL should be http://siteURL/Lists/discussionname/allitems.aspx

Else to export from “Flat view” tries following steps.

                       Open Excel
·         Click on DATA tab
·         Select from Web option
·         Then in URL provide the URL with http://siteURL/Lists/discussionname/flat.aspx
·         This will open a page with Allitems.aspx in pop up and then you can select (arrows) to        insert required data to excel.
·         And from Excel you can easily export to PDF