E-PC: Error in Find In SQL Definition in Application Designer Peopletools 8.55.15 on DB2. (Doc ID 2276005.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms

Error when trying to perform a Find In SQL Definitions, using Application Designer of PeopleTools 8.55.15 on DB2.
The issue does not replicate on Oracle. It does not replicated on MS SQL Server.

To replicate the issue:

Open Application Designer
Enter the string to be search for in field Find What: (e.g.: INSTALLATION)
Find Type: Text string in SQL
Project: Entire Database
Search Filters - Select 1 and only 1 from the options:
- Standalone SQL Definitions
- Application Engine SQL Definitions
- Record View SQL Definitions

Application Designer abends with error message:
File: E:\pt85515b-retail\peopletools\src\pside\PSFindInDlg.cppSQL error. Stmt #: 1863 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0103N The numeric literal "0AND" is not valid. SQLSTATE=42604
(SQLSTATE 42604) -103
Failed SQL stmt: SELECT COUNT(*) FROM PSSQLTEXTDEFN WHERE SQLTYPE = 0AND UPPER(SQLTEXT) LIKE UPPER('%INSTALLATION%')

 

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