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
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!
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.
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!
That is very strange and I cannot say I have seen that before. If you run the Interid script does it get changed?
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?
All of those are simply temp tables and Stored Procedures. Have you tried restarting the SQL instance?
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
Did you run the script to update the Interid? Have you created a Dexsql.log?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (