Dynamics Community Forum Thread Details

New GP Company

In an attempt to add a new company for a client we are running into the following error. Previous to this we were able to successfully add a test company on the same server just a few days prior. Nothing has changed on the server that we are aware of. The Database is created successfully but the GP portion fails.

The following SQL statement produced an error:

if exists (select * from sysobjects where id = object_id('dbo.GPS_CHAR') and sysstat & 0xf = 6) drop default dbo.GPS_CHAR

ERROR [Microsoft][SQL Server Native Client 11.0][SQL Server]The default 'dbo.GPS_CHAR' cannot be dropped because it is bound to one or more column.

Any ideas on what would cause this? I have deleted the DB, ran clear companies script, re-ran utilities to create the company again while enabling the DEX log but no additional information was provided.

We see this more on upgrades of the GP databases then we do creating a new company database.

Normally this 'GPS_CHAR' error message you're seeing is caused because GP Utilities is attempting to install the defaults for each data type, but in this company database, the defaults already exist so the above error is given.

Troubleshooting would be pretty much what you have mentioned already doing: deleting this new company database from SQL, running the ClearCompanies script and trying again.

The only other thing I'd mention is making sure DYNSA is the db owner of the GP system database, which you can verify by running this script:

sp_helpdb

One thing you can try is the following:

1. On one of the machines where you have Dynamics GP installed, rename the GP directory from something like this >> C:\Program Files(x86)\Microsoft Dynamics\GP\ to be something like this >> C:\Program Files(x86)\Microsoft Dynamics\GP_OLD\

2. In Control Panel > Programs > Programs and Features, right-click on this instance of Microsoft Dynamics GP and click ‘Change’.

3. In the options window that opens, choose the ‘Repair’ option and verify the process runs successfully. This will re-create the entire Dynamics GP directory, to include all files and folders, under the original directory name that we just changed.

4. Launch Dynamics GP Utilities from this ‘new’ GP directory after deleting the company, running ClearCompanies and verifying DYNSA is the db owner of the GP system database and then try to create the new company database again.

If it still fails, I'd maybe try installing GP on another machine and trying, if not on the SQL Server, otherwise open a support case so we can look at it further with you.

Thanks

Quick Links

Leaderboard