Showing posts with label portal. Show all posts
Showing posts with label portal. Show all posts

Friday, March 30, 2012

rsExecutionNotFound

Hello:

We are using Reporting Services 2005 as our production reporting portal. Sometimes our business users get similar messages to the following message (intermittently ) when running reports.

Execution 'ahk2v0rhpeaj3e45lkrf2ine' cannot be found (rsExecutionNotFound)

I have researched online and forums but could not find a solution to this problem. I know it has something to do with sessions dying and loss of session id. Once the user reruns the report it works fine. What is the way to resolve this from happening at all? We don't want the users to see this on production. Has Microsoft already fixed this problem?

Thanks.

Here is one 'hack' for the problem. It appears to be related to caching. Another way to fix if you are using a custom app is to specify a unique 'fake' parameter guid. rc:guid=<guid>

http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

You may want to try using SQL Profiler against ReportServerTempDB to determine if it is deleting sessions in the same manner as the url above. See the help file to check rsreportserver.config settings.

http://www.samspublishing.com/articles/article.asp?p=469625&seqNum=6&rl=1

cheers,

Andrew

Posted by rodshapedasdc at 6:39 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Wednesday, March 28, 2012

RSClientPrint Parameter Issues

Hi All

We're having a technical issue integrating the print reports into the portal. I'm hoping maybe some of your guys can help. We're using the RSClientPrint component to print the reports. The problem appears to be a conflict between the & in the URL and the & in the parameter value's cube reference. Below is an HTML code snippet. The 1st button works fine for us, it prints everything and has no & in the parameter's cube references. The second button references specific User and Employee values and therefore has & in the cube reference and generates an error. We tried encoding the & as &amp; but it did not help. Thanks.

<html>
<body>


<OBJECT ID="RSClientPrint" CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3"></OBJECT>

<script type="text/javascript">
function Print(ReportServer, ReportParameters, ReportTitle ) {
RSClientPrint.MarginLeft = .5 * 25.4;
RSClientPrint.MarginTop = .5 * 25.4;
RSClientPrint.MarginRight = .5 * 25.4;
RSClientPrint.MarginBottom = .5 * 25.4;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 1033;
RSClientPrint.PageWidth = 11 * 25.4;
RSClientPrint.PageHeight = 8.5 * 25.4;
RSClientPrint.Authenticate = false;
RSClientPrint.Print(ReportServer, ReportParameters, ReportTitle);
}

</script>


<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].[All]&UserUser=[User].[User].[All]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].[All]', 'SA.Report.6');"/>

<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].&[1]&UserUser=[User].[User].&[1]&[1]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].&[3356953]', 'SA.Report.6');"/>

</body>
</html>

Regards,

Nanda kumar R

&amp; is the encoding of & in xml, try using %26 which is the Url encoding of &.|||

Hi Daniel Reib,

Its working fine.

Thanks,

Regards,

Nanda kumar R

Posted by rodshapedasdc at 7:37 AM 0 comments
Labels: , , , , , , , , , , , ,

RSClientPrint Parameter Issues

Hi All

We're having a technical issue integrating the print reports into the portal. I'm hoping maybe some of your guys can help. We're using the RSClientPrint component to print the reports. The problem appears to be a conflict between the & in the URL and the & in the parameter value's cube reference. Below is an HTML code snippet. The 1st button works fine for us, it prints everything and has no & in the parameter's cube references. The second button references specific User and Employee values and therefore has & in the cube reference and generates an error. We tried encoding the & as &amp; but it did not help. Thanks.

<html>
<body>


<OBJECT ID="RSClientPrint" CLASSID="CLSID:FA91DF8D-53AB-455D-AB20-F2F023E498D3"></OBJECT>

