BODS Data Services - Migr Services - Lookup Maintainance

[Former Member]

Dear All,

Source : SQL              Target :

I have executed the jobs : Initial, File to App and SAP to APP.

Also, I configured the Migration Services and by giving the lookup repository name, i am able to go into Lookup Maintainance.

But i getting 1 error.

Cannot find HDR-ID in Table: MGMT_PROFILE_HDR. Please ensure that Data Services Job Job_AIO_Lookups_Initialise(Set the global variable $G_MigrationServices_ProfilingConfig = ’Y’ ) has been run successfully.

I have even created the profiler repository( but i could not able to add the profiler repository in Data Service Mgmt Console and also in CMC).

Can anyone, let me know how to eliminate this error.

Further, What do i need to do in Migration Services.

In Migration Services, I have all lookups  also i got a excel file having lookup values from functional consultant.

Can you one please provides some documents or way to work on Migration Services(http://localhost:8080/MigrationServices).

Also, Can anyone guide me how to put the values in lookup tables from excel.

Thanks,

A Sustainer

Attachments: Screen Shots of Migration Services with lookups.

[Former Member · Accepted solution]

Correction

Source : SQL Server

Target  : ECC

Reason Why i Could not able to add profiler repo in Data Service Management Console:

I could not able to find the option "Repository" in Administration->Management.

Reason Why i Could not able to add profiler repo in CMC:

Data Services->Configure Repository:

I am not sure what to add in

Profiler Server Host Name & Profiler Server Port:

Dear Experts...pls look into this and suggest me.

[former_member187605 · Accepted solution]

This question has been asked before. This question has been answered before.

See

[Former Member · Accepted solution]

Hi Dirk,

Thanks for your reply, I resolved the profiling issue.

But still i have following questions:

But i getting 1 error.

Cannot find HDR-ID in Table: MGMT_PROFILE_HDR. Please ensure that Data Services Job Job_AIO_Lookups_Initialise(Set the global variable $G_MigrationServices_ProfilingConfig = ’Y’ ) has been run successfully.

Can anyone, let me know how to eliminate this error.

Further, What do i need to do in Migration Services.

In Migration Services, I have all lookups  also i got a excel file having lookup values from functional consultant.

Can you one please provides some documents or way to work on Migration Services(http://localhost:8080/MigrationServices).

Also, Can anyone guide me how to put the values in lookup tables from excel.

Thanks,

A Sustainer

Attachments: Screen Shots of Migration Services with lookups.