Connecting to external server takes very long

Question

Hello, 
 I've created an application for Sage 50 using the SDK and I'm having a bit of an issue connecting to our company on a server. If I start a Peachtree session with a local company I created on my machine it works great but when I start a session with our company on the server it takes almost 10 minutes for the initial connection to complete. The same issue occurs when I use the sample code provided by the SDK to connect to our server. Is it normal for a Peachtree session to take this long to start? 
 Thanks, 
 Chris

Chris Krozel · Accepted Answer

I wanted to mention that I did solve this issue after I found out that a CompanyIdentifier has a DatabaseName in it. I was not able to find the database name another way so not sure if there is an easier way. 
 But if anyone else is having an issue with a slow connection to their database and you don't know the database name, my solution was to use the CompanyList call as explained above then output the database names to console. Once I figured out the database name I was able to use LookupCompanyIdentifier which decreased connection time significantly.

fuerstma · Answer

Hey Chris, 
 
 One thing to check... are you doing a ListAccounts() call in the PeachCommunication class? Some portions of our integration make that call, and we had some customers that had absolutely terrible performance (10+ minutes of wait). What had happened at these customers sites was that there was some Sage/Peach bug where one company profile/account had been duplicated literally a thousand times. So looping over the accounts was just absolutely brutal performance wise. Check your returns from that call or output the contents of the list to see what's going on. (The fine folks at Sage wrote a little utility that our mutual customer ran which cleaned up all the duplicate accounts. Worked like a charm.)

SoumenS · Answer

Hi Chris, I agree with the suggestions by 'fuerstma'. If these do not resolve the issue, we can investigate further from the Sage support side. But we require a subscription to our Developer Partner Program so we can open a support ticket and escalate the issue to the R&D team if necessary. If you are interested, please send your contact details to SDK.50US@sage.com and we will start the application process. Thanks!

Sage 50 US

Connecting to external server takes very long

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING