255
I have GP 10, on several occasions companies have created and deleted without problems until recently.
Currently the GP utilities can not finish creating a new company, the process does not succeed. What could be failing?
*This post is locked for comments
Regards,
I ask apologies for not writing sooner, the truth I've had a lot of work and could not answer to leave the case closed.
I'm sorry to admit it, but after the last script I wrote in this forum everything worked fine. properly cleaned all the lines of old records companies and everything went very well. confused me a link that appeared at the end of the installation, complete the installation of the company and then enter without any problem.
Thank you very much for your support.
1000 thanks
Hi Eddy, do you need the configuration / migration tools? Can you not configure the new company yourself?
Can you log into the new company? Has the database for the new company been created in SQL?
Best regards,
Hello Ian,
I tell you that I have solved the problem partially. I will explain in greater detail. I am a new employee,
I had this problem the first day of work, but I used Microsoft GP for over 3 years and I understand very well the system.
I did the steps you indicated me this way:
Yes, I found records of earlier tables and delete them, I'm sure because check 2 times.
Yes, replace IDcompany and Name in the query, it worked
Yes, back up all my information including DYNAMICS
Yes, unfortunately, is the live environment
When I run the utilities only blinking screen appears and blank boxes but do not let me do anything.
I understand the latest service pack installed is SP4 but im not sure.
As I mentioned before I have partially solved the problem. I found a script (can not remember the name of the creator)
to clean any record of previous tables. I show you here:
*********************************************************************************************************************************************
/* ClearCompanys.sql - Script that will clear out all entrys in the DYNAMICS
database referencing databases that no longer exist on the SQL Server.
Requirements:
Company database you wish to have cleaned out of the tables in the DYNAMICS
database must be removed from the SQL server before running this script.
Ensure that all your databases have been restored or they will be erased
from the DYNAMICS database.
*/
set nocount on
/* Remove all references in the company master (SY01500) for databases that
Do not exist on the SQL Server */
delete DYNAMICS..SY01500 where INTERID not in
(select name from master..sysdatabases)
/* Clear out all tables in DYNAMICS database that have a CMPANYID field
that no longer matches any Company ID's in the SY01500 */
USE DYNAMICS
declare @CMPANYID char(150)
declare CMPANYID_Cleanup CURSOR for
select 'delete ' + o.name + ' where CMPANYID not in (0,-32767)'
+ ' and CMPANYID not in (select CMPANYID from DYNAMICS..SY01500)'
from sysobjects o, syscolumns c
where o.id = c.id
and o.type = 'U'
and c.name = 'CMPANYID'
and o.name <> 'SY01500' order by o.name
OPEN CMPANYID_Cleanup
FETCH NEXT from CMPANYID_Cleanup into @CMPANYID
while (@@FETCH_STATUS <>-1)
begin
exec (@CMPANYID)
FETCH NEXT from CMPANYID_Cleanup into @CMPANYID
end
DEALLOCATE CMPANYID_Cleanup
go
/* Clear out all tables in DYNAMICS database that have a companyID field
that no longer matches any Company ID's in the SY01500 */
USE DYNAMICS
declare @companyID char(150)
declare companyID_Cleanup CURSOR for
select 'delete ' + o.name + ' where companyID not in (0,-32767)'
+ ' and companyID not in (select CMPANYID from DYNAMICS..SY01500)'
from sysobjects o, syscolumns c
where o.id = c.id
and o.type = 'U'
and c.name = 'companyID'
and o.name <> 'SY01500'
set nocount on
OPEN companyID_Cleanup
FETCH NEXT from companyID_Cleanup into @companyID
while (@@FETCH_STATUS <>-1)
begin
exec (@companyID)
FETCH NEXT from companyID_Cleanup into @companyID
end
DEALLOCATE companyID_Cleanup
go
/* Clear out all tables in DYNAMICS database that have a db_name field
that no longer matches any company names (INTERID) in the SY01500 */
USE DYNAMICS
declare @db_name char(150)
declare db_name_Cleanup CURSOR for
select 'delete ' + o.name + ' where db_name <> ''DYNAMICS'' and db_name <> ''''
and db_name not in (select INTERID from DYNAMICS..SY01500)'
from sysobjects o, syscolumns c
where o.id = c.id
and o.type = 'U'
and c.name = 'db_name'
set nocount on
OPEN db_name_Cleanup
FETCH NEXT from db_name_Cleanup into @db_name
while (@@FETCH_STATUS <>-1)
begin
exec (@db_name)
FETCH NEXT from db_name_Cleanup into @db_name
end
DEALLOCATE db_name_Cleanup
GO
set nocount on
/* Clear out all tables in DYNAMICS database that have a dbname field
that no longer matches any company names (INTERID) in the SY01500 */
USE DYNAMICS
declare @dbname char(150)
declare dbname_Cleanup CURSOR for
select 'delete ' + o.name + ' where DBNAME <> ''DYNAMICS'' and DBNAME <> ''''
and DBNAME not in (select INTERID from DYNAMICS..SY01500)'
from sysobjects o, syscolumns c
where o.id = c.id
and o.type = 'U'
and c.name = 'DBNAME'
set nocount on
OPEN dbname_Cleanup
FETCH NEXT from dbname_Cleanup into @dbname
while (@@FETCH_STATUS <>-1)
begin
exec (@dbname)
FETCH NEXT from dbname_Cleanup into @dbname
end
DEALLOCATE dbname_Cleanup
GO
set nocount on
/* Remove all stranded references from the other Business Alerts table that
no longer exist in the SY40500 */
delete SY40502 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
delete SY40503 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
delete SY40504 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
delete SY40505 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
delete SY40506 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
GO
***********************************************************************************************************************************
After this, attempt to once again create a new company. The GP utilities works fine and the installation stars.
Everything go normally, and the process ends.
I see a window "Configuration Options Company"
shows 3 ways of working and link below to download it the configuration and migration assistants.
Apparently both assistants are not installed, so download them.
I have a server 2003, 64 bits, so I indicated that I should install Rapid_Tools_GP2010.exe because it is
the only one that works in 64 bits.
With Rapid_Tools_GP2010 now on my hard drive, starts to install and shows me an error that says:
The eConnect is not installed.
I searched several places but still do not understand what this is or where I can download it.
Can you help me understand this?
Will thank a lot ...
Hi Eddy, just to confirm - did you find a record that belonged to an old company that was previously deleted - ie - one you reckon shouldn't have been in the tables? Did you replace the Company ID and Name in the query above with the company ID and name of the old company? Did you back up all databases before you ran the query as suggested?
Is this the live enviornment? If not, a re-install might be an idea.
When you say Utilities is frozen...what happens when you try and launch Utilities?
Did you apply a service pack to GP lately?
Hi,
I did the steps suggested and if I had some records of old tables. Once i finish doing
the routine, attempt to make a company but the effect was the same and now I have frozen the
GP utilities. Shows the names of the companies old but appears with lock and the other
two not updated.
Should I uninstall and reinstall everything?
If you find an old company record that should not be there you can replace the company ID and Name in the query below and use this to clear out any references to the company. As always...take backups of Dynamics and all company databases before you try this out. This was posted by another 'Ian' on a Microsoft Forum.
use DYNAMICS
go
delete MC60100 where CMPANYID = -1
delete MC60200 where CMPANYID = -1
delete SY00801 where CMPANYID = -1
delete SY01500 where CMPANYID = -1
delete SY01900 where CMPANYID = -1
delete SY02000 where CMPANYID = -1
delete SY02100 where CMPANYID = -1
delete SY05200 where CMPANYID = -1
delete SY40500 where CMPANYID = -1
delete SY60100 where CMPANYID = -1
delete UPR10300 where CMPANYID = -1
delete UPR10304 where CMPANYID = -1
delete W200002 where CMPANYID = -1
delete DU000020 where companyID = -1
delete DU000030 where companyID = -1
delete DB_Upgrade where db_name = 'TWO'
delete SY40500 where CMPANYID =-1
delete SY40502 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
delete SY40503 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
delete SY40504 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
delete SY40505 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
delete SY40506 where BARULEID NOT IN (SELECT BARULEID FROM SY40500)
You could try deleting the company in SQL, and re-running the company set up. Let us know if it fails again. Check that your ODBC set up is correct - although I would think it is since the company attempts to create.
Have you deleted companies form SQL before - the set up could be trying to use an old company ID. As per Richard's post check throgh your SY05100 table for any references to old companies that no longer exist. There is a clean up query I came across somewhere that removes all references to old companies from GP. I'll see can I find it and post it here.
In addition to Ian's questions...
Look in the Sy001500 table in the Dynamcs DB. You should have ONLY one line for each currently created company. Make sure any extra lines for companies that have been deleted are removed. (make a backup first!!)
What is the highest CompanyID in the SY001500 table?
Are you creating the tables empty or by copying data from another db?
Hi Eddy,
I suppose the first things I would check are:
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (