Telerik Forums / Data Access Forum / OQL (OQL specific questions) /

Oracle DB Integration Error With OpenAcess

Data Access
Resources Buy Try

Thread is closed for posting

6 posts, 0 answers

Zeeshan Ahmed Khan

11 posts

Member since:
Jul 2009

Posted 12 Aug 2009 Link to this post

Hi..

While using Open Access (trial Version) With Oracle 8.0 i ran into a problem..that is after connecting DB with Open Access & Selecting Reverse Mapping from the telerik menu during the process of loading tables for mapping it gives error "ORA-00904: invalid column name" & after that it does nothing,,m not sure why open access is showing this error because i've used the same DB many times i've never faced this problem or error before..

Any help regarding this will be appreciated..

Regards;

Zeeshan Ahmed Khan
Jan Blessenohl
Admin

707 posts

Posted 12 Aug 2009 Link to this post

Hello Zeeshan Ahmed Khan,
I am sorry but Oracle 8 is not supported. Some things might work but we are not actively testing it. The minimum supported version is Oracle 9. Is it possible for you to test with a higher Oracle version, maybe with Oracle 10 Express, you should be able to migrate the DB as well.

All the best,
Jan Blessenohl
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Gábor

10 posts

Member since:
Nov 2010

Posted 26 Nov 2010 Link to this post

Hi,

I get this sort of error when I change something on my Oracle DB and then map the changes to my OpenAccess DomainModel.

When I start my web-app, I get the following exception:

Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."company_id2": érvénytelen azonosító

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."company_id2": érvénytelen azonosító

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."company_id2": érvénytelen azonosító

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."company_id2": érvénytelen azonosító

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."company_id2": érvénytelen azonosító

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."company_id2": érvénytelen azonosító

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()

   at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()

SQL:

SELECT a."vendor_id2" COL1, a."company_id2" COL2, a."version" COL3, b."vendor_id" COL4, b."company_id" COL5, b."currency_code" COL6, b."deposit_flex_id" COL7, b."invoice_tax_code" COL8, b."payment_condition_id" COL9, b."site_name" COL10, b."vendor_flex_id" COL11, b."version" COL12 FROM "invoice_header" a LEFT JOIN "vendor_per_company" b ON (a."vendor_id2" = b."vendor_id" and a."company_id2" = b."company_id") WHERE a."invoice_id" = ? Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."company_id2": érvénytelen azonosító

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()

   at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()

Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904:"A"."company_id2": érvénytelen azonosító (invalid identifier)

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()

   at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()

SQL:

SELECT a."vendor_id2" COL1, a."company_id2" COL2, a."version" COL3, b."vendor_id" COL4, b."company_id" COL5, b."currency_code" COL6, b."deposit_flex_id" COL7, b."invoice_tax_code" COL8, b."payment_condition_id" COL9, b."site_name" COL10, b."vendor_flex_id" COL11, b."version" COL12 FROM "invoice_header" a LEFT JOIN "vendor_per_company" b ON (a."vendor_id2" = b."vendor_id" and a."company_id2" = b."company_id") WHERE a."invoice_id" = ?                        Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."company_id2": érvénytelen azonosító (invalid identifier)

   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()

   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()

   at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()

It is truly annoying because I have no idea where the "company_id2" is coming from. The real name of the column is "company_id". The same applies to "vendor_id".

Regards,

Gabor
Thomas
Admin

590 posts

Posted 26 Nov 2010 Link to this post

Hello Gábor,
please verify that your mapping information for InvoiceHeader is correct. It seem there are two columns for company id and I suspect the problem there. Maybe OpenAccess does not detect a shared column correctly because of case sensitivity issues or so.
All the best,
Thomas
the Telerik team

Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
Gábor

10 posts

Member since:
Nov 2010

Posted 29 Nov 2010 Link to this post

Hello Thomas,

The fun stuff is that they were actually mapped properly in the rlinq file as file as I could see looking at the file in the XML editor.

There are no company_id2 or vendor_id2 in the database. There is only one company_id field in the table and one vendor_id, both of them are foreign keys with the appropriate constrains created. All the field names are in lower case and the error only occurs if I change the schema in Oracle and then I update the mappings in my domain model.

When I delete the domain model and then recreate it from scratch again (using the populate from database option in the wizzard) it all work properly until I update something.

This morning I have experienced the very same error again. I can send you the files of my datamodel project, so that u can take a look at the mappings.
If the DDL of the Oracle DB helps I can provide u with that as well.

Regards,

Gabor
Alexander
Admin

727 posts

Posted 30 Nov 2010 Link to this post

Hello Gábor,

I answered to your support ticket on the same problem but I will provide the answer here as well, so if anyone else faces this problem, he could know the solution.

In the Q3 version of the product we found a problem that could lead to this behavior after the Update From Database wizard is executed. We have already addressed this issue in the service pack that we released last Friday (version 2010.3.1125.1). I would suggest downloading and installing this build. The problem should be gone and updating the model from the database will not have this negative effect.

Kind regards,
Alexander
the Telerik team

Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.

Back to Top