Financial Management Blogs by Members
Dive into a treasure trove of SAP financial management wisdom shared by a vibrant community of bloggers. Submit a blog post of your own to share knowledge.
cancel
Showing results for 
Search instead for 
Did you mean: 
Aleksandr
Participant
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