PSMSTPRC service suddenly stops after few mints of bringing up the Process scheduler in unix
Hi All,
Facing very strange issue for one of the application PSMSTPRC service for Unix Process Scheduler stops after few mints of bringing up the process scheduler due to which the master becomes N and PSJOB for APY1400 gets in processing state, Unable to find the reason why PSMSTPRC gets down after brining it up, rest all services are up.
We don't use PSDaemon.
Please share your thoughts.
Below is the error from stdout :
File: /vob/peopletools/src/psmgr/mgrgensql.cppSQL error. Stmt #: 2053 Error Position: 0 Return: 8602 - [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 (SQLSTATE 22001) -99999
Failed SQL stmt:SELECT LASTUPDDTTM, LASTUPDOPRID, VERSION, SLEEPTIME, HEARTBEAT, MAXAPIUNAWARE, MAXAPIAWARE, OPSYS, DESCR, DISTNODENAME, TRANSFERLOGFILES, TRANSFERMAXRETRY, TRANSFERINTERVAL, REDISTWRKOPTION, SRVRLOADBALOPTN, DAEMONGROUP, DAEMONENABLED, DAEMONSLEEPTIME, DAEMONPRCSINST, DAEMONCYCLECNT, PRCSNOTIFYFREQ, MAXCPU, MINMEM FROM PS_SERVERDEFN WHERE SERVERNAME = :1