The problem I have it appears that mail gets stuck in the Outbox while
Outlook is closed. When I leave it open (Outlook) it does not appear to be a
problem.
I cannot leave Outlook open and a Server Terminal open (in a locked
workstation state) as it is againist corporation policy.
"Yih-Yoon Lee" wrote:
> It should work. Are you having any problem?
> Yih-Yoon Lee
> Betty [User] wrote:
>
The spooling in Outlook was changed in 2002 and I'd suspect
it's the same in 2003. Use Outlook 2000. If that's not
doable or if you are getting sick of Outlook and MAPI issues
like these, you can use an alternative to SQL Mail. You can
use just plain old SMTP for mail. Less headache and easier
to maintain. You can download an extended stored procedure
that will do SMTP mail and get more information from:
http://www.sqldev.net/xp/xpsmtp.htm
You can also find some more information on this at:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
-Sue
On Wed, 19 Jan 2005 09:31:04 -0800, Betty [User]
<bettyuser@.noemail.mail2.com> wrote:
[vbcol=seagreen]
>The problem I have it appears that mail gets stuck in the Outbox while
>Outlook is closed. When I leave it open (Outlook) it does not appear to be a
>problem.
>I cannot leave Outlook open and a Server Terminal open (in a locked
>workstation state) as it is againist corporation policy.
>"Yih-Yoon Lee" wrote:
|||All,
Thank you for your replies, Yih-Yoon and Sue. I will consider the options
available (Outlook 2000/98 or SMTP Mail).
Thank you once again for your assistance,
Betty/
sql
Showing posts with label closed. Show all posts
Showing posts with label closed. Show all posts
Wednesday, March 28, 2012
Outer Joins
I have a set of data which needs to be put in a table in addition to dates
(daily). There are some dates where a location could be closed and hence no
data values but i still want to see the date row in the table with location
and all other associated details but NULL for visit counts.
I have tried LEFT OUTER / RIGHT OUTER but failed. Is there an easy way to do
this ?
Thanks
AsimAsim wrote:
> I have a set of data which needs to be put in a table in addition to
> dates (daily). There are some dates where a location could be closed
> and hence no data values but i still want to see the date row in the
> table with location and all other associated details but NULL for
> visit counts.
> I have tried LEFT OUTER / RIGHT OUTER but failed. Is there an easy
> way to do this ?
> Thanks
> Asim
You need to post table DDL and sample data.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||It is very hard to debug code that you cannot see :)|||It sounds like you want the output to include information (dates)
that are nowhere to be found in your data, as if you were to query
an empty sales table and expect a result with some dates.
If you want data in your result, the data has to be in the source
of the query. A calendar table might be what you want in this
case:
select
C.theDate,
A.Location,
A.otherStuff
from Calendar as C
left outer join AsimTable as A
on A.dt >= C.theDate
and A.dt < C.theDate + 1
See http://www.aspfaq.com/show.asp?id=2519
Steve Kass
Drew University
Asim wrote:
>I have a set of data which needs to be put in a table in addition to dates
>(daily). There are some dates where a location could be closed and hence no
>data values but i still want to see the date row in the table with location
>and all other associated details but NULL for visit counts.
>I have tried LEFT OUTER / RIGHT OUTER but failed. Is there an easy way to d
o
>this ?
>Thanks
>Asim
>|||Sorry guys!
Here is the code, the first temp table gets all the cost center, procedures
and etc and then the second table gets each date (D_DateMonth) .
DECLARE @.Procs TABLE
(ProcedureCode varchar(11), CostCtr varchar(16), CcName varchar(31),
StatCode varchar(11), LocationID varchar(30),
SubGrouping varchar(30), [Grouping] varchar(30), Service varchar(50), Campus
varchar(30), SiteGroup varchar(50))
INSERT INTO @.Procs
SELECT ProcedureCode, CostCtr, CcName, StatCode, LocationID, SubGrouping,
[Grouping], Service, Campus, SiteGroup
FROM D_Procedures
GROUP BY ProcedureCode, CostCtr, CcName, StatCode, LocationID,
SubGrouping, [Grouping], Service, Campus, SiteGroup
SELECT dbo.D_Date_month.[Date] as DOM, dbo.TitleCase(a.Service) as
Service,a.Campus as Hospital,dbo.TitleCase(a.SiteGroup) as Location,
a.CostCtr as CostCtr,dbo.TitleCase(a.CcName) as CcName,
SUM(CASE WHEN OC1_Txns.TransactionCount < 0 THEN -1 ELSE 1 END) as
Visits,NULL AS BudgetVisits,
NULL AS VisitVar, NULL AS LastFYVisits, NULL AS LastFYVar, NULL AS Charges,
NULL AS LastFYCharges,
NULL AS ChargesVar,Convert(smalldatetime, GetDate()) as RowUpdatedatetime
FROM dbo.D_Date_month LEFT OUTER JOIN OC1_Txns ON OC1_Txns.BatchDateTime
= dbo.D_Date_month.[Date]
INNER JOIN @.Procs a ON OC1_Txns.TransactionProcedure = a.ProcedureCode
WHERE (Left(a.StatCode,1) = 'V'
OR a.StatCode='FAMPLAN' OR a.StatCode='MIDWIFE' OR a.StatCode='ORTHOOTH')
AND (OC1_Txns.BatchDateTime >= '04/01/2005' AND OC1_Txns.BatchDateTime <
'04/03/2005')
GROUP BY dbo.D_Date_month.[Date],a.Service, a.Campus, a.SiteGroup,
a.CostCtr, a.CcName
ORDER BY dbo.D_Date_month.[Date],a.Service, a.Campus, a.SiteGroup,
a.CostCtr, a.CcName
"--CELKO--" wrote:
> It is very hard to debug code that you cannot see :)
>|||The C table has no dates.. The information is based on visit level in that
table and I need to build the daily visits grouped by service, location and
etc and even if there was no visit on a particular date for a service or
locaiton, i want to see that service or location with a null for visits but
the date.
"Steve Kass" wrote:
> It sounds like you want the output to include information (dates)
> that are nowhere to be found in your data, as if you were to query
> an empty sales table and expect a result with some dates.
> If you want data in your result, the data has to be in the source
> of the query. A calendar table might be what you want in this
> case:
> select
> C.theDate,
> A.Location,
> A.otherStuff
> from Calendar as C
> left outer join AsimTable as A
> on A.dt >= C.theDate
> and A.dt < C.theDate + 1
> See http://www.aspfaq.com/show.asp?id=2519
> Steve Kass
> Drew University
> Asim wrote:
>
>|||Why not fold the first query into the second one instead of creating a
physical table? Why are you doiing formatting in the query instead of
enforcing this in the DDL? Why do data elements keep changing names
from table to table?
My quick guess is that it might look like this:
SELECT D.foobar_date, A.service, A.campus, A.site_group), A.cost_ctr,
A.cc_name,
SUM(CASE WHEN T.transaction_count < 0
THEN -1 ELSE 1 END) AS visits,
CURRENT_TIMESTAMP
FROM D_Date_Month AS M
LEFT OUTER JOIN
Oc1_Txns AS T
ON T.batch_datetime = D.foobar_date
INNER JOIN
(SELECT DISTINCT procedure_code, cost_ctr, cc_name, stat_code,
location_id, subgrouping, grouping, service, campus, site_group
FROM D_Procedures) AS A
ON T.procedure_code = A.procedure_code
WHERE (LEFT(A.stat_code, 1) = 'V'
OR A.stat_code IN ('FAMPLAN', 'MIDWIFE', 'ORTHOOTH'))
AND T.batch_datetime BETWEEN '2005-04-01 00:00:00' AND '2005-04-03
23:59:59.9999'
GROUP BY D.foobar_date, A.service, A.campus, A.site_group, A.cost_ctr,
A.cc_name;|||On 27 May 2005 11:34:09 -0700, --CELKO-- wrote:
(snip)
>AND T.batch_datetime BETWEEN '2005-04-01 00:00:00' AND '2005-04-03
>23:59:59.9999'
Hi Joe,
This is a bad modification from the original code, for several reasons.
First, the constant '2005-04-03 23:59:59.9999' will not convert to a
datetime value, since you specify one decimal place too much.
Second, the format you used is not safe. It could be interpreted as
yyyy-mm-dd or yyyy-dd-mm, depending on regional settings. The only safe
formats in SQL Server are:
* yyyymmdd (date only - note: no interpunction)
* yyyy-mm-ddThh:mm:ss.ttt (date plus time - note the dashes in the date
part, the colons and decimal point in the time part and the capital T
that seperates the parts. Also note that the milliseconds (the .ttt
part) is optional).
Third, if you change it to '2005-04-03T23:59:59.999', it will be
converted to the fourth of april, midnight. You should use either
'2005-04-03T23:59:59.997' (if the column has datatype datetime) or
'2005-04-03T23:59:00' (if it is smalldatetime). And you must change it
if the column's datatype changes, or if MS changes the precision of
either the datetime or the smalldatetime datatype.
Of course, just using T.batch_datetime < '20050404' (almost the same as
the original code, only the date format is changed!) is much easier and
much safer.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
(daily). There are some dates where a location could be closed and hence no
data values but i still want to see the date row in the table with location
and all other associated details but NULL for visit counts.
I have tried LEFT OUTER / RIGHT OUTER but failed. Is there an easy way to do
this ?
Thanks
AsimAsim wrote:
> I have a set of data which needs to be put in a table in addition to
> dates (daily). There are some dates where a location could be closed
> and hence no data values but i still want to see the date row in the
> table with location and all other associated details but NULL for
> visit counts.
> I have tried LEFT OUTER / RIGHT OUTER but failed. Is there an easy
> way to do this ?
> Thanks
> Asim
You need to post table DDL and sample data.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||It is very hard to debug code that you cannot see :)|||It sounds like you want the output to include information (dates)
that are nowhere to be found in your data, as if you were to query
an empty sales table and expect a result with some dates.
If you want data in your result, the data has to be in the source
of the query. A calendar table might be what you want in this
case:
select
C.theDate,
A.Location,
A.otherStuff
from Calendar as C
left outer join AsimTable as A
on A.dt >= C.theDate
and A.dt < C.theDate + 1
See http://www.aspfaq.com/show.asp?id=2519
Steve Kass
Drew University
Asim wrote:
>I have a set of data which needs to be put in a table in addition to dates
>(daily). There are some dates where a location could be closed and hence no
>data values but i still want to see the date row in the table with location
>and all other associated details but NULL for visit counts.
>I have tried LEFT OUTER / RIGHT OUTER but failed. Is there an easy way to d
o
>this ?
>Thanks
>Asim
>|||Sorry guys!
Here is the code, the first temp table gets all the cost center, procedures
and etc and then the second table gets each date (D_DateMonth) .
DECLARE @.Procs TABLE
(ProcedureCode varchar(11), CostCtr varchar(16), CcName varchar(31),
StatCode varchar(11), LocationID varchar(30),
SubGrouping varchar(30), [Grouping] varchar(30), Service varchar(50), Campus
varchar(30), SiteGroup varchar(50))
INSERT INTO @.Procs
SELECT ProcedureCode, CostCtr, CcName, StatCode, LocationID, SubGrouping,
[Grouping], Service, Campus, SiteGroup
FROM D_Procedures
GROUP BY ProcedureCode, CostCtr, CcName, StatCode, LocationID,
SubGrouping, [Grouping], Service, Campus, SiteGroup
SELECT dbo.D_Date_month.[Date] as DOM, dbo.TitleCase(a.Service) as
Service,a.Campus as Hospital,dbo.TitleCase(a.SiteGroup) as Location,
a.CostCtr as CostCtr,dbo.TitleCase(a.CcName) as CcName,
SUM(CASE WHEN OC1_Txns.TransactionCount < 0 THEN -1 ELSE 1 END) as
Visits,NULL AS BudgetVisits,
NULL AS VisitVar, NULL AS LastFYVisits, NULL AS LastFYVar, NULL AS Charges,
NULL AS LastFYCharges,
NULL AS ChargesVar,Convert(smalldatetime, GetDate()) as RowUpdatedatetime
FROM dbo.D_Date_month LEFT OUTER JOIN OC1_Txns ON OC1_Txns.BatchDateTime
= dbo.D_Date_month.[Date]
INNER JOIN @.Procs a ON OC1_Txns.TransactionProcedure = a.ProcedureCode
WHERE (Left(a.StatCode,1) = 'V'
OR a.StatCode='FAMPLAN' OR a.StatCode='MIDWIFE' OR a.StatCode='ORTHOOTH')
AND (OC1_Txns.BatchDateTime >= '04/01/2005' AND OC1_Txns.BatchDateTime <
'04/03/2005')
GROUP BY dbo.D_Date_month.[Date],a.Service, a.Campus, a.SiteGroup,
a.CostCtr, a.CcName
ORDER BY dbo.D_Date_month.[Date],a.Service, a.Campus, a.SiteGroup,
a.CostCtr, a.CcName
"--CELKO--" wrote:
> It is very hard to debug code that you cannot see :)
>|||The C table has no dates.. The information is based on visit level in that
table and I need to build the daily visits grouped by service, location and
etc and even if there was no visit on a particular date for a service or
locaiton, i want to see that service or location with a null for visits but
the date.
"Steve Kass" wrote:
> It sounds like you want the output to include information (dates)
> that are nowhere to be found in your data, as if you were to query
> an empty sales table and expect a result with some dates.
> If you want data in your result, the data has to be in the source
> of the query. A calendar table might be what you want in this
> case:
> select
> C.theDate,
> A.Location,
> A.otherStuff
> from Calendar as C
> left outer join AsimTable as A
> on A.dt >= C.theDate
> and A.dt < C.theDate + 1
> See http://www.aspfaq.com/show.asp?id=2519
> Steve Kass
> Drew University
> Asim wrote:
>
>|||Why not fold the first query into the second one instead of creating a
physical table? Why are you doiing formatting in the query instead of
enforcing this in the DDL? Why do data elements keep changing names
from table to table?
My quick guess is that it might look like this:
SELECT D.foobar_date, A.service, A.campus, A.site_group), A.cost_ctr,
A.cc_name,
SUM(CASE WHEN T.transaction_count < 0
THEN -1 ELSE 1 END) AS visits,
CURRENT_TIMESTAMP
FROM D_Date_Month AS M
LEFT OUTER JOIN
Oc1_Txns AS T
ON T.batch_datetime = D.foobar_date
INNER JOIN
(SELECT DISTINCT procedure_code, cost_ctr, cc_name, stat_code,
location_id, subgrouping, grouping, service, campus, site_group
FROM D_Procedures) AS A
ON T.procedure_code = A.procedure_code
WHERE (LEFT(A.stat_code, 1) = 'V'
OR A.stat_code IN ('FAMPLAN', 'MIDWIFE', 'ORTHOOTH'))
AND T.batch_datetime BETWEEN '2005-04-01 00:00:00' AND '2005-04-03
23:59:59.9999'
GROUP BY D.foobar_date, A.service, A.campus, A.site_group, A.cost_ctr,
A.cc_name;|||On 27 May 2005 11:34:09 -0700, --CELKO-- wrote:
(snip)
>AND T.batch_datetime BETWEEN '2005-04-01 00:00:00' AND '2005-04-03
>23:59:59.9999'
Hi Joe,
This is a bad modification from the original code, for several reasons.
First, the constant '2005-04-03 23:59:59.9999' will not convert to a
datetime value, since you specify one decimal place too much.
Second, the format you used is not safe. It could be interpreted as
yyyy-mm-dd or yyyy-dd-mm, depending on regional settings. The only safe
formats in SQL Server are:
* yyyymmdd (date only - note: no interpunction)
* yyyy-mm-ddThh:mm:ss.ttt (date plus time - note the dashes in the date
part, the colons and decimal point in the time part and the capital T
that seperates the parts. Also note that the milliseconds (the .ttt
part) is optional).
Third, if you change it to '2005-04-03T23:59:59.999', it will be
converted to the fourth of april, midnight. You should use either
'2005-04-03T23:59:59.997' (if the column has datatype datetime) or
'2005-04-03T23:59:00' (if it is smalldatetime). And you must change it
if the column's datatype changes, or if MS changes the precision of
either the datetime or the smalldatetime datatype.
Of course, just using T.batch_datetime < '20050404' (almost the same as
the original code, only the date format is changed!) is much easier and
much safer.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Monday, February 20, 2012
orphaned request in the RSLog
we are trying to track down an error we get in RS where the ssl connection
is forcibly closed by the remote server. Going through the RS Logs I noticed
these info statements. Can anyone explain in better detail what these mean?
w3wp!runningjobs!11b4!9/16/2005-16:06:35:: w WARN: Thread pool pressure:
turning off threads
w3wp!runningjobs!11b4!09/16/2005-16:06:37:: w WARN: Thread pool pressure:
turning off threads
w3wp!library!11b4!09/16/2005-16:06:37:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!runningjobs!11b4!9/16/2005-16:07:15:: i INFO: Adding: 5 running jobs to
the database
w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:
RunningJobContext.IsClientConnected; found orphaned request
w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:
RunningJobContext.IsClientConnected; found orphaned request
w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:FYI,,, We are running RS SP2 on clustered Windows Server 2003
"Mark" wrote:
> we are trying to track down an error we get in RS where the ssl connection
> is forcibly closed by the remote server. Going through the RS Logs I noticed
> these info statements. Can anyone explain in better detail what these mean?
>
> w3wp!runningjobs!11b4!9/16/2005-16:06:35:: w WARN: Thread pool pressure:
> turning off threads
> w3wp!runningjobs!11b4!09/16/2005-16:06:37:: w WARN: Thread pool pressure:
> turning off threads
> w3wp!library!11b4!09/16/2005-16:06:37:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system properties.
> w3wp!runningjobs!11b4!9/16/2005-16:07:15:: i INFO: Adding: 5 running jobs to
> the database
> w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:
> RunningJobContext.IsClientConnected; found orphaned request
> w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:
> RunningJobContext.IsClientConnected; found orphaned request
> w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:|||Hi Mark,
Thanks for your posting!
From your descriptions, I understood when disconnected forcibly from remote
server, your Report Server will report the error message "found orphaned
request". If I have misunderstood your concern, please feel free to point
it out.
I believe due to the none response from client (it was disconnected
forcibly), some existing request become orphaned. Does this error message
make any business impact on your server?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||So are you saying then that its' the client that is actually disconnecting
from the server?
This issue actually goes back to an early post I had with long running
reports
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&query=long+running+reports&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=80219d15-436f-4b8e-ad0d-0c8c604c6b9f&mid=80219d15-436f-4b8e-ad0d-0c8c604c6b9f
It seems we constantly get this message when we have a batch job running
on a client machine doing a soap call to the RS server. Everything runs fine
until it hits 15 minutes and then we get the SSL connection closed error. We
have tried a variety of things from upgrading to sp2 applying serveral hot
fixes, and changing the defualt IIS timeout settings from 900 seconds to 600
seconds. All to no avail. At exaclty 15 minutes we get disconnected.
I was looking then through the RSlogs and saw the orphaned requests coming
up at about the same time we get the ssl connection error and decided to post
again to see if that might trigger a new approach.
Frustrated at 15!!!
"Michael Cheng [MSFT]" wrote:
> Hi Mark,
> Thanks for your posting!
> From your descriptions, I understood when disconnected forcibly from remote
> server, your Report Server will report the error message "found orphaned
> request". If I have misunderstood your concern, please feel free to point
> it out.
> I believe due to the none response from client (it was disconnected
> forcibly), some existing request become orphaned. Does this error message
> make any business impact on your server?
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hi Mark,
From the error, I belive it seems to be caused by data connection to
datasource for the report. You may want to check if the following error is
also in RS log:
e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error
has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Query
execution failed for data set 'MSFixlets'. -->
System.Data.SqlClient.SqlException:
Timeout expired. The timeout period elapsed prior to completion of the
operation
or the server is not responding.
You may try the following steps:
Open up the report project in VS.NET IDE, go to the Data tab and edit the
dataset which brings back those images. In the Query tab, set the timeout
property to more than 900 (15 mins).
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
is forcibly closed by the remote server. Going through the RS Logs I noticed
these info statements. Can anyone explain in better detail what these mean?
w3wp!runningjobs!11b4!9/16/2005-16:06:35:: w WARN: Thread pool pressure:
turning off threads
w3wp!runningjobs!11b4!09/16/2005-16:06:37:: w WARN: Thread pool pressure:
turning off threads
w3wp!library!11b4!09/16/2005-16:06:37:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!runningjobs!11b4!9/16/2005-16:07:15:: i INFO: Adding: 5 running jobs to
the database
w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:
RunningJobContext.IsClientConnected; found orphaned request
w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:
RunningJobContext.IsClientConnected; found orphaned request
w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:FYI,,, We are running RS SP2 on clustered Windows Server 2003
"Mark" wrote:
> we are trying to track down an error we get in RS where the ssl connection
> is forcibly closed by the remote server. Going through the RS Logs I noticed
> these info statements. Can anyone explain in better detail what these mean?
>
> w3wp!runningjobs!11b4!9/16/2005-16:06:35:: w WARN: Thread pool pressure:
> turning off threads
> w3wp!runningjobs!11b4!09/16/2005-16:06:37:: w WARN: Thread pool pressure:
> turning off threads
> w3wp!library!11b4!09/16/2005-16:06:37:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system properties.
> w3wp!runningjobs!11b4!9/16/2005-16:07:15:: i INFO: Adding: 5 running jobs to
> the database
> w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:
> RunningJobContext.IsClientConnected; found orphaned request
> w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:
> RunningJobContext.IsClientConnected; found orphaned request
> w3wp!runningjobs!1d5c!9/16/2005-16:07:15:: i INFO:|||Hi Mark,
Thanks for your posting!
From your descriptions, I understood when disconnected forcibly from remote
server, your Report Server will report the error message "found orphaned
request". If I have misunderstood your concern, please feel free to point
it out.
I believe due to the none response from client (it was disconnected
forcibly), some existing request become orphaned. Does this error message
make any business impact on your server?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||So are you saying then that its' the client that is actually disconnecting
from the server?
This issue actually goes back to an early post I had with long running
reports
http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?&query=long+running+reports&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=80219d15-436f-4b8e-ad0d-0c8c604c6b9f&mid=80219d15-436f-4b8e-ad0d-0c8c604c6b9f
It seems we constantly get this message when we have a batch job running
on a client machine doing a soap call to the RS server. Everything runs fine
until it hits 15 minutes and then we get the SSL connection closed error. We
have tried a variety of things from upgrading to sp2 applying serveral hot
fixes, and changing the defualt IIS timeout settings from 900 seconds to 600
seconds. All to no avail. At exaclty 15 minutes we get disconnected.
I was looking then through the RSlogs and saw the orphaned requests coming
up at about the same time we get the ssl connection error and decided to post
again to see if that might trigger a new approach.
Frustrated at 15!!!
"Michael Cheng [MSFT]" wrote:
> Hi Mark,
> Thanks for your posting!
> From your descriptions, I understood when disconnected forcibly from remote
> server, your Report Server will report the error message "found orphaned
> request". If I have misunderstood your concern, please feel free to point
> it out.
> I believe due to the none response from client (it was disconnected
> forcibly), some existing request become orphaned. Does this error message
> make any business impact on your server?
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hi Mark,
From the error, I belive it seems to be caused by data connection to
datasource for the report. You may want to check if the following error is
also in RS log:
e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error
has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Query
execution failed for data set 'MSFixlets'. -->
System.Data.SqlClient.SqlException:
Timeout expired. The timeout period elapsed prior to completion of the
operation
or the server is not responding.
You may try the following steps:
Open up the report project in VS.NET IDE, go to the Data tab and edit the
dataset which brings back those images. In the Query tab, set the timeout
property to more than 900 (15 mins).
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)