Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Dynamics GP Slow Login - smBindTableDefaults stored proc

Posted on by 65

Hi all, 

We're currently doing a GP10 to GP2015R2 upgrade at work and are seeing issues with performance after logging in and picking a company. The screen can go white for a good part of a minute and then finally come back to life with GP. 

I ran SQL Profiler and stuck on debugging and have pinpointed the following in the DEXSQL.LOG file. Notice how the time jumps about 50 seconds before continuing. 

Could someone please explain what smBindTableDefaults does and if there is a reason why this would take so long? Is this a red herring? 

/* Date: 03/12/2016 Time: 16:08:45
stmt(173440872):*/
BEGIN DECLARE @stored_proc_name char(28) DECLARE @retstat int DECLARE @param2 int set nocount on SELECT @stored_proc_name = 'MyCo.dbo.smBindTableDefaults' EXEC @retstat = @stored_proc_name 0, @param2 OUT SELECT @retstat, @param2 set nocount on END
/*
/* Date: 03/12/2016 Time: 16:09:35
SQLSTATE:(01000) Native Err:(5701) stmt(0):*/
[Microsoft][SQL Server Native Client 11.0][SQL Server]Changed database context to 'master'.*/

Many thanks

Graeme

*This post is locked for comments

  • Verified answer
    Graeme Profile Picture
    Graeme 65 on at
    RE: Dynamics GP Slow Login - smBindTableDefaults stored proc

    Update: Looks like it's one of the 3rd party bits of code. Removed from the SET file and GP now loads consistently within about 20 seconds. Possible some code has been left in their chunk which shouldn't have been. Main thing is it's not GP to blame and it should be fixable. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans