SAP Knowledge Base Article - Preview

2321124 - Issues with Tables with columns defined as DATETIMEOFFSET

Symptom

This is ONLY relevant for MSSQL as a source Database

Problems with the replication of tables with columns defined as DATETIMEOFFSET

Tables with columns defined as DATETIMEOFFSET are not loaded/replicated after doing the Initial Load/Replication in LTRC - No data is loaded/replicated to the target tables on the target system

In the Application Log Tab on LTRC transaction you might also find the error similar to below:

Z_<Tablename>: SQL-Fehler SQL code: 99 bei Zugriff auf Tabelle /1CADMC/L0000... aufgetreten.

Z_<Tablename>: Run 0000000002 aborted due to SYSTEM FAILURE at 20160517 020107

Z_<Tablename>: SQL-Fehler SQL code: 99 bei Zugriff auf Tabelle /1CADMC/L0000... aufgetreten.

Message no. DMC_RT_MSG041

 

Z_<Tablename>: SQL-Error SQL code: 99 when accessing table /1CADMC/L0000... occurred.

Z_<Tablename>: Run 0000000002 aborted due to SYSTEM FAILURE at 20160517 020107

Z_<Tablename>: SQL-Fehler SQL code: 99 when accessing table  /1CADMC/L0000... occurred.

Message no. DMC_RT_MSG041

Read more...

Environment

SAP HANA Database

Product

SAP HANA, platform edition all versions ; SAP NetWeaver 7.5

Keywords

MSSQL DB replication error, Microsoft SQL Database Server replication using SLT , KBA , CA-LTR-DB , LT Replication Server DB connection , HAN-DP-LTR , SAP Landscape Transformation 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.