Reports stuck in pending status, no errors in logs

Expand / Collapse
 

Reports stuck in pending status, no errors in logs


Article ID: 51478 - Last Review: , November 23, 2012

PROBLEM

Reports are stuck in a Pending status on the server.

SYMPTOMS

Reports are stuck in pending status.  If multiple reports are run, you will see the excel process numerous times in Task Manager unless auditing is enabled.  If auditing is enabled, it will eventually cause the report to display 'Failed'.

The Reporting.txt log shows absolutely nothing about the report being run, and the reporting service is started and funcitonal.

Attempting to export an Inspector report to excel also exhibits the same issue, where it will never complete the export.

Customer is using Excel 2007 

CAUSE

VBA is disabled in Microsoft Office, which in turn limits excel functionality, including report generation.

For more information please reference the following:  http://support.microsoft.com/kb/282847

 

RESOLUTION

You can open Excel and try the following:

1. Click the Office Button (top-left most button in the window)
2. Click the Excel Options button.
3. Click Trust Center in the menu on the left.
4. Click Trust Center Settings in the window on the right.
5. In the new window that opens click Macros in the menu on the left.
6. Check the box next to Trust Access to the VBA project object model.
7. Click OK.
8. Click OK.
9. Close all Office applications and try your project again.


If this does not work, you will need to add the VBA feature to Excel.

1. Go to the Control Panel.
2. Right-click Microsoft Office 2007 and select Change
3. When the Office screen comes up select Add-Remove Features.
4. Expand the Office Shared Features section and select Visual Basic for Applications.
5. Choose Run from My Computer.
6. Click Continue and follow the on-screen prompts to finish the feature change.
7. Go to Start => Run and type services.msc .
8. Restart the prairieFyre Reporting Service.



APPLIES TO

CCM all versions, Excel 2007 

Keywords: Report Pending 6.0 Excel



Rate this Article:
     

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Friday, November 23, 2012
Last Modified By: amontpetit
Type: FIX
Article not rated yet.
Article has been viewed 7,340 times.
Options