E-RD:Unexpected data type code:None.(180,605) At PSRF_REPORT_CREATE.CreateReport
Last updated on OCTOBER 11, 2015
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.1 and later
Information in this document applies to any platform.
Upgrade from PeopleTools 8.1x to 8.4x
Checked for relevance on [15-JUL-2011]
This document was previously published as Customer Connection Solution 200758702
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
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:
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms