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

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

Postby 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
anand123
 
Posts: 15
Joined: Thu 30 Jan 2014 08:58

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

Postby 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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

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

Postby 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.
anand123
 
Posts: 15
Joined: Thu 30 Jan 2014 08:58

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

Postby 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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to dotConnect for Oracle