The transform results function failed. Error: Object must be of type DateTime

[Phil Jones]

Hey,

I've noticed weirdness around one index I have:

https://gist.github.com/37cab98cf8d130b208bf

(index from a thread yesterday)

This error occurs only when I've deleted a document and redirected to
the list method. I can't figure out why, my ASP.NET MVC controller
code looks fine...

Server: 922 (unstable local, will be deployed to 888)
Client: 917 (unstable)

System..InvalidOperationException: Url: "/indexes/Payments/
ListProjection?query=&start=0&pageSize=50&aggregation=None&sort=-
Created"

System.InvalidOperationException: The transform results function
failed.
Doc '', Error: Object must be of type DateTime.
at
Raven.Database.DocumentDatabase.<>c__DisplayClass82.<Query>b__78(IStorageActionsAccessor
actions) in c:\Builds\RavenDB-Unstable\Raven.Database
\DocumentDatabase.cs:line 830
at Raven.Storage.Esent.TransactionalStorage.ExecuteBatch(Action`1
action) in c:\Builds\RavenDB-Unstable\Raven.Storage.Esent
\TransactionalStorage.cs:line 376
at Raven.Storage.Esent.TransactionalStorage.Batch(Action`1 action)
in c:\Builds\RavenDB-Unstable\Raven.Storage.Esent
\TransactionalStorage.cs:line 337
at Raven.Database.DocumentDatabase.Query(String index, IndexQuery
query) in c:\Builds\RavenDB-Unstable\Raven.Database
\DocumentDatabase.cs:line 766
at
Raven.Database.Server.Responders.Index.PerformQueryAgainstExistingIndex(IHttpContext
context, String index, IndexQuery indexQuery, Guid& indexEtag) in c:
\Builds\RavenDB-Unstable\Raven.Database\Server\Responders
\Index.cs:line 200
at Raven.Database.Server.Responders.Index.ExecuteQuery(IHttpContext
context, String index, Guid& indexEtag) in c:\Builds\RavenDB-Unstable
\Raven.Database\Server\Responders\Index.cs:line 165
at
Raven.Database.Server.Responders.Index.GetIndexQueryRessult(IHttpContext
context, String index) in c:\Builds\RavenDB-Unstable\Raven.Database
\Server\Responders\Index.cs:line 118
at Raven.Database.Server.Responders.Index.OnGet(IHttpContext
context, String index) in c:\Builds\RavenDB-Unstable\Raven.Database
\Server\Responders\Index.cs:line 90
at Raven.Database.Server.Responders.Index.Respond(IHttpContext
context) in c:\Builds\RavenDB-Unstable\Raven.Database\Server\Responders
\Index.cs:line 45
at Raven.Database.Server.HttpServer.DispatchRequest(IHttpContext
ctx) in c:\Builds\RavenDB-Unstable\Raven.Database\Server
\HttpServer.cs:line 548
at
Raven.Database.Server.HttpServer.HandleActualRequest(IHttpContext ctx)
in c:\Builds\RavenDB-Unstable\Raven.Database\Server\HttpServer.cs:line
315

at
Raven.Client.Connection.HttpJsonRequest.HanldeErrors(WebException e)
in c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Connection
\HttpJsonRequest.cs:line 426
at
Raven.Client.Connection.HttpJsonRequest.ReadStringInternal(Func`1
getResponse) in c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight
\Connection\HttpJsonRequest.cs:line 293
at Raven.Client.Connection.HttpJsonRequest.ReadResponseString() in
c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Connection
\HttpJsonRequest.cs:line 203
at Raven.Client.Connection.HttpJsonRequest.ReadResponseJson() in c:
\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Connection
\HttpJsonRequest.cs:line 650
at Raven.Client.Connection.ServerClient.DirectQuery(String index,
IndexQuery query, String operationUrl, String[] includes) in c:\Builds
\RavenDB-Unstable\Raven.Client.Lightweight\Connection
\ServerClient.cs:line 754
at
Raven.Client.Connection.ServerClient.<>c__DisplayClass3e.<Query>b__3d(String
u) in c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Connection
\ServerClient.cs:line 738
at Raven.Client.Connection.ServerClient.TryOperation[T](Func`2
operation, String operationUrl, Boolean avoidThrowing, T& result) in c:
\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Connection
\ServerClient.cs:line 222
at Raven.Client.Connection.ServerClient.ExecuteWithReplication[T]
(String method, Func`2 operation) in c:\Builds\RavenDB-Unstable
\Raven.Client.Lightweight\Connection\ServerClient.cs:line 192
at Raven.Client.Connection.ServerClient.Query(String index,
IndexQuery query, String[] includes) in c:\Builds\RavenDB-Unstable
\Raven.Client.Lightweight\Connection\ServerClient.cs:line 738
at
Raven.Client.Document.AbstractDocumentQuery`2.ExecuteActualQuery() in
c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Document
\AbstractDocumentQuery.cs:line 447
at Raven.Client.Document.AbstractDocumentQuery`2.InitSync() in c:
\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Document
\AbstractDocumentQuery.cs:line 428
at Raven.Client.Document.AbstractDocumentQuery`2.get_QueryResult()
in c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Document
\AbstractDocumentQuery.cs:line 414
at
Raven.Client.Linq.RavenQueryProviderProcessor`1.ExecuteQuery[TProjection]
() in c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Linq
\RavenQueryProviderProcessor..cs:line 1254
at
Raven.Client.Linq.RavenQueryProviderProcessor`1.Execute(Expression
expression) in c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Linq
\RavenQueryProviderProcessor.cs:line 1235
at Raven.Client.Linq.RavenQueryProvider`1.Execute(Expression
expression) in c:\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Linq
\RavenQueryProvider.cs:line 138
at
Raven.Client.Linq.RavenQueryProvider`1.System.Linq.IQueryProvider.Execute(Expression
expression) in c:\Builds\RavenDB-Unstable\Raven..Client.Lightweight
\Linq\RavenQueryProvider.cs:line 195
at Raven.Client.Linq.RavenQueryInspector`1.GetEnumerator() in c:
\Builds\RavenDB-Unstable\Raven.Client.Lightweight\Linq
\RavenQueryInspector.cs:line 97
at System.Collections.Generic.List`1..ctor(IEnumerable`1
collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at
Escape.Web.Admin..Controllers.PaymentsController.List(PaymentListViewModel
viewModel) in D:\Projects\EscapeV2\Escape.Web.Admin\Controllers
\PaymentsController.cs:line 87
at lambda_method(Closure , ControllerBase , Object[] )
at
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext
controllerContext, IDictionary`2 parameters)
at
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext
controllerContext, ActionDescriptor actionDescriptor, IDictionary`2
parameters)
at
System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()
at
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter
filter, ActionExecutingContext preContext, Func`1 continuation)
at
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter
filter, ActionExecutingContext preContext, Func`1 continuation)
at
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext
controllerContext, IList`1 filters, ActionDescriptor actionDescriptor,
IDictionary`2 parameters)
at
System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext
controllerContext, String actionName)
at System.Web.Mvc.Controller.ExecuteCore()
at System.Web.Mvc.ControllerBase.Execute(RequestContext
requestContext)
at
System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5()
at
System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
at
System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d()
at
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step,
Boolean& completedSynchronously)

[Oren Eini (Ayende Rahien)]

Can you create a failing test? The index def isn't enough to figure out what is wrong