Question Re: Data services using Rapid Data migration in Technology Q&A

Data services using Rapid Data migration

former_member384249 — Mon, 21 Jun 2021 15:14:03 GMT

Good Day All,

for S4HANA Migration using Data services i have few questions below, Could you please clarify for me.

Can we use Database SQL Anywhere 17 for RDM (Rapid Data Migration)
Can we do migration to S4HANA using data services without using RDM package

Basically i am trying the RDM package with SQL Anywhere database but my Lookup jobs are getting failed, i have tried to manage successful initialization of job Job_DM_Lookups_Initialise but Job_DM_Lookups_FileToApp getting failed and its throwing the below error.

when i tried check backend sql anywhere database those LKP_* tables are not showing.

Could you please assist on the above points,

Regards,

Sreenivas

Re: Data services using Rapid Data migration

Julian_Riegel — Wed, 23 Jun 2021 07:17:59 GMT

Hi, the error message has not been attached - could you resubmit your screenshot?

In case you have connected your target system already, have you tried executing Job_DM_Lookups_SAPToApp.

As per RDM Quick Guide:

Use one of the following databases:

SAP HANA 1.x or above

Oracle 12c

Microsoft SQL Server 2008 R2

IBM DB2 v9.7

Sybase ASE 15.7

For Data Quality Package, Database SAP HAHA 1.X and Sybase ASE 15.7 is out of scope

2. Yes you can, this would require some more manual developments for sure. An Option would be mentioned in following blog:

https://blogs.sap.com/2021/03/10/part-1-migrate-your-data-migration-cockpit-from-sap-s-4hana-2020-sap-s-4hana-cloud-2008-migrate-data-using-staging-tables-and-methods-for-populating-the-staging-tables-with-data/

You can use SAP Data Services to populate the staging tables of the Migration Cockpit.

Re: Data services using Rapid Data migration

former_member384249 — Thu, 24 Jun 2021 07:40:40 GMT

Hi Julian,

Thanks for responding me, Basically we have set upped DB SQL Anywhere 17 version for Data services, As part of RDM i have downloaded .ATL files and started lookup jobs execution that's only Initialize and FiletoAPP jobs,

for the filetoapp job execution i am getting below error attached

After my investigation i found that all LKP_* tables are not sitting in SQL Anywhere database but if i look in data store of DS_STG_MGMT_LKP i can see all tables under it and that data store connection pointing that SQL Anywhere 17.

I am wondering why those tables not showing in backend DB, if anything need to be done, could you please assist on that.

Re: Data services using Rapid Data migration

akhileshkiran — Thu, 24 Jun 2021 13:27:11 GMT

Hi bvasu.reddy,

If you are looking to execute the Lookup batch job - Job_DM_Lookups_FileToApp batch job. I see these are import tables in the target.

In RDS packages we have two data stores configured like DataStore_Name_LKP and another with DataStore_Name_LKP_INIT.

DataStore_Name_LKP_INIT - DataStore will be holding the Template Tables.
DataStore_Name_LKP - DataStore will be holding the Imported Tables of the Template Tables.

If you are unable to find the tables in the database, then you are running the wrong job.

By looking your screenshot, I am assuming that you are running the Job_DM_Lookups_FileToApp first.

f I look into the data flow, Those are imported tables pointed to DS_STG_MGMT_LKP.

EG : LOOKUP_RUNTIME_FILETOAPP(DS_STG_MGMT_LKP.DS_OWNER)

If I check this table in the LKP_INIT data store, It is being called in the Job_DM_Lookups_Initialise batch job.

If you run this batch job, then all the lookup tables will be created in the database.

I request you to please recheck and reconfigure the files path and the directories permissions to for the flat files.

Thanks & Regards,

Akhilesh Kiran N.

Re: Data services using Rapid Data migration

former_member384249 — Thu, 24 Jun 2021 18:31:39 GMT

Hi Akhilesh,

Thanks for responding, actually i executed Job_DM_Lookups_Initialise first then only i started with Job_DM_Lookups_FileToApp.

I have re executed the initialise job and its finished with warning of Replace_Substr_Max_Size_Characters parameter in DSConfig.txt

Again re executed the Job_DM_Lookups_FileToApp its throwing same error.

If you see tables starting with LKP_* under the data store of MGMT_LKP those are not visible in backend database of SQL Anywhere, actually i am not sure that issue with SQL Anywhere database or Data service lookup jobs are causing it.

Re: Data services using Rapid Data migration

kamal264 — Fri, 06 Aug 2021 17:35:59 GMT

First you have to run the Lookup initialize job .

That will create the Lookup tables to db level.

SAP RDS is not supporting SQL Anywhere directly , have to modify many things , so better to use another db for RDS or resolve issues one by one.

~ Kamal

Re: Data services using Rapid Data migration

former_member822352 — Tue, 20 Sep 2022 12:51:01 GMT

i am facing failure in saptopp job -- it shows failure that "no lookup table found in lkp_runtime_saptoapp" [below snapshot]

i have imported DM_BPFDM_Lookups project, then updated the datastore for my sap S4 target and my staging dbs [our staging db is oracle]. i run the initialize job --- all tables loaded with 0 records

next i run the saptopp job -- it shows failure that "no lookup table found in lkp_runtime_saptoapp" [below snapshot]

Re: Data services using Rapid Data migration

Former Member — Tue, 20 Sep 2022 12:52:00 GMT

I saw your posted comment. I recommend raising your question again as a new question and follow our rules of engagement: https://community.sap.com/resources/rules-of-engagement. Feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you'll be able to prepare questions that draw responses from our members.

Thanks!