#201 "FUNCTION jobscheduler.REPORT_GET_COUNTER does not exist" when installing 1.13.11 from scratch

[Tobias Schmid]

I'm trying to install a fresh jobscheduler 1.13.11 instance on an Ubuntu 20.04 server with mysql 8 and the mysql-connector-java-8.0.28.jar connector.

The installer finished but showed an error with the database setup, then I tried to reinstall the tables with ./scheduler_install_tables.sh

Also this process finished but showed the following exception:

[WARN ] (SOSConnectionFileProcessor.java:141) - sos.connection.SOSConnectionFileProcessor.process(70): an error occurred processing file [/opt/jobscheduler/db/mysql/reporting/reporting_agent_procedure.sql]: java.lang.Exception: sos.connection.SOSConnection.executeStatements(2382) : FUNCTION jobscheduler.REPORT_GET_COUNTER does not exist
java.lang.Exception: sos.connection.SOSConnection.executeStatements(2382) : FUNCTION jobscheduler.REPORT_GET_COUNTER does not exist

See the full script output attached.

The database schema was newly create before the installation.

Is there a problem in the sql installation scripts?