Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / MR 2012 RU5 Latest Hot...
Microsoft Dynamics GP (Archived)

MR 2012 RU5 Latest Hot Fix breaks GP Legacy Option

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730

After trying to apply the latest hot fix to MR 2012 RU5 I can now longer configure the GP Legacy Option. In the log file in this. What must I do to enable the GP Legacy option?

System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_IntegrationSourceID'. Cannot insert duplicate key in object 'dbo.ControlConfiguredIntegration'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ConfiguredIntegrationsDataSetTableAdapters.ConfiguredIntegrationTableAdapter.Insert(String SourceName, String SourceDiscriminator, Nullable`1 GLEntityID, String GLEntityConnectionInformation) at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.ConfiguredIntegration.<>c__DisplayClassd.b__c() at Microsoft.Dynamics.Performance.Reporting.DataAccess.DataExecution`1.Execute[T](Func`1 transact, Func`1 connect, Func`1 execute, Boolean retry) at Microsoft.Dynamics.Performance.Reporting.DataAccess.DataExecution`1.Execute[T](Func`1 connect, Func`1 execute) at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.CompanyService.<>c__DisplayClass2c.b__2b() at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.<>c__DisplayClass1f.b__1e() at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor) at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor) Component: Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.CompanyService

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: MR 2012 RU5 Latest Hot Fix breaks GP Legacy Option

    Please disregard previous post. I posted to the wrong question.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: MR 2012 RU5 Latest Hot Fix breaks GP Legacy Option

    By the way, there is no SYUPDATE table in the DYNAMICS database and the DU000010, DU000020 and DU300000 have almost no records in them and their structure is different. There is no PRODID column  in the DB_Upgrade table. So I have another 11.00.1524 GP instance, can I change the structure of these tables and populate the records with what is necessary or should I open a support case with MS to make sure I correct all the tables with the proper values. It appears that this happened when they went from SBM 8 to GP 8.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: MR 2012 RU5 Latest Hot Fix breaks GP Legacy Option

    Ryan, it sounds like when applying a hot fix to MR there is no reason to deply the Legacy GP option again.That would explain why MR appears to be working just fine. I will check but I bet the GP Legacy option already exists. I was a bit confused because with this hot fix you have to unistall MR and then run the hot fix so I just started going through the normal installation procedure. It would be easier if you could just apply the hot fix and it would upgreade whatever it finds just like every other piece of software.

  • Verified answer
    Ryan Sandness Profile Picture
    Ryan Sandness on at
    RE: MR 2012 RU5 Latest Hot Fix breaks GP Legacy Option

    Hi Richard,

    I took a look and could not reproduce this at first. I looked into it a bit more and it looks like this occurs if you already have a legacy integration configured, and then add the same integration a second time.

    So either the integration exists and it isn't appearing in the Configuration Console or you are encountering an incorrect duplicate error.

    Are you getting any errors in the Configuration Console that integrations can't be displayed or is the legacy integration already present? I'd start by looking in those areas.

    Thanks

    Ryan

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