My Oracle Support Banner

ILM_DT / ILM_ARCH_SW “not Nullable” In CI_TD_ENTRY. (Doc ID 2158506.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.3.0 and later
Information in this document applies to any platform.

Symptoms

**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

CCB - Oracle Utilities Customer Care and Billing
SQL - Standard Query Language

 

On CCB v2.4.0.3.0

ILM_DT / ILM_ARCH_SW “not nullable” in CI_TD_ENTRY.  

After the migration from 2.3.1 to 2.4.0.3 one is not able anymore to update todo because of the ILM_DT / ILM_ARCH_SW wich is “not nullable” in CI_TD_ENTRY. Is it normal to have a not nullable column for ci_td_entry. ILM_DT / ILM_ARCH_SW whereas all the other ILM_DT / ILM_ARCH_SW columns are nullable?

Moreover when you have a look to the meta data this column is supposed to be nullable (as you can see in the CI_MD_TBL_FLD_EXTRACT. The workaround is to alter the CI_TD_ENTRY table to set those columns as nullable . Is it possible to confirm that this work around is correct ?

Expected behavior
-------------------------
One is able to update TODOs.

ERROR
-----------------------
12:10:01,323 [CobolThread 4] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper) ORA-01407: impossible de mettre à jour ("CISADM"."CI_TD_ENTRY"."ILM_DT") avec NULL
12:10:01,323 [CobolThread 4] ERROR (com.splwg.base.support.context.FrameworkSession) Failed to flush session org.hibernate.QueryTimeoutException: ORA-01407: impossible de mettre à jour ("CISADM"."CI_TD_ENTRY"."ILM_DT") avec NULL


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Migrate from 2.3.1 to 2.4.0.3
2. Try and update any todo
3. Expect the application to crash

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
The system is crashing when he try to update a Todo.

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
References


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