cancel
Showing results for 
Search instead for 
Did you mean: 

unable to update Delivery Note ERROR ODBC -1029

nadav_caridi2
Participant
0 Kudos

Dear Experts ,

When trying to update a delivery note UDF Header Fields via B1iSN I get the following error

Exception : DI Error: (-1029) [DLN1.PackQty][line: 6] , ''Field cannot be updated (ODBC -1029)''

My BOM from debug is as follows :

<Payload Role="R2" Call="object" Type="DIAPI">
<Envelope xmlns="">
<Header>
<Action throwException="false" autoCommit="false">update</Action>
<WritePolicy insert_on_exists="error" update_on_miss="fallback2I" update_policy="regular"/>
</Header>
<Body>
<BOM>
-
<BO>
<AdmInfo>
<Object>15</Object>
<Version>2</Version>
</AdmInfo>
<QueryParams>
<DocEntry>11382</DocEntry>
</QueryParams>
-
<Documents>
-
<row>
<DocObjectCode>15</DocObjectCode>
<CardCode>20180</CardCode>
<U_B1IFeedBack>2</U_B1IFeedBack>
<U_B1iID>RSP_3871859_162621_824611</U_B1iID>
<U_ORDRVerDate>20161215</U_ORDRVerDate>
<U_nsClTry>3871859</U_nsClTry>
</row>
</Documents>
</BO>
</BOM>
</Body>
</Envelope>
</Payload>
<Payload id="ErrorInfos">
<ipo/>
<bfd/>
<calls/>
</Payload>

object was set on update only but I changed it to Update with fall back to Insert to see if that has to do with it.

as you can see from the above the I'm not trying to update any of the lines in DLN1 so I'm not sure why I get the above error .

another note is that the document is an Open-Printed state , I can edit the above fields from the SBO User interface client.

Any help is much appreciated.

Thanks ,

NC

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Navadi,

I suppose you have some values in row that you don't plan to update (DocObjectCode, CardCode). I would suggest to remove them from the message and leave only tags for UDF.

Probably that error comes because DI API tries to update DocObjectCode, which is fixed for the Delivery Note.

Hope it will help!

Answers (0)