======QoE Stor====== {{indexmenu_n>5}} [[en:dpi:qoe|Product Description]] If you have installed and configured everything according to the instructions, but the “QoE Analytics” section in DPIUI2 is empty, here are the steps to follow before contacting technical support. - Check the time and timezone settings on the DPIUI2 and QoE Stor servers. Try setting a large period in DPIUI2. If the issue is with the timezone, data will appear. Correct the time settings on the DPIUI2 and QoE Stor servers, and fully restart the servers (If you changed the timezone, you need to [[en:dpi:dpi_components:qoestor:commands#delete_db_schema|delete]] and [[en:dpi:dpi_components:qoestor:commands#create_update_database_schema|recreate the database schema]]). - On the QoE Stor server, check if the [[en:dpi:dpi_components:qoestor:commands#check_if_the_database_has_been_created|database is created]]. If not, [[en:dpi:dpi_components:qoestor:commands#create_update_database_schema|create it using the command]]. - On the QoE Stor server, [[en:dpi:dpi_components:qoestor:commands#check_if_there_is_data_in_the_database|check if there is data in the database]]. Alternatively, check how partitions are filling up through the web interface in the QOE ANALYTICS / ADMINISTRATOR / Table Space Information section. - Check if the [[en:dpi:dpi_components:qoestor:commands#check_if_receivers_are_running|receivers are running]] and [[en:dpi:dpi_components:qoestor:commands#restarting_receivers_and_configuration|restart the receivers]] if needed. - On the QoE Stor server, check the receiver logs in the folder ''/var/qoestor/backend/logs''. There should be no errors in the logs. You should see the rotation of dumps and their writing to the database. - On the QoE Stor server, check if ports 1500 and 1501 are being [[en:dpi:dpi_components:qoestor:commands#check_if_the_receivers_are_listening_to_the_ports_and_if_there_is_a_connection|listened to by the receivers]]. - Restart all receivers as a precaution using the [[en:dpi:dpi_components:qoestor:commands#restarting_receivers_and_configuration|command]]. - Double-check the [[en:dpi:dpi_components:qoestor:configuration:dpi|IPFIX export settings on the DPI]]. - On the DPIUI2 server, check the [[en:dpi:dpi_components:dpiui:configuration|GUI connection settings to QoE Stor]]. - On the QoE Stor server, check if the ClickHouse DBMS is running using the [[en:dpi:dpi_components:qoestor:commands#check_if_the_db_is_working|command]]. Ensure there is enough RAM on the server. - On the QoE Stor server, check the ClickHouse logs: /var/log/clickhouse-server/clickhouse-server.err.log If you need to clear all data in the database, on the QoE Stor server: - Delete the database using the [[en:dpi:dpi_components:qoestor:commands#delete_db_schema|command]]. - Recreate the database using the [[en:dpi:dpi_components:qoestor:commands#create_update_database_schema|command]]. Data clearing is performed by the DPIUI2 module. On the server where DPIUI2 is installed, modify the following parameters in the ''/var/www/html/dpiui2/backend/.env'' file: QOESTOR_MAIN_LOG_PARTITIONS_LIFE_TIME_HOUR=2 QOESTOR_AGG_LOG_PARTITIONS_LIFE_TIME_DAYS=15 Restart the service: dpiui2 queue:restart