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.

Apurva Tripathi
 

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

Click Here to Leave a Comment Below 0 comments