Runtime Error after some pause

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report]

Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229

Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25

Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40

Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25

System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105

System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7

System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11

System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andysql

Runtime Error after some pause

Hello,

My users often view some report for some minutes and after that want to return to parent report.
If they did it after small time (~less than minute), everything is OK. But if this pause is above 1 minute they receive "Runtime Error" message and can only to go to homepage.

I think that this is some session time or something like that.
Am I right? How can fix it?

Thank youAfter setting customError=off we receive "Back call without drillthrough report" error|||Did you find a fix for the problem? Can anyone help? I get the same problem.|||

Back call without drillthrough report

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Back call without drillthrough report

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: Back call without drillthrough report] Microsoft.Reporting.WebForms.ReportViewer.Toolbar_Back(Object sender, EventArgs e) +229 Microsoft.Reporting.WebForms.ToolbarControl.OnBack(Object sender, EventArgs e) +25 Microsoft.Reporting.WebForms.BackGroup.BackButton_Click(Object sender, EventArgs e) +40 Microsoft.Reporting.WebForms.ScriptSwitchImage.EnabledImage_Click(Object sender, ImageClickEventArgs e) +25 System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +105 System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

|||

I am also receiving this error but there is no delay. As soon as the report is loaded, I click back to goto the previous report and I get this error.

It is interesting because charts are also not loading. I dont receive an error message but in the event log this is entered: "The stream cannot be found."

This only happens when I drill-through.

|||

I'm having this issue also. Did anyone ever find a solution? thanks

|||Hey guys I think that this issue has something to do with some other problems I have been having due to SP1. I notice that the back button wasn't the only thing messing up, and it was only doing it in the ReportViewer (not when I went to the report directly in VS)

check out this article
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx

-nonoandy|||

i am also facing this problem...

any solutions for this?

|||Just checking if anyone has any luck with this? I spend more time on these forums than i do developing SSRS. Come across issues on a seemingly endless basis.|||Did you check out this link
http://www.eggheadcafe.com/software/aspnet/29672997/back-call-without-drillth.aspx
?
I had two things that was giving me the same problem one was a Ajax update panel around it and the other was because of the bad release of VS2005 SP1. The "Microsoft.ReportViewer.* assemblies" where messing it up so I had to un-install them from my GAC and find the older "File version"
(To find out what file version of the assemblies you have right click and hit properties. Don't look at the Version tab in the windows explore.)

But you don't have to do that now Microsoft came out with new assemblies in and you can download them in a redistributable package.

Read this
http://support.microsoft.com/default.aspx/kb/933137
and download

Thanks!
Andy

Runtime Error - Taskpad

When I change my view to "Taskpad" in Enterprise Manager,
and then click on each of the databases, I get a "Runtime
Error has occured. Do you want to debug". Has anyone
else encountered this problem and is there a fix?
Thanks,
PatrickIf you change it back to Large icons or another view, then back again, it
should work okay.
Also make sure you're at the latest service pack...
A
"Patrick Thorsell" <patrick_thorsell@.yahoo.com> wrote in message
news:024001c35528$142c82a0$a101280a@.phx.gbl...
> When I change my view to "Taskpad" in Enterprise Manager,
> and then click on each of the databases, I get a "Runtime
> Error has occured. Do you want to debug". Has anyone
> else encountered this problem and is there a fix?
> Thanks,
> Patrick|||Hmm why is there no MS articles about this? Anyone know
of a long term fix for this? the switching views is
surely just a work around.
Regards,
Yussuf Khan
>--Original Message--
>If you change it back to Large icons or another view,
then back again, it
>should work okay.
>Also make sure you're at the latest service pack...
>A
>
>"Patrick Thorsell" <patrick_thorsell@.yahoo.com> wrote in
message
>news:024001c35528$142c82a0$a101280a@.phx.gbl...
>> When I change my view to "Taskpad" in Enterprise
Manager,
>> and then click on each of the databases, I get
a "Runtime
>> Error has occured. Do you want to debug". Has anyone
>> else encountered this problem and is there a fix?
>> Thanks,
>> Patrick
>
>.
>|||This error still can occur in SP3, it happened to me about 2 minutes ago.
--
----
The views expressed here are my own
and not of my employer.
----
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:uKn6lJQXDHA.1680@.tk2msftngp13.phx.gbl...
> Since moving to SP3, I have never experienced the error. So if you're not
> at SP3, get there.
>
>
> "Yussuf Khan" <fearnan@.excite.com> wrote in message
> news:173301c35cfb$f3fc70e0$7d02280a@.phx.gbl...
> > Hmm why is there no MS articles about this? Anyone know
> > of a long term fix for this? the switching views is
> > surely just a work around.
> >
> > Regards,
> >
> > Yussuf Khan
>

Running Totals

I have an Oracle View I have brought into Crystal.
Sample Data is this. There are more CostCenters with consisting of various types:

View:
CostCenter Type Hrs
323 M 10
323 V 20
323 L 30
323 Q 39

I do a running totals for Hrs in my reports. I have 6 running totals variables. M, V, L, Q, R, X That I display on my report grouped by CostCenter. However, if a CostCenter is missing any of the 6 types, nothing is shown in my report under that type column. How can I default it to 0?

I want Crystal to be able to handle this issue. My report can't have blanks scattered throughout my report if a Type doesn't exist for that CostCenter.Create a formula having the code

If Isnull(field)=True then
'0'
else
Field

Running Sum In View (sql server 2000)

Please can anyone help me ....

how to do running sum in view in sql server 2000

Please see the example below on how to do this.
/*

This table tracks the quantity bought for a particular item.

The problem is to calculate the moving average of sales over the last 3 months

including the current month. The logic can be extended to any moving average problem.

*/

CREATE TABLE #ItemSales (

ItemID int ,

DateBought datetime ,

Quantity int ,

CONSTRAINT PK_ItemSales_ID_Bought PRIMARY KEY CLUSTERED( ItemID , DateBought )

);

INSERT INTO #ItemSales

SELECT 1 , '2000-10-20' , 62

UNION ALL

SELECT 1 , '2000-09-01' , 13

UNION ALL

SELECT 1 , '2000-11-01' , 45

UNION ALL

SELECT 1 , '2000-06-01' , 89

UNION ALL

SELECT 2 , '2000-06-01' , 37

UNION ALL

SELECT 2 , '2000-10-24' , 81

UNION ALL

SELECT 2 , '2000-10-12' , 56;

-- How the data looks, from the most recent sale for eacn item.

SELECT * FROM #ItemSales ORDER BY ItemID , DateBought DESC;

/*

ItemID DateBought Quantity

-- --

1 2000-11-01 00:00:00.000 45

1 2000-10-20 00:00:00.000 62

1 2000-09-01 00:00:00.000 13

1 2000-06-01 00:00:00.000 89

2 2000-10-24 00:00:00.000 81

2 2000-10-12 00:00:00.000 56

2 2000-06-01 00:00:00.000 37

*/

GO

/*

Corelated query for calculating the moving average of each item's sale over the

last 3 months including the current date.

*/

SELECT i1.ItemID , i1.DateBought ,

( SELECT AVG( i2.Quantity )

FROM #ItemSales AS i2

WHERE i2.ItemID = i1.ItemID And

DATEDIFF( mm , i2.DateBought , i1.DateBought ) Between 0 And 3

) AS MovingAverageOver3Months

FROM #ItemSales AS i1

ORDER BY i1.ItemID , i1.DateBought DESC;

-- Expected Output:

/*

ItemID DateBought MovingAverageOver3Months

--

1 2000-11-01 00:00:00.000 40

1 2000-10-20 00:00:00.000 37

1 2000-09-01 00:00:00.000 51

1 2000-06-01 00:00:00.000 89

2 2000-10-24 00:00:00.000 68

2 2000-10-12 00:00:00.000 68

2 2000-06-01 00:00:00.000 37

*/

DROP TABLE #ItemSales;

GO

running SQL file (view + procedure) problem

I am try to run a .sql file
CREATE VIEW LastReport
AS
SELECT MAX(ID) AS LastReport, RHost
FROM Report
WHERE (RComplete = 1)
GROUP BY RHost
CREATE PROCEDURE [dbo].[MembresAcces_Insert]
AS
INSERT INTO membresAcces (login, passe, id_membresTypes) VALUES ('admin','admin',50);

