dynamics nav connection manager

[sven.sta...@googlemail.com]

Hi,

 

I'm new to dynamics nav and I'm currently trying to establish a connection via the ssis to our dynamics server. Unfortunately I always get following error message:

 

TITLE: COZYROC SSIS+
------------------------------

The underlying connection was closed: An unexpected error occurred on a receive. (System)

------------------------------
ADDITIONAL INFORMATION:

Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. (System)

------------------------------

An established connection was aborted by the software in your host machine (System)

------------------------------
BUTTONS:

OK
------------------------------

 

I suspect I have not all needed privileges to make a connection to nav. Could you give me a example what I need to configure to establish a connection?

What I already tried is to use the same credentials as in management studio. In management studio I can connect me with my windows credentials but this throw always the error message from above when I try it in ssis.

Could it be I need to make some configuration in nav that I can connect me with your connection manager to nav? Please give me some advices, I run out of ideas.

 

Thanks in advance.

 

 

Regards,

 

 

[Ivan Peev]

Hi,

To connect to your server using COZYROC Dynamics NAV connection manager, you have to have the Dynamics NAV web services installed and enabled.

[sven.sta...@googlemail.com]

Thanks for your quick reply. Could you give me an easy understanding example what I have to enter in the settings of the connection manager? For example, how must the server address looks like, is it the same server what I'm using when I connect me to the sql server in management studio? Can I use the windows credentials or must I have special credentials what are set in nav? 

[Ivan Peev]

Hi,

The address is not the same. The address should be an address to the web services server. For credentials, yes you can use your Windows credentials.

[sven.sta...@googlemail.com]

Hi Ivan,

after a days of try outs I could set up a web service which can establish a connection to nav and so I could use the NAV connection manager to open a connection to the CRONUS test company.
Now I'm trying to migrate accounting data onto nav. I have set a web service page in nav and I can use this page in the dynamics nav destination dataflow element. The available destination columns in the column mapping tab looking exactly to what I have been searched as destination table so I'm pretty sure the web service page is correctly set up. Unfortunatley I get now an error message when I execute the package.

Error: 0xC002F304 at Data Flow Task 1, Dynamics NAV Destination [1]: An error occurred with the following error message: "The remote server returned an error: (500) Internal Server Error.".
Error: 0xC02090F9 at Data Flow Task 1, Dynamics NAV Destination [1]: The component "Dynamics NAV Destination" (1) was unable to process the data.

I have tried with a single row to migrate but the result was always the same. When I have looked on the nav server error log I got a more detailed message:

Type: Microsoft.Dynamics.Nav.Service.WebServices.ServiceBrokerException
Message: Method "CreateMultiple" is invalid!

I'm not sure why there is method "CreateMultiple", in the nav destination in ssis I have set as action "Create".

So I don't have a clue what I'm doing wrong. The column mapping looks good for me so I suspect perhaps something is not quite right with the web service pages.

Can you please give me an advise what could be the problem?

Thanks in advance


Kind regards,

Sven

[Ivan Peev]

Hi Sven,

What is the version of your Dynamics NAV server ? 

[sven.sta...@googlemail.com]

Hi Ivan,

it is Nav 2009 r2. I have investigated my problem in the meantime a bit and it seems I have to configure objects in Nav which can be then manipulated via web service.It seems the web service only allows to read this object at the moment and I'm now not quite sure where I can change this in Nav. Any ideas where I can do this? Can you give me perhaps an example how do you have tested the nav destination to import data? Maybe you can also give me a light what you have done in your nav environment before you imported the data. Technically the web service is up and running so I highly suspect I must change something directly in Nav.

Thanks in advance.

Kind regards,

Sven

[Ivan Peev]

Sven,

I would recommend you review your Dynamics NAV documentation how to configure to work with web services. We have followed the same documentation to do the setup.