Using Mysql as repository database

[chahal...@raxa.com]

Hello,

I am trying to using Mysql 5.7 as the repository database for Pentaho user console 8.1. I have used the following documentation -

https://help.pentaho.com/Documentation/8.1/Setup/Installation/Archive/MySQL_Repository

but getting the error in the tomcat logs:

20-Jul-2018 13:37:40.892 INFO [Thread-11] org.apache.karaf.main.Main$KarafLockCallback.lockAquired Lock acquired. Setting startlevel to 100

Updating configuration from org.ops4j.pax.web.cfg

Updating configuration from org.apache.activemq.webconsole.cfg

Updating configuration from org.apache.karaf.management.cfg

Updating configuration from org.apache.karaf.shell.cfg

13:37:42,580 ERROR [BootFeaturesInstaller] Error Boot feature pdi-engine-configuration not found

13:37:42,581 ERROR [BootFeaturesInstaller] Error Boot feature community-edition not found

13:37:42,581 ERROR [BootFeaturesInstaller] Error Boot feature camel-jms not found

13:37:42,581 ERROR [BootFeaturesInstaller] Error Boot feature pentaho-server not found

13:37:42,581 ERROR [BootFeaturesInstaller] Error Boot feature pentaho-marketplace not found

13:37:42,581 ERROR [BootFeaturesInstaller] Error Boot feature management not found

13:37:42,581 ERROR [BootFeaturesInstaller] Error Boot feature camel not found

13:37:42,581 ERROR [BootFeaturesInstaller] Error Boot feature camel-blueprint not found

13:37:42,581 ERROR [BootFeaturesInstaller] Error Boot feature pentaho-metaverse not found

13:37:42,582 ERROR [BootFeaturesInstaller] Error Boot feature camel-stream not found

13:37:42,582 ERROR [BootFeaturesInstaller] Error Boot feature config not found

13:37:42,582 ERROR [BootFeaturesInstaller] Error Boot feature kar not found

13:37:42,582 ERROR [BootFeaturesInstaller] Error Boot feature pentaho-dataservice-legacy not found

13:38:03,223 INFO  [PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.

13:38:33,225 INFO  [PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.

13:39:03,228 INFO  [PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.

13:39:33,234 INFO  [PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.

13:39:56,956 ERROR [ErrorLogger] An error occured while scanning for the next trigger to fire.

org.quartz.JobPersistenceException: Couldn't acquire next trigger: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1]

at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2785)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2728)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2724)

at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=5' at line 1

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)

at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1606)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2268)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)

at com.sun.proxy.$Proxy55.executeQuery(Unknown Source)

at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2921)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2742)

... 4 more

I am not sure how to solve the issue -  Error Boot feature not found. Also, I checked that Pentaho 8.1 supports Mysql 5.6 & 5.7 and I a using 5.7 so not sure why the version number issue is coming?

Any help will be highly appreciated.

Thanks and Regards

Chahal Arora