3639457 - SAC: Data Change Log, Audit Log Handling

• SAC user has concerns of SAC Data Change Log Capacity
• SAC Admin user wants to backup or archive or export audit data like Data Change Log
• Errors during publishing transaction data in SAC model (model has Data Audit feature enabled)
  • Publish cannot be performed because the data audit table has reached the maximum number of rows.
  • "An unexpected technical error occurred." during publish SAC model version
  • The data action "XX" couldn't run successfully on version "XX" because you don't have the resources available. Try restricting the scope or try again later 
  • HAR trace shows: An error occurred during the execution of the EPM command 'action': {\"Number\":43033,\"Type\":2,\"Text\":\"SQL update failed with error 260: invalid column name: Audit__old__SignedData at ptime/query/checker/check_insert.cc:689
  • Index server trace shows: Maximum number of rows per partition reached 
• SAC Admin user cannot open Data Change Log page, the page keeps loading
• Errors during opening, deleting or downloading data change log:
  • HAR trace shows: https://sac tenant/sap/fpa/services/rest/epm/objectmgr?tenant=2 "action":"listObjects","data":{"p1":"DATAAUDIT"...) with error 502 Bad Gateway: Registered endpoint failed to handle the request.

SAP Analytics Cloud

• Publish Version
• Download Data Change Log
• Delete Data Change Log

• Hard limit of 2 billion records Per Model for the data audit log
• Out of memory in SAC tenant

• Users frequently get error during updating on version due to Data Changes log reaching capacity: 
  • Prerequisite:
    • The model has Data Audit feature enabled
  • Workaround 1:
    • Go to Security - Data Changes - Select the model
    • Delete certain amount of Data Change log to reduce the Data Change log size until user can publish version. 
    • Use "Download Data Changes" or API getAuditData to backup the Data Change log if needed. 
  • If admin user cannot open Data Change log, for example: the page(Security - Data Changes - Select the affected model) keeps loading, then try Workaround 2:
    1. To delete ALL Data Change Log(audit log) to avoid version publish failure
    2. Go to Model page Turn off Data Audit Feature
    3. Save the model
    4. Enable Data Audit Feature
    5. Re-save the model
        
• Recommend to reduce Data Change Log size as regular Housekeeping Task in SAC:
  • Data Change log is hardcoded to 2 billion records (per model) and this setting can neither be increased or decreased
  • Help document: Track Data Changes
  • Since release 2025.15, Enable Configure Data Change Log Notifications (System - Administration - Notification)to get notification if the audit data size reaching certain threshold
     
  • Download Audit Data and Delete Audit data from SAC
    • Go to Security - Data Changes - Select the model
    • Click "Download Data Changes"
    • After saving the local copy, click "Delete Data Changes" 
       
  • Use Data Export Service API function to export audit data
    • Help document: /providers/{NamespaceID}/{ProviderID}/AuditData
    • https://api.sap.com/api/DataExport_API/resource/getAuditData
    • Please see detail setup in Leverage Data Export Service to Visualize Data Change Log 
       
  • Related User Roles:
    • Admins and BI Admin 
    • Roles: Data Change Log: Read or Delete 
    • User is having access to the folder where the model locates
       
• Workaround to know audit log size:
  • Open the data change log for a model
  • Click on the "last page" icon (>>) to show the last page of the logs.
  • Take a note of page number and multiply it by the number of records per page to get the number of records currently in the log
     
• Our developer continues working on the enhancement of Audit log feature, please Vote or Give your feedback on enhancement of Audit Log related features:
  • For example:
    • Direct access to data audit table to perform audit reporting in stories
    • Expose audit tables
    • Data Change Log- Source Tracking
  • You can also create new enhancement idea under SAC page

3413225 - You don't have the resources available to publish this version or for a step when running a data action in SAP Analytics Cloud for Planning (SAC)

KBA , LOD-ANA-ADM-AUD , Data Audit , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , LOD-ANA-PL-DA , Data Actions , LOD-ANA-PL-VER , Version Management , Problem