E-RD:Unexpected data type code:None.(180,605) At PSRF_REPORT_CREATE.CreateReport (Doc ID 621029.1)

Last updated on OCTOBER 01, 2023

Applies to:

This document was previously published as Customer Connection Solution 200758702

Symptoms

 
The user receives the following error message while trying to view reports in the Report Manager for the Explorer and List tabs:

Unexpected data type code: None. (180,605) At PSRF_REPORT_CREATE.CreateReport.  

In this case the user was upgrading from PeopleTools 8.19 to 8.43.04 and HRMS 8.8 and they found that their reports were not visible on the Report Manager for the Explorer and List tabs.  They had previously created new Report Manager folders on the administration page.  Here is the error that appears in the following navigation: Home > PeopleTools > Integration Broker > Message Detail > Under the section named Subscription Contract Errors of the (AMM_MSGPROPS) page.

Message Monitor shows each report post errors with details:
Unexpected data type code: None. (180,605) At PSRF_REPORT_CREATE.CreateReport.Subscription InsertFolder   PCPC:1559  Statement:21

THINGS TRIED:

1. <Document:616858.1>   PT8.4x - Unable to view report in Explorer or List tab of report manager with a new user.  Why?

2. <Document:614763.1>  - PT8.4 - Report is not showing in Explorer or List page of the Report Manager.  How does it work and what settings need to be configured for them to work? For Oracle See Also 200726561.

3. Note:  If the folders still do not appear on the Explorer or List tabs, you may need to delete and recreate the folders from the System Settings page.  Add the messages to the DEFAULT local node. One user added them to another local node and that was what was causing the issue. They added them to the Financials Node which links to Portal not the Default Local Node. The Node needs to be defined in the IntegrationGateway.Properties file on the Web Server. If the nodes you used are not defined there then you will not be able to use them.  

Here is an example of how the IntegrationGateway.Properties file should be changed:

ig.isc.serverURL=//birch:9300
ig.isc.userid=PS
ig.isc.password=5L/k/MZY1FM=
ig.isc.toolsRel=8.43

ig.isc.PT_LOCAL.serverURL=//birch:9300
ig.isc.PT_LOCAL.userid=PS
ig.isc.PT_LOCAL.password=5L/k/MZY1FM=
ig.isc.PT_LOCAL.toolsRel=8.43

4. Also, tried shutting down the webserver, appserver, process scheduler and deleting the cache files since the pub/sub services may have needed to be restarted.  

weblogic cache: C:\bea\wlserver6.1\config\peoplesoft\applications\PORTAL\ps
process scheduler cache: 8.1X:  C:\myserver\PT820\appserv\<cache folder>
process scheduler cache: 8.4X: F:\E841P843\appserv\prcs\E841P843\CACHE
appserv/domain name
 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.