26 August, 2011

InfoPath Error: This session has exceeded the amount of allowable resources + Event ID 5737

Microsoft Office InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. InfoPath Forms Services uses session state to store the large amount of transient data generated while filling out a form. As a result, front-end Web servers can remain stateless between round trips, and each post back is not burdened with carrying large amounts of session state information over narrow bandwidth pipes.

One of the users opened a ticket with our team By mentioning that he is getting some error message while opening InfoPath forms:

Error Message: InfoPath Error: This session has exceeded the amount of allowable resources

It was a actually a new issue for me so i had started my troubleshooting by debugging the InfoPath forms.

Checked InfoPath form settings, tried to designed a new form, analyzed SharePoint logs as well as Event viewer. While analyzing the event viewer error messages, i found something which was very useful towards the case resolution. (Please refer the below mentioned trace)

Event Viewer details:

Event Type:      Error
Event Source:    Office SharePoint Server
Event Category:  Forms Services Runtime
Event ID:        5737
Number of form actions 208, has exceeded 200, the maximum allowable value

Per request. This value is configurable and can be changed by the administrator.

Microsoft Note: In order for the session state database to be properly maintained, the SQL Agent must be turned on for the instance of Microsoft SQL Server where session data is stored. If the SQL Agent is not turned on, expired sessions are not automatically expunged from the session table and may eventually pose a storage problem.

As per the data from the event viewer, it states that we need to check something within central administration as "This value is configurable and can be changed by the administrator". When i checked the Central Administration settings then i found what i was looking for :-)


Increase the form actions in configuring InfoPath services section as mentioned below:-
  • Go to Central Administration of the SharePoint server.
  • Click on Application Management
  • In the section "InfoPath Forms Services"-->select Configure InfoPath Forms Services.
  • In the Number of Actions per Post back, enter some max value around 250 or 300 depends on your project form requirement.
  • There are chances that the error may retain same even after we increase the number of actions per post back. The second thing we have to increase is the value of "Maximum size of form session state" to 8192. By default it is 4092, by increasing it to 8192 the error should go away. 
If you have 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, Thanks

22 August, 2011

SharePoint 2010 Interview Questions With Answers

1. Describe the potential components for both a single server, and multiple servers, potentially several tiered farms:
A single-server SharePoint Server 2010 environment leverages a built-in SQL Server 2008 Express database. The problems with this environment is scalability, not being able to install the with built-in database on a domain controller, the database cannot be larger than 4 GB, and you cannot use User Profile Synchronization in a single server with built-in database installation.

Multiple tier farms would be a three-tier topology, considered one of the more efficient physical and logical layouts to supports scaling out or scaling up and provides better distribution of services across the member servers of the farm.

2. How will you use Web Parts or other solutions Created in SharePoint 2007 in SharePoint 2010?
In SharePoint 2010 the 12 hive is now replaced by 14 hive, So we will rewrite and recompile any code that refers to files and resources in “12 hive. In addition to we must recompile custom code written for Windows SharePoint Services 3.0 and Office SharePoint Server 2007 that does not run on IIS.

3. When would you use claims, and when would you use classic?
Classic is more commonly seen in upgraded 2007 environments whereas claims are the recommended path for new deployments.

4. What is the difference between Classic mode authentication and Claims-based authentication?
As the name suggests, classic authentication supports NT authentication types like Kerberos, NTLM, Basic, Digest, and anonymous. Claims based authentication uses claims identities against a against a trusted identity provider.

5. What is the advantage in using Windows PowerShell over stsadm in SharePoint 2010 ?
Unlike stsadm, which accept and return text, Windows PowerShell is built on the Microsoft .NET Framework and accepts and returns .NET Framework objects. Windows PowerShell also gives you access to the file system on the computer and enables you to access other data stores, such as the registry and the digital signature certificate stores etc..

6. What are My Sites?
Specialized SharePoint sites personalized and targeted for each user.

7. What are content databases?
A content database can hold all the content for one or more site collections.

8. What is a site?
A site in SharePoint contains Web pages and related assets such as lists, all hosted within a site collection.

9. What is a site collection?
A site collection contains a top-level website and can contain one or more sub-sites web sites that have the same owner and share administration settings.

10. Differentiate zones?
Different logical paths (URLs meaning) of gaining access to the same SharePoint Web application

11. Importance of application pools?
They provide a way for multiple sites to run on the same server but still have their own worker processes and identity.

12.  Define Web Applications in SharePoint?
An IIS Web site created and used by SharePoint 2010. Saying an IIS virtual server is also an acceptable answer.

13. What are Terms and Term Sets?
A term is a word or a phrase that can be associated with an item.  A term set is a collection of related terms.

14. How many of types of Term Sets?
There are Local Term Sets and Global Term Sets, one created within the context of a site collection and the other created outside the context of a site collection, respectively.

15. What is a sandboxed solution?
Components that are deployed to run within the sandboxed process rather than running in the production Internet Information Services (IIS) worker process.

16. Why are sandboxed solutions used?
Primarily because they promote high layers of isolation. By default they run within a rights-restricted, isolated process based around Code Access Security (CAS). Isolation is possible to increase with activities like running the sandboxing service on only specific SharePoint 2010 servers.

17. What is a search scope?
A search scope defines a subset of information in the search index. Users can select a search scope when performing a search.

18. What is query logging in SharePoint 2010?
Collects information about user search queries and search results that users select on their computers to improve the relevancy of search results and to improve query suggestions.

19. Please describe what a Service Application is in SharePoint 2010.
Service applications in SharePoint 2010 are a set of services that can possibly be shared across Web applications. Some of these services may or may not be shared across the SharePoint 2010 farm.

Examples are mentioned below:
Access Services
Business Data Connectivity service
Excel Services Application
Managed Metadata service
Performance Point Service Application
Search service
Secure Store Service
State service
Usage and Health Data Collection service
User Profile service
Visio Graphics Service
Web Analytics service
Word Automation Services
Microsoft SharePoint Foundation Subscription Settings Service

20. What is Access Services?
Allows users to edit, update, and create linked Microsoft Access 2010 databases that can be viewed and manipulated by using an internet browser, the Access client, or a linked HTML page.

21. What is Visio Services?
Allows users to share and view Microsoft Visio Web drawings. The service also enables data-connected Microsoft Visio 2010 Web drawings to be refreshed and updated from various data sources.

22.  What is Performance Point Services?
Allows users to monitor and analyze a business by building dashboards, scorecards, and key performance indicators (KPIs).

23. What is the Secure Store Service (SSS)?
A secure database for storing credentials that are associated with application IDs

24. What is Excel Services?
Allows sharing, securing, managing, and using Excel 2010 workbooks in a SharePoint Server Web site or document library. Excel Services consists of the Excel Calculation Services (ECS), Microsoft Excel Web Access (EWA), and Excel Web Services (EWS) components.

25. what is the difference between SQL clustering and mirroring?
Clustering provides a failover scenario whereby one or more nodes can be swapped as active depending on whether a node goes down. In mirroring, transactions are sent directly from a
principal database and server to a mirror database to establish essentially a replica of the database.

26.what are the monitoring features that are present in SharePoint 2010.
Diagnostic logging captures data about the state of the system, whereas health and usage data collection uses specific timer jobs to perform monitoring tasks, collecting information about:
Performance Counter Fata
Event Log Data
Timer Service Data
Metrics For Site Collections and Sites
Search Usage Data

27. Explain how connections are managed with Service Applications.
A virtual entity is used that is referred to as a proxy, due to label in PowerShell.


If you have 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, Thanks