Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.
No ratings
timchengappa
Saviynt Employee
Saviynt Employee

Problem Statement: During SAP Account/Access imports, several backup tables for default tables such as agr_agrs, agr_1251, etc. get created during each import cycle which contributes to performance issues...

Sample BackUp Temp Tables
distinct_temproletotcode_4450891_agr_agrs_20220403043125348_bkup
distinct_temproletotcode_4450907_agr_1251_20220403043810368_bkup
distinct_temproletotcode_4450907_agr_agrs_20220403043416398_bkup
distinct_temproletotcode_4450923_agr_agrs_20220403043915980_bkup

Solution: 
Navigate to Admin->Setting->Configuration Files, edit the externalconfig.properties file, and set the 'jobs.enableparallelimport.debugging' configuration to 'false'

Example:
# Disable parallel debugging by default.

jobs.enableparallelimport.debugging=false

timchengappa_0-1674597354167.png

This configuration specifies whether you want to create backup temp tables during SAP import. (available from Release v5.5 SP3.8 onwards)
The options are:
true - Creates backup temp tables.
false - Does not create backup temp tables.

Reference: https://docs.saviyntcloud.com/bundle/Internal-Resources/page/Content/Configuring-externalConfig-prop...

Version history
Last update:
‎01/24/2023 02:00 PM
Updated by:
Contributors