Analytics problem The table 'today_sizes' is full

Community Forums Backend Server Support
1

Hello,

My analytics just stopped working, showing N/A in my rows
I reinstalled kaltura-dwh rpm, and re ran kaltura-dwh-config-sh

I updated the dim_sync_last_update putting and old day
to see if I can process the missing data, and I got this error:

ERROR 24-08 09:56:51,825 - Execute SQL script - Unexpected error
ERROR 24-08 09:56:51,826 - Execute SQL script - org.pentaho.di.core.exception.KettleStepException:
Error while running this step!

Couldn’t execute SQL: Call kalturadw.calc_entries_sizes(20150817)

The table ‘today_sizes’ is full
at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:208)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Couldn’t execute SQL: Call kalturadw.calc_entries_sizes(20150817)

The table ‘today_sizes’ is full

any clues?
thank you very much

2

Hi @aquileasfx1,

Can you try
mysql> DROP TABLE IF EXISTS today_sizes;

and re-run the scripts?

3

Hello Jess,

thank you very much for your reply

I ran that query, and still:

ERROR 24-08 11:04:13,818 - Execute SQL script - Unexpected error
ERROR 24-08 11:04:13,819 - Execute SQL script - org.pentaho.di.core.exception.KettleStepException:
Error while running this step!

Couldn’t execute SQL: Call kalturadw.calc_entries_sizes(20150817)

The table ‘today_sizes’ is full

Note that I’m trying to execute an old day “20150817”

4

Hi @aquileasfx1,

Can you look at: