Unable to retrieve the database schema information

6 posts, 1 answers
  1. Wenrong
    Wenrong avatar
    14 posts
    Member since:
    Sep 2011

    Posted 01 May 2012 Link to this post

    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
  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 03 May 2012 Link to this post

    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
    Follow @OpenAccessORM Twitter channel to get first the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
  3. DevCraft banner
  4. Wenrong
    Wenrong avatar
    14 posts
    Member since:
    Sep 2011

    Posted 03 May 2012 Link to this post

    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;
  5. Wenrong
    Wenrong avatar
    36 posts
    Member since:
    May 2012

    Posted 07 May 2012 Link to this post

    Any solution regarding this issue?
  6. Answer
    Ady
    Admin
    Ady avatar
    589 posts

    Posted 07 May 2012 Link to this post

    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
    Follow @OpenAccessORM Twitter channel to get first the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
  7. Wenrong
    Wenrong avatar
    14 posts
    Member since:
    Sep 2011

    Posted 07 May 2012 Link to this post

    OK, that's fine.
Back to Top
DevCraft banner