Oracle DB Integration Error With OpenAcess

6 posts, 0 answers
  1. Zeeshan Ahmed Khan
    Zeeshan Ahmed Khan avatar
    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
  2. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    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.
  3. DevCraft banner
  4. Gábor
    Gábor avatar
    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
  5. Thomas
    Admin
    Thomas avatar
    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.
  6. Gábor
    Gábor avatar
    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
  7. Alexander
    Admin
    Alexander avatar
    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
DevCraft banner