> Go into the studio and look at the errors.
> Somehow, you have an index that throws errors, which is really strange.

> What does it shows?

> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com> wrote:

>> Hi,
>> I am trying to run this query:

>> RavenSession.Query<Picture>().Customize(x =>
>> x.WaitForNonStaleResults()).Where(c => c.ParentDocumentId == id &&
>> c.IsOfficial.Value).Select(c => new Picture

>> {

>> Name = c.Name,

>> Title = c.Title,

>> Url = c.Url,

>> Id = c.Id,

>> Description = c.Description,

>> IsMain = c.IsMain,

>> }).ToList();

>> But I get the following error:
>> *Url:
>> "/indexes/dynamic/Pictures?query=ParentDocumentId%253A7041%2520AND%2520IsOf ficial.Value%253Atrue&start=0&pageSize=128&aggregation=None&fetch=Name&fetc h=Title&fetch=Url&fetch=__document_id&fetch=Description&fetch=IsMain"
>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is invalid, out
>> of 258 indexing attempts, 258 has failed.
>> Error rate of 100% exceeds allowed 15% error rate*

>> Can anyone tell me what I'm doing wrong?

> בתאריך יום שבת, 16 ביוני 2012 11:53:31 UTC+3, מאת Oren Eini:

>> Go into the studio and look at the errors.
>> Somehow, you have an index that throws errors, which is really strange.

>> What does it shows?

>> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com> wrote:

>>> Hi,
>>> I am trying to run this query:

>>> RavenSession.Query<Picture>().**Customize(x =>
>>> x.WaitForNonStaleResults()).**Where(c => c.ParentDocumentId == id &&
>>> c.IsOfficial.Value).Select(c => new Picture
>>>                               **                              **
>>> {
>>>                               **                              **
>>> Name = c.Name,
>>>                               **                              **
>>> Title = c.Title,
>>>                               **                              **
>>> Url = c.Url,
>>>                               **                              **
>>> Id = c.Id,
>>>                               **                              **
>>> Description = c.Description,
>>>                               **                              **
>>> IsMain = c.IsMain,
>>>                               **                              **
>>> }).ToList();

>>> But I get the following error:
>>> *Url: "/indexes/dynamic/Pictures?query=ParentDocumentId%
>>> 253A7041%2520AND%2520IsOfficial.Value%253Atrue&start=0&pageSize=128&
>>> aggregation=None&fetch=Name&fetch=Title&fetch=Url&fetch=__
>>> document_id&fetch=Description&fetch=IsMain"
>>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is invalid,
>>> out of 258 indexing attempts, 258 has failed.
>>> Error rate of 100% exceeds allowed 15% error rate*

>>> Can anyone tell me what I'm doing wrong?

> Hm,
> What does the index looks like?

> On Sat, Jun 16, 2012 at 2:10 PM, dredme <dor.r...@gmail.com> wrote:

>> Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: 'bool' does not
>> contain a definition for 'Value'
>>    at CallSite.Target(Closure , CallSite , Object )
>>    at
>> Index_Temp_2fPictures_2fByIsOfficial_ValueAndParentDocumentId.<.ctor>b__b(O bject
>> doc)
>>    at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
>>    at Raven.Database.Indexing.RobustEnumerator.MoveNext(IEnumerator en,
>> StatefulEnumerableWrapper`1 innerEnumerator) in
>> c:\Builds\RavenDB-Stable\Raven.Database\Indexing\RobustEnumerator.cs:line 84

>> בתאריך יום שבת, 16 ביוני 2012 11:53:31 UTC+3, מאת Oren Eini:

>>> Go into the studio and look at the errors.
>>> Somehow, you have an index that throws errors, which is really strange.

>>> What does it shows?

>>> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com> wrote:

>>>> Hi,
>>>> I am trying to run this query:

>>>> RavenSession.Query<Picture>().**Customize(x =>
>>>> x.WaitForNonStaleResults()).**Where(c => c.ParentDocumentId == id &&
>>>> c.IsOfficial.Value).Select(c => new Picture
>>>>                               **                              **                      
>>>> {
>>>>                               **                              **                          
>>>> Name = c.Name,
>>>>                               **                              **                          
>>>> Title = c.Title,
>>>>                               **                              **                          
>>>> Url = c.Url,
>>>>                               **                              **                          
>>>> Id = c.Id,
>>>>                               **                              **                          
>>>> Description = c.Description,
>>>>                               **                              **                          
>>>> IsMain = c.IsMain,
>>>>                               **                              **                      
>>>> }).ToList();

>>>> But I get the following error:
>>>> *Url: "/indexes/dynamic/Pictures?query=ParentDocumentId%
>>>> 253A7041%2520AND%2520IsOfficial.Value%253Atrue&start=0&pageSize=128&
>>>> aggregation=None&fetch=Name&fetch=Title&fetch=Url&fetch=__
>>>> document_id&fetch=Description&fetch=IsMain"
>>>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>>>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is invalid,
>>>> out of 258 indexing attempts, 258 has failed.
>>>> Error rate of 100% exceeds allowed 15% error rate*

>>>> Can anyone tell me what I'm doing wrong?

> The paramaters ParectDocumentId is int and the IsOfficial parameter is a
> nullable bool

> בתאריך יום שבת, 16 ביוני 2012 14:28:04 UTC+3, מאת Oren Eini:

>> Hm,
>> What does the index looks like?

>> On Sat, Jun 16, 2012 at 2:10 PM, dredme <dor.r...@gmail.com> wrote:

>>> Microsoft.CSharp.**RuntimeBinder.**RuntimeBinderException: 'bool' does
>>> not contain a definition for 'Value'
>>>    at CallSite.Target(Closure , CallSite , Object )
>>>    at Index_Temp_2fPictures_**2fByIsOfficial_**
>>> ValueAndParentDocumentId.<.**ctor>b__b(Object doc)
>>>    at System.Linq.Enumerable.**WhereSelectEnumerableIterator`**
>>> 2.MoveNext()
>>>    at Raven.Database.Indexing.**RobustEnumerator.MoveNext(**IEnumerator
>>> en, StatefulEnumerableWrapper`1 innerEnumerator) in
>>> c:\Builds\RavenDB-Stable\**Raven.Database\Indexing\**RobustEnumerator.cs:li ne
>>> 84

>>> בתאריך יום שבת, 16 ביוני 2012 11:53:31 UTC+3, מאת Oren Eini:

>>>> Go into the studio and look at the errors.
>>>> Somehow, you have an index that throws errors, which is really strange.

>>>> What does it shows?

>>>> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com> wrote:

>>>>> Hi,
>>>>> I am trying to run this query:

>>>>> RavenSession.Query<Picture>().****Customize(x =>
>>>>> x.WaitForNonStaleResults()).**Wh**ere(c => c.ParentDocumentId == id
>>>>> && c.IsOfficial.Value).Select(c => new Picture
>>>>>                               ****                              ****
>>>>> {
>>>>>                               ****                              ****
>>>>> Name = c.Name,
>>>>>                               ****                              ****
>>>>> Title = c.Title,
>>>>>                               ****                              ****
>>>>> Url = c.Url,
>>>>>                               ****                              ****
>>>>> Id = c.Id,
>>>>>                               ****                              ****
>>>>> Description = c.Description,
>>>>>                               ****                              ****
>>>>> IsMain = c.IsMain,
>>>>>                               ****                              ****
>>>>> }).ToList();

>>>>> But I get the following error:
>>>>> *Url: "/indexes/dynamic/Pictures?query=ParentDocumentId%253A7041%
>>>>> 2520AND%2520IsOfficial.Value%253Atrue&start=0&pageSize=128&
>>>>> aggregation=None&fetch=Name&fetch=Title&fetch=Url&fetch=__do
>>>>> cument_id&fetch=Description&fetch=IsMain"
>>>>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>>>>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is invalid,
>>>>> out of 258 indexing attempts, 258 has failed.
>>>>> Error rate of 100% exceeds allowed 15% error rate*

>>>>> Can anyone tell me what I'm doing wrong?

> Can you show the actual index ?
> And a sample document?

> On Sat, Jun 16, 2012 at 6:47 PM, dredme <dor.r...@gmail.com> wrote:

>> I wrote a query in the first post above, when I run it I get this error
>> about RavenDB didn't succeed creating the index for this query.
>> I'm using build #888

>> The paramaters ParectDocumentId is int and the IsOfficial parameter is a
>> nullable bool

>> בתאריך יום שבת, 16 ביוני 2012 14:28:04 UTC+3, מאת Oren Eini:

>>> Hm,
>>> What does the index looks like?

>>> On Sat, Jun 16, 2012 at 2:10 PM, dredme <dor.r...@gmail.com> wrote:

>>>> Microsoft.CSharp.**RuntimeBinder.**RuntimeBinderException: 'bool' does
>>>> not contain a definition for 'Value'
>>>>    at CallSite.Target(Closure , CallSite , Object )
>>>>    at Index_Temp_2fPictures_**2fByIsOfficial_**
>>>> ValueAndParentDocumentId.<.**ctor>b__b(Object doc)
>>>>    at System.Linq.Enumerable.**WhereSelectEnumerableIterator`**
>>>> 2.MoveNext()
>>>>    at Raven.Database.Indexing.**RobustEnumerator.MoveNext(**IEnumerator
>>>> en, StatefulEnumerableWrapper`1 innerEnumerator) in
>>>> c:\Builds\RavenDB-Stable\**Raven.Database\Indexing\**RobustEnumerator.cs:li ne
>>>> 84

>>>> בתאריך יום שבת, 16 ביוני 2012 11:53:31 UTC+3, מאת Oren Eini:

>>>>> Go into the studio and look at the errors.
>>>>> Somehow, you have an index that throws errors, which is really strange.

>>>>> What does it shows?

>>>>> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com> wrote:

>>>>>> Hi,
>>>>>> I am trying to run this query:

>>>>>> RavenSession.Query<Picture>().****Customize(x =>
>>>>>> x.WaitForNonStaleResults()).**Wh**ere(c => c.ParentDocumentId == id
>>>>>> && c.IsOfficial.Value).Select(c => new Picture
>>>>>>                               ****                              ****                      
>>>>>> {
>>>>>>                               ****                              ****                          
>>>>>> Name = c.Name,
>>>>>>                               ****                              ****                          
>>>>>> Title = c.Title,
>>>>>>                               ****                              ****                          
>>>>>> Url = c.Url,
>>>>>>                               ****                              ****                          
>>>>>> Id = c.Id,
>>>>>>                               ****                              ****                          
>>>>>> Description = c.Description,
>>>>>>                               ****                              ****                          
>>>>>> IsMain = c.IsMain,
>>>>>>                               ****                              ****                      
>>>>>> }).ToList();

>>>>>> But I get the following error:
>>>>>> *Url: "/indexes/dynamic/Pictures?query=ParentDocumentId%253A7041%
>>>>>> 2520AND%2520IsOfficial.Value%253Atrue&start=0&pageSize=128&
>>>>>> aggregation=None&fetch=Name&fetch=Title&fetch=Url&fetch=__do
>>>>>> cument_id&fetch=Description&fetch=IsMain"
>>>>>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>>>>>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is
>>>>>> invalid, out of 258 indexing attempts, 258 has failed.
>>>>>> Error rate of 100% exceeds allowed 15% error rate*

>>>>>> Can anyone tell me what I'm doing wrong?

> from doc in docs.Pictures
> select new { ParentDocumentId = doc.ParentDocumentId, IsOfficial_Value =
> doc.IsOfficial.Value, IsOfficial = doc.IsOfficial }

> and here is a sample document
> {
>   "Title": null,
>   "Filename":
> "D:\\uploads\\pictures\\634745902552916022_Hotel_7041_4368107104_71956ab061 .jpg",
>   "Url":
> "/uploads/pictures/634745902552916022_Hotel_7041_4368107104_71956ab061.jpg" ,
>   "MediaType": null,
>   "Description": null,
>   "ParentDocumentId": 7041,
>   "ParentDocumentType": "Hotel",
>   "Username": "",
>   "IsOfficial": true,
>   "IsMain": null,
>   "CreatedOn": "2012-06-06T14:37:35.4316102",
>   "Name": null,
>   "Status": "Published"
> }

> בתאריך יום ראשון, 17 ביוני 2012 10:06:01 UTC+3, מאת Oren Eini:

>> Can you show the actual index ?
>> And a sample document?

>> On Sat, Jun 16, 2012 at 6:47 PM, dredme <dor.r...@gmail.com> wrote:

>>> I wrote a query in the first post above, when I run it I get this error
>>> about RavenDB didn't succeed creating the index for this query.
>>> I'm using build #888

>>> The paramaters ParectDocumentId is int and the IsOfficial parameter is a
>>> nullable bool

>>> בתאריך יום שבת, 16 ביוני 2012 14:28:04 UTC+3, מאת Oren Eini:

>>>> Hm,
>>>> What does the index looks like?

>>>> On Sat, Jun 16, 2012 at 2:10 PM, dredme <dor.r...@gmail.com> wrote:

>>>>> Microsoft.CSharp.**RuntimeBinder**.**RuntimeBinderException: 'bool'
>>>>> does not contain a definition for 'Value'
>>>>>    at CallSite.Target(Closure , CallSite , Object )
>>>>>    at Index_Temp_2fPictures_**2fByIsOf**ficial_**
>>>>> ValueAndParentDocumentI**d.<.**ctor>b__b(Object doc)
>>>>>    at System.Linq.Enumerable.**WhereSe**lectEnumerableIterator`**2.**
>>>>> MoveNext()
>>>>>    at Raven.Database.Indexing.**Robust**Enumerator.MoveNext(**
>>>>> IEnumerato**r en, StatefulEnumerableWrapper`1 innerEnumerator) in
>>>>> c:\Builds\RavenDB-Stable\**Raven**.Database\Indexing\**RobustEnume**rator.c s:line
>>>>> 84

>>>>> בתאריך יום שבת, 16 ביוני 2012 11:53:31 UTC+3, מאת Oren Eini:

>>>>>> Go into the studio and look at the errors.
>>>>>> Somehow, you have an index that throws errors, which is really
>>>>>> strange.

>>>>>> What does it shows?

>>>>>> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com> wrote:

>>>>>>> Hi,
>>>>>>> I am trying to run this query:

>>>>>>> RavenSession.Query<Picture>().******Customize(x =>
>>>>>>> x.WaitForNonStaleResults()).**Wh****ere(c => c.ParentDocumentId ==
>>>>>>> id && c.IsOfficial.Value).Select(c => new Picture
>>>>>>>                               ******                              **
>>>>>>> ****                      {
>>>>>>>                               ******                              **
>>>>>>> ****                          Name = c.Name,
>>>>>>>                               ******                              **
>>>>>>> ****                          Title = c.Title,
>>>>>>>                               ******                              **
>>>>>>> ****                          Url = c.Url,
>>>>>>>                               ******                              **
>>>>>>> ****                          Id = c.Id,
>>>>>>>                               ******                              **
>>>>>>> ****                          Description = c.Description,
>>>>>>>                               ******                              **
>>>>>>> ****                          IsMain = c.IsMain,
>>>>>>>                               ******                              **
>>>>>>> ****                      }).ToList();

>>>>>>> But I get the following error:
>>>>>>> *Url: "/indexes/dynamic/Pictures?query=ParentDocumentId%253A7041%2
>>>>>>> 520AND%2520IsOfficial.Value%253Atrue&start=0&pageSize=128&ag
>>>>>>> gregation=None&fetch=Name&fetch=Title&fetch=Url&fetch=__docu
>>>>>>> ment_id&fetch=Description&fetch=IsMain"
>>>>>>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>>>>>>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is
>>>>>>> invalid, out of 258 indexing attempts, 258 has failed.
>>>>>>> Error rate of 100% exceeds allowed 15% error rate*

>>>>>>> Can anyone tell me what I'm doing wrong?

> You have this:
> , IsOfficial_Value = doc.IsOfficial.Value

> The problem is that this is a boolean property, and bool doesn't have a
> Value property.
> I assume it is a nullable boolean in your code?

> On Mon, Jun 18, 2012 at 3:02 PM, dredme <dor.r...@gmail.com> wrote:

>> here is the index

>> from doc in docs.Pictures
>> select new { ParentDocumentId = doc.ParentDocumentId, IsOfficial_Value =
>> doc.IsOfficial.Value, IsOfficial = doc.IsOfficial }

>> and here is a sample document
>> {
>>   "Title": null,
>>   "Filename":
>> "D:\\uploads\\pictures\\634745902552916022_Hotel_7041_4368107104_71956ab061 .jpg",
>>   "Url":
>> "/uploads/pictures/634745902552916022_Hotel_7041_4368107104_71956ab061.jpg" ,
>>   "MediaType": null,
>>   "Description": null,
>>   "ParentDocumentId": 7041,
>>   "ParentDocumentType": "Hotel",
>>   "Username": "",
>>   "IsOfficial": true,
>>   "IsMain": null,
>>   "CreatedOn": "2012-06-06T14:37:35.4316102",
>>   "Name": null,
>>   "Status": "Published"
>> }

>> בתאריך יום ראשון, 17 ביוני 2012 10:06:01 UTC+3, מאת Oren Eini:

>>> Can you show the actual index ?
>>> And a sample document?

>>> On Sat, Jun 16, 2012 at 6:47 PM, dredme <dor.r...@gmail.com> wrote:

>>>> I wrote a query in the first post above, when I run it I get this error
>>>> about RavenDB didn't succeed creating the index for this query.
>>>> I'm using build #888

>>>> The paramaters ParectDocumentId is int and the IsOfficial parameter is
>>>> a nullable bool

>>>> בתאריך יום שבת, 16 ביוני 2012 14:28:04 UTC+3, מאת Oren Eini:

>>>>> Hm,
>>>>> What does the index looks like?

>>>>> On Sat, Jun 16, 2012 at 2:10 PM, dredme <dor.r...@gmail.com> wrote:

>>>>>> Microsoft.CSharp.**RuntimeBinder**.**RuntimeBinderException: 'bool'
>>>>>> does not contain a definition for 'Value'
>>>>>>    at CallSite.Target(Closure , CallSite , Object )
>>>>>>    at Index_Temp_2fPictures_**2fByIsOf**ficial_**
>>>>>> ValueAndParentDocumentI**d.<.**ctor>b__b(Object doc)
>>>>>>    at System.Linq.Enumerable.**WhereSe**lectEnumerableIterator`**2.**
>>>>>> MoveNext()
>>>>>>    at Raven.Database.Indexing.**Robust**Enumerator.MoveNext(**
>>>>>> IEnumerato**r en, StatefulEnumerableWrapper`1 innerEnumerator) in
>>>>>> c:\Builds\RavenDB-Stable\**Raven**.Database\Indexing\**RobustEnume**rator.c s:line
>>>>>> 84

>>>>>> בתאריך יום שבת, 16 ביוני 2012 11:53:31 UTC+3, מאת Oren Eini:

>>>>>>> Go into the studio and look at the errors.
>>>>>>> Somehow, you have an index that throws errors, which is really
>>>>>>> strange.

>>>>>>> What does it shows?

>>>>>>> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com> wrote:

>>>>>>>> Hi,
>>>>>>>> I am trying to run this query:

>>>>>>>> RavenSession.Query<Picture>().******Customize(x =>
>>>>>>>> x.WaitForNonStaleResults()).**Wh****ere(c => c.ParentDocumentId ==
>>>>>>>> id && c.IsOfficial.Value).Select(c => new Picture
>>>>>>>>                               ******                              *
>>>>>>>> *****                      {
>>>>>>>>                               ******                              *
>>>>>>>> *****                          Name = c.Name,
>>>>>>>>                               ******                              *
>>>>>>>> *****                          Title = c.Title,
>>>>>>>>                               ******                              *
>>>>>>>> *****                          Url = c.Url,
>>>>>>>>                               ******                              *
>>>>>>>> *****                          Id = c.Id,
>>>>>>>>                               ******                              *
>>>>>>>> *****                          Description = c.Description,
>>>>>>>>                               ******                              *
>>>>>>>> *****                          IsMain = c.IsMain,
>>>>>>>>                               ******                              *
>>>>>>>> *****                      }).ToList();

>>>>>>>> But I get the following error:
>>>>>>>> *Url: "/indexes/dynamic/Pictures?query=ParentDocumentId%253A7041%2
>>>>>>>> 520AND%2520IsOfficial.Value%253Atrue&start=0&pageSize=128&ag
>>>>>>>> gregation=None&fetch=Name&fetch=Title&fetch=Url&fetch=__docu
>>>>>>>> ment_id&fetch=Description&fetch=IsMain"
>>>>>>>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>>>>>>>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is
>>>>>>>> invalid, out of 258 indexing attempts, 258 has failed.
>>>>>>>> Error rate of 100% exceeds allowed 15% error rate*

>>>>>>>> Can anyone tell me what I'm doing wrong?

> בתאריך יום שני, 18 ביוני 2012 15:13:57 UTC+3, מאת Oren Eini:

>> You have this:
>> , IsOfficial_Value = doc.IsOfficial.Value

>> The problem is that this is a boolean property, and bool doesn't have a
>> Value property.
>> I assume it is a nullable boolean in your code?

>> On Mon, Jun 18, 2012 at 3:02 PM, dredme <dor.r...@gmail.com> wrote:

>>> here is the index

>>> from doc in docs.Pictures
>>> select new { ParentDocumentId = doc.ParentDocumentId, IsOfficial_Value =
>>> doc.IsOfficial.Value, IsOfficial = doc.IsOfficial }

>>> and here is a sample document
>>> {
>>>   "Title": null,
>>>   "Filename": "D:\\uploads\\pictures\\**634745902552916022_Hotel_7041_**
>>> 4368107104_71956ab061.jpg",
>>>   "Url": "/uploads/pictures/**634745902552916022_Hotel_7041_**
>>> 4368107104_71956ab061.jpg",
>>>   "MediaType": null,
>>>   "Description": null,
>>>   "ParentDocumentId": 7041,
>>>   "ParentDocumentType": "Hotel",
>>>   "Username": "",
>>>   "IsOfficial": true,
>>>   "IsMain": null,
>>>   "CreatedOn": "2012-06-06T14:37:35.4316102",
>>>   "Name": null,
>>>   "Status": "Published"
>>> }

>>> בתאריך יום ראשון, 17 ביוני 2012 10:06:01 UTC+3, מאת Oren Eini:

>>>> Can you show the actual index ?
>>>> And a sample document?

>>>> On Sat, Jun 16, 2012 at 6:47 PM, dredme <dor.r...@gmail.com> wrote:

>>>>> I wrote a query in the first post above, when I run it I get this
>>>>> error about RavenDB didn't succeed creating the index for this query.
>>>>> I'm using build #888

>>>>> The paramaters ParectDocumentId is int and the IsOfficial parameter is
>>>>> a nullable bool

>>>>> בתאריך יום שבת, 16 ביוני 2012 14:28:04 UTC+3, מאת Oren Eini:

>>>>>> Hm,
>>>>>> What does the index looks like?

>>>>>> On Sat, Jun 16, 2012 at 2:10 PM, dredme <dor.r...@gmail.com> wrote:

>>>>>>> Microsoft.CSharp.**RuntimeBinder****.**RuntimeBinderException:
>>>>>>> 'bool' does not contain a definition for 'Value'
>>>>>>>    at CallSite.Target(Closure , CallSite , Object )
>>>>>>>    at Index_Temp_2fPictures_**2fByIsOf****ficial_**
>>>>>>> ValueAndParentDocumentI****d.<.**ctor>b__b(Object doc)
>>>>>>>    at System.Linq.Enumerable.**WhereSe****lectEnumerableIterator`**
>>>>>>> 2.**MoveN**ext()
>>>>>>>    at Raven.Database.Indexing.**Robust****Enumerator.MoveNext(**
>>>>>>> IEnumerato****r en, StatefulEnumerableWrapper`1 innerEnumerator) in
>>>>>>> c:\Builds\RavenDB-Stable\**Raven****.Database\Indexing\**RobustEnume
>>>>>>> ****rator.cs:line 84

>>>>>>> בתאריך יום שבת, 16 ביוני 2012 11:53:31 UTC+3, מאת Oren Eini:

>>>>>>>> Go into the studio and look at the errors.
>>>>>>>> Somehow, you have an index that throws errors, which is really
>>>>>>>> strange.

>>>>>>>> What does it shows?

>>>>>>>> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com>wrote:

>>>>>>>>> Hi,
>>>>>>>>> I am trying to run this query:

>>>>>>>>> RavenSession.Query<Picture>().********Customize(x =>
>>>>>>>>> x.WaitForNonStaleResults()).**Wh******ere(c => c.ParentDocumentId
>>>>>>>>> == id && c.IsOfficial.Value).Select(c => new Picture
>>>>>>>>>                               ********
>>>>>>>>>                               ********                      {
>>>>>>>>>                               ********
>>>>>>>>>                               ********
>>>>>>>>> Name = c.Name,
>>>>>>>>>                               ********
>>>>>>>>>                               ********
>>>>>>>>> Title = c.Title,
>>>>>>>>>                               ********
>>>>>>>>>                               ********
>>>>>>>>> Url = c.Url,
>>>>>>>>>                               ********
>>>>>>>>>                               ********
>>>>>>>>> Id = c.Id,
>>>>>>>>>                               ********
>>>>>>>>>                               ********
>>>>>>>>> Description = c.Description,
>>>>>>>>>                               ********
>>>>>>>>>                               ********
>>>>>>>>> IsMain = c.IsMain,
>>>>>>>>>                               ********
>>>>>>>>>                               ********
>>>>>>>>> }).ToList();

>>>>>>>>> But I get the following error:
>>>>>>>>> *Url: "/indexes/dynamic/Pictures?query=ParentDocumentId%253A7041%2
>>>>>>>>> 520AND%2520IsOfficial.Value%253Atrue&start=0&pageSize=128&ag
>>>>>>>>> gregation=None&fetch=Name&fetch=Title&fetch=Url&fetch=__docu
>>>>>>>>> ment_id&fetch=Description&fetch=IsMain"
>>>>>>>>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>>>>>>>>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is
>>>>>>>>> invalid, out of 258 indexing attempts, 258 has failed.
>>>>>>>>> Error rate of 100% exceeds allowed 15% error rate*

>>>>>>>>> Can anyone tell me what I'm doing wrong?

> Nullable bool isn't supported right now.
> Try doing the query like this (just c.IsOfficial, not c.IsOfficial.Value)

> RavenSession.Query<Picture>().Customize(x => x.WaitForNonStaleResults()).Where(c
> => c.ParentDocumentId == id && c.IsOfficial).Select(c => new Picture

> {

> Name = c.Name,

> Title = c.Title,

> Url = c.Url,

> Id = c.Id,

> Description = c.Description,

> IsMain = c.IsMain,

> }).ToList();

> On Mon, Jun 18, 2012 at 3:28 PM, dredme <dor.r...@gmail.com> wrote:

>> yes it is

>> בתאריך יום שני, 18 ביוני 2012 15:13:57 UTC+3, מאת Oren Eini:

>>> You have this:
>>> , IsOfficial_Value = doc.IsOfficial.Value

>>> The problem is that this is a boolean property, and bool doesn't have a
>>> Value property.
>>> I assume it is a nullable boolean in your code?

>>> On Mon, Jun 18, 2012 at 3:02 PM, dredme <dor.r...@gmail.com> wrote:

>>>> here is the index

>>>> from doc in docs.Pictures
>>>> select new { ParentDocumentId = doc.ParentDocumentId, IsOfficial_Value
>>>> = doc.IsOfficial.Value, IsOfficial = doc.IsOfficial }

>>>> and here is a sample document
>>>> {
>>>>   "Title": null,
>>>>   "Filename": "D:\\uploads\\pictures\\**634745902552916022_Hotel_7041_*
>>>> *4368107104_71956ab061.jpg",
>>>>   "Url": "/uploads/pictures/**634745902552916022_Hotel_7041_**
>>>> 4368107104_71956ab061.jpg",
>>>>   "MediaType": null,
>>>>   "Description": null,
>>>>   "ParentDocumentId": 7041,
>>>>   "ParentDocumentType": "Hotel",
>>>>   "Username": "",
>>>>   "IsOfficial": true,
>>>>   "IsMain": null,
>>>>   "CreatedOn": "2012-06-06T14:37:35.4316102",
>>>>   "Name": null,
>>>>   "Status": "Published"
>>>> }

>>>> בתאריך יום ראשון, 17 ביוני 2012 10:06:01 UTC+3, מאת Oren Eini:

>>>>> Can you show the actual index ?
>>>>> And a sample document?

>>>>> On Sat, Jun 16, 2012 at 6:47 PM, dredme <dor.r...@gmail.com> wrote:

>>>>>> I wrote a query in the first post above, when I run it I get this
>>>>>> error about RavenDB didn't succeed creating the index for this query.
>>>>>> I'm using build #888

>>>>>> The paramaters ParectDocumentId is int and the IsOfficial parameter
>>>>>> is a nullable bool

>>>>>> בתאריך יום שבת, 16 ביוני 2012 14:28:04 UTC+3, מאת Oren Eini:

>>>>>>> Hm,
>>>>>>> What does the index looks like?

>>>>>>> On Sat, Jun 16, 2012 at 2:10 PM, dredme <dor.r...@gmail.com> wrote:

>>>>>>>> Microsoft.CSharp.**RuntimeBinder****.**RuntimeBinderException:
>>>>>>>> 'bool' does not contain a definition for 'Value'
>>>>>>>>    at CallSite.Target(Closure , CallSite , Object )
>>>>>>>>    at Index_Temp_2fPictures_**2fByIsOf****ficial_**
>>>>>>>> ValueAndParentDocumentI****d.<.**ctor>b__b(Object doc)
>>>>>>>>    at System.Linq.Enumerable.**WhereSe****lectEnumerableIterator`**
>>>>>>>> 2.**MoveN**ext()
>>>>>>>>    at Raven.Database.Indexing.**Robust****Enumerator.MoveNext(**
>>>>>>>> IEnumerato****r en, StatefulEnumerableWrapper`1 innerEnumerator)
>>>>>>>> in c:\Builds\RavenDB-Stable\**Raven****.Database\Indexing\**
>>>>>>>> RobustEnume****rator.cs:line 84

>>>>>>>> בתאריך יום שבת, 16 ביוני 2012 11:53:31 UTC+3, מאת Oren Eini:

>>>>>>>>> Go into the studio and look at the errors.
>>>>>>>>> Somehow, you have an index that throws errors, which is really
>>>>>>>>> strange.

>>>>>>>>> What does it shows?

>>>>>>>>> On Sat, Jun 16, 2012 at 11:21 AM, dredme <dor.r...@gmail.com>wrote:

>>>>>>>>>> Hi,
>>>>>>>>>> I am trying to run this query:

>>>>>>>>>> RavenSession.Query<Picture>().********Customize(x =>
>>>>>>>>>> x.WaitForNonStaleResults()).**Wh******ere(c =>
>>>>>>>>>> c.ParentDocumentId == id && c.IsOfficial.Value).Select(c => new Picture
>>>>>>>>>>                               ********
>>>>>>>>>>                               ********                      {
>>>>>>>>>>                               ********
>>>>>>>>>>                               ********                          
>>>>>>>>>> Name = c.Name,
>>>>>>>>>>                               ********
>>>>>>>>>>                               ********                          
>>>>>>>>>> Title = c.Title,
>>>>>>>>>>                               ********
>>>>>>>>>>                               ********                          
>>>>>>>>>> Url = c.Url,
>>>>>>>>>>                               ********
>>>>>>>>>>                               ********                          
>>>>>>>>>> Id = c.Id,
>>>>>>>>>>                               ********
>>>>>>>>>>                               ********                          
>>>>>>>>>> Description = c.Description,
>>>>>>>>>>                               ********
>>>>>>>>>>                               ********                          
>>>>>>>>>> IsMain = c.IsMain,
>>>>>>>>>>                               ********
>>>>>>>>>>                               ********                      
>>>>>>>>>> }).ToList();

>>>>>>>>>> But I get the following error:
>>>>>>>>>> *Url: "/indexes/dynamic/Pictures?query=ParentDocumentId%253A7041%
>>>>>>>>>> 2520AND%2520IsOfficial.Value%253Atrue&start=0&pageSize=128&ag
>>>>>>>>>> gregation=None&fetch=Name&fetch=Title&fetch=Url&fetch=__docu
>>>>>>>>>> ment_id&fetch=Description&fetch=IsMain"
>>>>>>>>>> Index: "Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId"

>>>>>>>>>> Index Temp/Pictures/ByIsOfficial_ValueAndParentDocumentId is
>>>>>>>>>> invalid, out of 258 indexing attempts, 258 has failed.
>>>>>>>>>> Error rate of 100% exceeds allowed 15% error rate*

>>>>>>>>>> Can anyone tell me what I'm doing wrong?