Page 1 of 1

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

Posted: Thu 12 Mar 2015 08:04
by anand123
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

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

Posted: Thu 12 Mar 2015 14:09
by Shalex
Please send us a small test project with the corresponding DDL script so that we can reproduce the issue in our environment.

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

Posted: Tue 17 Mar 2015 09:17
by anand123
Thanks for your comment Shalex .

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

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

Posted: Tue 17 Mar 2015 09:51
by MariiaI
Glad to see that the issue was resolved.
If you have any further questions, feel free to contact us.