Page 1 of 1

Error when trying to create a model

Posted: Tue 30 Dec 2008 20:22
by HintonBR
I have a fairly large Oracle DB - and when I try to create a model from that database even by selecting just one very simple table - the model fails to generate with the following error

An exception of type 'Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine+GenerateSSDLException' occurred while attempting to update from the database. The exception message is: 'Unable to cast object of type 'System.DBNull' to type 'System.String'

Please note that this error is the same whether I am trying to update the model or just generate it brand-new the first time. The designer quits and leaves me with an empty model. I can't find any log file that would give me more detail on why this is happening.
________
MAGIC FLIGHT

Posted: Wed 31 Dec 2008 11:09
by AndreyR
Please tell me the version of dotConnect for Oracle you are using.

Posted: Fri 02 Jan 2009 17:40
by HintonBR
I am using 5.0.16 which I thought was the latest version
________
Vaporgenie

Posted: Mon 05 Jan 2009 12:39
by AndreyR
I suppose that the discussed problem is identical to the one associated with EDMGen:
http://www.devart.com/forums/viewtopic.php?t=13775

Posted: Mon 05 Jan 2009 17:11
by HintonBR
I will run the query for both EdmGen and for the VS Integration and send them to you - I am somewhat skeptical that they are the same problem, because the errors I am getting back are quite different, but I will pass on the results I get from the SQL query that you want me to execute for you to analyze.
________
R-CLASS