Microsoft > Dynamics Forums > CRM > New Organization

Proposed Answer New Organization

  • Friday, September 24, 2010 9:37 PM
     
     

    I'm running CRM 4 with rollup 11 on Win 2k8R2.  I'm getting error when trying to create a new organization in deployment manager.  It completes most of the process, then finally errors out on the step 'Create Organization Reports.'

    Here is the error: Microsoft.Crm.CrmException.

    And in the install log:

    14:35:19|  Error| Create new Organization (Name=Test, Id=6372dbc4-22c8-df11-9966-428dce5f0c97) failed with Exception:
    Microsoft.Crm.CrmException: Could not publish report 'Neglected Cases' due to the following error:  The underlying connection was closed: An unexpected error occurred on a receive. ---> Microsoft.Crm.CrmReportingException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host

    I already have one organization running just fine, so I'm not sure why I can't create another one.  I can't seem to find anything on this issue online that has been of any help.  When it errors out, the organization is not created.

    Any help would be appreciated. 

All Replies

  • Monday, September 27, 2010 12:26 AM
    Moderator
     
     Proposed Answer
    Check the event logs of both CRM and sql. I would expect some kind of permissions error, possibly in ssrs. Is ssrs on the same sever as SQL or a different one.? If you don't see any errors in event logs, consider running a SQL profile trace while you create the org. It should tell you why the db connection is being lost.
  • Monday, September 27, 2010 5:10 AM
     
     

    Hi,

    Are you running any antivirus protection sofware. Please disable [for time being] and try to create new organisaion.

    If your re running AVG 8 antivirus protection sofware, please disable. I also had the same problem.

    Hoep this helps.


    Thanks, Ranjitsingh R | http://mscrm-developer.blogspot.com/ | MS CRM Consultant
  • Monday, September 27, 2010 5:30 AM
     
     Proposed Answer

    first see the logs in both CRM server and sql server to get more in details.

    may be the sql server or any services get restarted in the duration of creating organization.

    else check the free space in hard drive in sql server.

    or else as ranjit said check if any antivirus is running, this used to come, and check the folder access permission for the log file and data file access.

     

    Sudhanshu

    • Proposed As Answer by yes.sudhanshu Friday, October 08, 2010 9:14 AM
    •  
  • Wednesday, September 29, 2010 11:00 PM
     
     

    Sorry for the delayed response, I was out of town briefly.   We have a CRM server, which is also running SSRS, and the database for CRM is on an external SQL cluster (64bit, 2005).

    Turning off AV did not help, but I do see this error on the CRM box:

    "Report Server (MSSQLSERVER) cannot load the TERADATA extension"

    I fixed this issue with help from other posts (the fix is to comment out the teradata portion of the reporting services config file.  For some reason, it's in there by default, but the assemblies are not.).

    I still see an error in the event viewer on the CRM server, but nothing on the SQL server.

    Web service request CreateReport to Report Server http://server/ReportServer/ReportService2005.asmx failed. Error: The underlying connection was closed: An unexpected error occurred on a receive.

    Not sure if this matters, but the SQL server is 2005, reporting services on the CRM box is 2008.

  • Thursday, October 07, 2010 2:04 AM
    Owner
     
     
    You might want to try the SQL trace that Joel recommended.  It should give you additional information about why the host machine is closing the connection.

    Regards, Donna