My Oracle Support Banner

AgentAuditLoggingException ORA-12899: value too large for column Error on CSR_UPD_PROPS.PROPERTY_NAME Column in AuditRepository (Doc ID 2100266.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Commerce Service Center - Version 10.0 and later
Information in this document applies to any platform.

Symptoms

The Commerce Service Center (CSC) server periodically reports the following exception:

**** Error Mon Jan 25 10:36:59 CST 2016 1453739819054 /atg/agent/logging/AuditRepository SQL Statement Failed: [++SQLInsert++]
 INSERT INTO csr_upd_props(id,version,property_name,old_value,new_value,audit_id)
 VALUES(?,?,?,?,?,?)
-- Parameters --
p[1] = {pd} 608400008 (java.lang.String)
p[2] = {pd: version} 1 (java.lang.Integer)
p[3] = {pd: propertyName} creditCards[visa - 1234:credit-card:userxxxxxxxxxxxx].expirationYear (java.lang.String)
p[4] = {pd: oldValue} 2016 (java.lang.String)
p[5] = {pd: newValue} 2019 (java.lang.String)
p[6] = {pd: owner} xxxxxxxxx (java.lang.String)
[--SQLInsert--]
java.sql.SQLException: ORA-12899: value too large for column "CSC_AGENT"."CSR_UPD_PROPS"."PROPERTY_NAME" (actual: 68, maximum: 40)

or

**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository SQL Statement Failed: [++SQLInsert++]
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository INSERT INTO csr_upd_props(id,version,property_name,old_value,new_value,audit_id)
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository VALUES(?,?,?,?,?,?)
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository -- Parameters --
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository p[1] = {pd} 300006 (java.lang.String)
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository p[2] = {pd: version} 1 (java.lang.Integer)
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository p[3] = {pd: propertyName} creditCards[sss:credit-card:usercc10001].address1 (java.lang.String)
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository p[4] = {pd: oldValue} 1111Address Line 1Address Line 1Address Line (java.lang.String)
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository p[5] = {pd: newValue} 2222Address Line 1Address Line 1Address Line (java.lang.String)
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository p[6] = {pd: owner} 600028 (java.lang.String)
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository [--SQLInsert--]
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001410 /atg/agent/logging/AuditRepository
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001411 /atg/commerce/custsvc/logging/PaymentGroupEventRecorder --- CONTAINER:atg.agent.logging.AgentAuditLoggingException;SOURCE:CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLDataException: [SERVERNAME]String or binary data would be truncated.
**** Error Mon Jan 21 08:13:21 EST 2013 1358774001411 /atg/commerce/custsvc/logging/PaymentGroupEventRecorder Msg 8152, Level 16, State 14, Line 1, Sqlstate 22001
...

 

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.