SAP Knowledge Base Article - Preview

2478857 - Error 257 incorrect syntax near "SYSDATE' when replicating from Oracle to Hana - SRS

Symptom

The following error while replicating Oracle to HANA, subscription creation is aborted with next error:


Message from server: Message: 257, State 0, Severity 5 -- '[ statement ][ REPLICATED_HANA ] SQLPrepare [SAP AG][LIBODBCHDB SO][HDBODBC]
Syntax error or access violation;257 sql syntax error: incorrect syntax near "SYSDATE": line 1 col 332 (at pos 332)'.
ERROR #5051 MatApply( ) - eneric/dsi/dsiexec.c(695)
Received errors from database 'XXXXXXXXXXXX. See logged ct-lib and data server messages for more information

Note: This HANA server message 257 is throwing only for Oracle tables whenever contain columns with SYSDATE default value.


Read more...

Environment

  • SAP Replication Server 15.7.1 SP300 and later

Product

SAP Replication Server 15.7

Keywords

replication oracle hana error 257 incorrect syntax near access violation sysdate default value #5051 5051 808391 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , 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.