Symptom
- Model import with TGZ file fails with error "[Object ID] already exist." in SAP Analytics Cloud (SAC)
- First try of the model import failed after 5 minutes with error: "502 Bad Gateway: Registered endpoint failed to handle the request.", and the package with the model was still processing for more than 24 hours.
- When trying to re-import the same model (even with "Update existing object" or "Drop Object"), system returns an error that the model was already created: Error: [Object ID] already exists.
- However, the model does not exist in files folder, under model or under any other folder.
- It seems that it is stuck somewhere in the database.
Environment
SAP Analytics Cloud (Enterprise) 2022.08.17
Reproducing the Issue
- Login to SAC tenant.
- Go to Transport - Import - File System.
- Try to import the TGZ file created as per KBA 2538909 - topic "Using the Transport (file) Method (zipped / .TGZ files)".
- Upload - Select Source File - Upload - OK.
- Import.
- Select import options e.g. "Update existing object" and "Drop Objects".
- OK => import process ends with error message: "[Object ID] already exist."
Cause
In the export package there are many schedules with complex mappings for the model which results in a big json size of the model of approx. 40 MB in the export file.
This causes the import to take longer to process and can result in the reported timeout with error 502 - Bad Gateway.
Unfortunately, these timeouts can lead to an inconsistency of the model on the target system.
When exporting, the data import schedules are also exported.
Resolution
Delete outdated schedules in the source system manually and then export the model again. This should reduce the overall runtime of the import and the import should complete successfully.
See Also
- 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 incident 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.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.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 visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-XUS , User assistance, performance statistics , Problem