This question is locked. New answers and comments are not allowed.
Zeeshan Ahmed Khan
Top achievements
Rank 1
Zeeshan Ahmed Khan
asked on 12 Aug 2009, 05:40 AM
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
5 Answers, 1 is accepted
0
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.
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.
0
Gábor
Top achievements
Rank 1
answered on 26 Nov 2010, 11:33 AM
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:
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
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
0
Hello Gábor,
Thomas
the Telerik team
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
0
Gábor
Top achievements
Rank 1
answered on 29 Nov 2010, 09:23 AM
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
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
0
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
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