Enable Chart Web Part in SharePoint 2013

The SharePoint Chart Webpart was deprecated. But its still available in 2013.

Steps:

  1. Login to any farm server hosting SharePoint as a Site Collection Administrator.
  2. Go to: Settings > Site Settings > Go to top level site settings > Web Designer Galleries > Web parts.
  3. Click the FILES tab.
  4. Click New Document.
  5. Scoll down the list and look for: Microsoft.Office.Server.WebControls.ChartWebPart.
  6. Check this item.
  7. Scroll back up to the top, and then click the Populate Gallery button.
  8. Wait for it to refresh.
  9. Scoll down the list and look for: ChartWebPart.webpart.
  10. Click its Edit button.
  11. Enter the value, Content Rollup, or enter any other web part group value appropriate to your needs.
  12. Click Save.
  13. That’s it.  The next time you open a web page in edit mode and search for a web part to add to it, you’ll see the Chart web part there.

Search Host Controller Service ‘Starting’ does not start

I’ve tried everything from Registry Permissions to unprovisioning search and recreating search. Finally i found the solution. Do not use port 808 for any Web App. Apparently Windows Communication Foundation Service uses port 808 and Search SP 2013 Host Controller uses WCF.

 ULS logs had “Could not connect to net.tcp://server/ceres/hostcontroller/nettcp” …. and “connected host has failed to respond XX.XXX.XXX.XX:808”

I had to extend that site to another port then delete the IIS Web app that was using port 808.

SharePoint 2013 BI on mobile devices

We can build our mobile BI solutions based on SQL Server as a data source in the following (different) ways:

  • IIS (Internet Information Services; as a very low cost solution): SSRS (SQL Server Reporting Services; note: limited use for the Apple platform, details are described below)
  • SharePoint Server: Excel Services (easier solutions), SSRS integrated mode, PerformancePoint Services (much more complex solutions)
  • OWA Server (Office Web Apps): Excel
  • 3rd party developer tools/platforms or ready-to-use solutions

In a few bullets below, there are described the results of my investigation about some possibilities for mobile BI solutions based on the SQL Server platform.

Mobile BI (iPad/iPhone, Android, Windows 8/Phone devices) platform:

1. IIS:

  • SSRS:
  • iPad: Safari/Chrome/Opera – NO,  FF/IE – not supported
  • Android: FF – OK, Chrome/Opera – NO, Safari/IE – not supported
  • Windows 8: IE – OK, alternative – FF, Chrome/Opera – NO, Safari – not supported on tablet?

 

2. SharePoint 2013:

  • Excel Services:
    • iPad: Safari – OK (note: slicers – OK), alternatives – Chrome/Mercury (Chrome and Firefox alternative), Opera – NO, FF/IE – not supported
    • Android: FF – OK (note: slicers – NO), Chrome/Opera/(Built-in Browser/Dolphin) – NO, Safari/IE – not supported
    • Windows 8: IE – OK, alternatives – FF/Chrome/Opera, Safari – not supported
  • PerformancePoint Services (Dashboards):
  • OLAP/Excel Services:
    • iPad: Safari – OK (note: slicers – OK), alternatives – Chrome/Mercury (Chrome and Firefox alternative), Opera – NO, FF/IE – not supported
    • Android: FF – OK (note: slicers – NO), Chrome/Opera/(Built-in Browser/Dolphin) – NO, Safari/IE – not supported
    • Windows 8: IE – OK, alternative – FF, Chrome/Opera – OK (note: zoom – NO), Safari – not supported
  • SSRS:
    • iPad: Safari/Chrome/Opera – NO, Mercury (Chrome and Firefox alternative) – NO, FF/IE – not supported
    • Android: FF – OK, Chrome/Opera/(Built-in Browser/Dolphin) – NO, Safari/IE – not supported
    • Windows 8: IE – OK, alternative – FF, Chrome/Opera – NO, Safari – not supported on tablet?
  • PowerPivot/PowerView: the output is rendered in Silverlight
    • iPad: SL – not supported on iOS (note: SL is available only for Windows and Mackintosh)
    • Android: SL – not supported
    • Windows 8: IE – OK, alternatives – FF/Chrome/Opera (note: scroll – NO), Safari – not supported

 

Manage User Profiles, no dropdown menu to edit profile

There was no option to edit user profiles. Under Manage User Profiles. The result of users would be listed, but the menu dropdown to edit was not visible. Profile properties also had the same issue. Properties did not have a menu option to edit.

Solution: Add Central Admin to IE 11 compatibility view settings in the browser. Seems IE 11 is not compatible with SharePoint 2013 Central Admin.

 

Sign as Different User in 2013

To add the option to sign in as a diff user in 2013 follow these steps:

Locate the file \15\TEMPLATE\CONTROLTEMPLATES\Welcome.ascx

 

Add the following element before the existing element with the id of “ID_RequestAccess”:

<SharePoint:MenuItemTemplate runat=”server” ID=”ID_LoginAsDifferentUser” Text=”<%$Resources:wss,personalactions_loginasdifferentuser%>” Description=”<%$Resources:wss,personalactions_loginasdifferentuserdescription%>” MenuGroupId=”100″ Sequence=”100″ UseShortId=”true” />

 

 

Save the file.

Do on each WFE. careful updating hive files. any updates will overwrite your changes…

enjoy!

 

 

SharePoint 2013 workflow HTTP Unauthorized error

I was able to create and publish a 2013 workflow. I created a simple workflow that only added comments to the workflow history. So it should work… but I kept getting this error:

HTTP Unauthorized to http://sitename/_vti_bin/client.svc/web/lists/getbyid(guid’guid’) Correlation Id: id Instance Id: id

I tried everything. After going thru the logs I noticed an error .pdf” is not checked out.  You must first check out this document before making changes.

So I disabled “Require Check Out to edit” and workflow was able to update the status and completed successfully

 

 

SharePoint 2013 Crawl Access Denied Error

I usally can fix these crawl errors fast. DisableLoopbackCheck, Check Web App permissions, check DB permmisions…

But all was configured correctly. All other web apps were being index and running smooth. I just had one web app that would not get indexed. I even deleted the web app and recreated the site since it was a QA server.

Even the logs were not very clear. Just some access denied to robots.txt. I dont even use robot.txt files…

After many hours i decided to ping the FQDN and that when i noticed the issue. Someone in Networking team created the DNS as a C-Name alias. Which means it would return the name of the computer and not the proper name. It was also pointed to an incorrect WFE server.  Once they changed it to a A- Record DNS Search was able to index.

BI Resources and Links

Here’s a list of blogs that has helped me configure Power Pivot for SharePoint 2010 and 2013

SharePoint 2013 Kereberos setup http://blog.blksthl.com/2012/09/26/the-first-kerberos-guide-for-sharepoint-2013-technicians/#step4

Installing 2013 BI features : http://blogs.msdn.com/b/querysimon/archive/2012/11/26/installing-the-bi-features-of-sharepoint-2013.aspx

Installing 2010 BI features: http://blog.cloudshare.com/2012/05/22/step-by-step-guide-to-installing-sharepoint-with-sql-2012-powerpivot-powerview-and-reporting-services/

another 2010 BI blog: http://blogs.msdn.com/b/karang/archive/2012/04/13/step-by-step-guide-of-installing-power-view-with-powerpivot-2012.aspx

Notes: things get tricky in a multi server farm. the SQL install will have all the features needed for SharePoint. For SharePoint 2013 there is a spPowerPivot.msi you can use on the WFEs instead of the SQL server install.

1 2