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 'REPLICATED_HANA.DB'. See logged ct-lib and data server messages for more information

  • Note: This HANA server message 257 is throwing only for Oracle tables whenever they 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

808391, CR808391, CR#808391, Message: 257, SYSDATE , 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) , Product Enhancement

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.