If you are getting this error, here is a quick fix.
Set the following value in psappsrv.cfg (appserver) and psprcs.cfg (batch server) for all the configured appservers and batch servers. You may have to reconfigure the appserver and batch servers and restart them.
DbFlags=8
Default value is DbFlags=0 which means use Persistent Secondary DB Connection.
Setting DbFlags=4 is not recommended by PeopleSoft, which completely disables the secondary database connection.
Setting it to 8 disables Persistent Secondary DB Connection, but it still uses on demand Secondary DB Connection for each request. This is required for using GetNextNumberWithGapsCommit (GNNWGC) function, which is internally used by PeopleSoft for workflow transactions to generate APPR_INSTANCE
If you do not do this, you may get row inserted in PS_APPR_INST_LOG with APPR_INSTANCE = 0 which may cause, some undesired workflow routings.
The easiest solution I have found is
delete from ps_appr_inst_log where APPR_INSTANCE = 0
Please make sure that you backup the data and test it.
No comments:
Post a Comment