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":
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    [TaskEngine_11(ParallelMaterializerTask)(XXX):150][MATERIALIZERTASK] - Closing Table Reader for Table XXX
    [TaskEngine_11(ParallelMaterializerTask)(XXX):150][MATERIALIZERTASK] - Materialize Failed for XXX
    [TaskEngine_11(ParallelMaterializerTask)(XXX):150][LOGGER] - Diagnostic Data for Exception com.sap.db.jdbc.exceptions.JDBCDriverException
        Detected by: com.sap.rahana.materialization.MaterializationTask
        Thread: TaskEngine_10(ParallelMaterializerTask)(XXX) - [150]
        Description: SAP DBTech JDBC: [257] (at 630): sql syntax error: incorrect syntax near "LIMIT": line 1 col 630 (at pos 630)
        SQLCode: 257
        SQLState: HY000 
        StackTrace
         ( 0) - com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java)
         (-1) - com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java)
         (-2) - com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java)
         (-3) - com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java)
         (-4) - com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java)
         (-5) - com.sap.db.jdbc.StatementSapDB.sendCommand(StatementSapDB.java)
         (-6) - com.sap.db.jdbc.StatementSapDB.sendSQL(StatementSapDB.java)
         (-7) - com.sap.db.jdbc.StatementSapDB.execute(StatementSapDB.java)
         (-8) - com.sap.db.jdbc.StatementSapDB.executeQuery(StatementSapDB.java)
         (-9) - com.sap.db.jdbc.trace.Statement.executeQuery(Statement.java)
         (-10) - com.sap.rahana.materialization.db.reader.StandardMaterializationReader.read(StandardMaterializationReader.java)
         (-11) - com.sap.rahana.materialization.db.AbstractDatabaseMaterializer.materialize(AbstractDatabaseMaterializer.java)
         (-12) - com.sap.rahana.materialization.MaterializationTask.materialize(MaterializationTask.java)
         (-13) - com.sap.rahana.materialization.MaterializationTask.call(MaterializationTask.java)
         (-14) - com.sap.rahana.materialization.ParallelMaterializerTask.call(ParallelMaterializerTask.java)
         (-15) - com.sybase.rs.container.taskservices.PoolRunnable.run(PoolRunnable.java)
         (-16) - java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java)
         (-17) - java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java)
         (-18) - com.sybase.rs.container.taskservices.PoolThread.run(PoolThread.java)
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


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 for Me (Login required).

Search for additional results

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