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

(Doc ID 2308409.1)

Last updated on SEPTEMBER 18, 2017

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: d37339a5-fad0-479b-9a68-07d85674cc91-0000000a,0:736:1] [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")

  

Cause

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