E1: OS: CNDW Error Message on UBEs Causing Performance Issues - AS400 iSeries Platform (Doc ID 656138.1)

Last updated on JULY 28, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
IBM i on POWER Systems

Symptoms

UBES submitted via Batch Versions to AS400 Enterprise Server go into CNDW (Condition Wait Resulting in Error) due to SQL server mode being activated in the server JDE.INI.
UBES running with SQL Server Mode turned on will spend more time in status CNDW. This occurs as they are waiting for their corresponding QSQSRVR job to finish handling the database request. So this status is not inherently bad.
Error found in JDE.LOG:

 

Changes

 

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