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...

Sunday, September 28, 2014

AppFabric1.1-RTM-x64 not found or this package does not contain compatible update.

Error:
AppFabric1.1-RTM-x64 not found or this package does not contain compatible update.

Reason:
You will get this error when you are trying to install the Windows Server AppFabric v1.1 CU1[KB 2671763] directly on SharePoint 2013 server.

Solution:
Before trying to install this Windows Server AppFabric v1.1 CU1, you need to install the "Windows Server AppFabric". After installing the AppFabric, if you try to install the CU, you will not get this error.

Also make sure that the below services are in "Running" state in the server.

  1. Windows Update service
  2. Windows Firewall service
If you are facing any difficulty on installing Appfabric, please refer my other posts in this blog.




That's it...



Another Appfabric installation error due to PSModulePath

Error:

Product: AppFabric 1.1 for Windows Server -- Error 1722. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor.  Action Env_PSModulePath_powershell_i, location: C:\Program Files\AppFabric 1.1 for Windows Server\Microsoft.ApplicationServer.InstallHelper.exe, command: powershell.exe "-command \"$str = [System.Environment]::GetEnvironmentVariable(\\\"PSModulePath\\\",[System.EnvironmentVariableTarget]::Machine); $str = $str+\\\";C:\Program Files\AppFabric 1.1 for Windows Server\PowershellModules\\\"; C:\Windows\system32\setx.exe /MPSModulePath \\\"$str\\\"\"" "C:\Users\senthil\AppData\Local\Temp\AppServerSetup1_1_CustomActions(2014-09-28 20-02-35).log"

 (Or)
Unable to proceed the installation after restarting the Server by AppFabric.


Reason:

You will this error during the installation of Appfabric service in SharePoint server 2013. You need to fix 2 issues. 
  1. Need to update the "PSModulePath" in the environment variable section
  2. Enable the "Windows Firewall" service

Solution:

1. "PSModulePath" in the Environment variable will have extra double quote (") at end of the value. Appfabric installation will not be able to parse the value, if it contains the double quote. So we need to remove that additional character.   Follow the below screenshots to remove the extra double quote character






























2. One more important thing is, we need to enable to the "Windows firewall" service which is mandatory for Appfabric to complete its full installation. Because

Appfabric will try to add few entries in the Windows firewall.  See the below screenshot for more info.

(This second one has killed me a lot)