Troubleshooting
Problem
YCS PLD Upload Failing with SQL Error : ORA-01401: inserted value too large for column at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
Symptom
The stack trace in YCS_Alert.log is:
Context:null @ <Errors><Error ErrorCode="YFC_ERR_CODE_NOTSETUP"
ErrorDescription="UNKNOWN"
ErrorRelatedMoreInfo="java.sql.SQLException"><Attribute Name="DBErrorCode"
Value="1401"/><Attribute Name="SQLState" Value="23000"/><Attribute
Name="SQLStatement" Value="INSERT INTO YCS_MANIFEST_UPS_DTL <br>...<br><Error
ErrorCode="java.sql.SQLException" ErrorDescription="UNKNOWN"
<br>ErrorRelatedMoreInfo="ORA-01401: inserted value too large for column
"><br><Stack>java.sql.SQLException: ORA-01401: inserted value too large for
column at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
Cause
Resolving The Problem
When running the UPS PLD Upload for warehouse, WHBU030 is failing with the
error:
In DCS_Alert.log:
75 |235077 |0 |CS0000 |110 |0 |3 |Carton
Number = 00005465004 | |whs_parm.c |1468 |CS:System Error. Contact System
Administrator |2 |20030227121236 |yantra |BU030
From
YCS_Alert.log
ORA-01401: inserted value too large for column
--The error message reported:
ORA-01401: inserted value too
large for column at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
The
problem occurs when the fields to be uploaded contain ampersands (&), often
occurring in Customer Name and/or Customer Address fields.
This is an
issue with custom code: the user exit contained a basic logic
error.
The logic was:
replace & with &
replace " with
"
parse XML
if (FEDEX) {
// Do some work
replace & with &
replace " with "
}
return XML
Fix:
Rework the logic so that any time special characters are encoded they are
subsequently decoded before being returned.
Historical Number
PRI49148
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21543275