ORM Error after connecting with the DB

[Grace Manasseh]

Hello,

I'm trying to enable ORM with an existing Oracle database schema, using the Telerik OpenAccess domain model designer by using 'Add new item' and add a 'Telerik OpenAccess Domain Model'. It connects with the database and when retreiving the database schema, I'm getting the following error:

Connection error, ExceptionTelerik.OpenAccess.RT.sql.SQLException, Details:ORA-00942: table or view does not exist

Any Idea?? Please find attached the screenshot.
Note that I'm using the latest version Telerik-OpenAccess-ORM-2010.1.623.5

[Peter Meinl]

I have the same problem.

Using:
Telerik_OpenAccess_ORM_2010_1_624_trial
Oracle ODP.NET: ODAC112011beta

[Damyan Bogoev]

Hello Grace Manasseh,

This is a known issue which is already fixed. The fix will be part of the product in the Q2 release (due this week).
I am sorry for the inconvenience caused.

All the best,
Damyan Bogoev
the Telerik team

[Emanuele]

I have a similar issue with version 2010.2.714.1 of ORM and Oracle ODAC 11g R2.
In the Domain Model wizard all work correctly.

Error ORA-00942 (table or view not found) raise when I query the data with this code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    Dim conn As New Db
    Dim qry = From p In conn.TBLNOLEGGIRAC Where p.DDATAFINEFATTURA.Value.Year = 2009 Select p
    For Each item In qry.ToList
        Debug.WriteLine(item.ToString)
    Next
End Sub

[Ady]

Hello Emanuele Zambrano,

 As pointed out  in your other support ticket  (341728) for the same problem, the Domain Wizard will detect the appropriate pk column(s) and it will be automatically mapped to a field(s) which is marked as the identity field for the class. Can you verify this in the wizard? You should ensure that every class has a Pk specified in the designer.

Do you still get the 'PK not defined' error?

Greetings,
Ady
the Telerik team

[Emanuele]

I have fixed the problem adding voa_key table and defining all PKs.