Error message in some Web parts in Business Portal: "Cannot convert the AssociatedView, XXX to an EntityAlias because a valid parent key cannot be assigned"

Applies to: Dynamics GP 2010Dynamics SL 2011

Symptoms


You receive the following error message in some Web parts:
Cannot convert the AssociatedView, XXX to an EntityAlias because a valid parent key cannot be assigned.
This problem occurs in Business Portal for Microsoft Dynamics GP and in Business Portal for Microsoft Dynamics SL.

In addition if using Business Portal for Microsoft Dynamics SL, you may recieve the following error message in Project Web Time Entry:

A Timeout has occured. Please refresh your browser


In addition if using Business Portal for Microsoft Dynamics SL, you recieve the following error message in Top 5 Reports:


Server Error in '/' Application.
Invalid object name 'SLsystemdb..ReportCatalog'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'SLsystemdb..ReportCatalog'.

Cause


Cause 1

This problem occurs because there is an underscore in the name of the computer that is running Business Portal. We recommend that you do not use an underscore in the name of the computer that is running Business Portal. This recommendation is documented in the BusinessPortalInstallation.pdf file. This file is located in the documentation folder on the Business Portal CD. See Resolution 1 in the "Resolution" section.

Cause 2

If you are using Business Portal for Microsoft Dynamics GP 10.0 or for Microsoft Dynamics SL 7.0, the Company Containment feature was incorrectly installed during the installation. See Resolution 2 in the "Resolution" section.

Resolution


Resolution 1

Install Business Portal on a computer that does not have an underscore in its name.

Resolution 2

To correctly install the Company Containment feature, follow these steps:
  1. Verify that the user account with which you are logged on to the Business Portal computer is a site collection administrator. To do this, follow these steps:
    1. Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.
    2. Click the Application Management tab.
    3. In the SharePoint Site Management area, click Site Collection Administrators,. Then, in the Site Collection list, click the site on which you installed Business Portal.
    4. Make sure that the user account with which you are logged on to the computer is listed as a primary site collection administrator or as a secondary site collection administrator.
  2. Download one of the following files depending on whether you are running Microsoft Dynamics GP 10.0 or Microsoft Dynamics SL 7.0:
    • If you are running Microsoft Dynamics GP 10.0, download one of the following files, depending on whether you installed Microsoft Office SharePoint Server 2007 or Windows SharePoint Services 3.0.

      Microsoft Office SharePoint Server 2007
      The following file is available for download from the Microsoft Dynamics File Exchange Server:


      Release Date: January 31, 2008




      Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.



      Windows SharePoint Services 3.0
      The following file is available for download from the Microsoft Dynamics File Exchange Server:


      Release Date: January 31, 2008




      Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

    • If you are running Microsoft Dynamics SL 7.0, download the following file.
      The following file is available for download from the Microsoft Dynamics File Exchange Server:


      Release Date: January 31, 2008




      Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

    • If you are running Microsoft Dynamics SL 2011, download the following file.
      The following file is available for download from the Microsoft Dynamics File Exchange Server:


      Release Date: November 28, 2011



      Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

  3. Extract the contents of the file that you downloaded. Edit the CompanyContainmentDeactivateFeature.cmd file and the CompanyContainmentActivateFeature.cmd file. To do this, replace %sitecollection% with the name of the site collection.

    Note If you are unsure of the site collection name, follow these steps to determine the site collection name:
    1. Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.
    2. Click the Application Management tab.
    3. In the SharePoint Site Management area, click Site Collection List, and then click Change Web Application in the Web Application list. The Select Web Application list contains all the site collections.
    4. Locate the site collection to which you installed Business Portal. Use this site collection instead of %sitecollection% in each .cmd file.
  4. To run the files that you downloaded, double-click the files in the following order:
    1. CompanyContainmentDeactivateFeature.cmd
    2. CompanyContainmentUninstalllFeature.cmd
    3. CompanyContainmentInstallFeature.cmd
    4. CompanyContainmentActivateFeature.cmd