Skip to Content
avatar image
Former Member

unable to update Delivery Note ERROR ODBC -1029

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 04, 2017 at 02:04 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded