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.
SAP Knowledge Base Article - Preview