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
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.