After running : php /opt/kaltura/bin/dwh_cycle.php /opt/kaltura/bin/sanity_config.ini
I got result echo:
KalturaReportTable Object
(
[header] =>
[data] =>
[totalCount] =>
[relatedObjects] =>
)
KalturaReportInputFilter Object
(
[keywords] =>
[searchInTags] =>
[searchInAdminTags] =>
[categories] =>
[timeZoneOffset] => -540
[interval] =>
[fromDate] =>
[toDate] =>
[fromDay] => 20160720
[toDay] => 20160721
[relatedObjects] =>
)
KalturaFilterPager Object
(
[pageSize] =>
[pageIndex] =>
[relatedObjects] =>
)
entry id: 0_4862nk69
Reported wrong total count []
I got log file:
tail -f /opt/kaltura/dwh/logs/log_storage_usage_calc_storage_usage.log
2016/07/21 10:28:11 - calc_storage_usage - Starting entry [Add Storage Usage Missing Days]
2016/07/21 10:28:11 - Add Storage Usage Missing Days - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/aggregation/add_aggr_missing_days.ktr]
2016/07/21 10:28:11 - add_aggr_missing_days - Dispatching started for transformation [add_aggr_missing_days]
2016/07/21 10:28:11 - Table input.0 - Finished reading query, closing connection.
2016/07/21 10:28:11 - calc_storage_usage - Starting entry [Calc storage usage]
2016/07/21 10:28:11 - Calc storage usage - Loading transformation from XML file [/opt/kaltura/dwh/etlsource/storage_usage/calc_storage_usage.ktr]
2016/07/21 10:28:11 - calc_storage_usage - Dispatching started for transformation [calc_storage_usage]
2016/07/21 10:28:11 - Table input.0 - Finished reading query, closing connection.
2016/07/21 10:28:11 - Table input.0 - Finished processing (I=38, O=0, R=0, W=38, U=0, E=0)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Unexpected error
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Error while running this step!
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Couldn't execute SQL: Call kalturadw.calc_entries_sizes(20160513)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Table has no partition for value 20160513
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:208)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at java.lang.Thread.run(Unknown Source)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Couldn't execute SQL: Call kalturadw.calc_entries_sizes(20160513)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Table has no partition for value 20160513
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) :
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1650)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1595)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.core.database.Database.execStatements(Database.java:1800)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.trans.steps.sql.ExecSQL.processRow(ExecSQL.java:182)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : ... 2 more
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Caused by: java.sql.SQLException: Table has no partition for value 20160513
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : at org.pentaho.di.core.database.Database.execStatement(Database.java:1618)
2016/07/21 10:28:12 - Execute SQL script.0 - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : ... 5 more
2016/07/21 10:28:12 - Execute SQL script.0 - Finished reading query, closing connection.
2016/07/21 10:28:12 - calc_storage_usage - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Errors detected!
2016/07/21 10:28:12 - Execute SQL script.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2016/07/21 10:28:12 - calc_storage_usage - ERROR (version 4.2.1-stable, build 15952 from 2011-10-25 15.27.10 by buildguy) : Errors detected!
2016/07/21 10:28:12 - calc_storage_usage - calc_storage_usage
2016/07/21 10:28:12 - calc_storage_usage - calc_storage_usage
2016/07/21 10:28:12 - calc_storage_usage - Finished job entry [Calc storage usage] (result=[false])
2016/07/21 10:28:12 - calc_storage_usage - Finished job entry [Add Storage Usage Missing Days] (result=[false])
Please help me know what the problem. Thank you very much.