SharePoint Apps vs Cloud Business Apps

Cloud Business Apps

Create Cloud Business Apps in Visual Studio

By using the Cloud Business App template in Visual Studio, you can quickly and easily create line-of-business apps that are hosted on SharePoint for Office 365 and based on Visual Studio LightSwitch technologies. Users can download and run cloud business apps on desktop computers and most mobile devices.

Understanding LightSwitch

Visual Studio LightSwitch is a development environment designed to simplify and shorten the development of businesses applications and data services. LightSwitch makes it easy to create data-centric business applications that can consume a variety of data sources and create clients that can run on a variety of devices. With LightSwitch you can:

  • Build HTML5-based apps that run on all modern devices
  • Consume and aggregate multiple data sources like databases, SharePoint and OData
  • Eliminate plumbing code and focus on what makes your application unique
  • Have flexible deployment and cloud hosting options including Azure and Office 365
  • Trust that your solution is built on best-of-breed technologies and practices

SharePoint Apps

Create Apps for SharePoint by using Visual Studio

By using Visual Studio, you can create apps for SharePoint, which are solutions that have a small footprint and that use standards-based technologies such as HTML5, JavaScript, and OAuth. You typically design one of these apps to help users complete a specific task or related set of tasks. For example, you can create an app to track travel expenses or maintain a team sign-up sheet.

What you can do in an app for SharePoint > Using SharePoint Components

Almost every major type of SharePoint component can be part of an app for SharePoint, including custom content types, list templates, list instances, pages, workflows, event handlers, and many more. You can also have built-in Web Parts, including a Silverlight Web Part that hosts a Silverlight application and an app part that wraps an IFrame.

refer to, http://sharepoint.stackexchange.com/questions/101661/sharepoint-apps-vs-cloud-business-apps

SharePoint 2016 CU installation failure: “The upgraded database schema doesn’t match the TargetSchema”

After installing CU for SharePoint 2016, “SharePoint 2016 Products Configuration Wizard” threw out error as follows,

An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: The upgrade command is invalid or a failure has been encountered.

Feature (Name = [w.package.my Feature1], Id = [0ee3c9fb-76bb-420c-82cd-52c59e2d3d7c], Description = [], Install Location = [w.package.my_packageFeature]) is referenced in database [WSS_Content_4198], but isn’t installed on the current farm. The missing feature might cause upgrade to fail. If necessary, please install any solution that contains the feature and restart upgrade.      (EventID:ajxkh)

Upgrade [SPContentDatabase Name=WSS_Content_4198] failed.       (EventID:an59t)

Exception: The upgraded database schema doesn’t match the TargetSchema  (EventID:an59t)

        (EventID:an59t)

Upgrade Timer job is exiting due to exception: Microsoft.SharePoint.Upgrade.SPUpgradeException: The upgraded database schema doesn’t match the TargetSchema

Just run the PowerShell script below:

Upgrade-SPContentDatabase WSS_Content_4198 -NoB2BSiteUpgrade -Confirm:$false

then re-run,

psconfig.exe -cmd upgrade -inplace b2b

OR one line PowerShell script,

Get-SPContentDatabase | ?{$_.NeedsUpgrade –eq $true} | Upgrade-SPContentDatabase -Confirm:$false

 

 

 

[Apps] Sorry, this app is not supported on your server.

To configure Internet-facing endpoints for apps

  1. In Central Administration, click Application Management.
  2. On the Application Management page, click Manage Web applications.
  3. On the Manage Web Applications page, select the web application that you want to change.
  4. On the ribbon, click Manage Features.
  5. In the feature list, next to Apps that require accessible internet facing endpoints, click Activate.
  6. Click OK.

How to add/ remove/ view SharePoint Event Handler (.dll) to the GAC

When you would like to install your event handler in the SharePoint Platform, I will suggest you using PowerShell.

To ADD a DLL to the GAC

  1. Set-location “your assembly location” | e.g. c:\tmp
  2. [System.Reflection.Assembly]::Load(“System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a”)
  3. $publish = New-Object System.EnterpriseServices.Internal.Publish
  4. $publish.GacInstall(“your assembly location”)  | e.g. c:\tmp\abcDLL.dll
  5. iisreset

To REMOVE a DLL to the GAC

Set-location “c:\tmp”
[System.Reflection.Assembly]::Load(“System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a”)
$publish = New-Object System.EnterpriseServices.Internal.Publish
$publish.GacRemove(“c:\tmp\w.package.h.dll”)
iisreset

To find the Version, Culture, and Public Key of the Assembly

([system.reflection.assembly]::loadfile(“c:\tmp\w.package.h.dll”)).FullName

GAC Folder is located at,

C:\Windows\Microsoft.NET\assembly\GAC_MSIL

Object Reference error when SharePoint PowerShell Snapin is added

Navigate to below directory:

%COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\16\CONFIG\POWERSHELL\Registration\

find SharePoint.ps1 file in this directory. Open it and add one line

[System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”)|Out-Null

before

Add-PsSnapin Microsoft.SharePoint.PowerShell

Timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

To enable TCP/IP for additional IP addresses:

  • Start SQL Server Configuration Manager
  • Open the node SQL Server Network Configuration
  • Left-click Protocols for MYSQLINSTANCE
  • In the right-hand pane, right-click TCP/IP
  • Click Properties
  • Select the IP Addresses tab
  • For each listed IP address, ensure Active and Enabled are both Yes.

SharePoint 2016 Site – “cannot save site as template”

If your site is a publishing site or have the publishing features activated(need to deactivate). I got the error message:

Sorry, something went wrong

… “Save site as template” action is not supported on this site.

TECHNICAL DETAILS

….

Solve,

  • visual studio

_web.SaveSiteAsTemplateEnabled = true;                    
_web.Update();

  • powershell

PS C:\Users\Administrator> $web = Get-SPWeb http://sharepoint:4198/psaP/mineProjs/
PS C:\Users\Administrator> $web.AllProperties[“SaveSiteAsTemplateEnabled”] = “true”
PS C:\Users\Administrator> $web.Update()

then we must access on the following URL directly,

/_layouts/savetmpl.aspx Or /_layouts/15/savetmpl.aspx