Skip to main content
Question

While loading the data model, I am getting the below error message. Could you help me with increasing the limit or any other alternative?

  • January 19, 2024
  • 2 replies
  • 20 views

richa.patel
Level 2
Forum|alt.badge.img+3

The load failed: Load failed. Error Message: Table "XYZ" has 7,145,120,256 rows. The current limit is 5,000,000,000 rows. 

2 replies

Sverre Klein
Level 10
Forum|alt.badge.img+14
  • Level 10
  • January 20, 2024

Hi Richa,

 

I think it is not possible to increase the limit for the data model load.

 

As an alternative, you could

 

1) Force the created table to contain 5.000.000 rows by using the LIMIT statement in SQL.

You would do this after an SELECT FROM statement, for example:

 

SELECT *

FROM your_table

LIMIT 5000000;

 

2) Aggregate the data rows that is not required at a granular level, such as activities that don't add much value.

 

Let me know if you need more help.

 

 

 


mukesh.gupta11
Level 7
Forum|alt.badge.img+15

Hi Richa,

 

Check with the Celonis Service desk, they can help.