3643830 - Import Errors Due to Invalid Date Values in SAP Analytics Cloud (SAC)

• An error appear while attempting to import a dimension into the target tenant through content network. The error message states: "Couldn't import object 'Object name': Failed to execute statement exec. Component = Statement. Reason = invalid DATE, TIME or TIMESTAMP value: SQL Error." 
• The error appears despite there is no timestamp property or validation error in the dimension.
• The issue persists whether the dimension is transported with or without data.  

SAP ANALYTICS CLOUD 2025.8.17

1. Login to SAC.
2. Navigate to Transport / Export/ Content Network / My content
3. Click on New Export and select Dimension in Object Types.
4. Fill all the details and in destination provide the URL of tenant and complete the process.
5. Login to Target tenant.
6. Navigate to Transport / Import 
7. Click on the package you just exported from Test tenant
8. In Overview tab scroll down and accept the terms and conditions
9. In Import Options tab select "Overwrite objects and data"  and Deselect the connections as Support users are not allowed to modify connections, Then click on Import.
10. Notice the error "Couldn't import object 'Object Name': Failed to execute statement exec. Component = Statement. Reason = invalid DATE, TIME or TIMESTAMP value: SQL Error."  

The error is caused by a 5-digit year value ("10000-01-01T04:55:00Z") in the recurrence end time of a job group in the dimension, which was incompatible with the importing code.  

The recurrence end time for the job group in the dimension must be adjusted to a valid date earlier than Dec 30th, 9999.  

• 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 visit the solution finder today!

import error, invalid date, SAP analytics cloud, dimension, recurrence end time , KBA , LOD-ANA-ACN , SAC Content Network , Problem