Deployed Error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
wajeeh
Posts: 2
Joined: Fri 16 Nov 2012 01:04

Deployed Error

Post by wajeeh » Fri 16 Nov 2012 01:10

We are using Devart for Oracle, Entities Assembly project .Net 4.0.
.ssdl is Embedded Resource of project also License file too. when I am running through Visual Studio its working fine. but when I deployed into server "WCF" its give me Error as following.
Devart.Data, Devart.Data.Oracle and Devart.Data.Oracle.Entity in Bin folder.


System.AggregateException: One or more errors occurred. ---> System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]: Schema specified is not valid. Errors:
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(3,4) : error 0019: The EntityContainer name must be unique. An EntityContainer with the name 'Schema' is already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(746,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.Table' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(756,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.TableColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(782,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.View' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(794,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ViewColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(820,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.Function' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(845,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.Procedure' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(855,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.Parameter' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(879,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.Constraint' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(891,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.CheckConstraint' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(899,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ConstraintColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(908,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ForeignKeyConstraint' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(917,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ForeignKey' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(928,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ViewConstraint' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(943,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.TableTableConstraint' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(956,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ConstraintConstraintColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(969,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ConstraintForeignKey' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(982,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.FromForeignKeyColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(995,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ToForeignKeyColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1008,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.TableTableColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1021,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ViewViewColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1034,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.FunctionFunctionParameter' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1047,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ProcedureProcedureParameter' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1060,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ViewViewConstraint' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1073,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ViewConstraintConstraintColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1086,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ViewConstraintForeignKey' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1099,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.FromForeignKeyViewColumn' was already defined.
Devart.Data.Oracle.Entity.ProviderManifest.StoreSchemaDefinition.ssdl(1112,4) : error 0019: Each type name in a schema must be unique. Type name 'DotConnect.Oracle.ToForeignKeyViewColumn' was already defined.
error 0194: All artifacts loaded into an ItemCollection must have the same version. Multiple versions were encountered.
PRESTO.Service.POCOEntities.PrestoEntities.ssdl(2,87) : error 0169: All SSDL artifacts must target the same provider. The ProviderManifestToken 'Ora11g' is different from 'ORA' that was encountered earlier.

Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Deployed Error

Post by Shalex » Fri 16 Nov 2012 15:49

How many EF models do you have in your project? If there is only one model, select it in Solution Explorer > right click > Open With > XML Editor and change the value of the ProviderManifestToken attribute: 'Ora11g' -> 'ORA'.

wajeeh
Posts: 2
Joined: Fri 16 Nov 2012 01:04

Re: Deployed Error

Post by wajeeh » Fri 16 Nov 2012 16:45

I did that but still not working getting following error.
PrestoEntities.csdl(3,4) : error 0019: The EntityContainer name must be unique. An EntityContainer with the name 'PrestoOwnEntities' is already defined.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Deployed Error

Post by Shalex » Wed 21 Nov 2012 11:02

There are different possible reasons of the problem. Try a solution which is described at http://thedatafarm.com/blog/data-access ... rror-0019/.

Post Reply