Inner Exception:ORA-00904: "Extent1"."IsModified": invalid identifier

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
anand123
Posts: 17
Joined: Thu 30 Jan 2014 08:58

Inner Exception:ORA-00904: "Extent1"."IsModified": invalid identifier

Post by anand123 » Thu 12 Mar 2015 08:04

after generating codefirst using DevArt from Working EDMX model getting below error.

below columns not in actual table, POCO class and mapping configuration as well. But ef generating query looking for those columns.

Code: Select all

 "Extent1"."DisableEvent",
"Extent1"."RowNumberValue",
"Extent1"."IsNew",
"Extent1"."IsModified"
FROM USERS "Extent1"

Code: Select all

An error occurred while executing the command definition. See the inner exception for details.
Inner Exception:ORA-00904: "Extent1"."IsModified": invalid identifier

SELECT 
"Extent1".USERID,
"Extent1".FIRST_NAME,
"Extent1".LAST_NAME,
"Extent1".EMAIL_ADDRESS,
"Extent1".PHONE_NO,
"Extent1".FAX_NO,
"Extent1".ID,
"Extent1"."DisableEvent",
"Extent1"."RowNumberValue",
"Extent1"."IsNew",
"Extent1"."IsModified"
FROM USERS "Extent1"
WHERE (((UPPER("Extent1".USERID)) = :p__linq__0) OR ((UPPER("Extent1".USERID) IS NULL) AND (:p__linq__0 IS NULL))) AND ROWNUM <= 1
-- p__linq__0: 'SYSADM' (Type = String, Size = 6)
-- Executing at 3/11/2015 14:25:40 +05:30

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Inner Exception:ORA-00904: "Extent1"."IsModified": invalid identifier

Post by Shalex » Thu 12 Mar 2015 14:09

Please send us a small test project with the corresponding DDL script so that we can reproduce the issue in our environment.

anand123
Posts: 17
Joined: Thu 30 Jan 2014 08:58

Re: Inner Exception:ORA-00904: "Extent1"."IsModified": invalid identifier

Post by anand123 » Tue 17 Mar 2015 09:17

Thanks for your comment Shalex .

It works now. actually there were some old devArt version references. after cleaning up it works now.

MariiaI
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Inner Exception:ORA-00904: "Extent1"."IsModified": invalid identifier

Post by MariiaI » Tue 17 Mar 2015 09:51

Glad to see that the issue was resolved.
If you have any further questions, feel free to contact us.

Post Reply