Internal Server Error occurred after logging in

errorcodes

#1

Hi

After logging in KMC, I got a pop up “Internal Server Error occurred”.

Kaltlog shows:

2017-08-30 04:55:36 [0.001391] [180.151.85.198] [103783215] [29] [API] [myReportsMgr::executeQuery] ERR: exception ‘Exception’ with message ‘Invalid query: Table ‘kalturadw.dwh_hourly_partner’ doesn’t exist’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1343): KalturaLog::err(‘Invalid query: …’)

#10 {main}
2017-08-30 04:55:36 [0.000549] [180.151.85.198] [103783215] [30] [API] [kCoreException->__construct] ERR: exception ‘kCoreException’ with message ‘Invalid query’ in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1345
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(884): myReportsMgr::executeQuery(’?SELECT??DATE(D…’, Object(mysqli))

2017-08-30 04:55:36 [0.000293] [180.151.85.198] [103783215] [31] [API] [myReportsMgr::executeQueryByType] NOTICE: Invalid query
2017-08-30 04:55:36 [0.000515] [180.151.85.198] [103783215] [32] [API] [KalturaFrontController->getExceptionObject] CRIT: exception ‘kCoreException’ with message ‘Invalid query’ in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1345
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(884): myReportsMgr::executeQuery(’?SELECT??DATE(D…’, Object(mysqli))

2017-08-30 04:55:36 [0.001144] [180.151.85.198] [103783215] [50] [API] [myReportsMgr::executeQuery] ERR: exception ‘Exception’ with message ‘Invalid query: PROCEDURE kalturadw.calc_partner_usage_data does not exist’ in /opt/kaltura/app/infra/log/KalturaLog.php:83
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(1343): KalturaLog::err(‘Invalid query: …’)

#11 {main}
2017-08-30 04:55:36 [0.000416] [180.151.85.198] [103783215] [51] [API] [kCoreException->__construct] ERR: exception ‘kCoreException’ with message ‘Invalid query’ in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1345
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(884): myReportsMgr::executeQuery(’?CALL kalturadw…’, Object(mysqli))

2017-08-30 04:55:36 [0.000251] [180.151.85.198] [103783215] [52] [API] [myReportsMgr::executeQueryByType] NOTICE: Invalid query
2017-08-30 04:55:36 [0.000320] [180.151.85.198] [103783215] [53] [API] [KalturaFrontController->getExceptionObject] CRIT: exception ‘kCoreException’ with message ‘Invalid query’ in /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php:1345
Stack trace:
#0 /opt/kaltura/app/alpha/apps/kaltura/lib/reports/myReportsMgr.class.php(884): myReportsMgr::executeQuery(’?CALL kalturadw…’, Object(mysqli))

Same thing happens under analytics tab.

2 popups basically.

Please help.


#2

Hi @ankit-devops-oodles,

You’re missing at least some of the DWH tables.
Did you run kaltura-dwh-config.sh? does the kalturadw DB exist at all?