3585454 - Failed to loading FX rate via import job to category Actuals in Conversion Tables after QRC

Failed to  loading FX rate via import job to category Actuals in Conversion Tables after QRC.

From HAR trace, below error can be confirmed:

{
    "message": "An unexpected error occurred while trying to update the currency conversion table data.",
    "stack": "",
    "errorDetails": [
        {
            "messageId": null,
            "message": "An unexpected error occurred while trying to update the currency conversion table data.",
            "bUIMessage": false,
            "bWarning": false
        },
        {
            "status": 500,
            "errorId": "ST_GSTFVT",
            "messageId": "STAGING_CREATE_FAIL",
            "message": "Failed to create staging table from view table. Please contact your company administrator with the following error code (ST_GSTFVT)",
            "bUIMessage": false,
            "bWarning": false
        },

}

• SAP Analytics Cloud 2025.1.9 (Client)
• SAP Analytics Cloud 2025.1.8 (Server)

1. Navigate to the Modeler->Conversions tab.
2. Select VGO_XPA_Currency.
3. Click on Import Data button and select Data Source option.
4. Select SAP S4/HANA Source System.
5. Select Connection FP&A-SAP Best Practices.
6. Create New Query.
7. Select  Query.
8. Select fields and Filter.
9. Click on Next to create the job.
10. Do the data wrangling and mappings (change the status to Actrual).
11. Clicking on Finish mappings gives us the error:
12. The trace will show:
    An unexpected error occurred while trying to update the currency conversion table data.

If instead of Actuals/Specific category if we write these rates to the Planning category, then there is no error.
There was no issue with the above before the last quarterly upgrade.

This issue is currently under investigation of development team.

This issue is currently under investigation of development team.

• SAP Analytics Cloud Best Practices and Troubleshooting Community expert page
• SAP Analytics Cloud – Authentication and Data Connectivity openSAP course (free!)
• 2540886 - How to export data from models in SAP Analytics Cloud?
• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or Support - Search - SAP for Me

Your feedback is important to help us improve our knowledge base.

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Import, Acquired, Acquire, agent, C4A, C4AAgent, C4A_Agent, KIT, Tomcat, Trace, Log, Logging  , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , How To , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem