3628824 - Error: Data Import Fails Due to Exceeding Character Limit in SAC Model Using OData Connection from Datasphere

•  When trying to create a dataset using an OData Connection from Datasphere, the error is displayed: 
• "Query results exceeded the cell character limit of 4998 in column XXX. Please edit your query to acquire fewer characters."
• From the error message in the HAR file: "LIMIT_EXCEEDED_CELL_LENGTH - errorDefinition": "{\"errorCode\":274,\"errorMessage\":\"SAP DBTech JDBC: [274]: inserted value too large for column: Failed in \\\"XXX\\\" 

SAP Analytics Cloud 2025.8.5

1. 1. Log into SAC;
   2. Go to Dataset > Try to create one using the OData Connection from Datasphere
   3. Select the field (Dimension) 'XXX' as Selected Data and try to create the dataset
   4. It throws the error above

• The error occurs because the size defined for the XXX column does not accommodate the length of all incoming data points. 
• Columns must be defined with appropriate lengths to ensure all data can be imported without issues. In this instance, the column length defined on Datasphere needs to be adjusted.

1. Review and Adjust Column Size: Increase the character limit for the XXX column in your Datasphere source system. This change should allow larger string values to be imported without error.

2. Data Validation: Conduct a quick check on the data format and ensure all entries conform to expected types and lengths. For values that might be exceptionally long, consider truncation or processing them separately as needed.

• 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 a case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
  • https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
  • 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!

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

SAC, error, Datasphere, model, dataset, limit exceeded, cell, length, Analytics Cloud, limit, character, column, query, data , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem