Tuesday, February 4, 2014

Difference between Document Library and Lists in SharePoint

Difference between Document Library and Lists in SharePoint                



It’s a basic question that arises in mind that, what makes difference between those.

Lists:
1.     Can have attachments
2.     Have major versions only
3.     Do not have Check-in/Check-out features
4.     Upload Document is not available
5.     It store data in table structure
Libraries:
1.     Cannot have attachments (files are directly in the library)
2.     Have both minor (draft) and major (published) versioning
3.     Have Check-in/Check-Out
4.     Publishing Libraries can use Page Layouts
5.     Have Unique Document Ids out of the box
6.     Upload Document is available.
7.     It store document/files

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Cross farm service applications in SharePoint 2013

Cross farm service applications in SharePoint 2013

In SharePoint, we can use some service applications across farms. The below are the service applications that can share across farms. The other service applications apart from below can’t share across farms.

·         Business Data Connectivity
·         Machine Translation
·         Managed Metadata
·         User Profile
·         Search
·         Secure Store
Cross farm Service Applications Integration between two separate SharePoint farms
How to connect Different farms to use the service applications, below is the detailed Explanation from Issa.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Monday, February 3, 2014

Issues Uploading Large Files To SharePoint

Issues Uploading Large Files To SharePoint
Generally, In SharePoint we encounter the below issues while uploading the larger files to SharePoint web site. The issues it could be many reasons. we come to know the Exact issue by checking the Application,ULS or any trace. Here in the below article, I am mentioning the general cause of the issues and the resolutions that Occur In my experience.Follow any below methods as per your issue.

·         "An unexpected error has occurred"
·         "The page cannot be displayed”
·         "An unknown error occurred"
·         "HTTP 404 – Page Not Found”
·        “Request timed Out’

1.Increase the maximum upload size for the web application


 Go to 'Start > All Programs > Administrative Tools > SharePoint Central Administration > Application Management'.

1.     Under SharePoint Web Application Management, click 'Web application general settings’.
2.     On the Web Application General Settings page, choose the appropriate web application.
3.        Under Maximum upload size, type the file size which you want to upload and click on OK. You can specify a maximum file size up to 2,047 megabytes.
                         

                                 
Note:
Any upload size which is below 250 MB is enforced directly through web app settings. Above 250 MB, you need to make a some small change to the web.config file to allow larger uploads. Repeat the steps listed below for all zones for your web app all the servers which host the web application role.
  • Open the web.config from
  • 'C:\Inetpub\wwwroot\wss\VirtualDirectories\<Virtual Directory>' folder and modify it as follows 
 <httpRuntime maxRequestLength="51200" /> with <httpRuntime      executionTimeout="999999" maxRequestLength="51200" />
  • Perform an IISReset and you should be good to go.

2.  Increase the connection time-out setting in IIS

while uploading large files, there are chances that the request will timeout. By default, the IIS connection time-out setting is 120 seconds. Follow these steps to increase the connection time-out setting,


·         Click Start, point to All Programs, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
·         Right-click the virtual server that you want to configure, and then click Properties.
·         Click the Web Site tab. Under Connections, type the number of seconds that you want in the Connection time-out box,
and then click OK.
              
                                                   
          
                                                

3.  Increase the maximum upload size in the web.config file of web application


In the web.config file of web application which has issues to upload larger files or getting the error the page can’t be displayed. Increase the value of the Upload size.

4.Explorer view or Web client issues


While trying to use the explorer view, you may see the following error
“Error 0x800700DF: The file size exceeds the limit allowed and cannot be saved” message
If this is the case then the issue is most likely caused by a local restriction set on Web Client service. By default, Web Client file size limit is set to around 47 Mb. To increase this limit:

  • Click Start, click Run, type regedit, and then click OK.
  • In Registry Editor, locate the following registry key
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClientParameters
  • Right click on the FileSizeLimitInBytes and then click Modify.
  • In the Value data box, click on Decimal, and type 4294967295 and then click OK.
  • Quit Registry Editor
  • Restart Web Client service from Services.msc

5.Increase the default chunk size for large files


The large-file-chunk-size property sets the amount of data that can be read from server running SQL Server at one time.
  • If you have a file that is greater than your chunk size (such as 70 MB when the chunk size is set to 5 MB), the file would be read in 14 chunks (70 / 5).
  • The chunk size is not related to the maximum upload file size.
  • The chunk size simply specifies the amount of data that can be read from a file at one time. By default, the large-file-chunk-size property is set to 5 MB.
  • Check if the 'large-file-chunk-size' property is set or not
    Stsadm -o getproperty -propertyname large-file-chunk-size
  • In order to set the large–file–chunk–size property, we need to use the command line. This property is configured for a server or server farm, and cannot be configured for an individual web app server. To set this property, use the following syntax:
   Stsadm.exe –o setproperty –pn large–file–chunk–size –pv <size in bytes>
  • After making a change to this property, perform an IISreset /noforce.

6.Add the execution Timeout value  


Increase the execution timeout for the upload page (upload.aspx) to prevent timeouts on the page..
  • Navigate to 'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\LAYOUTS' folder on the SharePoint server.
  • Open the 'web.config' file in notepad or any other text editor and add the execution Timeout parameter. For example, replace the value as follows
Existing code
<location path="upload.aspx">
    <system.web>
      <httpRuntime maxRequestLength="2097151" />
    </system.web>
</location>
Replacement code
<location path="upload.aspx">
    <system.web>
      <httpRuntime executionTimeout="999999" maxRequestLength="2097151" />
    </system.web>
</location>
  • Open the 'web.config' file from the 'C:\Inetpub\wwwroot\wss\Virtual Directories\<Virtual Directory>'folder and modify it as follows 
  Existing line :  <httpRuntime maxRequestLength="51200" /> 
  Replacement line : <httpRuntime executionTimeout="999999" maxRequestLength="51200" />

  

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Site Collection Admin Can't Delete or modify Site

Site Collection Admin Can't Delete or modify Site
         


The SharePoint farm administrator or site collection administrator can't do any changes in the site still has full permissions.

Issue: The site is locked.

Solution: Go into Central Admin unlock the site.

Application Management->Site Collection Quotas and Locks->Choose the site and then pick Not locked->Click on OK

Environment: MOSS 2007 

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Sunday, February 2, 2014

How to create a SharePoint 2010 farm with no GUIDs using Power Shell

      How to create a SharePoint 2010 farm with no GUIDs using Power Shell

A very detailed and useful article Written by Todd Klindt. If use the PSCONFIG.exe it will create the GUID at the end of databases. To avoid this we can use power shell commands.

http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=241

   2.  removing the GUID out of the AdminContent database in SharePoint 2010


http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=233

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

ShareThis

X