Pages

Common nVision Error Setups

User actions can cause many errors with PeopleSoft nVision.

Here are the scenarios under which I have been able to generate an OLE and/or Excel interface exception errors. If your users are reporting any of these, check below to see if it helps you identify is any user behavior is causing the error.

1.    Kicked off an nVision report, and then while it is processing, kick off a query at the same time to Excel in 3-tier




2.    Kicked off a report and then during the “Initializing” phase I put  a cell on another spreadsheet into edit mode by typing F2 and leaving it – this simulates actively working on another spreadsheet while the nVision report is running.







3.    Kicked off a report and then during the data fetch phase, I put a cell on another spreadsheet into edit mode by typing F2 and leaving it.





4.    Start nVision and then open any regular existing Excel spreadsheet and make some changes to the spreadsheet. Do not save the changes.
Then kick off an nVision report.
While in the initializing phase, close the other spreadsheet.

(Note that the error does not occur when saving a workbook that has not been changed and does not issue the Save dialog box)

Two interface exceptions were received, including the gridapp.ccp:1828 error that Rob sent us





5.    Start nVision and then open any regular existing Excel spreadsheet and make some changes to the spreadsheet. Do not save the changes.
Then kick off an nVision report.
While in the data fetch phase, close the other spreadsheet.

(Note that the error does not occur when saving a workbook that has not been changed and does not issue the Save dialog box)




 

OLE Errors with nVision and Outlook Social Plug-In

Once our work environment moved to Windows 7 / Excel 2010, the occurrence of OLE errors with nVision increased for some users. The specific error message received is “Excel is waiting for another application to complete an OLE action” and the users report that they have to force a shutdown of nVision through Task Manager and restart nVision.
 
After spending some time researching what I could find online, one thing that was of interest was a recommendation to disable the Outlook Social Connector Add-in. We are currently testing if this improves things for affected users, and if your users are having similar issues, you might like to try this.
 
Here are the steps required to disable the Outlook Social Connector Add-In:
 
 

Within Outlook, click File > Options

 
 
 
 

Select Add-Ins on the left and then Go for COM Add-Ins:

 
 
 

Uncheck Microsoft Outlook Social Connector. Click OK and shut down and restart Outlook.