My Oracle Support Banner

E-UPG: PT8.56: Change Assistant System Filter Query Step Fails / Result: Change Assistant Failure: SQL Error. Error Position: 0 Return: 0 - A SELECT item number is outside valid range for query (SQLSTATE PS095) (Doc ID 2337212.1)

Last updated on NOVEMBER 23, 2019

Applies to:

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

Symptoms

PROBLEM STATEMENT:
-----------------------------------
While upgrading PeopleTools to version 8.56.04 using Change Assistant 8.56.04 the initial step "Running the PeopleTools System Filter Query" fails with one of the following errors :
 
ERROR
-----------------------
Filter Query Name: Filter2040
Filter Query ID: PT_ANSI
Description: no description
True If Value: N
Query: Database Unicode Only
Compare Value Type: String
Compare operation: contains
Directory Type:
File Name:
Result: Change Assistant Failure: SQL Error. Error Position: 0  Return: 0 - A SELECT item number is outside valid range for query (SQLSTATE PS095)

or

ERROR
-----------------------
Filter Query Name: Filter2040
Filter Query ID: PT_ANSI
Description: no description
True If Value: N
Query: Database Unicode Only
Compare Value Type: String
Compare operation: contains
Directory Type:
File Name:
Result: Change Assistant Failure: SQL Error. Error Position: 21 Return: 0 - Invalid SELECT item number

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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