Skip to main content

Posts

Showing posts from 2016

Add-SPSolution : Operation is not valid due to the current state of the object.

Add-SPSolution : Operation is not valid due to the current state of the object. At line:1 char:1 + Add-SPSolution + ~~~~~~~~~~~~~~ + CategoryInfo : InvalidData: (Microsoft.Share...dletAddSolution: SPCmdletAddSolution) [Add-SPSolution], InvalidOperationException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletAddSolut Ion I have received this error when I’m trying to deploy an .wsp file to the SharePoint farm using PowerShell Scripts. It’s kind of unusual the error I have got but IIS reset Solved my problem.

Default SharePoint 2013 / 2010 System Pages where you should takecare when you go online

There are list of SharePoint System Pages which inheriting view permission by default. If you are going to make public SharePoint site , you might not want to access these pages by anonymous users or by Form Based Authentication User. There are may ways to restrict the users access to these pages that I will explain later in a different post. Below I’m listing down pages ; those are available in each site under layout mapping. Site Collection and Site Level Recycle Bin Urls /_layouts/15/AdminRecycleBin.aspx /_layouts/15/RecycleBin.aspx User , User Info , Site Permission related Urls _layouts/15/permsetup.aspx This is used to create default groups in SharePoint such as visitors, members and owners. /_layouts/15/people.aspx?MembershipGroupId=0 All People Url , This can be even used to delete users from the site collection User Information Hidden List Urls /_catalogs/users/detail.aspx /_catalogs/users/simple.aspx These lists are actually available from previous version of SharePoint

Office Web Apps Not Showing Review Tab in SharePoint 2013

I’m used to do my developments are testing for SharePoint Apps in SharePoint Online rather than using OnPrem deployment singe its easy. But I suddenly found out Office Web Apps on my On Premise environment not showing Review tab on Word Documents which SharePoint Online does. When I searched through the root cause, I have found out OnPrem updates are little bit behind the O365 updates. Apart from Review tab there are few other functionalities missing in OnPrem version. Following list down the current available updates for Office Web Apps. 15.0.4420.1007 RTM  15.0.4481.1005 March 2013 PU         KB2760445 15.0.4481.1508 April 2013 CU         KB2810007 15.0.4505.1001 April 2013 Hotfix     KB2799821 15.0.4517.1003 June 2013 CU         KB2817350 15.0.4535.1000 August 2013 CU         KB2817521 15.0.4551.1003 October 2013 CU         KB2825686 15.0.4551.1508 December 2013 CU     KB2850013 ​15.0.4551.1515 ​MS14-001 Security Update ​KB2863879 ​15.0.4569.1000 ​Service Pack 1 ​        KB2817431

SharePoint 2013 Automatically Redirects to another Mapping

  There are multiple reason for this behavior of your sharepoint farm. exclusing all other DNS mapping and firewall and proxy configurations there might be a problem in SharePoint Access mapping that will cause the this behaviour. Furthur descrbing the issue… when you type http://abc.company.ae it may redirect to http://d.company .ae ; the second address also you wanted and imagine its in AAM. This behaviour is tottaly because of Aulternate Acess mapping , where you have put abc.company.ae and d.company.ae in same default zone in Alternate Access Mapping. so just delete one entry from Default Zone and put it to another Zone.

Email option in Delivery Extension is not available in SharePoint 2013 integrated Mode

As you already know Report Server can be run either in Native mode or SharePoint integrated mode. Report server has feature of scheduling subscriptions for your reports. Report Subscription allows you to schedule your reports to deliver to recipients. There are few Delivery mechanisms available in SharePoint. Windows File Share Email SharePoint Document Library Null Delivery Provider There might be a situation that you cannot find the Email option in the list. What you need to do is configure Email in Report Server Application. How to Configure Email server for reporting server Go to Central admin and then go to Manage Service Applications Then find the related Reporting Server Service Application and click on SQL Server Reporting Services Service Application Then go to Email Setting Section And Enter you SMTP server details. And save the settings. Now you can find the Email delivery option in the subscription settings.

Customize PageNotFoundError.aspx

PageNotFoundError.aspx is a SharePoint default Error page which is resides on <SharePointrl>/pages library. http://<SharePoint>/Pages/Forms/AllItems.aspx As you can see it is by default using Layout called Error. If you want to edit the exiting page you can simply check out and Edit the page in the browser. If you can want to change the Layout you can change the Page Layout out by editing the page layout. If you are good at PowerShell scripts, you can Update the custom page Url in Site Collection property. $spsite = Get-SPSite “http://<SharePoint>” $spsite.FileNotFoundUrl = “/pages/myerror.aspx“

How to filter SharePoint list Based in Date Time related functions in SharePoint 2013 using REST/ODATA

REST queries are quiet familiar when you are working with SharePoint Apps and SharePoint development. I have found quiet difficult to pass the Date Time parameter to REST and took few minutes to figure that out. There are two ways to end points to access list data. http://<SharePoint Url>/_api/web/lists/getbytitle('Pages')/items? http:// <SharePoint Url>/_vti_bin/listdata.svc And these functions are working only on listdata.svc These are few example of REST queries which uses Created Column as a sample field.   Filter using day () function http:// <SharePoint Url>/_vti_bin/listdata.svc/<listname>?$filter = day(Created) eq 2   Filter using month () function http:// <SharePoint Url>/_vti_bin/listdata.svc/<listname>?$filter = month (Created) eq 2   Filter using year () function http:// <SharePoint Url>/_vti_bin/listdata.svc/<listname>?$filter = year (Created) eq 2   Filter using hour () function http:// <SharePoint

Working with SharePoint Report Server 2012 using URL parameters in SSRS 2008/2012 in SharePoint Integrated Mode – Part Two

In my previous post I have explained how to pass the custom URL parameter to the Report when it is SharePoint Integrated Mode. As explained earlier post report server parameter has three parts. <prefix>:<Parameter Name>= <Value>   Parameter Type Prefix Note Report Viewer Control rc: Report Server HTML controller Report Server rs: Report Server to process Report Viewer Web Part rv: Web part parameters Report Parameters rp: Report parameters (Explained in Part One) When you are running the Report Server under SharePoint, You can Access the report Server using /_vti_bin/reportserver. You can find similar page if report server is running.   rc: This is for passing parameters to Report Server HTML viewer. Here are the list of parameters. rc:Parameters rc:Zoom rc:Section rc:FindString rc:StartFind rc:EndFind rc:FallbackPage rc:GetImage rc:Icon rc:Stylesheet EX: - http://mysharePoint/_vti_bin/ reportserver?<Document Li

SharePoint 2013 Web site Keep on Prompting for credentials

There are many reasons to happen this but most of the time it will happen when you change the Access mapping to match your domain. For an example you might have webwfe01 as your web application in your default zone. And if you change that to www.sampleweb.com this may be occurred for Windows Users. This is because by not having Fully Qualified Domain name specified is not matching with the local machine. For an Example, Your local machine can be in a domain myorg.com and the specified Mapping is sampleweb.com Thus this will cause LoopBack check which it true by design for security reasons. Microsoft specifies two methods to resolve the issue. Disable Strict Name Checking [ Ref ] Disable Loopback Check [ Ref ] REF: https://support.microsoft.com/en-us/help/896861/you-receive-error-401.1-when-you-browse-a-web-site-that-uses-integrated-authentication-and-is-hosted-on-iis-5.1-or-a-later-version You need to do it all SharePoint servers for safe side in the future service deploymen

How to filter SharePoint list Based in Date Time in SharePoint 2013 using REST/ODATA

REST queries are quiet familiar when you are working with SharePoint Apps and SharePoint development. I have found quiet difficult to pass the Date Time parameter to REST and took few minutes to figure that out. These are few example of REST queries which uses Created Column as a sample field. Filter Greater than Date http://<sharepointurl>/_api/web/lists/getbytitle('Pages')/items?$filter=Created gt dateTime '2017-03-03T00:00:00Z' Filter Less than Date http://<sharepointurl>/_api/web/lists/getbytitle('Pages')/items?$filter=Created lt dateTime '2017-03-03T00:00:00Z' Filter Equal Date http:// <sharepointurl>/_api/web/lists/getbytitle('Pages')/items?$filter=Created eq dateTime '2017-03-03T00:00:00Z' Filter Between Dates http:// <sharepointurl>/_api/web/lists/getbytitle('Pages')/items? $filter=( Created gt dateTime '2016-03-03T00:00:00Z' and Created lt dateTime'2017-03-03T00:00:00Z&

'C:\inetpub\wwwroot\wss\VirtualDirectories\80\_app_bin\Microsoft.SharePoint.WorkflowServices.ApplicationPages.dll' because it is being used by another process.

'C:\inetpub\wwwroot\wss\VirtualDirectories\80\_app_bin\Microsoft.SharePoint.WorkflowServices.ApplicationPages.dll' because it is being used by another process. I have received this error when I’m trying to create a Web Application in central admin. I did a IIS reset and tried again and it worked. But when I tried again I got the same error after Restarting the Server it went off fully.

Disable Loopback Check in IIS

This is use full in many scenarios. For me it’s more use full for disable keep on prompting credentials in SharePoint 2013 Environment. In this method you can simply disable the check by editing the following registry key. Open the RegEdit. And navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa Click on Lsa Registry and add DisableLoopbackCheck registry key as DWORD value. After adding the registry key you can find the entry as follows. Then double click the key and Enter 1. And click OK. Then restart the IIS.

System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’.

  This error occured to me when im trying to access the Manage Processing Oprions in SharePoint SSRS. “ An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. —> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. —> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’ .” Cause is configurations isses and provisioning issues of Reporting Server User on Related Databases (Master , SSRS) You can resolve the issue by re run the script on your database server. For that you can downlod the report from the Central Admin by Application Management  ->  Manage service applications Then go to Reporting server service app

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

  This error occured to me when i triyng to connect to a SQL database from SharePoint App which is use Entity Framework. This is a timeout issue when app is trying to connect to a SQL database and connection was expired before execution. I simply connected it adding a Coonection Timeout to the connection string. <add name="dbtemponeEntities" connectionString="metadata=res://*/DataModels.dbtempone.csdl|res://*/DataModels.dbtempone.ssdl|res://*/DataModels.dbtempone.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=ASQL;initial catalog=dbtempone;persist security info=True; Connection Timeout=120 ;user id=SQLAdmin;password=*****$so;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Dissable paging in SSRS Reports on SharePoint 2013

  I have a problem with showing a entire report (without page brakes) in the SharePoint with the ssrs integrated mode. I have tried many options and nothing work but changing the Height of the InteractiveSize to 0 worked for me

Disable Strict Name Checking in IIS

This is use full in many scenarios. For me it’s more use full for disable keep on prompting credentials in SharePoint 2013 Environment. In this method you need to add your domain as an exception list to IIS for not checking the FQDN for loopback. Open the RegEdit. And navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa and click on MSV1_0 Then add new Multi Connection String And add BackConnectionHostNames Then you will see that is added to the registry. You can double click and add your fully qualified domain names (One per line) that will be working as an exception. Then you can save and restart the IIS.

Working with SharePoint Report Server using URL parameters in SSRS 2008/2012 in SharePoint Mode – Part One

There is a slightly different between earlier SSRS report parameters and NEW SSRS running in SharePoint server 2013. URL parameters are slightly different from native mode and SharePoint Mode. This article is only about SharePoint mode parameters. SSRS running on SharePoint has few parameter types and types are passing to SSRS engine using prefix.   Parameter Type Prefix Note Report Viewer Control rc: Report Server HTML controller Report Server rs: Report Server to process Report Viewer Web Part rv: Web part parameters Report Parameters rp: Report parameters Most of the time passing parameters to report is more frequently used than any other Passing the Reports as a URL Parameter Assume that we have created a Report with parameter interval and need to pass the values from the URL. Let’s see the attributes of the @interval parameter. I have mentioned the visibility as visible but you can also have it as Internal as well. Internal will not be visi

Report Server has encountered a SharePoint error. in SharePOint 2013

Report Server has encountered a SharePoint error. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: The user does not exist or is not unique. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors in SharePOint 2013 This is error accouring because of Anonimous access to the Microsoft Reporting Services. According to the Microsoft ; Microsoft Reporting Service not supporting annonimous access for integrated mode. Ref: https://msdn.microsoft.com/en-us/library/bb283324.aspx#Anchor_4 So you might be wondered how you can archive this. Option One Simply you can dissable the Anonimous access from IIS. But this wont work if you really want anonimous access in your farm. For an Example If are hosting internet site with integration mode public reports you can not dissable the anon