Troubleshooting
Problem
ORA-1461 ORA-1483 or YFC0011 Insert Failed on YFS_ORDER_AUDIT_DETAIL (Long column insert error) > fixed in 9.2.0.5 ojdbc14.jar, oracleDriver.zip
Symptom
PART: Yantra-Console 7.0 SP3 Platform
PRODUCT: Distributed Order
Management
COMPONENT: Order Management
DATABASE: Oracle
We
are seeing this error happen consistently for some kinds of SQLInserts into
tables that have a LONG column
for.e.g. YFS_ORDER_AUDIT_DETAIL
For
the failure scenario -
The first two INSERTs goes through ( Header
Change)
xxx2005-03-08 16:07:02,689:SQLDEBUG:ExecuteThread: '15' for queue:
'weblogic.kernel.Default': Executing sql [PREPARED STATEMENT - INSERT
/*YANTRA*/ INTO
YFS_ORDER_AUDIT_DETAIL(ORDER_AUDIT_DETAIL_KEY,ORDER_AUDIT_KEY,ORDER_AUDIT_LEVEL_
KEY,AUDIT_XML,CREATETS,MODIFYTS,CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPRO
GID,LOCKID) values (
200503081609001324855,200503081609001324853,200503081609001324854,A-Clob-Value,2
005-03-08T16:09:00,2005-03-08T16:09:00,UIuser,UIuser,Console,Console,0 ) :
YFCEntityDBHome
second insert goes through
(CreateOrder)
xxx2005-03-08 16:07:02,722:SQLDEBUG:ExecuteThread: '15' for
queue: 'weblogic.kernel.Default': Executing sql [PREPARED STATEMENT - INSERT
/*YANTRA*/ INTO
YFS_ORDER_AUDIT_DETAIL(ORDER_AUDIT_DETAIL_KEY,ORDER_AUDIT_KEY,ORDER_AUDIT_LEVEL_
KEY,AUDIT_XML,CREATETS,MODIFYTS,CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPRO
GID,LOCKID) values (
200503081609001324857,200503081609001324853,200503081609001324856,A-Clob-Value,2
005-03-08T16:09:00,2005-03-08T16:09:00,UIuser,UIuser,Console,Console,0 ) :
YFCEntityDBHome
the third INSERT fails (ChangeOrder with an
AddLine)
xxx<Error ErrorCode="YFC0011" ErrorDescription="Insert
failed. An unknown error was encountered." ErrorRelatedMoreInfo="The Statement
that was being executed is [INSERT /*YANTRA*/ INTO YFS_ORDER_AUDIT_DETAIL
(ORDER_AUDIT_DETAIL_KEY,ORDER_AUDIT_KEY,ORDER_AUDIT_LEVEL_KEY,AUDIT_XML,CREATETS
,MODIFYTS,CREATEUSERID,MODIFYUSERID,CREATEPROGID,MODIFYPROGID,LOCKID) values
(?,?,?,?,?,?,?,?,?,?,?)]">
=============================
A
variant on this same error is possible
where the Exception happens, on this
same table YFS_ORDER_AUDIT_DETAIL, Yantra catches it and tries logging an
exception and this causes an
ORA-1483 - ORA-1483 Invalid length for DATE or
NUMBER variable.
when inserting into INTO YFS_INBOX_REFERENCES.
again
the root cause is still the same wrong oracle driver.
=============================
another variant is
ErrorDescription="ORA-01461: can bind a LONG value only for insert into a
LONG column
" ErrorRelatedMoreInfo="">
seen during migration
=============================
Cause
Resolving The Problem
This happens because of the incorrect driver version .
Sometimes customers
use the ojdbc14.jar that came with WebLogic/Websphere. This is NOT advisable.
Sometimes Oracle has provided a driver Oracle9i RAC, since Oracle hasn't
packaged the right drivers with 9i RAC customer end up using incorrect driver
of version less than 9.2.0.5
Problem can be resolved by replacing the
driver with Yantra recommended version 9.2.0.5.0 . from the below url
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
Oracle9i 9.2.0.5
For use with JDK 1.4
ojdbc14.jar - JDBC classes
(1,200,046 bytes) - This is for 9i (9.2.0.5)
After installing this,
Yantra's system management console should display the correct version of the
Driver. i,e 9.2.0.5.
Note: For correct driver version , we should be
looking at System Management console not the Manifest file.
Also refer
to Solution 15371.
In the 10G world, the correct size should
be
ojdbc14.jar - JDBC classes (1,540,457 bytes) - This is for 10gR2
(10.2.0.2)
Historical Number
PRI49508
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21545357