E-PORTAL: Creating the Pagelet Based on Query Generating SQL Error (Doc ID 1663907.1)

Last updated on SEPTEMBER 30, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.

Symptoms

On : 8.52.12 version,HCM9.1 FP2 Portal Technology

When attempting to create the pagelet based on query (AV_BIO_ADDRESSES for example) and on DB2 database, the sql error occurs. It is working fine on oracle database. This can be replicated on 8.52.xx and 8.53.09.

the following error occurs.

ERROR
-----------------------
Fatal SQL error occurred. (2,125) PTPPB_PAGELET.Pagelet.OnExecute Name:Save PCPC:106139 Statement:1744
Called from:PTPPB_WIZARD.GBL.SavePostChange Statement:5

A SQL error has occurred, review the SQL to determine the cause of the error.

Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to PeopleTools->Portal->Pagelet Wizard, add a new pagelet
2. select PS Query from the data type.
3. Enter AV_BIO_ADDRESSES query, then click next, next and next.
4. Select to publish the pagelet as homepage pagelet and select one folder.
5. Click Save button.



Cause

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