E1: DB: Rowset Size and Performance in SQL Server 2008 Database (Doc ID 1144405.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.97 and Prior and later
Information in this document applies to any platform.

Symptoms

EnterpriseOne is configured as follows:

[JDENET]
enterpriseServerTimeout=60000

[DB SYSTEM SETTINGS]
SSQueryTimeout=1
SSQueryTimeoutRetries=17
Rowset Size=1

 

[JDENET]
enterpriseServerTimeout=60000

[DB SYSTEM SETTINGS]
SSQueryTimeout=1
SSQueryTimeoutRetries=17
Rowset Size=0

While running P09210A/P09214 it ends in error after 2 minutes time as follows:

BSFN failed and need roll back!! | Form Name : P09214_W09214A
com.jdedwards.runtime.base.SystemException: There was a problem with the sever while running the business function TrialBalanceCalculateBalances.
The server may still be available, but because of state information, the entire unit of work must be resubmitted.
Please exit the application and restart it.
Grid Record is Fetched Line number 138




BSFN failed and need roll back!! | Form Name : P09210A_W09210AA
com.jdedwards.runtime.base.SystemException: There was a problem with the sever while running the business function TrialBalanceCalculateBalances.
The server may still be available, but because of state information, the entire unit of work must be resubmitted.
Please exit the application and restart it.
Grid Record is Fetched Line number 114
P09210A_W09210AA



While running P09210A/P09214 on a Windows client in  JPD812, the following message appears:

JDE000126b
There was a problem with the server. You must exit this application all the way to the menu and restart it



The JDEDEBUG.LOG shows:

19:16:24 Entering JDB_SelectKeyed
16:16:24 SELECT GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBCO, GBAPYC, GBAN01, GBAN02, GBAN03, GBAN04, GBAN05, GBAN06, GBAN07, GBAN08, GBAN09, GBAN10, GBAN11, GBAN12, GBAN13, GBAN14, GBAPYN, GBBORG, GBBREQ, GBBAPR, GBMCU, GBSBLT, GBCRCD, GBCRCX FROM JDE_PRODUCTION.PRODDTA.F0902 WHERE ( GBAID = '00125137' AND GBCTRY = 20.000000 AND GBFY = 9.000000 AND GBFQ = ' ' AND GBLT = 'AA' ) ORDER BY GBAID ASC,GBCTRY ASC,GBFY ASC,GBFQ ASC,GBLT ASC,GBCRCD ASC
16:16:24 Entering DBPerformRequest
16:16:25 ODBC[Jdbodbc.c,7882] wSQLExecute failure. rc = -1
16:16:25 ODBC[Jdbodbc.c,7882] STMT:00 [HYT00][0] [Microsoft][SQL Server Native Client 10.0]Query timeout expired
16:16:25 ODBC[Jdbodbc.c,7919] wSQLCloseCursor - warning: invalid cursor state failure. rc = -1
16:16:25 ODBC[Jdbodbc.c,7919] STMT:00 [24000][0] [Microsoft][SQL Server Native Client 10.0]Invalid cursor state
...
*** this message repeats 17 times ***
19:16:42 Data selection processed with high concurrency option.
19:16:42 SELECT GBAID, GBCTRY, GBFY, GBFQ, GBLT, GBSBL, GBCO, GBAPYC, GBAN01, GBAN02, GBAN03, GBAN04, GBAN05, GBAN06, GBAN07, GBAN08, GBAN09, GBAN10, GBAN11, GBAN12, GBAN13, GBAN14, GBAPYN, GBBORG, GBBREQ, GBBAPR, GBMCU, GBSBLT, GBCRCD, GBCRCX FROM JDE_PRODUCTION.PRODDTA.F0902 WITH (NOLOCK) WHERE ( GBAID = '00125137' AND GBCTRY = 20.000000 AND GBFY = 9.000000 AND GBFQ = ' ' AND GBLT = 'AA' ) ORDER BY GBAID ASC,GBCTRY ASC,GBFY ASC,GBFQ ASC,GBLT ASC,GBCRCD ASC
19:16:43 Exiting DBPerformRequest
19:16:43 Exiting JDB_SelectKeyed with Success




Changes

In the logic server JDE.INI, the following change was made:

[DB SYSTEM SETTINGS]
Rowset Size=1

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