Dataweave - 10 quick functions

Read through this blog which has 10 useful functions(substring, reverse string, flatten, floor/ceil and other string operations) that can be used in Dataweave

SharePoint Online Migration API's - New

Please read through the new article here, which describes the new way to upload content to SharePoint Online.

This might be useful to you!!!

SSRS - Display fixed number of rows per page with report headers.

For one of our KPI report hosted on SharePoint, the users want to have fixed headers when they use horizontal scroll. We tried to use the OOTB features(Fixed data=True) but it does not work out properly for us. Hence decided to have fixed number of rows per page and show the headers in each page.

It was decided to have 10 rows per page. I followed what is given in this blog. The downside of it , the headers were visible only in the first page and the subsequent pages did not show the headers. So found a work around which is to add group header while performing step 1 of that blog.

I copied and pasted the report header as the group header and deleted the report header. Then followed the subsequent steps as given in the blog. Now all the pages had headers with fixed number of rows.

Hope this helps you!!!

Local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.

One of my newly joined team member was getting this error on his powershell editor. Following has been done to fix this.

Log on to the DB server choose the SharePoint Config DB -> provide the user with the following membership SharePoint_Shell_Access and db_owner. 

Hope this helps you!!!

SiteActions menu is not displaying properly

After we deployed a WSP in our production SP 2010 farm, one of our application did not show Site actions menu properly.

We tried the following steps

1) We checked the WSP\code thoroughly and could not find anything.
2) Checked the permissions of all the users and could not find anything.
3) Retracted the new WSP and deployed the backed up WSP(As a process we always take a backup of  WSP's). It did not work.
4) Checked all other production applications, they did not have any issues.
5) Checked Central Administration -> Manage Content Database Settings , the database was not offline.
6) Checked Central Administration -> Site Collection Quotas and Locks and found that the DB was set to ReadOnly. Removed the lock status and Site Actions menu started showing up.

I hope this helps you!!!

SSRS Parameters\Filters should be displayed only in print.

My business users wanted to display parameters(Country, Street, Phone) on the page header only when it is printed and they do not want to show it while rendering the SSRS report.

To achieve this I did the following

1) Inserted a rectangle in the page header and added the parameters.
2) In the rectangle properties -> Visibility -> Enable Show hide based on an expression.
3) In the expression window add the following expression and save the report.

=IIF(Globals!RenderFormat.Name = "IMAGE", False, True)

Thus the country, street and phone parameters are shown only during print and they are not shown during report rendering.

Hope this helps!!!

Could not load file or assembly 'RSSharePointSoapProxy' - Solved

The error showed something to do with Reporting services and check that under general settings of CA. The following application setting was missing.

Then found that we need to downloaded and install "Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft SharePoint® Technologies 2010"  . Did the same and then the problems seems to be fixed. Hope this helps you!!!

The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded.

After I installed SSRS on SharePoint integrated mode, when I tried to configure SSRS using configuration manager I got the following error.


The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Objects.RSSPImpSecurity.set_StaticCatchAccessDeniedException(Boolean value) at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled) .


The reason for this error is , I installed SSRS on the SQL Server, rather then installing it on the SharePoint farm. Then I corrected my mistake by installing it on the SharePoint farm. Hope this helps!!!

SSRS native mode reports and SharePoint 2010

I am now developing SSRS reports which will be hosted on native mode. These SSRS reports will be consumed by SharePoint 2010 applications. To consume native mode SSRS reports please follow the below steps.

1. Copy the RSWebParts.cab to a folder on the SharePoint server. By default the RSWebparts.cab can be found in "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint".
2. On the SharePoint Server run the STSADM command on the RSWebParts.cab file using the following syntax "STSADM.EXE -o addwppack -filename "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall". -globalinstall is must if you want to create connected web parts.

After these you will be able to use Report Viewer web parts, which are under miscellaneous categories.

Hope this helps you!!!

PerformancePoint Services error code 20700 - Resolved

I was working with Performance Point 2010 application and I got this following error. The performance point application was pointing to a SSAS cube and it was configured to refresh now and then.

Following error was displayed in the event viewer.

I checked the permissions of the page in which the aforementioned error was appearing and nothing has changed. I checked whether something has changed in cube, but nothing appears to be.  Finally I altered the data connection in performance point dashboard designer to point to some other cube(as a precautionary measure) and then back to the original cube.

Then things have started working. Hope this helps you!!!