Skip to main content
Question

DM-Error: The export failed: There is no column on the table to export for schema

  • February 8, 2024
  • 2 replies
  • 12 views

julia.bauer
Level 9
Forum|alt.badge.img+6

Hello everyone,

 

in the data model purchase requistions, I want to add the EINE to this snowflake (with join with EKPO). However, when setting up the join with the needed keys the DM does not load with following error message - what does this mean?

 

Thanks for your help!

 

BR

Julia Bauer

imageimage

2 replies

dennis.pflug
Level 10
  • Level 10
  • February 8, 2024

Hi Julia,

 

have you checked that for each of the tables an entry is selected within "Name" setting:

 

Click on the three dots per each table -> Edit -> check if Name field is filled.

 

I am just wondering because of the warning message: Missing Primary Keys and Error Message pointing on a schema.

 

If setup is correct I would try to do a SELECT * query on each table / view used in your data model within any transformation to check if nothing is wrong with your views.

 

BR

Dennis


janpeter.van.d
Level 12
Forum|alt.badge.img+26

Hi @julia.bauer,

 

Could it be that the (PR_)EBAN table was moved to a different data connection or was renamed?

It seems that the Data Model lost its link to this table, which could be caused by moving it to a different data connection (which in the back-end is a different database schema). \\

 

You could resolve this, by following this steps:

  • click on the three dots of the table en click 'edit'
    • image
  • Ensure that the correct data source/schema and table name are selected.
    • image

 

Best regards,

Jan-peter