Wednesday, July 24, 2013

Configuring recycle bin for SharePoint

Configuring recycle bin for SharePoint

The recycle bin can also be accessed as a site administrator at the site collection level.

This feature is configured at the Web application level.

This capability can be used by the users to recover lists, documents and document libraries, folders and list items.   By default 1st stage recycle bin is 30 days with subsequent 2nd stage at 30 days as well and/or 50% of site quota limit. You can adjust the 1st and 2nd stage quota can at the web application level.



SharePoint Topics


SharePoint Topics

SharePoint foundation
•       Service applications, Web applications, Sites, Webs, Lists, list definitions, list instances, content types, site columns, master pages, page layouts, site pages, application pages, themes, branding, ribbon customization
•       Webparts and controls
•       OOB webparts  like content query webparts, content editor webparts, page viewer webparts, search webparts, chart webparts, XSLTListview webparts, dataview webparts, listform webparts etc
•       Custom webparts, visual webparts, asynchronous webparts, conncted webparts, editor parts and tool parts, personalizable webparts
•       Web user controls, custom controls, delegate controls
•       Workflows – Designer level workflows, Sequential workflows, state machine workflows, reusable workflows,  Site workflows, etc
•       Event receivers (List, Item, Web, Email, Workflow, feature)
•       Sandboxed solutions, farm solutions, and full trust proxies
•       Timer jobs
•       Manual packaging of wsp files – .ddf, manifest.xml, feature.xml, element.xml files etc.
•       Powershell scripts
•       Client object model – ECMA, Managed client object model
•       Server object model, WCF Data services, RESTful services,  LINQ to SharePoint
•       CAS policies
•       Site templates and site definitions, feature stapling, save as templates, web templates,
•       Diagnostic logging(ULS log files), code review , fxcop, spdispose checker, power tools, code metric tools.
Advanced SharePoint
InfoPath
•       Working on domain level and administrator approved form templates
•       InfoPath forms with code behind
•       Data-connections library-.udcx files                

Localization and Internationalization
•       Configuration of MUI(multi-user interface)
•       Configuration Variations for publishing sites   

•       IRM policies – Custom expiration formulas, auditing, expiration etc.

Search services- SharePoint 2010
•       Installation, configuration of Fast Search 2010
•       Configuration of content sources, crawl  rules, scopes, scope rules, metadata properties,
•       Content and Query search service application
•       Customization of search center
•       Customization of visual best bets, faceted search, search core results webparts,  Keyword query, FullTextSqlQuery, Search web services
•       Crawling external sources
•       Custom Protocol handlers, IFilters, Search Connectors

Business connectivity services
•       Configuring BCS, profile pages, creating external content types, external lists in SharePoint designer, BCS web parts like Business Data Actions, Business Data Item, Business Data List, Chart Web Part, Excel Web Access, Visio Web Access
•       Implementation custom .net assembly connector to connect to LOB and implemented BCS methods like finder, specific finder, creator, updator, deletor, filters
•       BCS Meta man

Secure store service application
•       Configuration of secure store service application, creating application ids for storing service account credentials in scenarios like consuming web services(WCF Data services, Oracle web services, connecting to BCS LOBs, PPS etc).
•       Retrieving secure store credentials from the credential store in various custom solutions.  

Authentication mechanisms
•       Classic authentication
•       Windows vs NTLM
•       Claims authentication
•       Windows
•       Sql membership provider, LDAP membership provider.
•       Configuring FBA
•       Web parts for login, user registration, forgot password, retrieve password.
•       Trusted identity provider (ADFS-AD, ADFS-Other identity provider like OpenSSO).
•       Installation of certificates on IP-STS, RP-STS
•       Establishing trust relationships
•       Implementation of custom claims provider, people picker
•       Implementation of claims augmentation                    
Visio services
•       Configuration of Visio services and Visio web access webpart
•       Visio Services JavaScript API   

