Unable to retrieve the database schema information

[Wenrong]

Hi,

I received the following error when trying to create an entity model from PostgreSQL database

Unable to retrieve the database schema information.
Reason: Not all of the primary key columns were found on table '...'

What does this error mean, and any suggestion on how to resolve it?

Thanks
Jackie

[Ady]

Hi Wenrong,

 This error indicates that while reading the primary keys for a table OpenAccess detected that there are 'x' number of columns in the primary key but it could not find all these 'x' column in the table. The table name looks wierd though - '...'. Do you have a peculiar table name in your database?
Can you send us your database or any tables with a strange/peculiar name? This will help us in reproducing the error locally.

Kind regards,
Ady
the Telerik team

[Wenrong]

Sorry, I used '...' to hide the table name I used.

I tried to reproduce this issue with a simpler database. It seems to happen when the primary key is renamed. The following should reproduce it:

CREATE TABLE test
(
  test_id SERIAL NOT NULL,
  test_name char(32) NOT NULL,
  CONSTRAINT pk_test PRIMARY KEY (test_id)
);
ALTER TABLE test
  RENAME test_id TO test_id1;

[Wenrong]

Any solution regarding this issue?

[Ady]

Hello Wenrong,

 We have fixed this problem and the fix will be available in the Q2 release (due in the first half of June). I'm afraid there is no workaround for this at the moment.

I'm sorry for the inconvenience caused.

Regards,
Ady
the Telerik team

[Wenrong]

OK, that's fine.