IIS - COM Exception - Asked By Sumit Tyagi on 15-Nov-11 02:21 AM

Timestamp: 11/15/2011 6:45:47 AM
Message: There is no explicit mapping for the categories 'Exception'. The log entry was: 
Timestamp: 11/15/2011 12:15:47 PM
Message: 
Page Name: ReportHandler.cs:line 1374
   at ReportViewer.OpenSelectedReport()
   at ReportViewer.Button_Click(Object sender, EventArgs e)
Namespace: Microsoft.Office.Interop.Excel.Workbooks
Method Name: Add
Error Description: Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. 


• To make more memory available, close workbooks or programs you no longer need. 


• To free disk space, delete files you no longer need from the disk you are saving to.
Category: Exception
Priority: 2
EventId: 0
Severity: Error
Title:Microsoft Office Excel
Machine: SUMITTYAGI
App Domain: /LM/W3SVC/1/Root/PlazaBO-2-129658131005741186
ProcessId: 892
Process Name:    at Microsoft.Office.Interop.Excel.Workbooks.Add(Object Template)
   at Plaza.BusinessObjects.ExcelReportHandler.GenerateExcelFile(String& dbMessage, String& fileName) in D:\Vinculum\backoffice\Dynamic\Source\Plaza Service Management\BusinessObjects\ReportHandler.cs:line 1374
   at ReportViewer.OpenSelectedReport()
   at ReportViewer.Button_Click(Object sender, EventArgs e)
Thread Name: 
Win32 ThreadId:2932
Reena Jain replied to Sumit Tyagi on 15-Nov-11 03:00 AM
hi,

I Solved the Problem by setting permission in  dcomcnfg

step1 :Go to run type dcomcnfg

Step2: Click >Component services >Computes >My Computer>Dcom config> and select micro soft Excel Application>

Step3: Right Click on microsoft Excel Application>Properties>Give Asp.net Permissions

Step 4: Select Identity table >Select interactive user >select ok

that will work fine


or check this
http://support.microsoft.com/?kbid=892544
Jitendra Faye replied to Sumit Tyagi on 15-Nov-11 03:33 AM

According to http://geekswithblogs.net/mnf/articles/89483.aspx


There should be a listener added for the category of 'Trace, Http Handler' in the configuration file, like the following:


<categorySources>   
   <add name="Debug" switchValue="All">
   <listeners>
    <add name="Debug Destination" />
    <add name="TextBox Destination" />
   </listeners>
   </add>
</categorySources>

Sumit Tyagi replied to Reena Jain on 16-Nov-11 08:39 AM
Thanks Reena u r rite.
I found the solution after following ur steps