Report Model Timeout

I am trying to create a report model consisting of one main table with
several views connecting to the main table. The main table is rather large
(20-30 million records). I keep getting the following error message below.
Any ideas?
An error occurred while executing a command.
Message: Timeout expired. The timeout period elapsed prior to completion of
the operation or the server is not responding.i have same problem,
there must be a timeout setting somewhere
"retkow" wrote:
> I am trying to create a report model consisting of one main table with
> several views connecting to the main table. The main table is rather large
> (20-30 million records). I keep getting the following error message below.
> Any ideas?
> An error occurred while executing a command.
> Message: Timeout expired. The timeout period elapsed prior to completion of
> the operation or the server is not responding.
>|||I am getting the same error message after 30 minutes into my report
execution. The execution timeout in site settings is set to 3 hours.
SO dont seem to understand what can be causing this timeout.
Any ideas on where to look is greatly appreciated.
Thanks
"Tango" wrote:
> i have same problem,
> there must be a timeout setting somewhere
> "retkow" wrote:
> > I am trying to create a report model consisting of one main table with
> > several views connecting to the main table. The main table is rather large
> > (20-30 million records). I keep getting the following error message below.
> > Any ideas?
> >
> > An error occurred while executing a command.
> > Message: Timeout expired. The timeout period elapsed prior to completion of
> > the operation or the server is not responding.
> >