My Oracle Support Banner

E-PRCS: DB2 SQL Error 'SQL0401N The Data Types Of The Operands For The Operation "" Are Not Compatible' (Doc ID 1571450.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 to 8.52 [Release 8.4]
Information in this document applies to any platform.

Symptoms

 When booting the Process Scheduler on PeopleTools 8.52 running DB2 the following errors appear in the Process Scheduler log files:

 File: E:\pt85209c-retail\peopletools\src\psschdlr\schedulermonitor.cppSQL error. Stmt #: 334 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0401N The data types of the operands for the operation "" are not compatible. SQLSTATE=42818 (SQLSTATE 42818) -401
Failed SQL stmt:UPDATE PSPRCSQUE SET RUNSTATUS = 10, DISTSTATUS = 0 WHERE RUNSTATUS = 7 AND PRCSINSTANCE = JOBINSTANCE AND MAINJOBNAME IN (SELECT A.MAINJOBNAME FROM PSPRCSQUE A, PS_PRCSJOBITEM B WHERE A.MAINJOBNAME = B.PRCSJOBNAME AND A.PRCSJOBSEQ = B.PRCSJOBSEQ AND A.PRCSTYPE = 'Application Engine' AND A.RUNSTATUS = 3 AND B.RUNALWAYS NOT IN ('1', '2'))
PSPRCSRV.2784 (0) [11/06/12 08:13:22  Database Options: override_connection_reset: 0

 

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.