E-PIA: IANATIMEZONETOPSTIMEZONE: SAMEXECFETCH FAILED

(Doc ID 2261884.1)

Last updated on SEPTEMBER 13, 2017

Applies to:

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

Symptoms

After applying Patch 8.55.13, which added the new table PSTIMEZONEMAP. Logs are show thousands of repeated failures attempting to execute SQL against that table that is incorrect.

Repeated error in Application Server logs:
PSAPPSRV.11940 (5) [2017-03-13T00:00:00.210 0001571579@xxxxxxxxx (IE 11.0; WIN7) ICQuery] - - - (1) IANATimeZoneToPSTimeZone: SamExecFetch Failed.
PSAPPSRV.11940 (5) [2017-03-13T00:00:00.248 0001571579@xxxxxxxxx (IE 11.0; WIN7) ICQuery] - - - (3) File: E:\pt85513b-retail\peopletools\src\pssys\qdmutil.cppSQL error. Stmt #: 6062 Error Position: 0 Return: 8601 - [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 (SQLSTATE 22001) -99999
Failed SQL stmt: SELECT TIMEZONE FROM PSTIMEZONEMAP WHERE IANA_TIMEZONE = :1 OR TIMEZONE = :1

And from a SQL trace:

PSAPPSRV.38896 (865) 1-251736 09.31.39 0.002000 Cur#1.38896.PSPROD RC=0 Dur=0.002000 COM Stmt=SELECT TIMEZONE FROM PSTIMEZONEMAP WHERE IANA_TIMEZONE = :1 OR TIMEZONE = :1
PSAPPSRV.38896 (865) 1-251737 09.31.39 0.000000 Cur#1.38896.PSPROD RC=0 Dur=0.000000 Bind-1 type=2 length=15 value=America/Chicago


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