1 Reply Latest reply on Jun 26, 2017 5:20 PM by shawkins

The Primary Key must reference 1 or more columns; there are none

crmp-1 Jun 26, 2017 3:28 AM

Hi Experts,

I created the datasource of sqlserver 2008 in the teiid designer(jboss developer studio).

and then I selected the tables as the metadata , every tables were listed in the left sources folder.

but I found below errors in the problems window:

The Primary Key must reference 1 or more columns; there are none.

Is there anyone know about this issue

1. Re: The Primary Key must reference 1 or more columns; there are none

shawkins Jun 26, 2017 5:20 PM (in response to crmp-1)

> Is there anyone know about this issue

That does not look familiar. Can you tell which table(s) are affected? And if there is a primary key defined for them in the database?
Actions