Auto Job notification error for STAT 5.7.2 from PSLockSynch (4305641)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Auto Job notification error for STAT 5.7.2 from PSLockSynch
Description

In Stat 5.7.2 with PS 8.54 when runnin PSLockSynch job the error below is raised by the agent log.
ERROR [QuartzWorkerThread-7] (PSObjectLockSyncBean.java:341) - ******* SQL Exception ******
ERROR [QuartzWorkerThread-7] (PSObjectLockSyncBean.java:342) - SQLState: 42815
ERROR [QuartzWorkerThread-7] (PSObjectLockSyncBean.java:343) - Message : [jcc][10145][10844][3.51.90] Invalid parameter 2: Parameter index is out of range. ERRORCODE=-4461, SQLSTATE=42815
ERROR [QuartzWorkerThread-7] (PSObjectLockSyncBean.java:344) - Vendor : -4461
ERROR [QuartzWorkerThread-7] (PSObjectLockSyncBean.java:345) - *****************************
FATAL [QuartzWorkerThread-7] (StatBaseJob.java:174) - Error executing job: 23, org.quartz.JobExecutionException: javax.ejb.EJBException: com.ibm.db2.jcc.a.bn: [jcc][10145][10844][3.51.90]
Invalid parameter 2: Parameter index is out of range.
Cause

PS 8.54 uses a different table for PSOBJGROUP name than previous versions of PeopleSoft.
The 5.7.2 release runs PS object locking against the new table when it should look at the tools release and uses 1 table for 8.54 and a different table for everything else.
Resolution

The 5.7.2 release runs PS object locking against the new table when it should look at the tools release and use 1 table for 8.54 and a different table for everything else.
This statement that the object group is not found in the db could be because the PS release is less than 8.54.
Apply Stat 5.7.2 HF-b.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Auto Job notification error for STAT 5.7.2 from PSLockSynch (4305641)

Title

Description

Cause

Resolution

Leave a Comment