Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Unable to import an organization in CRM 4.0 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    This is day number 9 of my CRM import

    I started with CRM 4.0 Workgroup Edition, found out that I cannot "upgrade", found a great support KB to tell me what to do ( <http://support.microsoft.com/kb/947272> ).  I am getting further and further in the import.  I am stuck here.  Here is what I believe to be the facts.

    My original install was CRM 4.0, with rollup 5 and 9.  I don't believe I put 7 in b/c I did not understand that 7 was not included in rollup 9.  I have have uninstalled and reinstalled my crm software several several times.  I think this is how I have it now.  CRM DVD download from partnernet with Rollup 9 on it.  I have NOT been deleting the program files directory or the registry entries.  That is my next step if I don't get anywhere here.

    I found this support KB (http://support.microsoft.com/default.aspx/kb/977867?p=1) and it took my 6 hour installation down to about 3 minutes and makes it further in the installation, before it was timing out, now I have an issues with invalidcastexception.  Here is the error from the log with the portion before it... there is a lot more before it, if you need that let me know.

     23:40:35|   Info| Database version: 4.0.7333.2644.
    23:40:35|   Info| Check OrganizationDatabaseVersionValidator: Success
    23:40:35|Verbose| BaseGroup.Validate completed
    23:40:35|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    23:40:35|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    23:40:35|Verbose| After context key substitutions RunModes
    23:40:35|Verbose| After env var substitutions RunModes
    23:40:35|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    23:40:35|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    23:40:35|Verbose| After context key substitutions DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update
    23:40:35|Verbose| After env var substitutions DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update
    23:40:35|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessSubstitutions
    23:40:35|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate Microsoft SQL Server Reporting Services
    23:40:35|Verbose| Calling BaseGroup.Validate
    23:40:35|   Info| Check ReportingUrlValidator: Success
    23:40:39|   Info| Check ExistingRSValidator: Success
    23:40:39|Verbose| BaseGroup.Validate completed
    23:40:39|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunSnifferValidate
    23:40:39|Verbose| Validation ran.
    23:40:39|Verbose| Validation completed.
    23:40:39|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
    23:40:39|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
    23:40:39|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    23:40:39|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    23:40:43|   Info| Import Organization (TomorrowsTechnologyToday)
    23:40:43|   Info| Update Organization...
    23:40:44|  Error| Import Organization (Name=TomorrowsTechnologyToday, Id=7894e129-9c4a-df11-a468-001b212ec37d) failed with Exception:
    System.InvalidCastException: Specified cast is not valid.
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Import(Guid organizationId, String organizationUniqueName, String organizationFriendlyName, String sqlServerName, String databaseName, Uri reportServerUrl, String privilegedUserGroupName, String sqlAccessGroupName, String userGroupName, String reportingGroupName, String privilegedReportingGroupName, ICollection`1 users, MultipleTenancy multipleTenancy)
    23:40:44|Warning| Attempting to cancel a long running process: ProgressWizard. This might leave the data in an invalid state and the application might not function correctly.

    I have searched for that invalidcastexception, but no luck there.  I have one customization that I don't believe is in place, it links my MS Accounting to my CRM, everything else in my CRM is generic.

    Any advice would be GREATLY appreciated!!!  I just need my CRM back.

    Sunday, April 18, 2010 4:12 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Lisa - if you're able to install and create a working Test organization, you are probably good on rights & permissions.

    I know you'd rather not use another case, but I think you'd be better off with Microsoft Support's assistance (as opposed to 'tinkering' for several days more on what could be either a very simple - or complex problem.

    Good luck and please update the status if you find the answer - or you are able to resolve it with MSFT's assistance.

    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    • Marked as answer by Jim Glass Jr Monday, April 19, 2010 6:18 PM
    Sunday, April 18, 2010 9:07 PM
    Moderator

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    I don't see an 'obvious' answer - but would suggest a couple of things that have tripped me up before.

    1. try creating a new 'generic' organization - if you can complete that without issue, it eliminates potential rights and permissions errors that might not be caught by the import wizard.

    2. Ensure that you don't already have a database with the name "TomorrowsTechnologyToday_mscrm" on the server.

    3. I have had one case that threw the error you're seeing, we ultimately involved Microsoft Support since the 'fix' involved editing the CRM Config database and removing an invalid organization. - I wouldn't recommend editing it 'experimentally' since it could create more unknown errors.

     

    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Sunday, April 18, 2010 8:22 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    The support document from Microsoft that told me how to get from CRM Workgroup to Professional edition, said to backup my organization (unfortunately I did not backup the MSCRM_config), sincet this is my 9th day, I don't think I have my system backups... shame on me...but will go look for them.  so I deleted the MSCRM_Config db, uninstalled CRM (did not delete the dir or registry entries). then do a fresh install, apply rollup #9 b/c my original install was r/up 5 and 9. I added the registry entry OptimizeOrgImport

    yes, I can get into the "professional edition" create a user, and that seems to work on my fresh install.  I did not test further, I can if that helps. 

    I then import from deployment manager.  and this is where I get.  My "temporary db is TTechT_mscrm.  I do leave the old db in place "TomorrowsTechnologyToday" because I thought that is what it uses, should I then make my new,new organization a third name? 

    from the import I made my third name TomorrowTechnologyToday and it still fails with
    12:48:12|  Error| Import Organization (Name=TomorrowTechnologyToday, Id=6eae862a-0a4b-df11-a468-001b212ec37d) failed with Exception:
    System.InvalidCastException: Specified cast is not valid.

    Deployment Manager "new organization" works fine, so now I have a "Test" organization so it is something with my import.  should I have installed r/up 5 and r/up9 instead of just r/up 9 on my new install?  Any suggestions would be greatly appreciated.  I already wasted 1 of my support cases on this installation b/c of authenitication issues.  could this be related? 

    • Edited by Lisa n-u Sunday, April 18, 2010 4:55 PM update results
    Sunday, April 18, 2010 2:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Lisa - if you're able to install and create a working Test organization, you are probably good on rights & permissions.

    I know you'd rather not use another case, but I think you'd be better off with Microsoft Support's assistance (as opposed to 'tinkering' for several days more on what could be either a very simple - or complex problem.

    Good luck and please update the status if you find the answer - or you are able to resolve it with MSFT's assistance.

    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    • Marked as answer by Jim Glass Jr Monday, April 19, 2010 6:18 PM
    Sunday, April 18, 2010 9:07 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Sorry I don't think I am going to spend a case on MS Support, I am just going to install my MS Accounting interface, reload the accounts and contacts from there.  My office manager will have to reenter her contracts, but she said she wanted to revamp the way she was doing that now anyways.  I have outlook connect with an offline database, if I name my new company the same name, is there a chance it will reconnect and throw that info back over to CRM from the offline database?

    Thank you so much for all your advice!

    Monday, April 19, 2010 5:33 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Lisa , that won't work.

    SJ
    Tuesday, April 20, 2010 12:38 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hey,

    I'm experiencing the same issue here, what was the cause of this issue and how did you manage to fix it?

    Kind regards,

    Philippe

    it's all very nice when it works
    Friday, May 21, 2010 8:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Guys,

    I'm receiving the same error when trying to import a 4.0 database backup that was captured from a different machine on a different AD domain.  CRM versions/rollups are the same on both environments, but Windows Server and SQL Server versions are newer (2008, 2008R2, respectively) in the destination environment.

    Any advice on getting past this short of opening a case with Microsoft?

    TIA,

    Jeff

    Monday, November 12, 2012 12:04 PM