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 , Use CA-LT-SLT instead , HAN-DP-LTR , Use CA-LT-SLT instead , 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.