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 using Test Data ...
Microsoft Dynamics AX (Archived)

Error using Test Data Transfer Tool (BETA)

(0) ShareShare
ReportReport
Posted on by RobbanAx 175

Hi,

When running "Test Data Transfer Tool (BETA)" i get an error saying:

"A connection with the  Server="Servername"/INST3 cannot be established"

As you see from the error this is a SQL (2012) with more than one instance, and the command I am using is:

"dp.exe export D:\DTExport MicrosoftDynamicsAX "servername"/INST3"

I've tried running bcp and that seems to work fine. The user I'm loged in with is sysadm and dbo on DynamicsAX database.

I've also been able to run the tool successfully on both R2 and R3 contoso installations.

Anny suggestions on where to start investigating?

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,880 Most Valuable Professional on at

    Do you really have a server named "servername"/INST3. I doubt it - and it also can't be found.

    Didn't you intend to write something like dp.exe export "D:\DTExport MicrosoftDynamicsAX" servername INST3? (Assuming that servername is your database server and INST3 is your database.)

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Haven't tried it with instances yet, but the logic should be:

    dp export "d:\DTExport microsoftDynamicsAX" <databasename> <instancename>

  • SomuAx2012 Profile Picture
    SomuAx2012 1,235 on at

    Hi JAN-LUUC

    How did you resolve this issue?

    I am trying to import data using the following command

    dp.exe IMPORT "Datafolderpath" <databasename>

    I am getting the same error as you.

    "A connenction with the Server =XXXXX cannot be established. Please check the server is accessible".

    I am running this on the server where my AOS and client are installed. I have my database on different server.

    Please help

  • Martin Dráb Profile Picture
    Martin Dráb 237,880 Most Valuable Professional on at

    If you have the database on another server, you have to add a parameter with the server name, otherwise the tool is trying to find out the database on the current computer.

  • SomuAx2012 Profile Picture
    SomuAx2012 1,235 on at

    That is it. Thanks!

    Is there a place that I can check for the details of the errors during the import. It looks like every table is throwing error for me.

    I installed a fresh copy of R3 and trying to import contoso data.

  • Community Member Profile Picture
    Community Member on at

    I have the database on another server, the connection is working OK but it seems that it throws an error for every table (I can see on the database server the bulk insert statements).

    How can I get more information about the errors?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    I think error for every table means the bulk inserts cannot be seccessfully executed due to some reasons, for me it was the filesystem access from the sql server to the server where the dp.exe was executed. The sql server service account (network service) has not the rights to access the load files, the bulk insert looks something like:

    BULK INSERT [MicrosoftDynamicsAXR3]..[PDSREBATEPROGRAMTMATABLE] From '\\<DPSERVERNAME>\C$\Users\<username>\AppData\Local\Temp\2\vv33wb45' WITH (DATAFILETYPE = 'widechar', FIELDTERMINATOR = '#|EOC|#', ROWTERMINATOR = '#|EOR|#\n')

    Solution1: Change the service account of Sql Server to an account which has access to \\<DPSERVERNAME>\C$....."

    Solution 2: Run the dp.exe on the Server where the SQL Server is running (I assume that the dp.exe is doing nothing with the AOS)

    I hope this will help...

  • swoo Profile Picture
    swoo 5 on at

    Hi

    It needs to be -

    DP.exe Import/export "Filelocation" databasename servername\instance

    do not put server=servername\instance, it's all about the order of the parameters - command then file then database then server\instance.

    I suggest you run elevated cmd (as Administrator)

    Steve

  • Don Shields Profile Picture
    Don Shields 650 on at

    Thanks for the info here on the parameters.  The documentation fails to mention that.

  • Community Member Profile Picture
    Community Member on at

    Hello,

    I am getting the following error while transferring data into AX2012R3 CU10, my sql server is 2014.

    what could be the valid reason, please guide me.

    C:\DT>DP.EXE Import E:\DD\DynamicsAXR3DemoData MicrosoftDynamicsAX
    1. Import to Production is not Supported with this tool.
    2. The import action truncates data in the table before importing.
    3. Target Tables that are not present in the source, are not touched by the impo
    rt.Please remember to look at these tables and clean data if necessary. The list
    of these tables will be generated at the end of the Import
    Please choose an action:
    1. enter y/Y if you understand and agree to continue with Import.
    2. enter l/L to abort and open license terms.
    3.enter any key to abort
    y
    A connection with the Server=AX cannot be established. Please check the Server
    is accessible

    Unhandled Exception: System.InvalidOperationException: ExecuteReader requires an
    open and available Connection. The connection's current state is closed.
    at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean as
    ync)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
    ior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletio
    nSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehav
    ior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, S
    tring method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behav
    ior)
    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
    at Microsoft.Dynamics.AX.Dataport.Extensions.<ExecuteLater>d__10`1.MoveNext()
    in e:\bt\110700\Source\DataPort\Dataport\Library\Extensions.cs:line 230
    at Microsoft.Dynamics.AX.Dataport.SqlHelper.<GetAllDatabases>d__22.MoveNext()
    in e:\bt\110700\Source\DataPort\Dataport\Library\SqlHelper.cs:line 846
    at Microsoft.Dynamics.AX.Dataport.SqlHelper.<GetAllConnections>d__18.MoveNext
    () in e:\bt\110700\Source\DataPort\Dataport\Library\SqlHelper.cs:line 800
    at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
    at Microsoft.Dynamics.AX.Dataport.DataportApplication..ctor(String server) in
    e:\bt\110700\Source\DataPort\Dataport\Model\DataportApplication.cs:line 38
    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 108
    at DP.Program.Main(String[] args) in e:\bt\110700\Source\DataPort\DP\Program.
    cs:line 82

    Note - If a person do not have experience, please do not reply to my post.

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