This project is read-only.

More problems with datetime2

Apr 20, 2009 at 6:45 PM
Hi,
I have problems with the data type datetime2. I have installed the Microsoft SQL Server System CLR Types, attached a blank and a test ODM databases, I have restarted SQL server, computer and so on, and I have still one exception. While debugging the project, when I write in the browser (Firefox):
 http://localhost:2693/Swe.svc/?service=SOS&request=GetCapabilities

I get the exception:
<ExceptionReport xml:lang="de">

<Exception exceptionCode="NoApplicableCode">

<exceptionText>
Renci.Ogc.Exceptions.NoApplicableCodeException: Application error. ---> System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Type datetime2 is not a defined system type.

Type datetime2 is not a defined system type.

Type datetime2 is not a defined system type.

Type datetime2 is not a defined system type.

   bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   bei System.Data.SqlClient.SqlDataReader.get_MetaData()

   bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

   bei System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

   bei System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

   --- Ende der internen Ausnahmestapelüberwachung ---

   bei System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

   bei System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)

   bei System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)

   bei System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()

   bei Renci.Ogc.WebService.Sos.GetCapabilitiesOperation.GetContents() in D:\Shared\Sensor Web Enablement\OGC WebService 1.1 Source\Renci.Ogc.WebService\Sos\GetCapabilitiesOperation.cs:Zeile 470.

   bei Renci.Ogc.WebService.Sos.GetCapabilitiesOperation.ProcessRequest(Object request) in D:\Shared\Sensor Web Enablement\OGC WebService 1.1 Source\Renci.Ogc.WebService\Sos\GetCapabilitiesOperation.cs:Zeile 299.

   bei Renci.Ogc.WebService.Swe.ProccessRequest(Message messageRequest) in D:\Shared\Sensor Web Enablement\OGC WebService 1.1 Source\Renci.Ogc.WebService\Swe.svc.cs:Zeile 138.

   --- Ende der internen Ausnahmestapelüberwachung ---
</exceptionText>
</Exception>
</ExceptionReport>


I know that there is an issue about it, but it is closed (the solution is installing CLR Types in SQL-Server 2005), therefore I didn't post this info there.
Do you have an idea what I'm doing wrong?
I'm using:
XP Professional (in german)
Visual Studio 2008 SP1 (english)
SQL Server 2005 Express
IIS 5.1
Apr 20, 2009 at 6:50 PM
Recompile with the SOS.edmx attached to issue :
http://ogc.codeplex.com/WorkItem/View.aspx?WorkItemId=1475

On Mon, Apr 20, 2009 at 10:45 AM, aykito <notifications@codeplex.com> wrote:
> From: aykito
>
> Hi,
> I have problems with the data type datetime2. I have installed the Microsoft
> SQL Server System CLR Types, attached a blank and a test ODM databases, I
> have restarted SQL server, computer and so on, and I have still one
> exception. While debugging the project, when I write in the browser
> (Firefox):
> http://localhost:2693/Swe.svc/?service=SOS&request=GetCapabilities
>
> I get the exception:
>
> <ExceptionReport xml:lang="de">
> -
> <Exception exceptionCode="NoApplicableCode">
> -
> <exceptionText>
> Renci.Ogc.Exceptions.NoApplicableCodeException: Application error. --->
> System.Data.EntityCommandExecutionException: An error occurred while
> executing the command definition. See the inner exception for details. --->
> System.Data.SqlClient.SqlException: Type datetime2 is not a defined system
> type.
>
> Type datetime2 is not a defined system type.
>
> Type datetime2 is not a defined system type.
>
> Type datetime2 is not a defined system type.
>
> bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> Boolean breakConnection)
>
> bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection)
>
> bei
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj)
>
> bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
> bulkCopyHandler, TdsParserStateObject stateObj)
>
> bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
>
> bei System.Data.SqlClient.SqlDataReader.get_MetaData()
>
> bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
> ds, RunBehavior runBehavior, String resetOptionsString)
>
> bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
>
> bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
> DbAsyncResult result)
>
> bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
>
> bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> behavior, String method)
>
> bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
> behavior)
>
> bei System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
>
> bei
> System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
> entityCommand, CommandBehavior behavior)
>
> --- Ende der internen Ausnahmestapelüberwachung ---
>
> bei
> System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand
> entityCommand, CommandBehavior behavior)
>
> bei
> System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext
> context, ObjectParameterCollection parameterValues)
>
> bei System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1
> forMergeOption)
>
> bei
> System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
>
> bei Renci.Ogc.WebService.Sos.GetCapabilitiesOperation.GetContents() in
> D:\Shared\Sensor Web Enablement\OGC WebService 1.1
> Source\Renci.Ogc.WebService\Sos\GetCapabilitiesOperation.cs:Zeile 470.
>
> bei
> Renci.Ogc.WebService.Sos.GetCapabilitiesOperation.ProcessRequest(Object
> request) in D:\Shared\Sensor Web Enablement\OGC WebService 1.1
> Source\Renci.Ogc.WebService\Sos\GetCapabilitiesOperation.cs:Zeile 299.
>
> bei Renci.Ogc.WebService.Swe.ProccessRequest(Message messageRequest) in
> D:\Shared\Sensor Web Enablement\OGC WebService 1.1
> Source\Renci.Ogc.WebService\Swe.svc.cs:Zeile 138.
>
> --- Ende der internen Ausnahmestapelüberwachung ---
> </exceptionText>
> </Exception>
> </ExceptionReport>
>
>
> I know that there is an issue about it, but it is closed (the solution is
> installing CLR Types in SQL-Server 2005), therefore I didn't post this info
> there.
> Do you have an idea what I'm doing wrong?
> I'm using:
> XP Professional (in german)
> Visual Studio 2008 SP1 (english)
> SQL Server 2005 Express
> IIS 5.1
>
> Read the full discussion online.
>
> To add a post to this discussion, reply to this email
> ([email removed])
>
> To start a new discussion for this project, email
> [email removed]
>
> You are receiving this email because you subscribed to this discussion on
> CodePlex. You can unsubscribe or change your settings on codePlex.com.
>
> Please note: Images and attachments will be removed from emails. Any posts
> to this discussion will also be available online at codeplex.com