Integration source XXX with discriminator :DYNAMICS not found

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (15)

Answers (0)

Community Member on at

Like (0)

Report

OK. Too many problems with this release. I'm reverting for now and we'll revisit updating when we're out of audit season. CU10 works...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is a known issue (3373819) with MR2012 CU11 HF2. It is set to be resolved in the HF3 release tentatively scheduled for later this week. It looks like you may have rolled back which should also correct the issue but for anyone else that reads this, a work-around is to disable to [CompanyProvider to Company] task using this script against the ManagementReporter SQL database:

update Scheduling.[Trigger] set IsEnabled = 0 where id in (select triggerid from Scheduling.Task where name like '%company')

Then, go to Security in Report Designer and confirm the non-Administrator users have the correct access rights.

Once released, HF3 will be available from the main MR download page. If you are considering upgrading now, this issue does not occur with the 2.1.11001.1 version of CU11 which is also available:

mbs.microsoft.com/.../MROverview

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

I've installed CU11 HF3 this morning and still getting the "Integration source XXX with discriminator :DYNAMICS not found" error. I've restarted the services, disabled and re-enabled the integration, even rebooted the server with no luck. Only thing that seems to work is to disable the CompanyProvider to Company trigger as outlined by a previous post but doesn't that disable some of the DM integration from occurring?

I've also noticed after HF3 installation that only the Report Designer was updated to ver. 2.1.11002.11 while Report Viewer and the Configuration Console both remained at ver. 2.1.11002.5. Is this expected behavior? I've installed both the HF3 x64 client and server components and received no errors. Windows Programs and Features shows todays installations as versions 2.1.11002 only for both client and server components.

Should I completely delete our data mart and attempt the integration from scratch? Any help would be appreciated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am in the same boat as jarekf. I also tried CU11 HF3 and still get the error. I also see that the version numbers do not change in the server and client software after HF3 is applied. Reverting back to CU10 as it works for now.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

The only way I have found so far that works every time, is to remove, uninstall and re-build the entire management reporter database. Steps I took are below.

1. Start by exporting the building blocks and ALL settings for ALL companies (make sure you have everything backed up first).

2. Disable the integration to the data mart, then remove the datamart.

3. Stop the process and application services and then delete the data mart and management reporter databases.

4. I also uninstalled both the server and client manager reporter software and re-installed MR again using HF2 as a base and then upgraded to HF3 after first Datamart sync. Reboot the server as you see fit. I rebooted after removing everything and before the software re-install.

5. Then re-install the managemen reporter software (HF2 version), follow the wizards to setup process and application services along with the datamart.

6. WAIT for the first succsssful sync of the datamart.

7. Upgrade to MR HF3 version.

8. Then re-build / Import building blocks and settings into the management reporter database from scratch.

9. The datamart rebuilds itself during the wizard process.

Print reports and verify they are ok. Hooray, your done and no more errors in the MR logs!

Enjoy....

Was this reply helpful? Yes No
dtolive on at

Like (0)

Report

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?

Was this reply helpful? Yes No
frozencanuck 157 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Volker Breitkopf on at

Like (2)

Report

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!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Volker Breitkopf on at

Like (0)

Report

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.

Was this reply helpful? Yes No