My Oracle Support Banner

WCC Scheduled Job failing: Cannot Insert NULL Into ("Server_OCS"."HTMLCONVERSIONSUMS"."DLASTKEY") (Doc ID 2308409.1)

Last updated on JULY 24, 2023

Applies to:

Oracle WebCenter Content - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

A scheduled job is failing with the following error

[2017-09-03T02:00:35.140+02:00] [WCC_UCM1] [ERROR] [UCM-CS-000008] [oracle.ucm.idccs] [tid: Scheduled System Events] [userId: ] [ecid: <ECID>] [APP: Oracle Universal Content Management - Content Server] [partition-name: DOMAIN] [tenant-name: GLOBAL] service exception[[
intradoc.common.ServiceException:
  at intradoc.server.converter.ConverterUtils.deleteExpiredConversions(ConverterUtils.java:560)
  at intradoc.server.DatedCacheUtils.removeDatedCaches(DatedCacheUtils.java:67)
  at intradoc.server.ScheduledSystemEvents.checkHandleEvent(ScheduledSystemEvents.java:638)
  at intradoc.server.ScheduledSystemEvents.processWork(ScheduledSystemEvents.java:591)
  at intradoc.server.ScheduledSystemEvents.run(ScheduledSystemEvents.java:490)
  at java.lang.Thread.run(Thread.java:745)
Caused by: intradoc.data.DataException: !csJdbcGenericError
  at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2729)
  at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:683)
  at intradoc.server.converter.ConverterUtils.setConversionSumValues(ConverterUtils.java:270)
  at intradoc.server.converter.ConverterUtils.deleteExpiredConversions(ConverterUtils.java:542)
  ... 5 more
 Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("SERVER_OCS"."HTMLCONVERSIONSUMS"."DLASTKEY")

  

Changes

 

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
Changes
Cause
Solution
References


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