<script type="text/javascript">
function Print(ReportServer, ReportParameters, ReportTitle ) {
RSClientPrint.MarginLeft = .5 * 25.4;
RSClientPrint.MarginTop = .5 * 25.4;
RSClientPrint.MarginRight = .5 * 25.4;
RSClientPrint.MarginBottom = .5 * 25.4;
RSClientPrint.Culture = 1033;
RSClientPrint.UICulture = 1033;
RSClientPrint.PageWidth = 11 * 25.4;
RSClientPrint.PageHeight = 8.5 * 25.4;
RSClientPrint.Authenticate = false;
RSClientPrint.Print(ReportServer, ReportParameters, ReportTitle);
}

</script>


<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].[All]&UserUser=[User].[User].[All]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].[All]', 'SA.Report.6');"/>

<button onclick="Print('http://localhost/reportserver', '/SA/SA.Report.6.Print&SessionSession=[Session].[Session].&[1]&UserUser=[User].[User].&[1]&[1]&TerritoryIdentifier=[Territory].[Identifier].[All]&EmployeeActiveFlag=[Employee].[Active Flag].[All]&EmployeeIdentifier=[Employee].[Identifier].&[3356953]', 'SA.Report.6');"/>

</body>
</html>

Regards,

Nanda kumar R

&amp; is the encoding of & in xml, try using %26 which is the Url encoding of &.|||

Hi Daniel Reib,

Its working fine.

Thanks,

Regards,

Nanda kumar R

sql
Posted by rodshapedasdc at 7:37 AM 0 comments
Labels: , , , , , , , , , , , , ,

Monday, March 12, 2012

RS Web parts: Change web part title?

Maybe I should have asked in one of the SharePoint groups, but maybe someone
in this group knows what's wrong. Anyway, in a SharePoint Portal server 2003
portal, I've created a page with the Reporting services web parts. As the
company in question is Norwegian, I want to change the title of the webparts
from Report Explorer and Report Viewer to something in Norwegian. I go to
"Change web part", change the name in the Title text box, click OK. It
changes to the new title, but when I refresh the page, it's back to "Report
Explorer". All other settings are stored, like height and width of the web
part, but not the title. I've had this problem in a different cutomer's
portal too.
Any suggestions?
Kaisa M. LindahlHi.
I have the exact same problem!
Pedro
"Kaisa M. Lindahl" wrote:
> Maybe I should have asked in one of the SharePoint groups, but maybe someone
> in this group knows what's wrong. Anyway, in a SharePoint Portal server 2003
> portal, I've created a page with the Reporting services web parts. As the
> company in question is Norwegian, I want to change the title of the webparts
> from Report Explorer and Report Viewer to something in Norwegian. I go to
> "Change web part", change the name in the Title text box, click OK. It
> changes to the new title, but when I refresh the page, it's back to "Report
> Explorer". All other settings are stored, like height and width of the web
> part, but not the title. I've had this problem in a different cutomer's
> portal too.
> Any suggestions?
> Kaisa M. Lindahl
>
>
Posted by rodshapedasdc at 8:57 AM 0 comments
Labels: , , , , , , , , , , , , ,

Friday, March 9, 2012

RS portal Layout

hi

Is there a way to personalize the reporting services web portal? (company logo, colors ...)?

You can modify the style sheet that it uses but other than that, you would need to build your own front end application (or use SharePoint).

Posted by rodshapedasdc at 8:24 PM 0 comments
Labels: , , , , , , , , , , , , , , ,

Wednesday, March 7, 2012

RS in Sharepoint 2007

Sharepoint Server Portal 2007, MSSQL 2005, Reporting Services

When I try to integrate Reporting Services in Adminitsrator, for url of RS I write this: http://servername/ReportServer/ and click OK.

But when I try to go to 'Set Server defaults' or 'Managed Shared Shedules' I get this:

Server was unable to process request. > Client found response content type of '', but expected 'text/xml'. The request failed with an empty responseWhat should I Do ?

Hello,

Unfortunatelly I face the same problem.

I just put a little bit more info.

In the "reporting service" area of the application management, there is 3 links:

Manage integration settings : I put the url of my reporting server and the authentiation mode (windows)

Posted by rodshapedasdc at 7:47 PM 0 comments
Labels: , , , , , , , , , , , , , , ,
Subscribe to: Comments (Atom)