ORA-00942: table or view does not exist

6 posts, 0 answers
  1. Libertad
    Libertad avatar
    53 posts
    Member since:
    Sep 2008

    Posted 26 Aug 2011 Link to this post

    Hi,
    I've created a DataService using DSW from an EntitiesModel which is created from an Oracle database.
    When I was creating this EntitiesModel I choose a prefix to be added to all of my classes (tables name).
    Now when I try to get access to a table of my DB using the DataService I face the message "ORA-00942: table or view does not exist"

    here is my code to call the table content:

    protected void Page_Load(object sender, EventArgs e)
            {
                var dm = new DataManager();
                GridView1.DataSource = dm.RN_USERSs; // original table name is USERS
                GridView1.DataBind();
            }

    Why OpenAccessModel cannot specify prefixes?
  2. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 01 Sep 2011 Link to this post

    Hello Majid,

    Just to note in this thread that following our communication in your support ticket regarding the same issue, we are already working on it. We will contact you on the support ticket in case we need any details.

    When there are any final results, I will post them on the forum thread as well for future references.


    Regards,
    Ivailo
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

  3. DevCraft banner
  4. Libertad
    Libertad avatar
    53 posts
    Member since:
    Sep 2008

    Posted 01 Sep 2011 Link to this post

    Thank you Ivailo 
    I'm waiting for that.
  5. Stefano
    Stefano avatar
    5 posts
    Member since:
    Feb 2009

    Posted 11 Oct 2011 Link to this post

    I have the same problem. Any suggestion?
  6. Libertad
    Libertad avatar
    53 posts
    Member since:
    Sep 2008

    Posted 11 Oct 2011 Link to this post

    Check the Error List window of Visual Studio - it will show the problems and you will be able to fix them through the OpenAccess ORM Validation window, which will open automatically when you double click the errors. 

    In order to find out how to handle issues with missing primary keys, you can refer to this article. If there are any other errors in your Error List, you can use the information and recommendations of the Validation window to try to resolve them or you can get back to us with the error messages.
  7. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 13 Oct 2011 Link to this post

    Hi Guys,

    First of all, Majid is correct in his recommendations, so let me say thanks for the support.

    The only thing I would add is that this error could be a result of different problems in your mapping, one of which is the missing primary key. Another problem that is frequently encountered is a wrong table to class mapping - check if all of your Domain Classes are mapped properly to the tables you want to use. You can verify that for each class if you click on Edit Table item of the class context menu or alternatively you can verify in the Model Schema Explorer that all the tables are added to the Domain Model (the ones that are not mapped to a class would be grayed out).

    I hope that helps. Do not hesitate to let us know if you need further assistance on this.

    All the best,
    Ivailo
    the Telerik team

    Check out the latest stable build of Telerik OpenAccess ORM. Download it and benefit from our new Project Templates.

Back to Top
DevCraft banner