Management Reporter (MR) Error #3660431 After Starting the DataMart Integration

Posted by David Gigear, Senior Consultant on November 1, 2016


Error 3660431 – “Sequence contains no elements”

I’ve seen this error happen a couple times now with both MR2012 CU13 and most recently, with CU15.  The error occurs after starting the DataMart Integration.  So, always make sure to go check the log after you start the DataMart integration.

If you see the error 3669431 – “Sequence contains no elements”, follow the steps to update the correct values in the ControlCompanyIntegration table in the Management Reporter (MR) database.

How to fix the MR error:

Step 1:  Find the Source ID

Look for ID  where the Discriminator = ':DYNAMICS'

select * from Reporting.ControlIntegrationSource
where Discriminator = ':DYNAMICS'

Step 2:  Find the ID

select * from reporting.ControlCompany

Step 3:  Insert ID and Source ID into the table reporting.ControlCompanyIntegration

select * from reporting.ControlCompanyIntegration

Here is a sample insert statement:

insert into reporting.ControlCompanyIntegration (ID,SourceID)
(select a.ID,b.ID
from reporting.ControlCompany a
cross join  Reporting.ControlIntegrationSource b
where b.Discriminator = ':DYNAMICS')

Now start the DataMart integration again and check the log file.  If no error, you're good to go. 

If you're still receiving the MR error, send us an email at Support@Crestwood.com and our team of experts can help.


Share this:
 
 

Comments:

Add your comment: