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.