+1-888-319-3663

COMMUNITY FORUM

Error running SmartList – The remote server returned an error 404 Not Found

Kevin Collins asked 6 years ago

I am attempting to use SmartList as a data source. In SmartList, I execute the SmartConnect – Create/Update list and the message returns that the list was successfully created. I create the Map specifying a SmartList Data Source. I select the SmartList favorite and build my destination. When I go back to the SmartList in GP and select Additional -> SmartConnect Run, it allows me to select my map. When I click Run, I get the dialog that asks if I am sure I want to run the Map, I select yes and the following error message is returned.Error running SmartList The remote server returned an error: (404) Not Found. Feels like I missed something in the configuration of SmartConnect but I am not sure where. Any ideas? Thanks,Kevin

Answers

0 Vote Up Vote Down

Patrick Roth Staff answered 6 years ago

I would suspect that in SmartConnect in the MS GP Connector Setup window, for the Real time and SmrtList web service URL, you have that empty.
Or possibly you have it set to “localhost” instead of your actual server name. And then when you run it from GP (on a machine that isn’t the web server) you would get that message since IIS probably isn’t installed and even if it was that isn’t where the eOne SmartConnect Web Services are installed to.
After you change it in SC, you can verify this in the DYNAMICS db by running the query:
Select URL from SC9101
this is where the GP addin finds the url & credentials of the web service user to use to call to the web service.
patrick

Kevin Collins replied 6 years ago

Thanks Patrick…The URL has been specified in the GP Connector Setup window…it is using localhost, but IIS, SQL, and Dynamics GP all reside on the same box…The URL successfully validates. I’m seeing the following in the IIS event logs:
#Software: Microsoft Internet Information Services 8.5
#Version: 1.0
#Date: 2017-03-08 19:39:28
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) cs(Referer) sc-status sc-substatus sc-win32-status time-taken
2017-03-08 19:39:28 ::1 GET /SmartConnect.svc – 5557 – ::1 Mozilla/5.0+(Windows+NT+6.3;+WOW64;+Trident/7.0;+rv:11.0)+like+Gecko – 307 0 0 484
2017-03-08 19:39:28 ::1 GET /SmartConnect.svc/ – 5557 – ::1 Mozilla/5.0+(Windows+NT+6.3;+WOW64;+Trident/7.0;+rv:11.0)+like+Gecko – 200 0 0 0
2017-03-08 19:41:00 ::1 POST /SmartConnect.svc/runmapdatatable/all/1 – 5557 – ::1 – – 404 0 0 0

Does this provide any assistance with the troubleshooting? Thanks, Kevin

If you would like to submit an answer or comment, please sign in to the eOne portal.