SBX - Search With Button

SBX - Forum Post Title

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

Microsoft Dynamics GP Forum

Barb M asked a question on 26 Sep 2012 9:19 AM
My Badges

Question Status

Suggested Answer

https://community.dynamics.com/product/gp/f/32/p/54170/97625.aspx#97625

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.

 

Reply
Mohammad Daoud responded on 27 Sep 2012 11:41 PM
My Badges
Suggested Answer

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.

Reply
Barb M responded on 28 Sep 2012 6:08 AM
My Badges

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?

Reply
Barb M responded on 1 Oct 2012 2:17 PM
My Badges

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.

Reply
Trevor Zimwara responded on 11 Feb 2016 6:16 AM

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.

Reply
Mohammad Daoud responded on 27 Sep 2012 11:41 PM
My Badges
Suggested Answer

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.

Reply

SBX - Two Col Forum

SBX - Migrated JS