User profile service application and MySItes
•       Configuration of user profile service application, user profile properties and their mapping, profile synchronization and profile import
•       Consuming OOB user  profile web services
•       User profile object model for retrieving user profiles and properties.

Integration of SSRS with SharePoint
•       SQL Server Reporting Services Report Viewer webpart
•       Installation and Configuration of SSRS
•       Tabular and matrix reports

Managed Metadata services
•       Term store, taxonomies, folksonomies
•       Content type syndication hub
ECM, Documents and Records management features
•       Record Hold, routing
•       Document ID service, document sets
•       Content organizer rules, drop off library
•       IRM policies
Performance Point services
•       Dashboard designer
•       SSAS, SSRS, Third-party Data source integration
•       KPIs, Reports, Drill-downs
•       Data connections library– secure store,

Secure-Store service application
•       Generating keys
•       Adding application ids
Publishing and subscribing service applications in cross farm scenarios
Word automation services
Excel Services
•       Excel workbooks
•       Excel web- access webpart
•       Custom UDF functions
•       Trusted locations
•       Data connections - .odcx
Office Web Apps integration
•       Installation, configuration
•       Powerpoint services
SharePoint capacity planning and Governance
SharePoint OOB (Out of the box) features
UI operations, OOB Web services
Customization in SharePoint designer
Pages, Content Types, lists, workflows, external content types, html, javascript, css, jquery, xslt, webparts, master pages, page layouts
Third party products integration
•       SAP Integration with SharePoint
•       Oracle Integration with SharePoint etc
SharePoint administration
SharePoint installation, configuration, post-installation steps, health monitoring, SSOM, SCOM, Logs, Backup and restore, Hardening the server, Import and export, Active directory, DNS, Alternate access mappings, service accounts
SharePoint farm topologies- WFE, APP server, Database, Index, Query, SharePoint administration toolkit- Diagnostics, replication, powershell scripts
Migration projects
Upgrade of MOSS 2007 to SharePoint 2010

Upgrade of WSS 2.0 to WSS 3.0
Migration of third party ECM products to SharePoint
Exposure to other ECM products
Exposure on Alfresco, Liferay, Adobe CQ, Vignette, Stellent, Drupal, Joomla, DotnetNuke, Site Core, Interwoven, FileNet, etc.
Understanding of content management concepts

Other SharePoint Capabilities

Third party SharePoint products
AvePoint products, Nintex workflow solutions, K2, BCS Meta Man, CAML Builder

Increasing the file upload maximum size

Increasing the file upload maximum size

I was not able upload a document of size more than 50 MB. It was giving document upload with status as failed.

This is because of the default configuration of 50MB for the corresponding web application in the SharePoint central administration website.

To increase the default file upload maximum size, follow the below steps.

1) Goto -> Central Administration
2) click on “Manage Web Applications”
3) Select (single click on the row) desired web application
4) Click on “General Settings” in the ribbon
5) Under "Maximum Upload Size", change the setting to the desired value (e.g. 100 MB in our example)
6) “OK”

If you are running IIS 7, follow the below KB article
http://support.microsoft.com/kb/944981/en-us


Service Unavailable

While browsing the SharePoint web application, I got the below error.

Service Unavailable

The possible reasons why this error occurs are 

1) Your application pool for the corresponding SharePoint web application is down  (is not in running state)
2) You might have changed your application pool identity password.

Cannot connect to configuration database

While opening the SharePoint web application I received the below error.

Cannot connect to configuration database

The possible reasons for this error are 
1) You might have changed the application pool identity password.
2) The SQL server instance fro SharePoint is not in "running" state.
3) There is some network issue connecting to the SQL server database.

Error parsing XML, line 666, column 112 The entity name must immediately follow the '&' in the entity reference.

Error parsing XML, line 666, column 112 The entity name must immediately follow the '&' in the entity reference.

While editing the blogger template html, I faced the below error.

Error parsing XML, line , column  The entity name must immediately follow the '&' in the entity reference.

This occurs because you have character "&" in the html code. which you need to replace it with "&"
This has solved my issue and I was able to save the html

Tuesday, July 23, 2013

Coding Standards, Guidelines, and Best Practices

 Coding Standards, Guidelines, and Best Practices



Coding standards by msdn


Quick Links:
Naming Conventions

Class Design Guidelines        

Best Practices   

Tools

FXCop:
This is an application which analyzes managed code assemblies and reports information about the assemblies, such as possible design, localization, performance, and security improvements.

Code metrics tools by visual studio gallery:
Cyclometic complexity, class depth

SPDisposeChecker: 
Analyzes memory leaks in your managed code and reports the same

SharePoint Code Analysis Framework (SPCAF) BETA

Web site worker process has been terminated by IIS error

 Web site worker process has been terminated by IIS error

You receive the below error
" Web site worker process has been terminated by IIS with error message" while you are debugging the solutions


This is because of the default timeout setting which is 90 seconds for the corresponding worker process (w3sp.exe).

In order to debug for more time without any error message follow the below steps.

  1. Go to IIS Manager (Run-> inetmgr)
  2. Expand the leftside tree view and click on the Application Pools
  3. Select the corresponding application pool for the worker process you have attached in the visual studio while debugging
  4. Click on the “Advanced Settings” in the right side of the pane.
  5. Locate the Process Model section in the advanced settings dialog box
  6. Set Ping Enabled to False.
  7. Set Ping Maximum Response Time to a value that is larger than 90 seconds say 300 seconds.
  8. Setting the “Ping Enabled” to False stops the IIS from checking whether the worker process is still running and keeps the worker process alive until you have stopped debugging the process.
  9. Click OK 

Debugging SharePoint Web application in Visual Studio

1)      Debugging farm solutions (applies to MOSS 2007 / SharePoint 2010)

a.       Using user-interface
                                                               i.      Go to Internet Information Services 7.0 (Run->inetmgr)
                                                             ii.      Single click machine name in the left side of the tree view
InetMgr



                                                            iii.      Double click “Worker Processes” in the IIS Section in Features view as shown below.
Worker processes

                                                           iv.      Identify the ProcessID corresponding to your web application application pool
                                                             v.      Attach the process with the process id identified in the above step in the visual studio
b.      Using command line
                                                               i.      Open Run->Cmd
                                                             ii.      Type Appcmd –list wp
1.       This command will list the worker processes present running in the current machine
2.       Identify the ProcessID corresponding to your web application application pool
3.       Attach the process with the process id identified in the above step in the visual studio

2)      Debugging Sandboxed solutions

a.       Pre-requisite :  The SharePoint Sanboxed User code service is started. You will see that the three process “SPUCHostService.exe”, “SPUSWorkerProcess.exe” and “SPUCWorkerProcessProxy.exe” are running
b.      Attach the “SPUSWorkerProcess.exe” process in the visual studio as shown below

3)      Debugging Full trust proxies or hybrid solutions.

a.       You have to attach two processess
                                                               i.      one is the worker process corresponding to your web application (W3WP.exe)
                                                             ii.      And the other is the corresponding “SPUCWorkerProcessProxy.exe” process as shown below


4)      Debugging Timer Jobs

a.       You have to attach two processess
                                                               i.      one is the worker process corresponding to your web application (W3WP.exe)
                                                             ii.      And the other is the corresponding “OWSTimer.exe” process as shown below








Oracle11g Database Instance Creation

Oracle11g Database Instance Creation

1)      Click on Start and Oracle Database Assistant as shown below.


2)      Click on next

3)      Select “Create database” and click on next.

4)      Select Custom database

5)      Fill in the details and click on next 


6)      Click next

7)      Click next


8)      Click browse and select the location and click on next.



9)      Click next

10)   Click next

11)   Click next

12)   Click next

13)   Click next

14)   Click next

15)   Click next


16)   Click Finish and wait till the database is created.