KMCng - Analytics - Errors in UI

[mudassir]

Like the following POST:

KMCng - Analytics - Errors in all graphics

When I access to KMCng Analytis y see error in all graphics (Internal server error occurred): [imagen] 2019-04-18 17:52:09 [0.000120] [10.178.174.62] [1143835794] [38] [API] [global] INFO: API-end [0.20371913909912] 2019-04-18 17:52:09 [0.004313] [10.178.174.62] [828574694] [26] [API] [KalturaFrontController->getExceptionObject] CRIT: exception ‘Exception’ with message ‘Cannot find mapping for []’ in /srv_apl/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsSqlFileMgr.class.php:664 Stack …

We’re having similar issue with out analytics. Analytics page has multiple popups that say " Error Internal server error occurred". Here’s our output from the following commands:

# rpm -q kaltura-base kaltura-html5-analytics
kaltura-base-14.19.0-12.noarch
kaltura-html5-analytics-v0.2-2.noarch

# grep kmc_analytics_version /opt/kaltura/app/configurations/base.ini
kmc_analytics_version** = v0.2

Please help. Thanks.

[jess]

Hello @mudassir,

What is the KMCng version?

$ rpm -q kaltura-kmcng

Also, is it possible that the druid_url directive is enabled in /opt/kaltura/app/configurations/local.ini? If so, please comment it out, reload Apache and retry. If it still doesn’t work, start by checking /opt/kaltura/log/kaltura_api_v3.log. Feel free to post your findings here for additional guidance.

Cheers

[mudassir]

@jess

rpm -q kaltura-kmcng

kaltura-kmcng-v5.8.0-1.noarch

The druid directive does not seem to be enabled as I don’t see any entry for it.

Here’s what logs say when I try to access Analytics:

