DWH Table has no partition Error, kalturadw.calc_entries_sizes

Hello, while runing etl_daily I have the following error:
can somebody help me please?

INFO 08-11 13:49:14,207 - execute kjb file - Starting entry [Run kjbVar job]
INFO 08-11 13:49:15,140 - calc_storage_usage - Starting entry [Add Storage Usage Missing Days]
INFO 08-11 13:49:15,141 - Add Storage Usage Missing Days - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/storage_usage/add_storage_usage_missing_days.ktr]
INFO 08-11 13:49:15,167 - add_storage_usage_missing_days - Dispatching started for transformation [add_storage_usage_missing_days]
INFO 08-11 13:49:15,198 - Table input - Finished reading query, closing connection.
INFO 08-11 13:49:15,212 - calc_storage_usage - Starting entry [Calc storage usage]
INFO 08-11 13:49:15,213 - Calc storage usage - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/storage_usage/calc_storage_usage.ktr]
INFO 08-11 13:49:15,232 - calc_storage_usage - Dispatching started for transformation [calc_storage_usage]
INFO 08-11 13:49:15,254 - Table input - Finished reading query, closing connection.
INFO 08-11 13:49:15,255 - Table input - Finished processing (I=7, O=0, R=0, W=7, U=0, E=0)
ERROR 08-11 13:49:15,265 - Execute SQL script - Unexpected error
ERROR 08-11 13:49:15,266 - Execute SQL script - org.pentaho.di.core.exception.KettleStepException:
Error while running this step!

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

Table has no partition for value 20151101

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(20151101)

Table has no partition for value 20151101


thank you very much.

I solved by using:

call kalturadw.add_partitions();

on mysql server.

thank you

Hi @aquileasfx1,

Indeed, that is what was needed.
For future reference: https://github.com/kaltura/platform-install-packages/blob/Kajam-11.1.0/doc/kaltura-packages-faq.md#analytics-issues