E-PN: 'Failed SQL stmt: SELECT PACKAGEROOT, APPCLASSID FROM PSPTPNCOLL WHERE PTPNCOLLNAME = :1 ' Errors In App Server Log Relating To Push Notification

(Doc ID 2383412.1)

Last updated on APRIL 06, 2018

Applies to:

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

Symptoms

On : PT8.55

Appserver log is showing the following errors:

PSAPPSRV.8564 (203) [2017-12-11T08:25:33.440] - - - (3) File: E:\pt85512b-retail\peopletools\src\psevent\psevent.cppSQL error. Stmt #: 325 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0]String data, right truncation (SQLSTATE 22001) 0
Failed SQL stmt: SELECT PACKAGEROOT, APPCLASSID FROM PSPTPNCOLL WHERE PTPNCOLLNAME = :1
PSAPPSRV.8564 (203) [2017-12-11T08:25:33.440] - - - (1) GenMessageBox(200, 0, M): E:\pt85512b-retail\peopletools\src\psevent\psevent.cpp: A SQL error occurred. Please consult your system log for details.

The said error appears randomly.


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