{"ORA-00942: table or view does not exist"}

FrankHealy · Post by **FrankHealy** » Wed 30 Mar 2011 16:57

I am simply trying to savechanges to a very simple part of model I get the following error

3 tables many to many

All have sequence PKS and FKs are being recognised etc...

{"An error occurred while updating the entries. See the inner exception for details."}
[System.Data.UpdateException]: {"An error occurred while updating the entries. See the inner exception for details."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: {"ORA-00942: table or view does not exist"}
Message: "An error occurred while updating the entries. See the inner exception for details."
Source: "System.Data.Entity"
StackTrace: " at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)\r\n at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)\r\n at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)\r\n at System.Data.Objects.ObjectContext.SaveChanges()\r\n at BarclaysWealth.Cart.WI.BL.ApplicationManager.SaveApplicationClient(WI_APPLICATIONCLIENT theAppClient) in C:\workwi\BarclaysWealth.Cart.WI\ApplicationManager.cs:line 121"
TargetSite: {Int32 Update(System.Data.IEntityStateManager, System.Data.IEntityAdapter)}

AndreyR · Post by **AndreyR** » Thu 31 Mar 2011 08:38

Are you using the Code First approach?
This error is rather generic, it can have different reasons.
Could you please provide the call stack of the inner exception?
If possible, please send us (support * devart * com, subject "EF: ORA-00942") a small test project illustrating the issue.

anand · Post by **anand** » Tue 04 Oct 2011 16:29

We are also facing same problem. Please see the attached screen shot for exception details. If anyone has resolved this issue, please let us know.

Message:
{"ORA-06550: line 4, column 19:\nPL/SQL: ORA-00942: table or view does not exist\nORA-06550: line 4, column 1:\nPL/SQL: SQL Statement ignored\nORA-06550: line 7, column 47:\nPL/SQL: ORA-00942: table or view does not exist\nORA-06550: line 7, column 24:\nPL/SQL: SQL Statement ignored"}

Stack Trace:
at Devart.Data.Oracle.au.b(Int32 A_0)
at Devart.Data.Oracle.ax.d(Int32 A_0)
at Devart.Data.Oracle.ax.a(Int32 A_0, bf A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.e.a(CommandBehavior A_0)
at Devart.Common.Entity.ak.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.e.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

Shalex · Post by **Shalex** » Wed 05 Oct 2011 08:06

Which Entity Framework code generation template are you using?

We recommend you to install the dbMonitor tool that performs per-component tracing of database events such as SQL statement execute etc.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html

In dbMonitor you will find the SQL statement that fails to execute. Try executing the same statement (with the same parameters) using another tool (e.g., OraDeveloper Studio http://www.devart.com/dbforge/oracle/studio/) to localize the problem.