Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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"

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: kbexpertiseinter, kbprb, kbmbsmigrate, kbtshoot, kbexpertisebeginner, kbmbspartner, kbsurveynew, kberrmsg, kbexpertiseadvanced, kbgreatplainsbp, kbmbsinstallation, kbnosurvey, kb

↑ Back to the top

Article Info
Article ID : 967810
Revision : 1
Created on : 3/25/2017
Published on : 1/3/2015
Exists online : False
Views : 90