Skip to main content

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

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


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


Reply