My Oracle Support Banner

Cannot Assign Number Property To Counter Template - Error: CSI_COUNTER_TEMPLATE_PVT Procedure UPDATE_CTR_PROPERTY_TEMPLATE (Doc ID 1375465.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


When attempting to update counter template, by adding a new property with Data Type = Number,
the following error occurs.

ERROR
-----------------------
'ORA-01407: cannot update ("CSI"."CSI_CTR_PROPERTY_TEMPLATE_B"."CREATION_DATE") to NULL in Package CSI_COUNTER_TEMPLATE_PVT Procedure UPDATE_CTR_PROPERTY_TEMPLATE'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
(R): Oracle Installed Base Agent User
(N): Counters -> Groupings.
Search for counters group
Click Update icon
Click Update icon for counter template
In Properties area, push Add Another Row button
Add any property with Data Type = Number
Push Apply button
Error message above is displayed

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.