|
|
You're in the
sql server reporting services
group:Long Oracle report
sql server reporting services:
I'm having problems with a report that has a Oracle datasource. The query source is a stored procedure that takes 3 hours to complete but reporting services don't wait this time and shows an error page. Reporting Services is configured to "Do not timeout report execution" and the report uses "Use default setting" This works ok with a SLQ Server Stored procedure. Any ideas? Andrés
Hello Andres,
I'd like to know the exact error message you encountered. Also, how long did it take to display error message after you started to execute the report? You mentioned, the SP works in SQL but I wonder if the report from SQL server also takes 3 hours to render? As I know, IE version 5.x and higher have 60 minute time-out limit. A quick registry setting and a restart fixes the problem. 1. Add a ReceiveTimeout DWORD value with a data value of (<number ofseconds>)*1000 in the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings For example, if you want the timeout duration to be 8 minutes, set the ReceiveTimeout data value to 480000 (<480>*1000). 2. Restart your computer. You can find more info at: http://support.microsoft.com/kb/q181050/ You could check the datasource of Oracle in RS designer by open the data source->Edit->Advanced and set connection timeout to 0 (not timeout). Also, the issue could occur if Oracle disconnect the connection from RS due to some issues. You may want to include Oracle support on this specific issue and look into the logs under C:\Program Files\Microsoft SQL Server\mssql\reporting services\logfiles Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA 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. -------------------- [quoted text, click to view] >From: "Andres" <andres.fontan@alcuadrado.com>
>Subject: Long Oracle report >Date: Tue, 27 Dec 2005 09:33:15 -0500 >Lines: 21 >X-Priority: 3 >X-MSMail-Priority: Normal >X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 >X-RFC2646: Format=Flowed; Original >Message-ID: <Oc3YNKvCGHA.4068@TK2MSFTNGP14.phx.gbl> >Newsgroups: microsoft.public.sqlserver.reportingsvcs >NNTP-Posting-Host: static-adsl200-75-93-227.epm.net.co 200.75.93.227 >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:65737 >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > >Hi, > >I'm having problems with a report that has a Oracle datasource. > >The query source is a stored procedure that takes 3 hours to complete but >reporting services don't wait this time and shows an error page. > >Reporting Services is configured to "Do not timeout report execution" and >the report uses "Use default setting" > >This works ok with a SLQ Server Stored procedure. > >Any ideas? > >Andrés > > > > > > >
Hello Peter
I tried with this with SQL Server (A report based in a stored procedure with a waifor command before a select ..... ) and it works fine!. Now we are working with Oracle to find if it works also. The problem is that each try is 4 hours! Regards, Andres [quoted text, click to view] "Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message news:FwMN0q1CGHA.3764@TK2MSFTNGXA02.phx.gbl... > Hello Andres, > > I'd like to know the exact error message you encountered. Also, how long > did it take to display error message after you started to execute the > report? You mentioned, the SP works in SQL but I wonder if the report from > SQL server also takes 3 hours to render? > > As I know, IE version 5.x and higher have 60 minute time-out limit. A > quick > registry setting and a restart fixes the problem. > > 1. Add a ReceiveTimeout DWORD value with a data value of (<number > ofseconds>)*1000 in the following registry key: > HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings > > For example, if you want the timeout duration to be 8 minutes, set the > ReceiveTimeout data value to 480000 (<480>*1000). > > 2. Restart your computer. > > You can find more info at: > > http://support.microsoft.com/kb/q181050/ > > > You could check the datasource of Oracle in RS designer by open the data > source->Edit->Advanced and set connection timeout to 0 (not timeout). > > Also, the issue could occur if Oracle disconnect the connection from RS > due > to some issues. You may want to include Oracle support on this specific > issue and look into the logs under > > C:\Program Files\Microsoft SQL Server\mssql\reporting services\logfiles > > Regards, > > Peter Yang > MCSE2000/2003, MCSA, MCDBA > 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. > > > -------------------- >>From: "Andres" <andres.fontan@alcuadrado.com> >>Subject: Long Oracle report >>Date: Tue, 27 Dec 2005 09:33:15 -0500 >>Lines: 21 >>X-Priority: 3 >>X-MSMail-Priority: Normal >>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 >>X-RFC2646: Format=Flowed; Original >>Message-ID: <Oc3YNKvCGHA.4068@TK2MSFTNGP14.phx.gbl> >>Newsgroups: microsoft.public.sqlserver.reportingsvcs >>NNTP-Posting-Host: static-adsl200-75-93-227.epm.net.co 200.75.93.227 >>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl >>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:65737 >>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs >> >>Hi, >> >>I'm having problems with a report that has a Oracle datasource. >> >>The query source is a stored procedure that takes 3 hours to complete but >>reporting services don't wait this time and shows an error page. >> >>Reporting Services is configured to "Do not timeout report execution" and >>the report uses "Use default setting" >> >>This works ok with a SLQ Server Stored procedure. >> >>Any ideas? >> >>Andrés >> >> >> >> >> >> >> >
Hello Andres,
Thank you for taking time to write in about the status of the issue. :-) Regards, Peter Yang MCSE2000/2003, MCSA, MCDBA 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. -------------------- [quoted text, click to view] >From: "Andres" <andres.fontan@alcuadrado.com>
>References: <Oc3YNKvCGHA.4068@TK2MSFTNGP14.phx.gbl> <FwMN0q1CGHA.3764@TK2MSFTNGXA02.phx.gbl> >Subject: Re: Long Oracle report >Date: Tue, 3 Jan 2006 11:51:19 -0500 >Lines: 111 >X-Priority: 3 >X-MSMail-Priority: Normal >X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 >X-RFC2646: Format=Flowed; Original >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 >Message-ID: <OCz67XIEGHA.1424@TK2MSFTNGP12.phx.gbl> >Newsgroups: microsoft.public.sqlserver.reportingsvcs >NNTP-Posting-Host: static-adsl200-75-93-227.epm.net.co 200.75.93.227 >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:66018 >X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs > >Hello Peter > >I tried with this with SQL Server (A report based in a stored procedure with >a waifor command before a select ..... ) and it works fine!. > >Now we are working with Oracle to find if it works also. The problem is that >each try is 4 hours! > >Regards, > >Andres > > > > >"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message >news:FwMN0q1CGHA.3764@TK2MSFTNGXA02.phx.gbl... >> Hello Andres, >> >> I'd like to know the exact error message you encountered. Also, how long >> did it take to display error message after you started to execute the >> report? You mentioned, the SP works in SQL but I wonder if the report from >> SQL server also takes 3 hours to render? >> >> As I know, IE version 5.x and higher have 60 minute time-out limit. A >> quick >> registry setting and a restart fixes the problem. >> >> 1. Add a ReceiveTimeout DWORD value with a data value of (<number >> ofseconds>)*1000 in the following registry key: >> HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings >> >> For example, if you want the timeout duration to be 8 minutes, set the >> ReceiveTimeout data value to 480000 (<480>*1000). >> >> 2. Restart your computer. >> >> You can find more info at: >> >> http://support.microsoft.com/kb/q181050/ >> >> >> You could check the datasource of Oracle in RS designer by open the data >> source->Edit->Advanced and set connection timeout to 0 (not timeout). >> >> Also, the issue could occur if Oracle disconnect the connection from RS >> due >> to some issues. You may want to include Oracle support on this specific >> issue and look into the logs under >> >> C:\Program Files\Microsoft SQL Server\mssql\reporting services\logfiles >> >> Regards, >> >> Peter Yang >> MCSE2000/2003, MCSA, MCDBA >> 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. >> >> >> -------------------- >>>From: "Andres" <andres.fontan@alcuadrado.com> >>>Subject: Long Oracle report >>>Date: Tue, 27 Dec 2005 09:33:15 -0500 >>>Lines: 21 >>>X-Priority: 3 >>>X-MSMail-Priority: Normal >>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 >>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 >>>X-RFC2646: Format=Flowed; Original >>>Message-ID: <Oc3YNKvCGHA.4068@TK2MSFTNGP14.phx.gbl> >>>Newsgroups: microsoft.public.sqlserver.reportingsvcs >>>NNTP-Posting-Host: static-adsl200-75-93-227.epm.net.co 200.75.93.227 >>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl >>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:65737 >>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs >>> >>>Hi, >>> >>>I'm having problems with a report that has a Oracle datasource. >>> >>>The query source is a stored procedure that takes 3 hours to complete but >>>reporting services don't wait this time and shows an error page. >>> >>>Reporting Services is configured to "Do not timeout report execution" and >>>the report uses "Use default setting" >>> >>>This works ok with a SLQ Server Stored procedure. >>> >>>Any ideas? >>> >>>Andrés >>> >>> >>> >>> >>> >>> >>> >> > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |