Skip to Content
Author's profile photo Jagadeesh Mandepudi

HANA SLT(System Landscape Transformation) Archived Files(SARA) Replication to HANA

Hi All

In this blog we are going to discuss how to replicate the data which had been archived on source systems through SARA files.

In every project based on agreement we will go for archiving either it will be to keep only last 12 months data or last 24 months based on business agreement.

If we have Archive user exclusion setting on SLT system from initial phase of the project then we are good but in some cases we may have to reload tables from source systems but if the tables already archived then we can use below steps to replicate archived data directly from SARA files without loading data to source system.

Refer my below blog for archive exclusion steps:

https://blogs.sap.com/2017/09/29/hana-sltsap-landscape-transformation-archiving-settings-when-source-table-being-archived/

Steps to Replicate Archived Data to HANA Directly from SARA files.

  1. Lets Check HANA system table for which data had been archived to make sure data no record counts showing for specific periods.

Example:Below table don’t have data for 2014 because had been archived so on source system also you don’t find any records.

HANA:

Source System Records for 2014:

2. Lets go to SLT system and use SE38 to execute IUUC_CREATE_ARCHIVE_OBJECT program.

If archive Object is not correct then you don’t see options for tables which archived through this archive file name so we have to make sure to enter correct name.

Portion size leave it as it which is 8000 portion.

We can use archive date from and to in case source system archived multiple times but we are interested to retrieve data only for specific periods so please enter the dates between when archive job had been executed.

Write behavior keep it 3 so that it will use array modify for replication.

When you execute above program screen then if you archive object name is correct it will shown you below screen to select for which tables you want to replicate data from SARA file.

After table selection please use below enter button to proceed.

As soon as you press enter button it will create migration object for replication and it will display below successful screen with names.

Press enter to see next successful message

3. Go to LTRC transaction on SLT system to see weather migration object created with the name which used in step 2.

4. If you see loaded in above step for migration object then next step check HANA table record counts for same table and same period which we checked in above steps.

 

With this we are successful replication from SARA files to HANA directly without using source system.

Thanks

Jagadeesh

 

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Chandrashekhar Mahajan
      Chandrashekhar Mahajan

      Hi Jagadeesh,

       

      Nice blog. I have few questions on this topic.

      1. As per my understanding, Archive files are getting stored into content server so how is it being accessed from LT server?
      2. what is the file format of archive file?
      3. if archive file having data from archive object [which could be from multiple associated DB tables], how it will be parsed when it is read from HANA and replicated back to similar DB schema? is this taken care by LT system?

      Please let me know.

       

      Regards,

      Chandra

      Author's profile photo Jagadeesh Mandepudi
      Jagadeesh Mandepudi
      Blog Post Author

      Hi Sorry for the delay

      Please see my answers for your questions.

      1. As per my understanding, Archive files are getting stored into content server so how is it being accessed from LT server?

      Since we are using SAP recommended archive mechanism it will support automatically to extract data which is stored in other system like Dolphin etc.

      1. what is the file format of archive file?

      SARA files.

      1. if archive file having data from archive object [which could be from multiple associated DB tables], how it will be parsed when it is read from HANA and replicated back to similar DB schema? is this taken care by LT system?

      If you see my steps above in case of multiple tables associated with SARA file then you will get option to select table for which you wanted to replicate so SLT will take all these.

      Regards

      Jagadeesh

      Author's profile photo Ranadheer Jalapati
      Ranadheer Jalapati

      Hi Jagadeesh,

      Will this process works even if archived files (SARA format) were created from a different database (apart from HANA)

      Author's profile photo Norwynn Marian Bergonio
      Norwynn Marian Bergonio

      Hello Jagadeesh,

       

      When we tried to do Step 2. We encountered the error below:

      No consumer number found for object. It would have been nice if there was a logging table provided. But in this case, where can we start with checking error?

      Author's profile photo Nisha Meledath
      Nisha Meledath

      Hi Norwynn,

      Error "No consumer number found for object" is addressed in 2784440 - SLT (DMIS 2011) SP14 Correction 19CW17 Central System. Please ensure that this correction note is implemented in the SLT system.

      Cheers,

      Nisha

      Author's profile photo TC2 -D BI-BI
      TC2 -D BI-BI

      Hi All,

       

      I have question: How can we stop archiving object. I tried many things but SLT shows that no such tables exist.

       

      Thanks,

      Ankur