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)

Test Data Transfer Tool Export : Name has unexpected characters

(0) ShareShare
ReportReport
Posted on by 345

Hi

I have searched the community and found a couple of threads that talk about errors with TDTT but this does not seem to be answered yet.

When I run the command DP EXPORT C:\TEMP MicrosoftDynamicsAX [Server name] i get the error below on three of four environments. The only installation where I am able to export is the development. The kind of tells me that this is a security issue but I think I have been through this. My user has the SysAdmin role on the SQL server and is Local Administrator on the SQL server. I am running the command locally so networking and firewalls should not be a problem either.

The Event viewer just tells me that the DP.exe terminated due to an unhandled exception.

Error message in the command prompt running as Administrator.

Direction: Export
Database : MicrosoftDynamicsAX
Executing pre-export command: EcpPresentationPreImport

Unhandled Exception: System.ArgumentException: Name has unexpected characters
   at Microsoft.Dynamics.AX.Dataport.SqlName..ctor(String original, String brack
eted) in e:\bt\110700\Source\DataPort\Dataport\Library\SqlHelper.cs:line 120
   at Microsoft.Dynamics.AX.Dataport.SqlHelper.<GetTableNames>b__e(String t) in
e:\bt\110700\Source\DataPort\Dataport\Library\SqlHelper.cs:line 751
   at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.OrderedEnumerable`1.<GetEnumerator>d__1.MoveNext()
   at Microsoft.Dynamics.AX.Dataport.DataportDatabase.get_Tables() in e:\bt\1107
00\Source\DataPort\Dataport\Model\DataportDatabase.cs:line 160
   at Microsoft.Dynamics.AX.Dataport.DataportDatabase.get_FilteredTables() in e:
\bt\110700\Source\DataPort\Dataport\Model\DataportDatabase.cs:line 203
   at Microsoft.Dynamics.AX.Dataport.DataportDatabase.AddToExportQueue(DataportA
ction action, String folder) in e:\bt\110700\Source\DataPort\Dataport\Model\Data
portDatabase.cs:line 281
   at DP.Program.Execute(String currentDirectory, DataportDirection direction, S
tring directory, String database, String server, DataportAction action) in e:\bt
\110700\Source\DataPort\DP\Program.cs:line 151
   at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 98

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Thomas Vogt Poulsen Profile Picture
    345 on at

    I found this link that tells the story (https://technet.microsoft.com/en-us/library/dn296448.aspx)

    Apparently some tables name reportingintergration.[GUID] is added to the list of tables in the database and the tools does not like them. I am not sure what they are and how they appear but I am sure that they are not part of the data dictionary and does not hold any data.

    When I deleted them everything works perfectly.

  • bondlela Profile Picture
    88 on at

    I am having a similar error when extracting the data from my production instance. How to I find the tables that I need to drop in order to get the data transfer tool to work. 

  • Community Member Profile Picture
    on at

    Hi Thomas, so did you just write and exclude into [Lists]? Thanks, Serge

  • Community Member Profile Picture
    on at

    The Link above you referred to is gone now

  • Thomas Vogt Poulsen Profile Picture
    345 on at

    No, as I wrote I just deleted the tables.

  • MMDAXGUY Profile Picture
    10 on at

    Thank you for posting this Thomas.  It was very helpful.

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