Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / your multicurrency reg...
Microsoft Dynamics GP (Archived)

your multicurrency registration status has changed

(0) ShareShare
ReportReport
Posted on by Jennifer Kaufman

I just ran through kb871973 to setup a test company with a copy of live company data.  All went fine except when I ran the sql script provided i did get these duplicate errors.  I'm not sure how to clear them up.

 

Msg 2627, Level 14, State 1, Line 1

Violation of PRIMARY KEY constraint 'PKSY04800'. Cannot insert duplicate key in object 'dbo.SY04800'.

The statement has been terminated.

Msg 2627, Level 14, State 1, Line 1

Violation of PRIMARY KEY constraint 'PKMC60100'. Cannot insert duplicate key in object 'dbo.MC60100'.

The statement has been terminated.

Msg 2627, Level 14, State 1, Line 1

Violation of PRIMARY KEY constraint 'PKMC60200'. Cannot insert duplicate key in object 'dbo.MC60200'.

The statement has been terminated.

Msg 2601, Level 14, State 1, Line 1

Cannot insert duplicate key row in object 'dbo.Spot_Work_FGInfo' with unique index 'DBFG_Idx'.

The statement has been terminated.

Msg 2601, Level 14, State 1, Line 1

Cannot insert duplicate key row in object 'dbo.Spot_Work_IXInfo' with unique index 'DBTBIX_Idx'.

The statement has been terminated.

Msg 2601, Level 14, State 1, Line 1

Cannot insert duplicate key row in object 'dbo.Spot_Work_TBInfo' with unique index 'DBTBInfoIX_Idx'.

The statement has been terminated.

Msg 2601, Level 14, State 1, Line 1

Cannot insert duplicate key row in object 'dbo.Spot_RefreshRates' with unique index 'IX_Spot_RefreshRates'.

The statement has been terminated.

Msg 2601, Level 14, State 1, Line 1

Cannot insert duplicate key row in object 'dbo.Spot_Work_DBInfo' with unique index 'DBNameIdx'.

The statement has been terminated.

 

Also, when I logon to the test company and try to open sales transaction I get this error:  your multicurrency registration status has changed.  Please check links on the multicurrency setup table. 

I ran checklinks on the multicurrency setup and that didn't help. I ran check links on sales setup and that found some multicurrency errors but that didn't fix it.  I reran on the multicurrency setup but no luck.  Also, we do have manufactoring installed if that makes a difference.

*This post is locked for comments

  • Andy Sather Profile Picture
    Andy Sather on at
    RE: your multicurrency registration status has changed

    Hello Paul - It looks like you have multiple records in the SY04800.  You should only have one record in this table.  Take a backup of Dynamics, Production, and Test databases in case of data loss.

    1. Run the following script to identify the records in the SY04800 table

    a. Select * from SY04800

    2. Here you should find two records with two separate CompanyID’s

    3. Run the following script to identify the correct CompanyID for the production company

    a. Select * from SY01500

    4. Once complete make a backup of the test company

    5. Remove the record that was not for the production company (in the SY04800)

    6. Once complete run the script from the KB again and it should be successful

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: your multicurrency registration status has changed

    Here is the KB article I believe since no one linked it yet.  In step 6 it says if you get any duplicate errors like I did you have to manually update them, but it Microsoft fashion it doesn't tell me how to do this, can anyone please provide assistance.  

    http://support.microsoft.com/kb/871973 

     Here is the error, the database opens I am the IT guy not a GP user so I dont know what issues this will cause. 

    Msg 2627, Level 14, State 1, Line 1

    Violation of PRIMARY KEY constraint 'PKSY04800'. Cannot insert duplicate key in object 'dbo.SY04800'. The duplicate key value is (9).

    The statement has been terminated.

     

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    Re: your multicurrency registration status has changed

    Jennifer & Tahir,

    There is a KB from Microsoft about the way to copy a live company in GP and made a TEST copy...

    There are some SQL scripts that needs to be executed after the TEST company was created/restored in SQL... : KB871973

  • Tahir Akram Profile Picture
    Tahir Akram 50 on at
    Re: your multicurrency registration status has changed

    I've the same question. How did you resolve this issue?

  • jrk7352 Profile Picture
    jrk7352 2,790 on at
    Re: your multicurrency registration status has changed

    I did resolve this.  I can't remember what I did.

  • Andy Sather Profile Picture
    Andy Sather on at
    Re: your multicurrency registration status has changed

    I was reviewing the Forums and see this one was not answered.  Did you still need assistance?

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans