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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Error in using Test Da...
Microsoft Dynamics AX (Archived)

Error in using Test Data Transfer Tool (BETA) for CONTOSO data import

(0) ShareShare
ReportReport
Posted on by Srika 145

Hi all,

I have setup a single computer installation of AX 2012 R3 and trying to import the contoso demo data using the Test Data Transfer Tool (BETA). I get the below exception error. Please suggest. Thanks in advance for the support.

Unhandled Exception: System.NotSupportedException: The given path's format is no
t supported.
   at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boo
lean needFullPath)
   at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[
] str, Boolean needFullPath)
   at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionA
ccess access, AccessControlActions control, String[] pathListOrig, Boolean check
ForDuplicates, Boolean needFullPath, Boolean copyPathList)
   at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionA
ccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFul
lPath, Boolean copyPathList)
   at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess
access, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath)
   at System.IO.FileSystemEnumerableIterator`1..ctor(String path, String origina
lUserPath, String searchPattern, SearchOption searchOption, SearchResultHandler`
1 resultHandler, Boolean checkHost)
   at System.IO.Directory.InternalGetFileDirectoryNames(String path, String user
PathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, S
earchOption searchOption, Boolean checkHost)
   at System.IO.Directory.InternalGetFiles(String path, String searchPattern, Se
archOption searchOption)
   at Microsoft.Dynamics.AX.Dataport.SqlHelper.GetDifferentialTableNames(Datapor
tDatabase db, String directory) in e:\bt\110700\Source\DataPort\Dataport\Library
\SqlHelper.cs:line 721
   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 183
   at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
cs:line 82

*This post is locked for comments

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

    Hi Srika,

    When you use this tool, you have to specify 4 parameters. It might be related to the file path specified. Can you verify if all paramters were entered correctly? What path have you specified?

  • Srika Profile Picture
    Srika 145 on at

    Hi Andre,

    I had executed the DP.exe in the command prompt. I have a domain admin for my user as well.

    DP.exe IMPORT “C:\AX2012DDATA\DynamicsAXR3DemoData” MicrosoftDynamicsAX

    The above is based on the syntax for DP.EXE as

    DP.exe [IMPORT / EXPORT] [DIRECTORY PATH] [DATABASE NAME]

    Since both database and application are in the same computer, I did not specify the server name.

    Thanks.

    Srika

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,168 Super User 2025 Season 2 on at

    Hi Srika,

    The command line seems to be correct. Make sure the directory you mentioned do have the import files in it. If it is in another sub folder, it will not work.

    Do you have the SQL Server client tools installed? See this page for this requirement: technet.microsoft.com/.../dn296450.aspx

    Once I had a similar or maybe the same error. I found out that my environment did not had the Client tools installed.

  • Srika Profile Picture
    Srika 145 on at

    Hi Andre,

    Thanks for the suggestions. I checked for the database client tools and could find lot of tools listed. I could not identify the tool that is required for Test Data Transfer Tool. It will be great if you can suggest.

    Regards,

    Srikanth Seshadri

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,168 Super User 2025 Season 2 on at

    Hi Srikanth,

    You can search for the program "bcp.exe" on the SQL server harddrive. This is required for the Test Data Transfer Tool. If it is not present in your SQL installation folders, you need to run the SQL server setup files. Then enable the features:

    - Client Tool Connectivity

    - Client Tools Backward Compatibility

    Perhaps only the first would be sufficient. I have installed almost all shared options in my environment.

  • Srika Profile Picture
    Srika 145 on at

    Hi Andre,

    Thanks. I had verified for the file and installed it and I have completed the data import as well. However, I have another issue now. I have created a TEST company when I installed AX and had only one user (Admin) configured for access. Now, after the import, seems the default company is erased and when I try to login the client I get the error

    Login Error The default login company does not exist.

    Is there a way to change the default login company in the back end and not through the client?

    Thanks.

    Srikanth

  • Srika Profile Picture
    Srika 145 on at

    Hi,

    I had identified and rectified the issue. The default company is changed in the USERINFO table in sql server.

    Regards,

    Srikanth

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,168 Super User 2025 Season 2 on at

    Hi Srikanth,

    Glad you solved this problem. So it was the missing SQL client tools.

    You can change the default company in SQL directly. The table UserInfo contains the field Company. You can change the value to a new company id (e.g. USMF).

  • Srika Profile Picture
    Srika 145 on at

    Hi Andre,

    Thanks for all your support, much appreciated.

    Regards,

    srikanth

  • Kishore Barik Profile Picture
    Kishore Barik 5 on at

    Hello Andre,

    I also getting same error, and have gone through all discussion in this post.

    Checked:

    - Client Tool Connectivity[Installed]

    - Client Tools Backward Compatibility[Installed]

    - bcp.exe file is available in Path "C:\Program Files\Microsoft SQL Server\100\Tools\Binn"

    - And "C:\Program Files\Microsoft SQL Server\100\Tools\Binn" path is already set to Environment Variable of System.

    - Data files are available in C:\Users\dynamicsax2\Documents\ContosoDemoData\AXR3DemoData

    - Logged in User is administrator.

    But still I am facing same error while Importing the data using following command.

    DP.exe IMPORT “C:\Users\dynamicsax2\Documents\ContosoDemoData\AXR3DemoData” MicrosoftDynamicsAx

    Error:

    Application: DP.exe
    Framework Version: v4.0.30319
    Description: The process was terminated due to an unhandled exception.
    Exception Info: System.NotSupportedException
    Stack:
    at System.Security.Util.StringExpressionSet.CanonicalizePath(System.String, Boolean)
    at System.Security.Util.StringExpressionSet.CreateListFromExpressions(System.String[], Boolean)
    at System.Security.Permissions.FileIOPermission.AddPathList(System.Security.Permissions.FileIOPermissionAccess, System.Security.AccessControl.AccessControlActions, System.String[], Boolean, Boolean, Boolean)
    at System.Security.Permissions.FileIOPermission.AddPathList(System.Security.Permissions.FileIOPermissionAccess, System.String[], Boolean, Boolean, Boolean)
    at System.Security.Permissions.FileIOPermission..ctor(System.Security.Permissions.FileIOPermissionAccess, System.String[], Boolean, Boolean)
    at System.IO.FileSystemEnumerableIterator`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..ctor(System.String, System.String, System.String, System.IO.SearchOption, System.IO.SearchResultHandler`1<System.__Canon>, Boolean)
    at System.IO.Directory.InternalGetFileDirectoryNames(System.String, System.String, System.String, Boolean, Boolean, System.IO.SearchOption, Boolean)
    at System.IO.Directory.InternalGetFiles(System.String, System.String, System.IO.SearchOption)
    at Microsoft.Dynamics.AX.Dataport.SqlHelper.GetDifferentialTableNames(Microsoft.Dynamics.AX.Dataport.DataportDatabase, System.String)
    at DP.Program.Execute(System.String, Microsoft.Dynamics.AX.Dataport.DataportDirection, System.String, System.String, System.String, Microsoft.Dynamics.AX.Dataport.DataportAction)
    at DP.Program.Main(System.String[])

    Also I tried to Export the Data using same tool

    DP.exe export “C:\test1” MicrosoftDynamicsAx

    While exporting, I am not getting error details in command window, but DPLog.xml file is filled with the same error.

    <?xml version="1.0" encoding="utf-8"?>
    <root>
    <item>
    <status>Failed</status>
    <message>System.NotSupportedException: The given path's format is not supported.
    at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath)
    at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath)
    at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
    at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
    at System.IO.Directory.InternalCreateDirectoryHelper(String path, Boolean checkHost)
    at Microsoft.Dynamics.AX.Dataport.BulkCopy.WriteOutFile(String serverName, SqlTableName table, String query, String folder) in e:\bt\110700\Source\DataPort\Dataport\Library\BulkCopy.cs:line 263
    at Microsoft.Dynamics.AX.Dataport.DataportQueryExtensions.WriteBulkCopyFiles(IDataportQuery query, String database, String server, String folder) in e:\bt\110700\Source\DataPort\Dataport\Model\DataportQuery.cs:line 94
    at Microsoft.Dynamics.AX.Dataport.DataportQueue.&lt;&gt;c__DisplayClass8.&lt;&gt;c__DisplayClassc.&lt;ProcessItem&gt;b__7() in e:\bt\110700\Source\DataPort\Dataport\Model\DataportQueue.cs:line 240
    at Microsoft.Dynamics.AX.Dataport.Functional.&lt;&gt;c__DisplayClass1.&lt;Retry&gt;b__0() in e:\bt\110700\Source\DataPort\Dataport\Library\Functional.cs:line 28
    at Microsoft.Dynamics.AX.Dataport.DataportQueue.&lt;&gt;c__DisplayClass8.&lt;ProcessItem&gt;b__6(Object state) in e:\bt\110700\Source\DataPort\Dataport\Model\DataportQueue.cs:line 260</message>
    <direction>Export</direction>
    <action>Overwrite</action>
    <database>MicrosoftDynamicsAX</database>
    <table>ACCOUNTANTLOGISTICSLOCATIONROLE_BR</table>
    <targetTable>ACCOUNTANTLOGISTICSLOCATIONROLE_BR</targetTable>
    <folder>“C:\test1”</folder>
    </item>

    I know I am doing something wrong, but could not find the solution in whole day. 

    Please advice me, how can I import data to AX, I shall thankful your advice.

    With Best Regards

    Kishore

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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