NAV 2009 Crashes while trying to export the Blob Field

st0328
st0328 Member Posts: 97
in NAV/Navision Classic Client
Hi Experts,

we are trying to export the table data using xmlport port.

In the table we have Blob Field, we are using Customer.CALCFIELDS("NEW BLOB Field"); . The moment Cursor reaches this code, NAV Crashes and error comes as shown below (attached image).

NAV VERSION is 'NL Dynamics NAV 6.0 R2'
2009 Build - '32012'
DB is SQL DB.

please give your suggestions.

Answers

  • mdPartnerNL
    mdPartnerNL Member Posts: 802
    do other blob fields have same issue? you need to eliminate more options first
  • st0328
    st0328 Member Posts: 97
    Hi,

    Thanks for responding.

    We also have blob fields in other Tables, there we don't have any issue while exporting.
  • parm
    parm Member Posts: 49
    Hi,
    I don't have a solution for you but I recommend this steps to isolate the problem.
    1) Try to use the Customer.CALCFIELDS("NEW BLOB Field"); in a codeunit to ensure that all blob in customer table are ok. Maybe one customer has a corrupted blob field.
    2) The blob a text? I think you can't use XMLPort to export binary.

    Regards and good luck.

    parm

Categories