AnsweredAssumed Answered

SQL error with Enterprise Dashboard CIC

Question asked by Benoit_B on Mar 3, 2017
Latest reply on Mar 6, 2017 by Benoit_B

Hello Community,

 

I have configured Enterprise Dashboad CIC. 

Running with Mysql, there are SQL errors : 

017-03-03 09:09:15,672Z (09:09) [Event Sink Thread Pool Thread 2] INFO  org.eclipse.persistence        -  Communication failure detected when attempting to perform read query outside of a transaction. Attempting to retry query. Error was: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'CIC.DRADISCACHE' doesn't exist Error Code: 1146 Call: SELECT ID, DATA FROM DRADISCACHE Query: ReadAllQuery(referenceClass=DbDradisCache sql="SELECT ID, DATA FROM DRADISCACHE"). 

 

With Derby configuration, there is no SQL error.

As specified here Database Requirements, I was trying to setup Mysql for EDB CIC. But is it really helpful/necessary ?

 

Regards,

 

Benoit

Outcomes