Tuesday, October 14, 2014

Method 'get_IsClientValid' in type 'Microsoft.SharePoint.WorkflowServices.WorkflowServiceApplicationProxy' from assembly 'Microsoft.SharePoint.WorkflowServices, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' does not have an implementation

Error:
Method 'get_IsClientValid' in type 'Microsoft.SharePoint.WorkflowServices.WorkflowServiceApplicationProxy' from assembly 'Microsoft.SharePoint.WorkflowServices, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' does not have an implementation

(Or)

SharePoint 2013 SP1 failed to install.

(Or)

Getting error when you are trying to create a new web application in central admin

Reason:
You will get this error, after you tried to install "SharePoint server 2013 Service Pack 1 (officeserversp2013-kb2880552-fullfile-x64-en-us.exe)

The reason is there would not be enough space in the "C" drive.

Solution:
Keep minimum of 3 GB in C drive and install the SharePoint server 2013 SP1 from http://www.microsoft.com/en-in/download/details.aspx?id=42544

Your Service pack will continue to install now without any issues. Also you will not get the above mentioned issues.

That's it...



Monday, October 13, 2014

Apps are disabled on this site.

Error:

 ErrorDetail: Apps are disabled on this site.
        ErrorType: Configuration
        ErrorTypeName: Configuration
        ExceptionMessage: Microsoft.SharePoint.SPException: Apps cannot be installed. Review the diagnostic logs for more details regarding app deployment failures.
   at Microsoft.SharePoint.Utilities.SPUtility.ThrowSPExceptionWithTraceTag(UInt32 tagId, ULSCat traceCategory, String resourceId, Object[] resourceArgs)
   at Microsoft.SharePoint.Packaging.SPUserCodeSolutionDeploymentGroup.Deploy()
   at Microsoft.SharePoint.Administration.SPAppTask.DeployOperation()
   at Microsoft.SharePoint.Lifecycle.MonitoredTaskExecution.DoTask()
        Source: AppWeb
        SourceName: App Web Deployment
Error occurred in deployment step 'Install app for SharePoint': Failed to install app for SharePoint. Please see the output window for details.


Reason:
You will get this error when you are trying to deploy your SharePoint 2013 "app" through visual studio.The reason behind this error is you might not created the "App domains" for your application.

Solution:
To create the "App domain",  please refer my another post in the below URL:

http://sensoft2000-sharepoint.blogspot.in/2014/10/the-subscription-settings-service-and.html


Thats it...



The Subscription Settings service and corresponding application and proxy needs to be running in order to make changes to these settings.

Error:

The Subscription Settings service and corresponding application and proxy needs to be running in order to make changes to these settings.

Reason:
You will get this error when you are trying to create the "App URL" through "Configure App URLs" in central admin.

Solution:

  • First you need to provide the "db creator" role for the specific user which you are going to use for the "Subscription service"
  • Then you need to enable the "Subscription service" ONLY  through the below PowerShell script. (Replace your actual values in the highlighted areas)

$account = Get-SPManagedAccount domainname\username
$appPool = New-SPServiceApplicationPool -Name SubscriptionServiceAppPool -Account $account 
$serviceApp = New-SPSubscriptionSettingsServiceApplication -ApplicationPool $appPool -name "Subscription Settings Service Application" -DatabaseName "SP2013DEV-SubscriptionSettingsDB
$serviceAppProxy = New-SPSubscriptionSettingsServiceApplicationProxy -ServiceApplication $serviceApp


  • Then go to Application management  --> Manage services on the server  and start the "Microsoft SharePoint Foundation Subscription Settings Service" service
  • Then click the "Apps" in the left navigation and click the "Configure Apps URLs" and your error will not be displayed there

Error occurred in deployment step 'Uninstall app for SharePoint': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.

Error:
Error occurred in deployment step 'Uninstall app for SharePoint': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.

Reason:
some of the core databases in your SharePoint SQL server does not have the enough access rights for the "currently logged-in" user. You must provide "db_owner" for them.

Solution:
You need follow the steps which i was published in the year 2011.
URLhttp://sensoft2000-sharepoint.blogspot.in/2011/07/error-occurred-in-deployment-step.html


Thats it...

Sunday, October 5, 2014

How to Shrink WSS_Logging Database?

Issue:
SharePoint 2010/2013 always fill the "WSS_Logging.mdf" file continuously. If you are trying to shrink or empty the ".mdf" or ".ldf" files, you will not be able to shrink them.

Follow the below steps to shrink them immediately.

Solution:
1. Open a new Query window by right clicking the "WSS_Logging" database.
2. Paste the below query and execute it which will empty the unwanted contents from database.

DECLARE @TableName AS VARCHAR(MAX)
DECLARE table_cursor CURSOR
FOR 
SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME LIKE '%_Partition%'
OPEN table_cursor
FETCH NEXT FROM table_cursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @SQLText AS NVARCHAR(4000)

SET @SQLText = 'TRUNCATE TABLE ' + @TableName

EXEC sp_executeSQL @SQLText

FETCH NEXT FROM table_cursor INTO @TableName 
END
CLOSE table_cursor
DEALLOCATE table_cursor


3. Once the above is query executed, your SQL DB is ready to shrink. (If the above query is not executed, then you will not be able to shrink the "WSS_Content.mdf" file.

4. Now right click on the database and go to the "shrink window" as mentioned below and shrink the DB to "50 MB".

























5. Now the DB size would be re-sized to 50 MB.

Thats it...