MSRT - Error with Exporting the Reports to Excel Format.

I tried to export a report to excel format. I am getting the below error(Array Index out of bounds). The report is around 12 pages. Any thoughts on this?

Server Error in '/Reports' Application.

---

Index was outside the bounds of the array.

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.Exception: Index was outside the bounds of the array.

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:

[Exception: Index was outside the bounds of the array.]

[Exception: An error occurred during rendering of the report.]

[Exception: An error occurred during rendering of the report.]
Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489
Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +924
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Santhosh

Santosh,

Do you get this for all reports or just for one particular report. If it is for one particular report next thing is do you know if it is for a particular field?

|||Im getting just this particular report and in the pre prod the same report is working fine only in production Im having this issue. That too it works fine on one day and breaks on the next day .

MSDTC cluster resource

I am configuring a two node SQL cluster and i have 5 physical disk arrays and
i intend to use them in the following order
disk array 1 for quorum
disk array 2 for DATA
disk array 3 for backup
disk array 4 for TempDB
disk array 5 create two partition (1 for Tlog and 2 for MDTC disk resorces)
Will there be any probelm or is there anything wrong with creating two
partitions on the disk array 5 to make available two disk resource for those
two resources i have mentioned above e.g the MSDTC resource and the TLOg
storage . Since i want the MSDTC resource to be in its own resource group.
Please any help will be gladly appreciated.
Slawal
Clustering does not understand partitions, only disks. With that said, array
5 should stay one partition. MSDTC is only 4 MB by default. Are you sure you
will even use MSDTC with SQL? If not, you don't have to install it
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"slawal" <slawal@.discussions.microsoft.com> wrote in message
news:4D82411F-5802-4DE7-AF51-62614083B82E@.microsoft.com...
>I am configuring a two node SQL cluster and i have 5 physical disk arrays
>and
> i intend to use them in the following order
> disk array 1 for quorum
> disk array 2 for DATA
> disk array 3 for backup
> disk array 4 for TempDB
> disk array 5 create two partition (1 for Tlog and 2 for MDTC disk
> resorces)
> Will there be any probelm or is there anything wrong with creating two
> partitions on the disk array 5 to make available two disk resource for
> those
> two resources i have mentioned above e.g the MSDTC resource and the TLOg
> storage . Since i want the MSDTC resource to be in its own resource group.
> Please any help will be gladly appreciated.
>
> Slawal
|||While SQL Server does not require MS DTC, MS DTC on a cluster is only
supported when clustered and it is recommended to cluster it.
When clustering MS DTC it is preferred to have it in its own group with its
own resources, This will require your partion to appear as a physical disk
to place the disk in its own group.
Your second choice should be to put it in the cluster group,
use the quorum disk and create MS DTC its own Network Name and IP Address
resources for your MSDTC resource to use and set that resources properties
not to affect the group.
Here are some KB articles on correctly setting this up:
301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600
817064 How to enable network DTC access in Windows Server 2003
http://support.microsoft.com/?id=817064
Also this article which may be of interest:
817065 How To Enable Network COM Access in Windows Server 2003
http://support.microsoft.com/?id=817065
Dave Whitney
SQL Support