E1: DB: Error SQL0501 - Cursor Not Open When Updating Tables F0002 or F00022 (Doc ID 1338825.1)

Last updated on AUGUST 14, 2017

Applies to:

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

Goal

The Enterprise Server is running iSeries V7R1 and users are having issues working in some applications like P4310.  When executing the application from a WebDev client from design tools and then Run HTML from the Row Exit bar, users get an error on screen:

Update to Table F00022 failed .... Check the JDE.LOG and JDEDEBUG.LOG for additional information

On the JDEDEBUG.LOG the following errors are found:

Jun 29 14:28:51.554004 - 4320/4984 WRK:Starting jdeCallObject UPDATE TESTDTA/F00022 SET UKOBNM='RRESERVE ',UKUKID=26498.000000 WHERE CURRENT OF C1A90BCB8
Jun 29 14:28:51.554005 - 4320/4984 WRK:Starting jdeCallObject Entering DBPerformRequest
Jun 29 14:28:51.554006 - 4320/4984 WRK:Starting jdeCallObject ODBC:I DBPerformRequest req=2C745110 con=2C9350F8 env=05D23078 dbc=1AD89E60 spid=0 WTES203A A (C0203OW@Business Data - DEV)
Jun 29 14:28:51.570000 - 4320/4984 WRK:Starting jdeCallObject ODBC[Jdbodbc.c,3990] wSQLPrepare failure. rc = -1
Jun 29 14:28:51.570001 - 4320/4984 WRK:Starting jdeCallObject ODBC[Jdbodbc.c,3990] STMT:00 [07005][-501] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501 - Cursor C1A90BCB8 not open.
Jun 29 14:28:51.570002 - 4320/4984 WRK:Starting jdeCallObject ODB0000163 - wSQLPrepare failure. rc=-1
Jun 29 14:28:51.570004 - 4320/4984 WRK:Starting jdeCallObject ODB0000164 - STMT:00 [07005][-501][2] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501 - Cursor C1A90BCB8 not open.

----------------

Jun 29 13:52:40.056008 - 4320/4496 WRK:Starting jdeCallObject UPDATE TESTCTL/F0002 SET NNN001=100274.000000,NNN002=1605.000000,NNN003=1.000000,NNN004=440172.000000,NNN005=0.000000,NNN006=6885.000000,NNN007=1052.000000,NNN008=0.000000,NNN009=0.000000,NNN010=0.000000 WHERE CURRENT OF C1A90C958
Jun 29 13:52:40.056009 - 4320/4496 WRK:Starting jdeCallObject Entering DBPerformRequest
Jun 29 13:52:40.056010 - 4320/4496 WRK:Starting jdeCallObject ODBC:I DBPerformRequest req=2C744310 con=1BD63EA0 env=05D23078 dbc=1AD89F30 spid=0 WTES203A A (C0203OW@Control Tables - Dev)
Jun 29 13:52:40.056011 - 4320/4496 WRK:Starting jdeCallObject ODBC[Jdbodbc.c,3990] wSQLPrepare failure. rc = -1
Jun 29 13:52:40.056012 - 4320/4496 WRK:Starting jdeCallObject ODBC[Jdbodbc.c,3990] STMT:00 [07005][-501] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501 - Cursor C1A90C958 not open.
Jun 29 13:52:40.056013 - 4320/4496 WRK:Starting jdeCallObject ODB0000163 - wSQLPrepare failure. rc=-1
Jun 29 13:52:40.056015 - 4320/4496 WRK:Starting jdeCallObject ODB0000164 - STMT:00 [07005][-501][2] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501 - Cursor C1A90C958 not open.


After doing some troubleshooting, it was found that when creating an OCM mapping for the X0010 and X00022 BSFNs to process on the server applications worked without any issues.


Solution

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