web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error Message: GPS Err...
Microsoft Dynamics GP (Archived)

Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

(0) ShareShare
ReportReport
Posted on by Community Member

Users have no issues logging into the production database however, they get the 3 errors above several times when logging into the test datqabase. We recopied live to test with no change.

 

Thanks!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

    Beat,

    We did follow the procedures and run the scripts. However, since the INTERID in the SY01500 table was incorrect for the test company, the INTERID script did not work properly. Once we corrected the INTERID in the table to the DB Name and reran the script, the issue was resolved. Have NO idea how the Interid was wrong but sometimes you've just gotta roll with it! :-)

    Thanks!

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

    Hi NOLA,

    Have you followed the procedure from the KB871973 ? this document explains in the detail how to take a copy of a production company and create a Test company db... there are several scripts that need to be run in order to make your Test company work properly... I've done this for years and never had any issues as long as you follow the proper procedure.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

    The INTERID script did not change it. We manually corrected the INTERID in SY01500 to the correct DB name, reran the INTERID script and logged in successfully. That also resolved a cannot create next note index error that they were getting in Integration Manager as it has to look up the note index on the SY01500 table also.

    Thanks for all of your help!

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

    That is very strange and I cannot say I have seen that before. If you run the Interid script does it get changed?

  • Community Member Profile Picture
    Community Member on at
    RE: Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

    Unfortunately they have restarted a few times since the error started a couple of months ago. Interesting thing we found. The INTERID is not the same as the Database name. It is actually equal to the company ID (2).  Is that possible? How would that happen?

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

    All of those are simply temp tables and Stored Procedures. Have you tried restarting the SQL instance?

  • Community Member Profile Picture
    Community Member on at
    RE: Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

    Interid was run and did not help. DexSQL.log:

    /*  Date: 06/04/2013  Time: 15:26:47

    stmt(21870480):*/

    {CALL GPTST.dbo.zDP_EXT43600F_1(NULL,NULL)}

    /*  Date: 06/04/2013  Time: 15:26:47

    stmt(21937800):*/

    {CALL GPTST.dbo.zDP_ReportPublishersF_1('sa',-32768,-32768,'','','sa',32767,32767,'þþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþ','þþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþþ')}

    /*  Date: 06/04/2013  Time: 15:26:49

    stmt(21956960):*/

    DROP PROC ##zDP_1682826S_1, ##zDP_1682826N_1, ##zDP_1682826F_1, ##zDP_1682826L_1, ##zDP_1682826S_2, ##zDP_1682826N_2, ##zDP_1682826F_2, ##zDP_1682826L_2, ##zDP_1682826S_3, ##zDP_1682826N_3, ##zDP_1682826F_3, ##zDP_1682826L_3, ##zDP_1682826SI, ##zDP_1682826SD

    /*  Date: 06/04/2013  Time: 15:26:49

    stmt(21956960):*/

    DROP PROC ##zDP_1682826S_1, ##zDP_1682826N_1, ##zDP_1682826F_1, ##zDP_1682826L_1, ##zDP_1682826S_2, ##zDP_1682826N_2, ##zDP_1682826F_2, ##zDP_1682826L_2, ##zDP_1682826S_3, ##zDP_1682826N_3, ##zDP_1682826F_3, ##zDP_1682826L_3, ##zDP_1682826SI, ##zDP_1682826SD

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826S_1', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826N_1', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826F_1', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826L_1', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826S_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826N_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826F_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826L_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826S_3', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826N_3', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826F_3', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826L_3', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826SI', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21956960):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_1682826SD', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(00000) Native Err:(3701) stmt(21956960):*/

    */

    /*

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(00000) Native Err:(3701) status(56):*/

    SWSTATUS DUMP*/

    /*  Date: 06/04/2013  Time: 15:26:49

    stmt(21956960):*/

    DROP TABLE ##1682826

    /*  Date: 06/04/2013  Time: 15:26:49

    stmt(21969336):*/

    DROP PROC ##zDP_0612926S_1, ##zDP_0612926N_1, ##zDP_0612926F_1, ##zDP_0612926L_1, ##zDP_0612926S_2, ##zDP_0612926UN_2, ##zDP_0612926N_2, ##zDP_0612926F_2, ##zDP_0612926L_2, ##zDP_0612926SI, ##zDP_0612926SD

    /*  Date: 06/04/2013  Time: 15:26:49

    stmt(21969336):*/

    DROP PROC ##zDP_0612926S_1, ##zDP_0612926N_1, ##zDP_0612926F_1, ##zDP_0612926L_1, ##zDP_0612926S_2, ##zDP_0612926UN_2, ##zDP_0612926N_2, ##zDP_0612926F_2, ##zDP_0612926L_2, ##zDP_0612926SI, ##zDP_0612926SD

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926S_1', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926N_1', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926F_1', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926L_1', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926S_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926UN_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926N_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926F_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926L_2', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926SI', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(S0002) Native Err:(3701) stmt(21969336):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the procedure '##zDP_0612926SD', because it does not exist or you do not have permission.*/

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(00000) Native Err:(3701) stmt(21969336):*/

    */

    /*

    /*  Date: 06/04/2013  Time: 15:26:49

    SQLSTATE:(00000) Native Err:(3701) status(56):*/

    SWSTATUS DUMP*/

    /*  Date: 06/04/2013  Time: 15:26:49

    stmt(21969336):*/

    DROP TABLE ##0612926

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: Error Message: GPS Error 58, SQL Error 102, ODBC Error 37000 test database only

    Did you run the script to update the Interid? Have you created a Dexsql.log?

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans