From: Rafi on
Hi,

I am trying to update the properties of a document in a document
library using "UpdateListItems " and all seems to work well except
in one scenario.

One of the documents properties is a field called
"Primary_x0020_Category", which is a lookup utilizing another SP
list.

When the document property is initialized (via a web browser) to say
value = "Summer" and I try to update to say "Spring", all works
well.

However, when the value of the property as seen via the web UI is
"(none)", any attempt to update (to any valid value from the lookup
list) fails with the folloiwng error message:
(Just to emphasize, the same code *works* when the field already has
value, and does &not* work when the field is (none) which probably
means null in the DB).


Thanks for any help,
Rafi E.
rafie(a)netformx.com

<ErrorCode>0x80020005</ErrorCode>
<ErrorText>The operation failed because an unexpected error
occurred. (Result Code: 0x80020005)</ErrorText>

The actual <BATCH> fragment looks like this:

<Batch OnError="Continue" ListVersion="1"
ViewName="{2B7B1263-ED14-44AE-8348-90C13B06C2BE}">
<Method ID="1" Cmd="Update">
<Field Name="ID">7</Field>
<Field
Name="FileRef">http://nfxussharepoint/sites/Sprint/TeamWorkSite/Reference
Documents/SmallPrint.doc</Field>
<Field Name="Status">Closed</Field>
<Field Name="Primary_x0020_Category"
Type="Lookup"
List="{F893BD32-D23B-4C6D-A6A0-F334F57E3EE1}"
ColName="int5"
ShowField="Title">2;Spring</Field>
<Field Name="Category_x0020_Keywords">Rafi Epstein</Field>
</Method>
</Batch>

From: Engelbert on
The .development subnewsgroup is the one specialising in programming
questions (which I presume this is).

Post programming questions to
microsoft.public.sharepoint.windowsservices.development instead of to this
main (Administration issues) newsgroup.

Engelbert

"Rafi" <rafie(a)netformx.com> wrote in message
news:1152317504.792310.233470(a)75g2000cwc.googlegroups.com...
> Hi,
>
> I am trying to update the properties of a document in a document
> library using "UpdateListItems " and all seems to work well except
> in one scenario.
>
> One of the documents properties is a field called
> "Primary_x0020_Category", which is a lookup utilizing another SP
> list.
>
> When the document property is initialized (via a web browser) to say
> value = "Summer" and I try to update to say "Spring", all works
> well.
>
> However, when the value of the property as seen via the web UI is
> "(none)", any attempt to update (to any valid value from the lookup
> list) fails with the folloiwng error message:
> (Just to emphasize, the same code *works* when the field already has
> value, and does &not* work when the field is (none) which probably
> means null in the DB).
>
>
> Thanks for any help,
> Rafi E.
> rafie(a)netformx.com
>
> <ErrorCode>0x80020005</ErrorCode>
> <ErrorText>The operation failed because an unexpected error
> occurred. (Result Code: 0x80020005)</ErrorText>
>
> The actual <BATCH> fragment looks like this:
>
> <Batch OnError="Continue" ListVersion="1"
> ViewName="{2B7B1263-ED14-44AE-8348-90C13B06C2BE}">
> <Method ID="1" Cmd="Update">
> <Field Name="ID">7</Field>
> <Field
> Name="FileRef">http://nfxussharepoint/sites/Sprint/TeamWorkSite/Reference
> Documents/SmallPrint.doc</Field>
> <Field Name="Status">Closed</Field>
> <Field Name="Primary_x0020_Category"
> Type="Lookup"
> List="{F893BD32-D23B-4C6D-A6A0-F334F57E3EE1}"
> ColName="int5"
> ShowField="Title">2;Spring</Field>
> <Field Name="Category_x0020_Keywords">Rafi Epstein</Field>
> </Method>
> </Batch>
>