Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration source XXX...
Microsoft Dynamics GP (Archived)

Integration source XXX with discriminator :DYNAMICS not found

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

So now that I've disabled AA reporting, MR 2012 CU11 HotFix2 is still not fully integrating, though it appears to work OK other that than. Every 5 minutes, I get a bunch of the errors below, along with "Failed: 0 record(s) have been written. 0 record(s) have been deleted. 14 record(s) have failed. 0 record(s) were filtered. Total runtime was 4 seconds." The runtime varies by a few seconds, but it's always 14 records failed every 5 minutes.

Not really expecting an answer to this here, but thought I'd share the experience in case I'm not only one dealing with it...

Integration source SQL1 with discriminator :DYNAMICS not found
    --- Exception Dump ---
    Caught Exception: [Microsoft.Dynamics.Integration.Service.Tasks.RecordException] Integration source SQL1 with discriminator :DYNAMICS not found
    Stack trace:


    Inner Exception: [System.InvalidOperationException] Integration source SQL1 with discriminator :DYNAMICS not found
    Stack trace:
   at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.ConfiguredIntegration.<>c__DisplayClass16.<GetIntegrationSourceId>b__15()
   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.Integration.Reporting.Adapter.CompanyProvider.WriteObject(Object value)
   at Microsoft.Dynamics.Integration.Service.Tasks.RecordWork.DoRecordWork(DbMap map, Object key, OperationType operationType, String loggingSourceName)


    Inner Exception: [System.NullReferenceException] Object reference not set to an instance of an object.
    Stack trace:
   at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.ConfiguredIntegration.<>c__DisplayClass16.<GetIntegrationSourceId>b__15()


    User: HQ\gpreportservice
    Machine: SQL1

*This post is locked for comments

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    This seems to happen every time I move the MR DB to a new server.  Perhaps Microsoft can update their documentation to include updating the field in ControlIntegrationSource when moving to a new server.

  • prs Profile Picture
    prs 800 on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    In my case I went to the controlIntegrationsource and it did have the :DYNAMICS but I was deploying to a different server the upgraded GP databases and the table under the name field was pointing to the old server for the GL databases. I changed this to the new server not sure if it is resolved yet though

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    I can also confirm that making the change from DYNAMICS to :DYNAMICS in the table solved the issue for me as well.  I had rebuilt my entire Management Reporter environment to avoid this issue using CU12.  I encountered this same issue AGAIN after having to rebuild the Datamart integration due to other non-related issues. Thanks so much!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    I can confirm that making this change solved the issue for me as well. Thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    Just to confirm what Volker Deuss was saying:

    I had this issue with Management Reporter and Dynamics GP when we went live but didn't experience it in our test environment.  I checked our test environment and confirmed the discriminator was :DYNAMICS.  Updating the Discriminator field in the ControlIntegrationSource in our production table from DYNAMICS to :DYNAMICS fixed the issue.

  • Volker Breitkopf Profile Picture
    Volker Breitkopf on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    The concatenation of both columns result in what I want to have in MR 2012 Configuration Console under "ERP Integrations":

    <ValueOfColumnName><ValueOfColumnDiscriminator> to <NameOfMyManagementReporterDatabaseServer> (ManagementReporterDM)

    Maybe that gives you a hint. As I said, in my case here (with AX) the Discriminator column contains a colon and the port of the application server's service that is talked to.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    So my 1 record has DYNAMICS in the discriminator column. Maybe I should change it to :DYNAMICS?

  • Suggested answer
    Volker Breitkopf Profile Picture
    Volker Breitkopf on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    Hey guys,

    Even though I'm integrating AX with MR (found this thread using web search) I might be able to tell you how to fix it. I was struggling with the discriminator error message, too. Actually Microsoft support did point out that there might be an incorrect entry in table ControlIntegrationSource in ManagementReporter database. In case of AX integration the three columns include an integer ID (in my case a 1 - there's only one record), the address of the AX application server and the port information including a colon.

    But as I said - that's an AX-related integration I'm dealing with.

    Do backups before playing around with that record. The server-side services need to be restarted after making changes. Good luck!

  • frozencanuck Profile Picture
    frozencanuck 155 on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    Tried to remove my post, since it seems my solution did not work.  Sorry.

  • dtolive Profile Picture
    dtolive on at
    RE: Integration source XXX with discriminator :DYNAMICS not found

    We are having the same issue  "Integration source xxx.xx.xx with discriminator :2713 not found"  and users are not being integrated after installing Hotfix 3.  Our integration is to Dynamics AX.  The hotfix states that if you are integration with GP or SL you have to disable integration before applying the Hotfix 3 but no mention of AX but apparently with AX it is the same issue.  is there a fix for this?

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans