Refresh test data in test SAP Financial Consolidation (FC)

[Aleksandr]

Hello colleagues,

If you are facing the task of updating test data with production data of SAP FC, I will try to help you solve it. Below you will find my experience.

Environment:

SAP Financial Consolidation 10.1 (production and test server)
Windows Server
SAP HANA 2.0

High-level steps:

1. Determine a schema in SAP HANA which is used by a production data source


2. Check the size of an exported schema in SAP HANA


3. Multiply by two the size of the exported scheme, that's how much free space should be on the servers (production and test SAP HANA server)


4. Stop the production data source


5. Export the schema to FS of the production SAP HANA server


6. Start the production data source


7. Move the export from the production SAP HANA server to test (see step 3)


8. Stop the test data source


9. (Optional) Export the test schema to FS of the test SAP HANA server


10. Import the export (step 7) to the test schema on the test server


11. Check size of imported tables (CT_FACT_DATA)


12. Start the test data source


13. Connect to the test data source via SAP FC application as user with admin permissions


14. Change production server names to test server name in Address book section, in General options -> External links, in General options -> Transfers

 

Some extra info about the steps:

1. Open SAP FC administration console ( https://<server_name>/FCWebAdmin/Default.aspx?TimezoneOffset=120 ), click on a data source -> Configuration -> Find User ID in Database configuration string field


2. SAP Note 1969700 -> Data -> Schemas , check the row Total under the schema name


3. Increase or create temp directories in the production and test SAP HANA server


4. Open SAP FC administration console, click on a data source -> click Data source options -> click Stop data source


5. 
   

   EXPORT "<schema_name>"."*" AS BINARY INTO '<dir_for_export>' WITH THREADS 10 , 
   
   You need to have permissions to export the schema or to log in as schema owner user.
   
   If the export will stop with "Export aborted due to concurrent operations", please re-execute script again or set threads to 1.

   
   


6. Open SAP FC administration console, click on a data source -> click Data source options -> click Start data source


7. 
   

   scp -r <dir_export> <user>@<test_server>:<dir_target>

   
   


8. Open SAP FC administration console, click on a data source -> click Data source options -> click Stop data source


9. (Optional) see step 5


10. 
    

    IMPORT "<prod_schema_name>"."*" FROM '<dir_target(see step 7)>' WITH REPLACE THREADS 4
    
    You need to have permissions to import the schema or to log in as schema owner user.
    
    
    
    If your target test schema has a different name:
    
    IMPORT "<prod_schema_name> "."*" FROM '<dir_target(see step 7)>' WITH REPLACE THREADS 4 RENAME SCHEMA <prod_schema_name> TO <test_schema_name>

    
    


11. See step 2 and compare the test schema after the import with the production schema


12. Open SAP FC administration console, click on a data source -> click Data source options -> click Start data source


13. Run Financial Consolidation application (Windows) and log in with admin permissions


14. Change production server names to test server name in Address book section, in General options -> External links, in General options -> Transfers


15. 
    Check /sapmnt/log size after import process (SAP HANA creates a lot of logs during these changes). Run manually SAP HANA log backup under <sid>adm user:
    

    hdbcons
    
    >log backup
    
    

    
    Once the log backup process is complete (SYSTEMDB tenant -> Backup and Recovery -> Open Backup Console), run manually cleanup of old log files (SQL in <SID> tenant):
    

    ALTER SYSTEM RECLAIM LOG
    
    

    
    


16. 
    Release SAP HANA memory after all operations by running command under <sid>adm user:
    

    hdbcons
    
    >resman shrink
    
    

    
    


17. 
    Run "Disk space allocation and fragmentation information" report (1969700) and check FRAG_PCT for indexservice, if the value more than 20, run defragmentation procedure (SQL in <SID> tenant):
    

    
    
    ALTER SYSTEM RECLAIM DATAVOLUME '<host>:<port_indexserver>' 120 DEFRAGMENT
    
    

    
    

 

Useful links:

SAP Notes: 

2033956 - How to create/copy a test environment from production? - FC 

1969700 - SQL Statement Collection for SAP HANA



How to Export and Import the SAP HANA Schema

Creating a Data Source

EXPORT Statement (Data Import Export)

Import Schemas, Tables, and Other Catalog Objects