Im using MySQL version 5.7.29
The JDBC Driver installed my default is 5.1.17
I had no issues creating a new datasource but im not sure a new datasource is what you want. The datasource wizard is usually used in Pentaho Enterprise tools and its not used at all for SuiteCRM Analytics. When the server is installed you already have a connection (datasource) to the SuiteCRMAnalytics Data Warehouse that you can use to build reports from.
I will be releasing some documentation on building reports on the next release coming soon
Its possible indeed but the way it is done is via the Report Designer. You create a new report in the designer, write your SQL to join the tables in the data warehouse for your query (Quotes to Users for example) and then publish that report to the server.
In the report designer you can create a simple JDBC connection to the Data warehouse to write your query. Be sure to name the connection exactly the same (SuiteCRMAnaltics) as it is on the live server so it all matches up.
There isn’t a whole lot of documentation for this release but there will be more in the next release to help users create their own content.
I keep running into this issue while trying to install.
Checking database Connections…
./kitchen.sh: line 9: ./kitchen.sh: No such file or directory
We could not establish a connection to the SuiteCRM database!
Please check the JDBC connection properties and run setup again.
We will configure your email properties and send you a test email
If you do not get this email then please check the log in …
./pan.sh: line 8: ./pan.sh: No such file or directory
Context
The database is hosted on a plesk server along with the SuiteCRM dashboard.
I’m trying to configure all three to use the same server with subdomains.
Been following them for the last 48 hours.
Switched to 3 different environments and the same error every time.
Even tried with local sql databases because I thought remote was the issue.
Request
Could you provide the environment specifications for optimal install & performance?
Installing...
Checking database Connections...
./kitchen.sh: line 9: ./kitchen.sh: No such file or directory
We could not establish a connection to the SuiteCRM database!
Please check the JDBC connection properties and run setup again.
We will configure your email properties and send you a test email
If you do not get this email then please check the log in ......
./pan.sh: line 8: ./pan.sh: No such file or directory
My MYSQL database is on a remote server an accessible (Tested)
I’m new to Pentaho so I barely understand the kitchen script and its use.
I redid the same steps using the zip files from https://suitecrm.com/suitecrm-analytics-tool/ and it worked for both the analytics and the data integration. I don’t know why that worked and gitclone didn’t.
Hi, am new to Suitecrm analytics.
I have installed it and when I am running the dashboard it’s through this "Error processing component (totalCreatedLeadsLineChartComponent).
"
Hi there im trying setup SuiteCRM Data Integration and SuiteCRM Web Analytics for two weeks without sucess, i tried ubuntu 20 , centos 8 and right on im on redhat 8, when i install data integration on demo always gives error on any OS.
Finally on redhat 8 is not giving any error on dashboard, but i cant get any report , nothing shows, in attach i send the catalina.out file to see if someone can help here.catalina.zip (11.7 KB)
I am trying to install the tool.
I already did what was recommended to me in
and
the data integration runs fine.
but the analytics does not execute and throws the following errors in the tomcat log:
22-Jul-2021 18:31:51.086 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [suitecrmanalytics] created a ThreadLocal with key of type [java.lang.InheritableThreadLocal] (value [java.lang.InheritableThreadLocal@7d951cf2]) and a value of type [org.springframework.security.core.context.SecurityContextImpl] (value [org.springframework.security.core.context.SecurityContextImpl@10358fcb: Authentication: org.springframework.security.authentication.UsernamePasswordAuthenticationToken@10358fcb: Principal: 05f96345-c37e-4e5e-8c21-ff0fe62682bb; Credentials: [PROTECTED]; Authenticated: false; Details: null; Not granted any authorities]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
22-Jul-2021 18:31:51.086 SEVERE [localhost-startStop-1] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [suitecrmanalytics] created a ThreadLocal with key of type [java.lang.InheritableThreadLocal] (value [java.lang.InheritableThreadLocal@4c9b7b83]) and a value of type [org.pentaho.platform.engine.core.system.StandaloneSession] (value [org.pentaho.platform.engine.core.system.StandaloneSession@2a6347f3]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
22-Jul-2021 18:31:51.102 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler [“http-nio-8080”]
22-Jul-2021 18:31:51.105 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler [“ajp-nio-8009”]
22-Jul-2021 18:31:51.108 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler [“http-nio-8080”]
22-Jul-2021 18:31:51.109 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler [“ajp-nio-8009”]
Exception in thread “Thread-15” java.lang.NoClassDefFoundError: org/apache/commons/vfs2/impl/PrivilegedFileReplicator$CloseAction
at org.apache.commons.vfs2.impl.PrivilegedFileReplicator.close(PrivilegedFileReplicator.java:95)
at org.apache.commons.vfs2.impl.DefaultFileSystemManager.closeComponent(DefaultFileSystemManager.java:444)
at org.apache.commons.vfs2.impl.DefaultFileSystemManager.close(DefaultFileSystemManager.java:534)
at org.pentaho.di.core.vfs.ConcurrentFileSystemManager.close(ConcurrentFileSystemManager.java:161)
at org.pentaho.di.core.vfs.KettleVFS$1.run(KettleVFS.java:87)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: Illegal access: this web application instance has been stopped already. Could not load [org.apache.commons.vfs2.impl.PrivilegedFileReplicator$CloseAction]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForClassLoading(WebappClassLoaderBase.java:1319)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1176)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1137)
… 6 more
Caused by: java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load [org.apache.commons.vfs2.impl.PrivilegedFileReplicator$CloseAction]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1329)
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForClassLoading(WebappClassLoaderBase.java:1317)
… 8 more