Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / in creating company in...
Microsoft Dynamics GP (Archived)

in creating company in gp utilities

(0) ShareShare
ReportReport
Posted on by Rai 585

While creating new Microsoft Dynamics GP Company on " Create Company Information" error message is displayed "Dexterity Runtime has encountered a problem and needs to close. We are sorry for inconvenience"

thanks

-rai

*This post is locked for comments

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: Re: Re: Re: Re: in creating company in gp utilities

    hi,

    there seems a problem with your Dynamics database, maybe an old company was not properly deleted or was not succesfully created. 

    i got this script from my old files which surely i got from someone else too in the past. make sure you can restore your system in case there is problem in this script.

    /* ClearCompanys.sql - Script that will clear out all entries 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 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 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

     

     

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: in creating company in gp utilities

     Although this may sound unrelated. I have had the same issue some time back and I had to re-install .net Framework 2.0 and also dexterity shared components and it worked.

    However I do not  the reasoning behind the same.

    Hope this helps

    Cheers

    Paul

  • Rai Profile Picture
    Rai 585 on at
    Re: Re: Re: Re: in creating company in gp utilities

    its version 9 and i already uninstall and reinstal it a couple of time, I also try to install it in the different version but it has same result, there's a message appears

  • Rai Profile Picture
    Rai 585 on at
    Re: Re: in creating company in gp utilities

    yes, i can login in the gp but when I create another sample company in the utilities there's a error message appears

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: in creating company in gp utilities

    hi,

    have you login to GP without any issues from this client?

  • vsquared Profile Picture
    vsquared 105 on at
    Re: Re: Re: in creating company in gp utilities

    Are you on v10 or v9?  If you're on v10 try it from a different workstation.  You should be able to create a company from any client install as long as you log in as SA.  If you're on v9 reinstall the client.  It's a little overkill, but on a time sense, it's not difficult to do and it would eliminate an actual problem with the Dexterity common files.

  • Rai Profile Picture
    Rai 585 on at
    Re: Re: in creating company in gp utilities

    thanks, I try it both but still not working, the error message still appearing.

    -rai

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: in creating company in gp utilities
    Hi Rai,

    To my guess, this is an Account Framework Synchronization error. There are two
    steps that you can try:

    1. Open DEX.INI from the "Data" folder found in GP Installation Folder. (If GP version is 10.0. If the version is 9.0, then DEX.INI can be found directly
    on GP Installation Folder).
    2. Set the Switch "Synchronize=FALSE" to "Synchronize=TRUE".
    3. Run GP Utilities again.

    If above does not solve the issue:

    1. Keep the switch "Synchronize=TRUE" in DEX.INI file.
    2. Uninstall and reinstall GP on that particular machine and run the
    Utilities again.

    Hope that helps.

    Paul

     

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans