SAP Knowledge Base Article - Preview

2306425 - Oracle CLOB datatype causes Replication Agent Oracle to stop replicating with datatype mismatch. Replication Agent Oracle 15.7.1

Symptom

  • Replication Agent Oracle (RAO) stops replicating when replicating CLOB data type to HANA database due to datatype mismatch.  Following is example error found in the RAO log:

E. 2016/04/07 12:49:19.452 ERROR com.sybase.ra.lti.rs.LTLSession _ds 4 ~,A{0x} 000000002513a4ef0002000200000e90000017b0016c00002513a4ef00000002,6 ~,?
{0x}5352535f4e494e2e554e49434150000000002513a4ef00a5001d00000876,3 8 _ap owner=~"'XXXXX ~"XXXXXXXXX.rs_writetext _apd _fi last
_ch with log _tl=112 ~$(MESSAGE=~.!"QRC_DE19-Customer signatures on the CAF vis-?-vis customer signature on photocopy of PoI and PoA are not
matching

E. 2016/04/07 12:49:19.456 ERROR com.sybase.ra.lti.rs.LTLSession The value given
for 'rs_in0x0100006500000202.MESSAGE' cannot be translated from datatype 'text' to the required datatype 'text'. Value length is '112';
Maximum target length is '226'; The value is '-Customer signatures on the CAF vis-[e0]-vis customer signature on photocopy of
PoI and PoA are not matching'.

E. 2016/04/07 12:49:19.456 ERROR com.sybase.ra.lti.rs.LTLSession com.sybase.jdbc4.jdbc.SybSQLException: The value given
for 'rs_in0x0100006500000202.MESSAGE' cannot be translated from datatype 'text' to the required datatype 'text'. Value length is '112';
Maximum target length is '226'; The value is '-Customer signatures on the CAF vis-[e0]-vis customer signature on photocopy of
PoI and PoA are not matching'.


Read more...

Environment

  • SAP Replication Server
  • SAP Replication Server Heterogeneous Edition
  • SAP Replication Server Option for Oracle

 

 

Product

SAP Replication Server 15.7 ; SAP Replication Server all versions ; SAP Replication Server, heterogeneous edition all versions ; SAP Replication Server, option for IBM DB2 all versions ; SAP Replication Server, option for Microsoft SQL Server all versions ; SAP Replication Server, option for Oracle all versions ; SAP Replication Server, real-time loading edition all versions ; Sybase Replication Server software all versions ; Sybase Replication Server, heterogeneous edition all versions ; Sybase Replication Server, real-time loading edition all versions

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.