Archive for November, 2014

You will be facing this error in website screen,

Report Server has encountered a SharePoint error. —> Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. —> Microsoft.SharePoint.Upgrade.SPUpgradeException: An error has occurred on the server.http://go.microsoft.com/fwlink?LinkID=96177 —> System.Exception: 

and another in inner exception error in SSRS logs

library!ReportServer_0-1!1fd4!11/14/2014-03:43:21:: Call to GetSystemPropertiesAction().

library!ReportServer_0-1!1fd4!11/14/2014-03:43:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: , Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. —> Microsoft.SharePoint.Upgrade.SPUpgradeException: An error has occurred on the server.http://go.microsoft.com/fwlink?LinkID=96177

at Microsoft.SharePoint.Administration.SPContentDatabase.ValidateDatabaseSchemaCompatibility()

at Microsoft.SharePoint.SPSite.PreinitializeServer(SPRequest request)

at Microsoft.SharePoint.SPWeb.InitializeSPRequest()

at Microsoft.SharePoint.SPWeb.EnsureSPRequest()

at Microsoft.SharePoint.SPWeb.get_Request()

at Microsoft.SharePoint.SPWeb.InitWebPublic()

at Microsoft.SharePoint.SPWeb.get_ServerRelativeUrl()

at Microsoft.SharePoint.SPWeb.get_Url()

at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpWeb.get_Url()

at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemMetaDataAndContent(ItemSpecifier itemSpecifier, UserContext userContext, Boolean returnContent, Byte[]& content)

at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.InternalCheckAccess(UserContext userContext, ExternalItemPath itemPath, RSSPBasePermissions requiredRights)

at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.CheckAccess(UserContext userContext, ExternalItemPath path, CatalogOperation requiredOperation)

at Microsoft.ReportingServices.Library.GetSystemPropertiesAction.PerformActionNow()

at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()

— End of inner exception stack trace —;

If your SSRS reports are not working in SharePoint site, identify in which DB server it is installed – Check the MOSS ServicePacks are installed correctly in that particular report server, if not install it again.

Because, Microsoft.SharePoint.Administration.SPContentDatabase.ValidateDatabaseSchemaCompatibility() means the binaries of schema is not compatible –  so identify the Service Pack with other web server and align it as equal to that server, if not install the Service Pack binaries again.

Stop the SSRS service, stop the IIS

then, start the SSRS and start the IIS too.

Before try above option, execute –

  • psconfig -cmd upgrade -inplace b2b –wait

Check now the SSRS reports are working now 🙂


Read Full Post »

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.

Read Full Post »

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

Read Full Post »