When any nVision report is run via the web, it result in errors such as:

‘Excel interface exception E:\pt84918b-retail\peopletools\src\psnxl\gridapp.cpp:2048 Microsoft Office Excel cannot access the file ‘pshome\nvision\LAYOUT\F_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.
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\CLSID\{00024500-0000-0000-C000-000000000046}

The Environment variable PS_CFG_HOME new in this version,  has been created to hold the configuration files for the application server, batch server and search server domains.

This posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.

If you have more PS_HOMEs on the same machine, you can create a separate Windows Service for each environment with the next steps:

Step1 – Setting PS_CFG_HOME

Create a  .bat file in each PS_HOME/appserv folder, for example psadmin.bat. This file would contain the following:

In Tools 8.50 the ‘secureFileKeystorePasswd’ parameter of the integrationgateway.properties file must now be encrypted.

This posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.

That can be done  through the application so that you do not need to restart the web server.
1. Navigate to PeopleTools -> Integration Gateway -> Configuration – Gateways.

PeopleCode compile error after a Tools-only upgrade to PeopleTools 8.50

This posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.

Five new keywords have been introduced in PeopleTools 8.50:

• Primitive
• Compound
• Collection
• Document
• DocumentKey

Some applications released before 9.1 use the word “collection” as class name what result in a PeopleCode compiler error such as:

PeopleCode compiler error.(The create operator can only be used for application classes(2,96)) for program xxxx.yyyy.OnExecute(2,405).

This posts is a part of the PeopleTools 8.50 Hints & Tips series on BAOA regarding PeopleSoft 8.50 tools upgrade.

Configuring Report Manager – List/Explorer – PeopleTools 8.50

Report Manager is a utility in PeopleSoft to view reports from another place than Process Monitor. It has fours pages: List, Explorer, Administration and Archives.

Setup of Integration Broker needs to be done and PUB/SUB App Server Processes are required to be up and running.

Configuration steps

Service Operation configuration

IB needs to be configured for four services

• PSRF_FOLDER_CREATE
• PSRF_REPORT_CREATE
• PSRF_REPORT_DATE _CHANGE
• PSRF_REPORT_DELETE

Navigate to PeopleTools -> Integration Broker -> Integration Setup -> Service Operations

Open Service Operation  PSRF_FOLDER_CREATE

In the General tab:

• Be sure that  the Service Operation  active
• If the Routing status from Local-to-local is “Does not exist”, check “Generate Local- to-Local” and click the Save button.

In the Routings tab, verify if there is only one routing definition active.

Repeat this step for the other  three services.

Clean cache and restart the application server.