SAP Knowledge Base Article - Public

3231657 - Model import with TGZ file fails with error "[Object ID] already exist." in SAP Analytics Cloud (SAC)

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

  1. Login to SAC tenant.
  2. Go to Transport - Import - File System.
  3. Try to import the TGZ file created as per KBA 2538909 - topic "Using the Transport (file) Method (zipped / .TGZ files)".
  4. Upload - Select Source File - Upload - OK.
  5. Import.
  6. Select import options e.g. "Update existing object" and "Drop Objects".
  7. 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

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.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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

Product

SAP Analytics Cloud 1.0