... 10 view and procedure like this one
i get an error view must be the first one
what is wrong ? running CREATE TABLE works perfectly
thank you


Try placing a GO in between each statement.
CREATE VIEW LastReport
AS
SELECT MAX(ID) AS LastReport, RHost
FROM Report
WHERE (RComplete = 1)
GROUP BY RHost
GO
CREATE PROCEDURE [dbo].[MembresAcces_Insert]
AS
INSERT INTO membresAcces (login, passe, id_membresTypes) VALUES ('admin','admin',50);
GO

Running sp_refreshview causes error for view on linked server

When I try to run sp_refreshview on a view that accesses a table on a linked
server (after that table's structure has changed), I get the following error
:
Server: Msg 7391, Level 16, State 1, Procedure vwTest, Line 3
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the
specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].
Help!!
How do I ensure that the view on the linked server remains correct, after
the table structure of the table it references changes? I understand that
sp_refreshview will do the same as dropping and re-creating the view, but wh
y
doesn't it work on a linked server?
Also, is there a way to automate the refresh of the view after a schema
change on the table it references? Some kind of trigger on the table maybe?
But the trigger events do not include a schema change do they?
FredFred,
What happens if you right-click the view in QA and choose Edit to generate
an ALTER statement and then execute that statement?
This would retain your permissions as opposed to DROP / CREATE.
HTH
Jerry
"fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
news:DB681BC7-36C7-4FB6-A9C9-C52166A96C17@.microsoft.com...
> When I try to run sp_refreshview on a view that accesses a table on a
> linked
> server (after that table's structure has changed), I get the following
> error:
> Server: Msg 7391, Level 16, State 1, Procedure vwTest, Line 3
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction.
> [OLE/DB provider returned message: New transaction cannot enlist in the
> specified transaction coordinator. ]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x8004d00a].
> Help!!
> How do I ensure that the view on the linked server remains correct, after
> the table structure of the table it references changes? I understand that
> sp_refreshview will do the same as dropping and re-creating the view, but
> why
> doesn't it work on a linked server?
> Also, is there a way to automate the refresh of the view after a schema
> change on the table it references? Some kind of trigger on the table
> maybe?
> But the trigger events do not include a schema change do they?
> Fred
>|||Thanks Jerry,
The Alter View statement works. It looks something like this:
ALTER VIEW ViewName
AS
select * from [LinkedServer\PRODUCTION].Database.dbo.TblName
However, my problem remains to automate the "refresh" of this view, every
time there is a schema change on the table (on the linked server) that it
references. Some kind of trigger based on the schema change maybe?
We have quite a few views that are based on tables on linked servers and the
person that makes the schema change to the referenced tables do not always
remember to refresh the views.
Fred
"Jerry Spivey" wrote:

> Fred,
> What happens if you right-click the view in QA and choose Edit to generat
e
> an ALTER statement and then execute that statement?
> This would retain your permissions as opposed to DROP / CREATE.
> HTH
> Jerry
> "fredscuba" <fredscuba@.discussions.microsoft.com> wrote in message
> news:DB681BC7-36C7-4FB6-A9C9-C52166A96C17@.microsoft.com...
>
>|||I was able to get the sp_refreshview to work on the linked server setup, by
configuring MS DTC (Distributed Transaction Coordinator) for network access
-
see Microsoft Article ID 329332.
I still need to find a way to automate the "refresh" of this view, every
time there is a schema change on the table (on the linked server) that it
references.
Any ideas?
Fred
"fredscuba" wrote:
> Thanks Jerry,
> The Alter View statement works. It looks something like this:
> ALTER VIEW ViewName
> AS
> select * from [LinkedServer\PRODUCTION].Database.dbo.TblName
> However, my problem remains to automate the "refresh" of this view, every
> time there is a schema change on the table (on the linked server) that it
> references. Some kind of trigger based on the schema change maybe?
> We have quite a few views that are based on tables on linked servers and t
he
> person that makes the schema change to the referenced tables do not always
> remember to refresh the views.
>
> Fred
>
> "Jerry Spivey" wrote:
>