SAP Knowledge Base Article - Preview

2313506 - Error ORA-00932 in SLT when load/replicate table using Oracle DB as Non-SAP source system

Symptom

  • Use SAP LT Replication Server to transfer data from a legacy Oracle DB.
  • Error in LT system Application Log (of Transaction LTRC) for this table:
    SQL error SQL code: 1000 occurred while accessing table <logging_tab>.
    Run 0000000001 aborted due to SYSTEM FAILURE at ...
    Execution of program /1CADMC/OLC_<XXX> failed, return code 2
  • Error in LT System Log (Transaction SM21) relevant for the logging table:
    Database error 932 with FET access to table <logging_tab>
    ORA-00932: inconsistent datatypes: expected %s got %s
    Runtime error "DBSQL_SQL_ERROR" occurred
  • The original application table contains one or more fields with long data types, for example: data type VARCHAR2 with a long length (such as 3000 or 4000).

Read more...

Environment

  • SAP Landscape Transformation replication server 2.0
  • Legacy Oracle Database as source system (Non-SAP)

Product

SAP Landscape Transformation replication server 2.0

Keywords

SLT Oracle ORA-00932 932 inconsistent datatypes DBSQL_SQL_ERROR %s   , KBA , HAN-DP-LTR , SAP Landscape Transformation Replication Server , Problem

About this page

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

Search for additional results

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