Analytics Error -

voneddie · August 26, 2020, 8:16am

Hi. When i run kaltura-run-dwh.sh the statistics do not update.
The logs show this

/opt/kaltura/dwh/logs/etl_perform_retention_policy-20200826.log:ERROR 26-08 09:47:17,446 - Move old partitions to archive - An error occurred executing this job entry :
/opt/kaltura/dwh/logs/etl_perform_retention_policy-20200826.log:ERROR 26-08 09:47:17,463 - Kitchen - Finished with errors
/opt/kaltura/dwh/logs/etl_update_dims-20200826-09.log:ERROR 26-08 09:46:52,170 - Mapping with Field Input - Unexpected error
/opt/kaltura/dwh/logs/etl_update_dims-20200826-09.log:ERROR 26-08 09:46:52,198 - Mapping with Field Input - org.pentaho.di.core.exception.KettleException:
/opt/kaltura/dwh/logs/etl_update_dims-20200826-09.log:ERROR 26-08 09:46:52,406 - iterate_sequences - Errors detected!
/opt/kaltura/dwh/logs/etl_update_dims-20200826-09.log:ERROR 26-08 09:46:52,406 - iterate_sequences - Errors detected!
/opt/kaltura/dwh/logs/etl_update_dims-20200826-10.log:ERROR 26-08 10:00:16,691 - Mapping with Field Input - Unexpected error
/opt/kaltura/dwh/logs/etl_update_dims-20200826-10.log:ERROR 26-08 10:00:16,691 - Mapping with Field Input - org.pentaho.di.core.exception.KettleException:
/opt/kaltura/dwh/logs/etl_update_dims-20200826-10.log:ERROR 26-08 10:00:16,872 - iterate_sequences - Errors detected!
/opt/kaltura/dwh/logs/etl_update_dims-20200826-10.log:ERROR 26-08 10:00:16,872 - iterate_sequences - Errors detected!

java -version
openjdk version “1.8.0_262”
OpenJDK Runtime Environment (build 1.8.0_262-b10)
OpenJDK 64-Bit Server VM (build 25.262-b10, mixed mode)

MariaDB select version();
±---------------+
| version() |
±---------------+
| 5.5.65-MariaDB |
±---------------+
1 row in set (0.00 sec)

angober · August 27, 2020, 2:19pm

You can try to run in BBDD (MariaDB) to see if it works for you:
CALL kalturadw.add_partitions();

github.com

kaltura/platform-install-packages/blob/master/doc/kaltura-packages-faq.md

# Frequently Asked Questions

### Before You Get Started Notes
* If you see a `#` at the beginning of a line, this line should be run as `root`.

### Commercial Editions and Paid Support

The Open Source Kaltura Platform is provided under the [AGPLv3 license](http://www.gnu.org/licenses/agpl-3.0.html) and with no commercial support or liability.  

[Kaltura Inc.](http://corp.kaltura.com) also provides commercial solutions and services including pro-active platform monitoring, applications, SLA, 24/7 support and professional services. If you're looking for a commercially supported video platform  with integrations to commercial encoders, streaming servers, eCDN, DRM and more - Start a [Free Trial of the Kaltura.com Hosted Platform](http://corp.kaltura.com/free-trial) or learn more about [Kaltura' Commercial OnPrem Edition™](http://corp.kaltura.com/Deployment-Options/Kaltura-On-Prem-Edition). For existing RPM based users, Kaltura offers commercial upgrade options.

### How to contribute
We value contributions from our Community Edition user base very much. To make a contribution, follow the [See our CONTRIBUTERS doc](https://github.com/kaltura/platform-install-packages/blob/master/doc/CONTRIBUTERS.md).


### Changing Apache configurations post install.

Sometimes, you may want to change deployment settings post installation, for example: replacing the domain, port or protocol, or changing the system to use SSL or stop using SSL.   
You can run `/opt/kaltura/bin/kaltura-front-config.sh` as many times as you'd like with different values. The script will re-configure the system accordingly.   
For instance, you may want to change the service URL, port or protocol.

This file has been truncated. show original