Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

management reporter 2012 import company error

Posted on by 620

I have upgraded my MR installation to MR 2012. I have added my GP server to 'ERP Integrations'. WHen I click on Import and enter my GP User and password, I receive and error that states "An error has occurred retreiving company information. Verify that the specified credentials are valid. Check the deployment log for details."

I reentered my GP credentials correctly. I checked the deployment log and see the below:

 

4/3/2012 3:49:51 PM - An error occurred while importing companies from a company import adapter. Additional information: System.InvalidOperationException: There is an error in XML document (0, 0). ---> System.Xml.XmlException: Root element is missing.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlTextReader.Read()
   at System.Xml.XmlReader.MoveToContent()
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderEntitySettingCollection.Read3_ArrayOfEntitySetting()
   --- End of inner exception stack trace ---
   at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
   at System.Xml.Serialization.XmlSerializer.Deserialize(TextReader textReader)
   at Microsoft.Dynamics.Performance.DataProvider.Core.EntitySettingCollection.Deserialize(String xmlDocument)
   at Microsoft.Dynamics.Performance.Deployment.CompanyImport.CompanyImport.CompanyImportViewModel.<ConvertToExistingCompanies>b__7(CompanyRow x)
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   at Microsoft.Dynamics.Performance.Deployment.CompanyImport.CompanyImport.CompanyImportViewModel.ConvertToExistingCompanies(CompanyDataTable companyDataTable)
   at Microsoft.Dynamics.Performance.Deployment.CompanyImport.CompanyImport.CompanyImportViewModel.<BeginImport>b__0()

*This post is locked for comments

  • Ryan Connolly Profile Picture
    Ryan Connolly 620 on at
    Re: management reporter 2012 import company error

    Thanks so Much Cory, that was the problem. There was a company that is no longer used in that table. Once I deleted from Table, company import was successful.

    Ryan

  • Verified answer
    Cory Severson Profile Picture
    Cory Severson 695 on at
    Re: management reporter 2012 import company error

    Hello Ryan,

    I've seen this one and it is caused by a problem most likely from a prior migration.  The ControlCompany table has a column called GLEntityConnectionInformation.  This needs to be filled in for every company before the import will work.  You will want to run update to get that set or delete the companies that are blank, usually the FW and FWC companies.

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