My Oracle Support Banner

Cannot Complete an Event with this Logged to JMService - error='ORA-12899: value too large for column "JOBS"."LAST_GASP_COUNT" (Doc ID 3060732.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Utilities Network Management System - Version 2.6.0.1.0 to 2.6.0.2.0 [Release 2.6]
Oracle Network Management for Utilities - DMS - Version 2.6.0.1.0 to 2.6.0.2.0 [Release 2.6]
Information in this document applies to any platform.

Symptoms

Attempting to complete an event but  it still shows as JOBS.active = 'Y'.  When it was attempted to be closed, there was a message in JMService log  file:

11/22/24 12:53:37Z: JMService 0x7f2034e70700,ctp=0x7d72518,"JMBroadcast::flush(writeToDB) - writing" *ERROR* - sql failed:
result=-1 error='ORA-12899: value too large for column "JOBS"."LAST_GASP_COUNT" (actual: 20, maximum: 10)

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
 Fix Description
 Migration
References


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