Skip to Content
0
Former Member
Feb 22, 2012 at 02:13 PM

Invalid object name 'MGMT_PROFILE_HDR' while installing Migration Services

156 Views

Hi guys,

I'm currently setting up SAP Business Objects Data Services 4.0 SP1 on windows 2008, SQL Server 2008 Express. I have been following the sap guide DM_ERP_Quick_Guide_EN_US_40. Now at the point where i have to install the migration services tool, after filling out all the parameters required to Add a staging area, and testing the connection, the test failed and gave the following details.

Invalid object name 'MGMT_PROFILE_HDR'.

I tried to trick the system by going into the database to create the missing MGMT_* tables using dummy columns. I tested the connection to the database and got the following message details:

Connection successful: But cannot find the MGMT_* tables.

I need an advice on how to go about solving the error.

Any suggestions will be appreciated.

These are the parameters i used:

Staging Area Name: ERP_SQL_Server_Authentication_sa

Database type: Microsoft_SQL_Server

Machine/DSN Name: TRNSAP\SAPBPDM

Port: 1433

Database/Service name: DM_REPO_ERP

User : sa

Password: Welcome1.

Regards.