Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

eConnect Failed to convert parameter value from a String to a Date/Time

Posted on by 1,540

community.dynamics.com/.../97625.aspx

I am also having this error.  The problem is, this integration works fine from user workstations, but we get the error when trying to run the integration in GP2010 on terminal server.

When I remotely connect to the Terminal Server, I can see the date/time format is the same as on my workstation (m/dd/yy).  Yet, I get the error on TS.

The user logs into TS using an rdp file and also gets this error.

Seeing as it works on my workstation, it is not a problem with the data source.

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: eConnect Failed to convert parameter value from a String to a Date/Time

    I had a similar error using smartConnect a third party tool which was built around the econnect framework. I solved it by making sure that the date formats were the same and the integration ran smoothly. Thanks to this discussion it helped me get my stuff working.

  • Accounting Department Profile Picture
    Accounting Department 1,540 on at
    Re: eConnect Failed to convert parameter value from a String to a Date/Time

    Sorry I misread your reply - I thought I had to change the date format for the user running the Integration.

    This time I logged in as the user that was configured to run eConnect when eConnect was installed... I changed the regional settings and restarted the service.

    I logged back in as the user running the Integration and it ran successfully for me and another user.

  • Accounting Department Profile Picture
    Accounting Department 1,540 on at
    Re: eConnect Failed to convert parameter value from a String to a Date/Time

    I have logged into the TS remotely as myself and tried running the integration.  I also get the error, yet it works from my local client. I made sure they both had the same Regional Settings and Date settings.

    The data source is a View I created in the GP database.  I even tried using Convert(date,[DOCDATE) instead of just the DOCDATE.  Is there another conversion I should be trying?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: eConnect Failed to convert parameter value from a String to a Date/Time

    Have you logged in to the TS server using the user who runs the eConnect and configured the date format? Setting the date format for the logged in user is not enough.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans