When any nVision report is run via the web, it result in errors such as:
‘Excel interface exception E:pt84918b-retailpeopletoolssrcpsnxlgridapp.cpp:2048 Microsoft Office Excel cannot access the file ‘pshomenvisionLAYOUTF_allocations_2.xnv’.
But the same report can be run in 2 or 3 tier client workstation.
Upgrading from Windows 2003 to Windows 2008 caused this issue to appear.
PeopleSoft Development has provided a workaround to be implemented on the affected process scheduler machine:
1) Take a backup of the registry before proceeding
2) Associate AppID of “Microsoft Office Excel Application” to its Class ID under the Wow6432Node registry node.
2.1) Create a new String Value by name “AppID” under the following registry key.
2.2) Insert the following string into the “Value data” of “AppID”.
3) DCOMCNFG settings for Excel has to be modified to run Excel under a Specific User account (we recommend a domain admin account)
3.1) Open DCOMCNFG through Run command of Windows.
3.2) Navigate to Component Services/Computers/My Computer/DCOM Config.
3.3) Find “Microsoft Excel Application” and open its properties dialog.
3.4) Go to Identity tab and select “This User” option. Here provide the User credentials and click on OK button.
4) Reboot the machine.