Make a quick vote 🗳 ️How do you refer to SuiteCRM extensions: add-ons or plug-ins? Click here to have your say 👈

Any problems or issues? Let me know!

OK, I thought creating a new data source would allow me to relate tables to create different reports as those that are already available.

For instance, one of the reports we needed was to relate products quotes with users.

Is it possible already?

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.

:+1::clap::clap::clap::clap:
thank you!

Sent you a private message

Problem

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.

Log Text

Overriding KETTLE default JVM mem size: 1024

Odd error to be getting. Are you sure you followed the instructions 100%?

Response

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?

  • I’m a Java newb!

Ubuntu 18.04 installation error

I get this error when running the install script.

  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.

Is there something basic that I’m missing?

I’ll take a look into this and get back to you

Ubuntu 20.04.1 LTS Installation Error, running Java 8, checked the db connections

After running ./setup-suitecrm-data-integration.sh, I get the following error.

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.


The Setup has FAILED! - Please check for any errors in the log files inside the logs directory!

BEGIN ERROR MESSAGE

awk: line 1: syntax error at or near &&


The logs from the folder only have one line

Overriding KETTLE default JVM mem size: 1024

It looks like it might be similar to [footbllman62]'s error in April. Please let me know if you found a fix.

Thanks!

I went ahead and tried to install analytics and got the following error after the start command.

./start-suitecrm-analytics.sh
DEBUG: Using JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
DEBUG: _PENTAHO_JAVA=/usr/lib/jvm/java-8-openjdk-amd64/bin/java
sh: 0: Can’t open startup.sh

The setup command for analytics did not have any issues even though data-integration setup command had the error in my comment above.

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

I have the same error in a fresh install
What’s your Mysql version?
I have MySQL 8 and it can be a problem
I just created a separate topic

mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3

Hey folks. Do a clean install of the platform, run a dashboard and send us the output of your tomcat/logs/catalina.out

Thanks!

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 have an issue with lead import I have turned off the display and reporting error still i am getting an error box on import.

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

Can you help me?
Thanks!