My Oracle Support Banner

E1: 31P: UBE Errors Out, Producing an Event Rule Error for Competing Background Processes (Doc ID 2080055.1)

Last updated on JUNE 29, 2022

Applies to:

JD Edwards EnterpriseOne Engineer to Order - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

When running Rollup ETO costs to Workbench (R31P301), the UBE job runs for a while (approx 20-30 minutes) and then errors out.  It is producing an Event Rule error. 

ERROR:
Various. Including:

Event Rule: Business Function RollupCosts at line 9 for Event 15 in Section Actual Cost Rollup has caused a memory violation.

14040/14700 WRK:Starting jdeCallObject ODBC[jdbodbc.C,4692] wSQLCloseCursor - warning: invalid cursor state failure. rc = -1
14040/14700 WRK:Starting jdeCallObject ODBC[jdbodbc.C,4692] STMT:00 [24000][0] [Microsoft][SQL Server Native Client 10.0]Invalid cursor state


ODB0000164 - STMT:00 [42000][16943][2] [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not complete cursor operation because the table schema changed after the cursor was declared.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.