Showing posts from December, 2011

Error while trying to run Report Builder 3.0 in Sharepoint 2010

Ran across an issue while trying to create using Report Builder 3.0:-

Following errors were detected during this operation.
* [12/29/2011 12:47:47 PM] System.Deployment.Application.DeploymentException (Subscription)
- Unable to install this application because an application with the same identity is already installed. To install this application, either modify the manifest version for this application or uninstall the preexisting application.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SubscriptionStore.CheckApplicationPayload(CommitApplicationParams commitParams)
at System.Deployment.Application.SubscriptionStore.CommitApplication(SubscriptionState& subState, CommitApplicationParams commitParams)
at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activati…

Meritocracy Vs Bureaucracy

A friend of mine asked me to watch this movie Aaarakshan (pretty bad movie except for Amitabh's performance) but the movie did have a moral to it though it turned out to become a complete Bollywood fiasco at the end. The concept of having a quota in place for people belonging to the backward communities is correct in a manner of speaking. But wait!!! this is not where I stand. I would actually prefer to have the quota system in place for people who are near the poverty belt and below. It does not make sense for a wealthy person who comes from a backward community to take the eay way out and place the trump card ("quota") when it comes to his or her relative battling it with others. Merit should be the ultimate winner here where people work hard and prove to the world that they can stand on their own two feet and not have everything handed to them in a platter. Maybe the UID (Unique identifier system) that is currently taking place in India would be a solution to figure o…

Nice Tidy SQL problem & Solution

Have been writing a couple of tech articles in the recent past (If I had started writing it on a regualr basis I might have had an encyclopedia by now.... I should write something else just 4 a change huh!!!):
Question posted on one of the SQL server sites out there--> concatenation of rows to columns....
There are 3 ways of accomplishing it and I ain't going thru all those approaches but will just highlight them (except for my solution here):-
1. Creating a dynamic SQL which will keep concatenating the rows into a specific column in a PL/SQL block which returns the required table.

2. Using recursive CTE to concatenate the rows into columns .... Maybe should hit upon CTE's which are extremely useful in a later post (If I get some time i.e.)

3. Now this method is pretty cool Now let me give the problem statement as posted by that individual...

Let us create the table in the following manner-->
select 'Report1' as reportID,'Browser' as RoleID, 'YChen' as U…

Sharepoint and SSRS configuration continued...

So my next step is to deploy the reports in sharepoint. Great! Except now you might run into the following issue:
the full path must be less than 260 characters
how would you go about resolving this-->simple follow the steps below....
1. Create a document library with the document type being null.
2. Else go to the library section and select reports as the type of library.
3. The next step is to ensure that you give a valid name for the library (This is an easy one) so your format would be http:///SiteName/LibraryName
4. Go back to your SSRS project properties. Make sure that the Target Data source folder and the Target Report Folder are configured with the following value as mentioned in step 3 :- http:///SiteName/LibraryName
5. The TargetReportPartFolder need not be filled.... Its upto you. This foldercan be used to deploy to a sub library...
6. The TargetServerUrl would be http:///SiteName
7. Make sure you point the TargetServerUrl to the right version of SQL server.
Click deploy and yo…

Sharepoint & SSRS integration Issues

Recently started working with Sharepoint 2010. PPS and excel services seemed pretty simple on the onset. Now while trying to integrate SSRS with share point 2010, I ran into this issue:
"Failed to establish connection with report server. Verify the server URL is correct or review ULS logs for more information. Product area: SQL Server Reporting Services, Category: Configuration Pages"
Man--> this was a mind boggler. Let me explain what I tried to do in order to eliminate this issue and still did not work:-
1. Opened the RSManager Config file (located at C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer if you have a 64 bit OS) and then changed the following
and changed it to Kerberos mode:
<RSWindowsNegotiate/> (acts as a intermediary between NTLM and RSWindowsKerberos))

Script Object Model object in SSIS (commonly used in the SSIS script tasks)

Just a quick code snippet on the usage of the ScriptObjectModel in SSIS script tasks... It takes one through all the required functions that can be exposed using the script object model:-
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Dts.DtsClient;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks.ScriptTask;
using Microsoft.SqlServer.Dts.Tasks;

namespace ScriptObjectNotifier
public class SOCall

ScriptObjectModel objModel;

public SOCall(ScriptObjectModel valObjModel)
objModel = valObjModel;
/// <summary>
/// gets the connection string from a conn Parameter
/// </summary>
/// <param name="connName">name of the connection</param>
/// <returns>string</returns>
public string GetConnectionString(string connName)
string connectionString = objModel.Connec…