Error message when you install Business Portal for Microsoft Dynamics GP: "The data type or table column '[TAST0532].[ACCRUED]' does not exist or you do not have permission"


Symptoms


When you install Business Portal for Microsoft Dynamics GP, you may receive the following error message:
SQL Error “One or more company SQL objects have failed to load. Please see C:\DOCUME~1\xxxxx\LOCALS~1\Temp\1\BPSQL.Log for more information.
The following error message is logged in the BPSQL.Log file:

EXEC sp_bindefault N'[dbo].[GPS_INT]', N'[TAST0532].[ACCRUED]' ~~The above statement produced the following error: ~~The data type or table column '[TAST0532].[ACCRUED]' does not exist or you do not have permission.

Cause


The Business Portal installation uses the HROD table in the DYNAMICS database and the HRCACC01 table in the Microsoft Dynamics GP company databases to check whether Human Resources exists in the back office because it is not created by Business Portal. If Human Resources was installed or was used at a version before Microsoft Dynamics GP 10.0 was installed but was not upgraded to the Microsoft Dynamics GP 10.0 version, you receive the error message that is mentioned in the "Symptoms" section. This problem occurs because the Human Resources tables still exist in the databases. However, the Human Resources tables are not at the Microsoft Dynamics GP 10.0 version.

Resolution


To resolve this error message, drop the HROD table from the DYNAMICS database, and drop the HRCACC01 table from all the Microsoft Dynamics GP company databases before you run the Business Portal installation. To do this, follow these steps:

  1. Back up the DYNAMICS database and all the Microsoft Dynamics GP company databases.
  2. Run the following statement in SQL Server Management Studio against the DYNAMICS database.
    Drop Table HROD
  3. Run the following statement in SQL Server Management Studio against all the Microsoft Dynamics GP company databases.
    Drop Table HRCACC01
  4. On the computer that is running Business Portal with an installation that failed, run SQL Configuration. To do this, follow these steps:
    1. Click Start, click Control Panel, and then click Add and Remove Programs.
    2. Click Business Portal for Microsoft Dynamics GP 10.0, and then click Change.
    3. In the Modify Business Portal Installation window, click SQL Configuration.
    4. Verify the connection information, click Next, and then click Install.