Solved

GoldSync Problem

Posted on 2010-08-18
10
1,642 Views
Last Modified: 2013-11-24
We are using the email feature of GoldSync to keep our remote users up to date. For some reason the Syncs are now failing. Goldmine version 6.5

Session Logs
*Processing Site: 11053*** - TEXAS SERVER
*Creating transfer set for all contacts since 8/7/2010 - 7:32 am
*Creating transfer files for GMBase tables...
*LookUp created: 1records (1 updates).
*Cal created: 27 records (101 updates).
*UserLog created: 47 records (169 updates).
*SysLog created: 6 records (588 updates).
*Transfer set: TSAA0441.gts compressed successfully.
*Sending transfer set to 'user@domain.com'.
!![77] Unable to send transfer set to 'user@domain.com: Retrieval failed: Socket Error Connection refused | System error 10061.'.
* Session Logs [Ended 10:00am - 8/18/2010; Dur: 0:03]

We have Exchange internally. For testing purposes, I setup to the emails through an external SMTP server. Same errors.

I am not fluent in the world of Goldmine so please let me know if you need any more information.

Thanks in advance.  
0
Comment
Question by:simplemojo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +1
10 Comments
 
LVL 28

Expert Comment

by:sunnyc7
ID: 33465420
What version of Exchange server ?
0
 

Author Comment

by:simplemojo
ID: 33465551
Exchange 2003 SP2
0
 
LVL 28

Expert Comment

by:sunnyc7
ID: 33466269
I am going to take a stab at it even though I am not a goldmine expert.

a) Can you increase the timeout value
Edit | Preferences | Sync then click the advanced button

From here
http://support.frontrange.com/support/GMSM/GoldSync/GoldSync_Resolutions_Tips2.htm

Also for your error >System error 10061
They recommend
Winsock error 10061 indicates problems connecting to a TCP/IP host. This usually results from trying to connect to a service that is inactive on the host. Verify that the configuration setting from the GoldSync server is set up properly. It is not a bad idea to telnet the Goldsync server as well. Another alternative would be to have another system on the network serve as a temporary GoldSync server then retry the synchronization process.

--
Another option would be
> Delete the GoldSync Server in the GoldSync Administrator, and then Rebuild your tables if in dBase.

Check the last posts here
http://forums.frontrange.com/viewtopic.php?printertopic=1&t=32893&start=0&postdays=0&postorder=asc&vote=viewresult&sid=df5eb70c95720ed3754e6ad86c6ec4d1

More Ref:
http://www.thegmblog.com/misc/

Paid support
http://www.djhunt.us/
0
Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

 
LVL 11

Expert Comment

by:stevengraff
ID: 33466454
10061 means failure to connect to the GoldSync server.

It sounds like your computer can't properly "see" the smtp connection.

0
 

Author Comment

by:simplemojo
ID: 33468336
@sunnyc7
>Can you increase the timeout value?
Already increased the value. No luck.

> Delete the GoldSync Server in the GoldSync Administrator, and then Rebuild your tables if in dBase.
Tried several times with no luck. Still get the 10061 error while sending.

>Check the last posts here
This info pertains to the TCP/IP version of the GoldSync. If I am unable to get it running via email withing a reasonable amount of time I may go this way.

@stevengraff
That is what I thought. I have tried multiple SMTP servers and checked our Relay options. Everything appears to be ok.  

I find it strange that I am able to sync via email if I use the Synchronization Wizard (profiles). That is able to email the updated files to my remote users, but its not automated. I will keep on it an post my findings. Thanks for all your help and ideas.
0
 
LVL 11

Expert Comment

by:stevengraff
ID: 33468685
** I am able to sync via email if I use the Synchronization Wizard **

Oh -- you mean it's failing with one-button sync? The entire sync process is "masked" when using one-button sync. The only way you can update the sync profile for one-button is through GoldSync, on the server. You'll have to e-mail the resultant new profile to the user in order to fix that. I think the one-button sync profile probably has the wrong smtp server in it.
0
 

Author Comment

by:simplemojo
ID: 33469327
We are not using the one button sync. When I click Create An Install File For One-Button Sync, I receive an error. (Active Delivery Files Are Missing)

We are configured to send via email only. To avoid any confusion, I have attached a picture.

Look out for my crazy good paint skills!

Error reads - ![77] Unable to send transfer set to 'user@domain.com: Retrieval failed: Socket Error Connection refused | System error 10061.'.


Goldmine.jpg
0
 
LVL 12

Accepted Solution

by:
GMGenius earned 500 total points
ID: 33469480
Connection refused tells me that the user that the sync process is setup to use cannot send email.
I suggest you login to goldmine as the GoldSync user and test your sending email and ensure your email credentials are setup correctly.
That said, I strongly recommend AGAINST using sync with email. If any emails go missing / blocked / deleted in error then you will be missing a chunk of data.
You should always use Direct TCP method as this will ensure you dont loose data.
 
0
 

Author Comment

by:simplemojo
ID: 33469665
I was under the impression that the direct TCP method required the remote users to have fixed IP address. Our guys travel the country, so static is not an option. Thanks for your advice.

I will leave this case open until I figure out a decent solution.
0
 
LVL 12

Expert Comment

by:GMGenius
ID: 33469703
No, the remote would connect to the server, not the other way around
If your server does not have a fixed IP you can always look at dynamic IP (2mydns.com or similar)
You configure the server to listen (open Port 5993 on your router to port forward to the GoldSync server) then you remotes initiate the sync process by clicking on the sync button
0

Featured Post

Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question