My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

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:


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

To view full details, 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 a vibrant support community of peers and Oracle experts.