2020-02-10 12:02:12 [0.016254] [172.28.132.255] [1087812017] [1] [API] [KalturaFrontController-
getExceptionObject] ERR: KalturaAPIException: The usage of feature [dropFolder] is forbidden in /opt/kaltura/app/plugins/drop_folder/services/DropFolderService.php:16
Stack trace:
#0 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(255): DropFolderService->initService(‘dropfolder_drop…’, ‘dropFolder’, ‘list’)
#1 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(124): KalturaActionReflector->initService(NULL)
#2 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(114): KalturaDispatcher->dispatch(‘dropfolder_drop…’, ‘list’, Array)
#3 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#4 {main}
2020-02-10 12:02:12 [0.023672] [172.28.132.255] [1125238774] [1] [API] [myReportsMgr::executeQuery] ERR: Exception: Invalid query: Table ‘kalturadw.dwh_hourly_events_entry’ doesn’t exist in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1358): KalturaLog::err(‘Invalid query: …’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT COUNT(DI…’, Object(mysqli))
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(653): myReportsMgr::executeQueryByType(‘101’, ‘1’, 4, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(358): myReportsMgr::getTotalTableCount(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’)
#4 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’, NULL)
#5 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’, NULL, false, Object(kReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘1’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-month_id’, ‘’, Object(KalturaReportResponseOptions))
#7 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#9 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#10 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#11 {main}
2020-02-10 12:02:12 [0.022851] [172.28.132.255] [252478613] [1] [API] [myReportsMgr::executeQuery] ERR: Exception: Invalid query: Table ‘kalturadw.dwh_hourly_events_context_entry_user_app’ doesn’t exist in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1358): KalturaLog::err(‘Invalid query: …’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT \n\tus.nam…’, Object(mysqli))
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(372): myReportsMgr::executeQueryByType(‘101’, ‘11’, 3, Object(endUserReportsInputFilter), 1, 1, ’ count_plays DE…’, ‘’, NULL)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘11’, Object(endUserReportsInputFilter), 1, 1, ‘-count_plays’, ‘’, NULL)
#4 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘11’, Object(endUserReportsInputFilter), 1, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘11’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#9 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#10 {main}
2020-02-10 12:02:12 [0.000122] [172.28.132.255] [252478613] [2] [API] [kCoreException->__construct] ERR: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT \n\tus.nam…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(372): myReportsMgr::executeQueryByType(‘101’, ‘11’, 3, Object(endUserReportsInputFilter), 1, 1, ’ count_plays DE…’, ‘’, NULL)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘11’, Object(endUserReportsInputFilter), 1, 1, ‘-count_plays’, ‘’, NULL)
#3 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘11’, Object(endUserReportsInputFilter), 1, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#4 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘11’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#6 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#8 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#9 {main}
2020-02-10 12:02:12 [0.000157] [172.28.132.255] [1125238774] [2] [API] [kCoreException->__construct] ERR: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT COUNT(DI…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(653): myReportsMgr::executeQueryByType(‘101’, ‘1’, 4, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(358): myReportsMgr::getTotalTableCount(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’, NULL)
#4 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’, NULL, false, Object(kReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘1’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-month_id’, ‘’, Object(KalturaReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#9 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#10 {main}
2020-02-10 12:02:12 [0.000262] [172.28.132.255] [252478613] [3] [API] [KalturaFrontController->getExceptionObject] CRIT: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT \n\tus.nam…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(372): myReportsMgr::executeQueryByType(‘101’, ‘11’, 3, Object(endUserReportsInputFilter), 1, 1, ’ count_plays DE…’, ‘’, NULL)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘11’, Object(endUserReportsInputFilter), 1, 1, ‘-count_plays’, ‘’, NULL)
#3 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘11’, Object(endUserReportsInputFilter), 1, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#4 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘11’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#6 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#8 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#9 {main}
2020-02-10 12:02:12 [0.000267] [172.28.132.255] [1125238774] [3] [API] [KalturaFrontController->getExceptionObject] CRIT: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT COUNT(DI…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(653): myReportsMgr::executeQueryByType(‘101’, ‘1’, 4, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(358): myReportsMgr::getTotalTableCount(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’, NULL)
#4 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 25, 1, ‘-month_id’, ‘’, NULL, false, Object(kReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘1’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-month_id’, ‘’, Object(KalturaReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#9 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#10 {main}
2020-02-10 12:02:12 [0.009138] [172.28.132.255] [1125238774] [4] [API] [myReportsMgr::executeQuery] ERR: Exception: Invalid query: Table ‘kalturadw.dwh_hourly_partner’ doesn’t exist in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1358): KalturaLog::err(‘Invalid query: …’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(’/* Plays | Uni…’, Object(mysqli))
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(287): myReportsMgr::executeQueryByType(‘101’, ‘1’, 2, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5842): myReportsMgr::getTotal(‘101’, ‘1’, Object(endUserReportsInputFilter), ‘’)
#4 /opt/kaltura/app/api_v3/services/ReportService.php(127): kKavaReportsMgr::getTotal(‘101’, ‘1’, Object(endUserReportsInputFilter), ‘’, Object(kReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTotalAction(‘1’, Object(KalturaEndUserReportInputFilter), ‘’, Object(KalturaReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettotal’, Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#9 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#10 {main}
2020-02-10 12:02:12 [0.000122] [172.28.132.255] [1125238774] [5] [API] [kCoreException->__construct] ERR: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(’/* Plays | Uni…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(287): myReportsMgr::executeQueryByType(‘101’, ‘1’, 2, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5842): myReportsMgr::getTotal(‘101’, ‘1’, Object(endUserReportsInputFilter), ‘’)
#3 /opt/kaltura/app/api_v3/services/ReportService.php(127): kKavaReportsMgr::getTotal(‘101’, ‘1’, Object(endUserReportsInputFilter), ‘’, Object(kReportResponseOptions))
#4 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTotalAction(‘1’, Object(KalturaEndUserReportInputFilter), ‘’, Object(KalturaReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#6 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettotal’, Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#8 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#9 {main}
2020-02-10 12:02:12 [0.000077] [172.28.132.255] [1125238774] [6] [API] [KalturaFrontController->getExceptionObject] CRIT: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(’/* Plays | Uni…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(287): myReportsMgr::executeQueryByType(‘101’, ‘1’, 2, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5842): myReportsMgr::getTotal(‘101’, ‘1’, Object(endUserReportsInputFilter), ‘’)
#3 /opt/kaltura/app/api_v3/services/ReportService.php(127): kKavaReportsMgr::getTotal(‘101’, ‘1’, Object(endUserReportsInputFilter), ‘’, Object(kReportResponseOptions))
#4 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTotalAction(‘1’, Object(KalturaEndUserReportInputFilter), ‘’, Object(KalturaReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#6 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettotal’, Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#8 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#9 {main}
2020-02-10 12:02:13 [0.022116] [172.28.132.255] [1590677246] [1] [API] [myReportsMgr::executeQuery] ERR: Exception: Invalid query: Table ‘kalturadw.dwh_hourly_events_entry’ doesn’t exist in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1358): KalturaLog::err(‘Invalid query: …’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT COUNT(DI…’, Object(mysqli))
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(653): myReportsMgr::executeQueryByType(‘101’, ‘1’, 4, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(358): myReportsMgr::getTotalTableCount(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’)
#4 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’, NULL)
#5 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘1’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#7 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#9 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#10 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#11 {main}
2020-02-10 12:02:13 [0.000106] [172.28.132.255] [1590677246] [2] [API] [kCoreException->__construct] ERR: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT COUNT(DI…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(653): myReportsMgr::executeQueryByType(‘101’, ‘1’, 4, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(358): myReportsMgr::getTotalTableCount(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’, NULL)
#4 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘1’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#9 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#10 {main}
2020-02-10 12:02:13 [0.000203] [172.28.132.255] [1590677246] [3] [API] [KalturaFrontController->getExceptionObject] CRIT: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT COUNT(DI…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(653): myReportsMgr::executeQueryByType(‘101’, ‘1’, 4, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(358): myReportsMgr::getTotalTableCount(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’, NULL)
#4 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘1’, Object(endUserReportsInputFilter), 50, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘1’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#9 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#10 {main}
2020-02-10 12:02:13 [0.020944] [172.28.132.255] [1792560023] [1] [API] [myReportsMgr::executeQuery] ERR: Exception: Invalid query: Table ‘kalturadw.dwh_hourly_events_domain’ doesn’t exist in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1358): KalturaLog::err(‘Invalid query: …’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT \n\tev_sta…’, Object(mysqli))
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(372): myReportsMgr::executeQueryByType(‘101’, ‘6’, 3, Object(endUserReportsInputFilter), 5, 1, ’ count_plays DE…’, ‘’, NULL)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘6’, Object(endUserReportsInputFilter), 5, 1, ‘-count_plays’, ‘’, NULL)
#4 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘6’, Object(endUserReportsInputFilter), 5, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘6’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#9 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#10 {main}
2020-02-10 12:02:13 [0.000130] [172.28.132.255] [1792560023] [2] [API] [kCoreException->__construct] ERR: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT \n\tev_sta…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(372): myReportsMgr::executeQueryByType(‘101’, ‘6’, 3, Object(endUserReportsInputFilter), 5, 1, ’ count_plays DE…’, ‘’, NULL)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘6’, Object(endUserReportsInputFilter), 5, 1, ‘-count_plays’, ‘’, NULL)
#3 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘6’, Object(endUserReportsInputFilter), 5, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#4 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘6’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#6 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#8 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#9 {main}
2020-02-10 12:02:13 [0.000213] [172.28.132.255] [1792560023] [3] [API] [KalturaFrontController->getExceptionObject] CRIT: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT \n\tev_sta…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(372): myReportsMgr::executeQueryByType(‘101’, ‘6’, 3, Object(endUserReportsInputFilter), 5, 1, ’ count_plays DE…’, ‘’, NULL)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(5538): myReportsMgr::getTable(‘101’, ‘6’, Object(endUserReportsInputFilter), 5, 1, ‘-count_plays’, ‘’, NULL)
#3 /opt/kaltura/app/api_v3/services/ReportService.php(215): kKavaReportsMgr::getTable(‘101’, ‘6’, Object(endUserReportsInputFilter), 5, 1, ‘-count_plays’, ‘’, NULL, false, Object(kReportResponseOptions))
#4 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getTableAction(‘6’, Object(KalturaEndUserReportInputFilter), Object(KalturaFilterPager), ‘-count_plays’, ‘’, Object(KalturaReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#6 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘gettable’, Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#8 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#9 {main}
2020-02-10 12:02:13 [0.008912] [172.28.132.255] [1792560023] [4] [API] [myReportsMgr::executeQuery] ERR: Exception: Invalid query: Table ‘kalturadw.dwh_hourly_events_domain’ doesn’t exist in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1358): KalturaLog::err(‘Invalid query: …’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT\n\tDATE(DA…’, Object(mysqli))
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(115): myReportsMgr::executeQueryByType(‘101’, ‘6’, 1, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#3 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(3737): myReportsMgr::getGraph(‘101’, ‘6’, Object(endUserReportsInputFilter), ‘’, ‘’)
#4 /opt/kaltura/app/api_v3/services/ReportService.php(96): kKavaReportsMgr::getGraph(‘101’, ‘6’, Object(endUserReportsInputFilter), ‘’, ‘’, Object(kReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getGraphsAction(‘6’, Object(KalturaEndUserReportInputFilter), ‘’, ‘’, Object(KalturaReportResponseOptions))
#6 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘getgraphs’, Array)
#8 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#9 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#10 {main}
2020-02-10 12:02:13 [0.000074] [172.28.132.255] [1792560023] [5] [API] [kCoreException->__construct] ERR: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT\n\tDATE(DA…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(115): myReportsMgr::executeQueryByType(‘101’, ‘6’, 1, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(3737): myReportsMgr::getGraph(‘101’, ‘6’, Object(endUserReportsInputFilter), ‘’, ‘’)
#3 /opt/kaltura/app/api_v3/services/ReportService.php(96): kKavaReportsMgr::getGraph(‘101’, ‘6’, Object(endUserReportsInputFilter), ‘’, ‘’, Object(kReportResponseOptions))
#4 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getGraphsAction(‘6’, Object(KalturaEndUserReportInputFilter), ‘’, ‘’, Object(KalturaReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#6 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘getgraphs’, Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#8 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#9 {main}
2020-02-10 12:02:13 [0.000084] [172.28.132.255] [1792560023] [6] [API] [KalturaFrontController->getExceptionObject] CRIT: kCoreException: Invalid query in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1360
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(‘SELECT\n\tDATE(DA…’, Object(mysqli))
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(115): myReportsMgr::executeQueryByType(‘101’, ‘6’, 1, Object(endUserReportsInputFilter), NULL, NULL, NULL, ‘’)
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/kKavaReportsMgr.class.php(3737): myReportsMgr::getGraph(‘101’, ‘6’, Object(endUserReportsInputFilter), ‘’, ‘’)
#3 /opt/kaltura/app/api_v3/services/ReportService.php(96): kKavaReportsMgr::getGraph(‘101’, ‘6’, Object(endUserReportsInputFilter), ‘’, ‘’, Object(kReportResponseOptions))
#4 /opt/kaltura/app/api_v3/lib/reflection/KalturaActionReflector.php(233): ReportService->getGraphsAction(‘6’, Object(KalturaEndUserReportInputFilter), ‘’, ‘’, Object(KalturaReportResponseOptions))
#5 /opt/kaltura/app/api_v3/lib/KalturaDispatcher.php(130): KalturaActionReflector->invoke(Array)
#6 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(312): KalturaDispatcher->dispatch(‘report’, ‘getgraphs’, Array)
#7 /opt/kaltura/app/api_v3/lib/KalturaFrontController.php(105): KalturaFrontController->handleMultiRequest()
#8 /opt/kaltura/app/api_v3/web/index.php(32): KalturaFrontController->run()
#9 {main}
2020-02-10 12:02:13 [0.008571] [172.28.132.255] [1792560023] [7] [API] [myReportsMgr::executeQuery] ERR: Exception: Invalid query: Table ‘kalturadw.dwh_hourly_events_domain’ doesn’t exist in /opt/kaltura/app/infra/log/KalturaLog.php:88
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1358): KalturaLog::err(‘Invalid query: …’)
#1 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(902): myReportsMgr::executeQuery(’/* Plays | Uni…’, Object(mysqli))
#2 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(287): myReportsMgr::executeQueryByType(‘101’, ‘6’, 2, Object(endUserReportsInputFilter),

[jess]

Hello,

As you can see from the log you posted, tables critical to the analytics mechanism (aka DWH) do no exist.

@mudassir

2020-02-10 12:02:12 [0.023672] [172.28.132.255] [1125238774] [1] [API] [myReportsMgr::executeQuery] ERR: Exception: Invalid query: Table ‘kalturadw.dwh_hourly_events_entry’ doesn’t exist in /opt/kaltura/app/infra/log/KalturaLog.php:88

Please review https://github.com/kaltura/platform-install-packages/blob/Orion-15.17.0/doc/kaltura-packages-faq.md#analytics-issues

And make sure to use MySQL <= 5.5 for this.