Skip to content
+1-888-319-3663

COMMUNITY FORUM

SmartConnect Activity is hung

Delano asked 3 years ago
I have a scheduled map which is pulling data from salesforce and pushing them to GP. It has been running generally fine for over 3 years. In the last few months the job constantly (every day) stops because an Activity is hang up.
I can’t find anything on the logs. I don’t know what to look for and the issue is becoming worst every passing day, disrupting our order processing.
Any suggestion would be appreciated.
Jim replied 3 years ago

Did you ever get a solution for this? We are running into the same thing on SC 20.18.0.34. Scheduled maps were running fine under 20.18.0.9.

Answers
Delano answered 3 years ago
No solution. No one ever replied to this question. I’ve been fighting with this stupid thing for months now and the worst is that I can’t figure what’s causing it.   
Jim replied 3 years ago

Thanks for the update. I’m going to open a support case with them. Will let you know if there is a resolution.

Jim replied 3 years ago

Update – still don’t have an answer for why things are getting stuck in the activity table, but someone pointed me to this writeup about using sql to handle the scheduling on maps. We put this in place and have had no problems for the past 2 weeks. Note that SmartConnect needs to be installed on the server where the SQL job is run.

https://www.eonesolutions.com/tech-tuesday-executing-smartconnect-maps-from-sql/

Ethan Sorenson Staff answered 3 years ago
SmartConnects can get stuck in the Activity log if the map is ‘orphaned’ by the scheduler. There are a number of environmental factors that can cause it. 
 
If you are unable to resolve the issue by restarting the SmartConnect Windows Service, I recommend reaching out to our support team.
support@eonesolutions.com

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