The schema version ( of the database WSS_Content_UROWNWEBAPP_TopLevel on UROWNDB01 is not consistent with the expected database schema version ( on UROWNFR1. Connections to this database from this server have been blocked to avoid data loss.

the stored procedure ‘dbo.proc_GetRunnableWorkItems’ is belong to admin_content

Recently, during SharePoint 2007 SP3 installation, we found this issue. It means the SP3 binaries are not installed properly in all the WebFront end servers. Ensure, that all the binaries are aligned equally. In my case, some idiot have installed SharePoint product in DB server, we missed the SP3 binaries are not required. Later we installed the SP3 in DB server.

Most of the architect won’t install the SharePoint product in Database server.


URL’s to Access SharePoint Pages

Here are some URL’s to access pages in SharePoint. These URL are helpful to save time and hassles of clicking many times to reach a speicfied page:

The URL’s are grouped based on the major functioanlity area:

Users and Permissions:

People and Groups: _layouts/people.aspx

Site Collection Admins: _layouts/mngsiteadmin.aspx

Advanced Permissions: _layouts/user.aspx

Master Pages: _Layouts/ChangeSiteMasterPage.aspx

Look and Feel:

Title, Desc, and Icon: _layouts/prjsetng.aspx

Navigation: _layouts/AreaNavigationSettings.aspx

Page Layout and Ste Templates: _Layouts/AreaTemplateSettings.aspx

Welcome Page: _Layouts/AreaWelcomePage.aspx

Tree View: _layouts/navoptions.aspx

Top Nav Bar: _layouts/topnav.aspx

Site Theme: _layouts/themeweb.aspx

Reset to Site Definition: _layouts/reghost.aspx

Searchable Columns: _Layouts/NoCrawlSettings.aspx

Site Content Types: _layouts/mngctype.aspx


Site Columns: _layouts/mngfield.aspx

Site Templates: _catalogs/wt/Forms/Common.aspx

List Templates: _catalogs/lt/Forms/AllItems.aspx

Web Parts: _catalogs/wp/Forms/AllItems.aspx

Workflows: _layouts/wrkmng.aspx

Master Pages and Page Layouts: _catalogs/masterpage/Forms/AllItems.aspx

Regoinal Settings: _layouts/regionalsetng.aspx

Site Administration

Site Libraries and Lists: _layouts/mcontent.aspx

Site Usage Report: _layouts/usageDetails.aspx

User Alerts: _layouts/sitesubs.aspx

RSS: _layouts/siterss.aspx

Search Visibility: _layouts/srchvis.aspx

Sites and Workspaces: _layouts/mngsubwebs.aspx

Site Features: _layouts/ManageFeatures.aspx

Delete This Site: _layouts/deleteweb.aspx

Site Output Cache: _Layouts/areacachesettings.aspx

Content and Structure: _Layouts/sitemanager.aspx

Content and Structure Logs: _Layouts/SiteManager.aspx?lro=all

Search Settings: _layouts/enhancedSearch.aspx

Site Collection Administration

Search Scopes: _layouts/viewscopes.aspx?mode=site
Search Keywords: _layouts/listkeywords.aspx

Recycle Bin: _layouts/AdminRecycleBin.aspx

Site Collection Features: _layouts/ManageFeatures.aspx?Scope=Site

Site Hierachy: _layouts/vsubwebs.aspx

Portal Site Connection: _layouts/portal.aspx

Site Collection Audit Settings: _layouts/AuditSettings.aspx

Site Collection Policies: _layouts/Policylist.aspx

Site Collection Cache Profiles: Cache%20Profiles/AllItems.aspx

Site Collection Output Cache: _Layouts/sitecachesettings.aspx

Site Collection Object Cache: _Layouts/objectcachesettings.aspx

Variations: _Layouts/VariationSettings.aspx

Variation Labels: _Layouts/VariationLabels.aspx

Translatable Columns: _Layouts/TranslatableSettings.aspx

Variation Logs: _Layouts/VariationLogs.aspx

Site Settings: _layouts/settings.aspx

When you are making changes to the documents inside the Document Library.

You will be facing error as,

“You must fill out all required properties before checking in this document.”

  • If you are uploading a file to a library that requires certain file properties to be filled out, and those properties are missing, the file remains checked out to you. When you fill out the required properties, you can check in the file.
  • If you are uploading a file to a library that requires files to be checked out, the file is initially checked out to you. You must check in the file before other people can edit it.

The changes like, renaming the document, changing the owner and properties are not allowed. To overcome from this issue, goto Document and library settings, goto Columns(under General Settings), Click into column, change the Properties as Hidden or Optional or Not required.

Now you can make changes to the file properties.

The flavors(Edition) in SP 2013 are,

  • SharePoint Foundation 2013 *(F)
  • SharePoint Server 2013 Standard *(S)
  • SharePoint Server 2013 Enterprise *(E)

Annotation used are F, S, E

The differences among the flavors are,

Access Services (E),

AD Sync (S, E),

Config wizard (S, E),

Multimedia Support (S, E),

Cloud Support (E),

Video Search (E),

Group of Insights Feature available only in Enterprise Edition,

Search Features (~F, (S, E)),

Sites features (S, E),

Social features (S, E)

To check the SP product version –

Start -> All Programs -> Microsoft SharePoint 2013 Products -> SharePoint 2013 Management Shell

>> Use the command “Get-SPProduct” to get the details.

To Check the status of already installed Product and Patch status.

Using SharePoint Central Administration Web site, under Upgrade and Migration, click Check product and patch installation status

>> Use the Windows PowerShell command, (get-spfarm) to get the details.

STSADM.EXE -o enumsites -url http://contoso.mysp.com > c:\results.xml

 The above command will output an XML document showing the list of site collections, the content database where they live, the size of the site collection in megabytes, etc

SharePoint logging and ULS

SharePoint issues we can make use of the SharePoint Unified Logging System or in short: ULS logs.

Default Location ULS log:

SPS2007 – C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS

SPS2010 – C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS

SPS2013 – C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\LOGS

Link to download:- http://ulsviewer.codeplex.com/

SharePoint 2010 introduced some new features with regards to trace logs like Correlation ID’s, 
Will discuss later on this.