E-PC: Error in Find In SQL Definition in Application Designer Peopletools 8.55.15 on DB2.
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.
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%')
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms