web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Excel add in - Update excel sheet based on failed publish errors

(0) ShareShare
ReportReport
Posted on by

Hello,

I am using Excel add in to import some data. Upon publishing the data, system failed to publish and reported me some errors as below:


From the error, i understand that i need to enter value in the field based on the supported char limit. so i went back to my worksheet and tried changing the value. As soon as i update the field value and move to next field (or press tab), excel reverts back to old value and i am unable to publish.

so i tried to use "Refresh-> Clear current" so i can enter afresh, system allowed me to enter correct value now. But when i try to publish, system is giving me the same error message even though i have given correct value in the field. 

It appears to me that Publish function tries to publish old data from cache/memory instead of reading current data from excel sheet. If i use new excel sheet, it works fine. 

Any thoughts?

Error message:

Invalid document schema. The following error was returned: The 'http://schemas.microsoft.com/dynamics/2008/01/documents/DirPartyTable:NameAlias' element is invalid - The value 'xxxx' is invalid according to its datatype 'http://schemas.microsoft.com/dynamics/2008/01/sharedtypes:AxdExtType_NameAlias' - The actual length is greater than the MaxLength value. The actual length is greater than the MaxLength value.

I use AX 2012 R2 CU7

Thanks

Venkatesh

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    300,915 Super User 2025 Season 2 on at

    Hi Venkatesh,

    Are you publishing data using tables or a (AIF) service? Which table/service did you use? Is it the DirPartyTable?

    The error is indicating something with a maximum length. What fields are on the sheet and filled? Is the NameAlias one of them? The value 'xxxx' in the error... is it the value used or is it an indication that some value was used?

    The NameAlias field itself has a maximum length of 20 characters. So perhaps you have to check this column in the sheet first.

  • Community Member Profile Picture
    on at

    Hi Andre,

    I am using "Add Tables" and added DirPartyTable. Yes, my data sheet contains NameAlias(Known As) and other fields viz Name, Party id, Party Type and Location.LocationId field.

    I initially forgot that NameAlias will accept only 20 char and entered more than that (about 25 char). Upon publishing, Excel addin threw the error "The actual length is greater than the MaxLength value in the NameAlias field".

    Now that I know the error, I tried to rectified it by updating the DirPartyTable excel sheet. As soon I as give in value less than 20 char and come out of the cell, excel "undo" my change.

    I tried deleting the row in question and created again. Even then when I enter the value in the new row, Excel automatically reverts the original text (i.e. more than 20 char). That's strange.

    The only way worked for me is to ignore this entire excel and create new excel. It somehow appeared for me that Excel cached the old value and not allowing me to enter new value.

    -Venkatesh

  • André Arnaud de Calavon Profile Picture
    300,915 Super User 2025 Season 2 on at

    Hi Venkatesh,

    In some cases I have seen some weird behaviour like "chache", indeed. Luckily you created a new sheet, otherwise I would have suggested it. Then you start with a new fresh "environment".

    Is your problem solved now?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans