PS/nVision Error – Excel interface exception

PS/nVision report on PeopleTools 8.5x version has a common error when it is run on Micrsoft Windows platform. The error shown below:

'Excel interface exception [E:\pt85420a-retail\peopletools\src\psnxl\gridapp.cpp:2172] Microsoft Excel cannot access the file '\\PS_HOME\FMS91\DVLP\NVISION\LAYOUT\MHSBS.xnv'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.' Error for 'Microsoft Excel: '. (28,160)
 Message Set Number: 28
 Message Number: 160
 Message Reason: 'Excel interface exception [E:\pt85420a-retail\peopletools\src\psnxl\gridapp.cpp:2172] Microsoft Excel cannot access the file '\\PS_HOME\FMS91\DVLP\NVISION\LAYOUT\MHSBS.xnv'. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.' Error for 'Microsoft Excel: '. (28,160)

It is a known issue and resolution of the issue is found in Microsoft’s website:

http://msdn.microsoft.com/en-us/library/ms678426(VS.85).aspx.

The issue occurs because on x64 operating systems, the 64-bit version of DCOMCNFG.EXE does not correctly configure 32-bit DCOM applications for remote activation. This behavior causes components that are meant to be activated remotely instead being activated locally.

Resolution

Run the 32-bit version of mmc.exe and load the 32-bit version of the Component Services snap-in by issuing the following command line.

C:\WINDOWS\SysWOW64>mmc comexp.msc /32

The 32-bit version of Component Services correctly registers 32-bit DCOM applications for remote activation.