SAP Knowledge Base Article - Preview

3117838 - Invalid/duplicate column/table name error after scheduling the creation of a view through data provisioning UI of LTRC - SLT

Symptom

  • Creation of view [name] failed (SQL Error Code: 260).
    A database error occured. The error message in the  database was: "invalid column name: [name].[datatype]..."
  • Creation of view [name] failed (SQL Error Code: 272).
    Error: A database error occurred. The error message in the database was: "duplicate column name: [name]..."
  • Error: Creation of view [name] failed (SQL Error Code: 259).
    Error: The database reports an unknown database object. T he error message from the database was: "invalid table name: Could not find table/view [name] in schema [schema name]..."
  • Views (and tables) stuck in scheduled status
  • Error: duplicate column name: [name]
  • SQLCODE    : 272
    SQLERRTEXT : duplicate column name: [name]
  • SQLCODE    : 260
    SQLERRTEXT : invalid column name: [name].[datatype]
  • SQL COMMAND: CREATE_VIEW


Read more...

Environment

  • SAP Landscape Transformation Replication Server version: DMIS 2018 SP04 or higher/ DMIS 2020 SP00 or higher/ S/4 HANA 2020 (S4CORE 105) FPS00 or higher.
  • Source system on S/4 HANA 2020 (S4CORE 105) FPS00 or higher.

Product

SAP Landscape Transformation replication server 3.0

Keywords

occured, occurred, ANEA, ANEP, GLT0, FAGLEXT, BSAD, COSP, V_COSP_WDV_9, V_GLT0_PER, V_GLT0_DIF , 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.