SAP Knowledge Base Article - Preview

3231199 - Dump: SQL error "SQL code: 102" occurred while accessing table XXXX, "SQL message: syntax error near 'OFFSET' "

Symptom

  • Dump:
    Short Text
    SQL error "SQL code: 102" occurred while accessing table "/1CADMC/00000528".

    What happened?
    Database error text: "SQL message: 'OFFSET' 附近有语法错误。"
  • In SM21 system trace:
    Runtime error "DBSQL_SQL_ERROR" occurred.
    > Short dump "220721 192153 ANTAP42SP1_P42_00 17100191" created.
    Database error 102 with FET access to table XXXX
    > syntax error near 'OFFSET'


Read more...

Environment

SAP Landscape Transformation Replication Server

Source is MSSQL database

Product

SAP Landscape Transformation replication server 1.0 ; SAP Landscape Transformation replication server 2.0 ; SAP Landscape Transformation replication server 3.0

Keywords

SLT, dump, syntax, SQL code: 102 , KBA , CA-LT-SLT , SAP Landscape Transformation Replication Server (SLT) , 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.