2344406 - Table including reserved words can not be replicated | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2344406 - Table including reserved words can not be replicated

Symptom

  • When you do HANA to HANA replication using HANARAX the following error reported in RAH log if table includes reserved words like "LIMIT","RETURN","ROLLUP":
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    [25.336][Info][08:46:46.350][TaskEngine_10(ParallelMaterializerTask)(RSADMINC):147][MATERIALIZERTASK] - Closing Table Reader for Table RSADMINC
    [25.336][Error][08:46:46.350][TaskEngine_10(ParallelMaterializerTask)(RSADMINC):147][MATERIALIZERTASK] - Materialize Failed for RSADMINC
    [25.336][Error][08:46:46.350][TaskEngine_10(ParallelMaterializerTask)(RSADMINC):147][LOGGER] - Diagnostic Data for Exception com.sap.db.jdbc.exceptions.JDBCDriverException
        Detected by: com.sap.rahana.materialization.MaterializationTask
        Thread: TaskEngine_10(ParallelMaterializerTask)(RSADMINC) - [147]
        Description: SAP DBTech JDBC: [257] (at 627): sql syntax error: incorrect syntax near "LIMIT": line 1 col 627 (at pos 627)
        SQLCode: 257
        SQLState: HY000 
        StackTrace
         ( 0) - com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345)
         (-1) - com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:176)
         (-2) - com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:102)
         (-3) - com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1033)
         (-4) - com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:823)
         (-5) - com.sap.db.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:896)
         (-6) - com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:945)
         (-7) - com.sap.db.jdbc.StatementSapDB.execute(StatementSapDB.java:256)
         (-8) - com.sap.db.jdbc.StatementSapDB.executeQuery(StatementSapDB.java:401)
         (-9) - com.sap.db.jdbc.trace.Statement.executeQuery(Statement.java:184)
         (-10) - com.sap.rahana.materialization.db.reader.StandardMaterializationReader.read(StandardMaterializationReader.java:143)
         (-11) - com.sap.rahana.materialization.db.AbstractDatabaseMaterializer.materialize(AbstractDatabaseMaterializer.java:147)
         (-12) - com.sap.rahana.materialization.MaterializationTask.materialize(MaterializationTask.java:250)
         (-13) - com.sap.rahana.materialization.MaterializationTask.call(MaterializationTask.java:190)
         (-14) - com.sap.rahana.materialization.ParallelMaterializerTask.call(ParallelMaterializerTask.java:117)
         (-15) - com.sybase.rs.container.taskservices.PoolRunnable.run(PoolRunnable.java:100)
         (-16) - java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1156)
         (-17) - java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:626)
         (-18) - com.sybase.rs.container.taskservices.PoolThread.run(PoolThread.java:73)
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Read more...

Environment

  • Replication Agent for SAP HANA Database 15.7.1 SP304 and earlier versions

Product

SAP Sybase Replication Server 15.7, heterogeneous edition

Keywords

reserved word, HANARAX , KBA , HAN-DP-REP , SAP Sybase 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.