I’ve been trying to install and run SuiteCRM Analytics. The installation process seemed to be successful. But when I ran start-suitecrm-analytics.sh I get a bunch of errors in Catalina logs and a 404 http error when trying to access the web interface.
Its difficult to tell looking at the log. Could you try stopping all Java processes and deleting the tomcat/logs/catalina.out log for me then try to start the server fresh again? If it fails to boot send me the catalina.out log file so I can see what happening from a fresh boot.
Please make sure that all java processes associated with the suitecrm server have stopped before you do this! Either run the stop bash script or kill the java processes before you try to boot again.
Greetings. I’m trying to get SuiteCRM data analytics installed in my server and i’m failing everytime.
I’ve checked and i have wget installed and tomcat running.
I also java SDK. Whenever i check it (By using java -version) i get this
openjdk version “1.8.0_242”
OpenJDK Runtime Environment (build 1.8.0_242-8u242-b08-0ubuntu3~18.04-? b08)
OpenJDK 64-Bit Server VM (build 25.242-b08, mixed mode)
Thing is, whenever i run setup-suitecrm-data-integration.sh script i get this error:
Checking database Connections…
./kitchen.sh: line 10: ./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.
It seems a bad configuration but i properly set install.properties based in my database configuration which it’s perfectly running with suiteCRM itself and other projects hosted in my server.
Hi there i installed the data analytics, but when i try to get information from the database of suite crm, i get Error processing component or error parsing parameter information. Does anybody knows how to solve this.
Waiting for reply
The last error I can see is this: Table ‘webcrm.D_CAMPAIGNS’ doesn’t exist
It looks like your installation is pointing to a database with the name webcrm and this database does not exist. Are you sure that this database exists and its populated with the correct tables. You need to run SuiteCRM Data Integration to create the database / tables
Hi there i installed suitecrm data integration, put the data on install properties, run setup-suitecrm-data-integration.sh the connection to the database successful, populating with success to the other database, witch right now is not empty. i run run-suitecrm-data-integration.sh and then data-integration-client.sh . Then i went to analytics, i can see custom oportunities that i made but i can not retrieve any data. I tried other report like agent opportunity performance and shows
Agent Opportunity Performance Report
Filters:
Opportunity Created Period: All Periods
Opportunity Lead Source: All Opportunity Lead Sources
Opportunity Sales Stage: All Opportunity Sales Stages
Opportunity Type: All Opportunity Types
No Data Available for Selected Parameters
Report Run By: admin
Report Run Date: 2021-05-04
Hi There thanks for your reply, the first time i didnt install any demo data, the second time i cleaned the database and installed the demo data , and the problem persists, the second time is giving another error on agents aportunity report " Failed to process the report. Failed to fire report event for sub-layout-process. Could not initialize class sun.awt.x11GraphicsEnvironment. Is there any walktrought to setup this correctly.
Hi there i tried everything instaling on centos 8 and then on ubuntu 20.10, every time i run the demo install of Data Integration its giving errors errors
Installing Demo Data…
We could not create all the Demo Date in the SuiteCRM DWH!
Please make sure write privilege enabled in the SuiteCRM Analytics DWH
DEMO DATA has FAILED! - Please check for any errors in the log files inside the logs directory!
BEGIN ERROR MESSAGE
2021/05/10 12:00:35 - Calculate amounts.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : !Calculator.ErrorInStepRunning :
2021/05/10 12:00:35 - Calculate amounts.0 - resultType: 2; targetMeta: 1
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - Unexpected conversion error while converting value [result String] to a Number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - !
org.pentaho.di.core.exception.KettleStepException:
Error while running the step
resultType: 2; targetMeta: 1
Unexpected conversion error while converting value [result String] to a Number
result String : couldn’t convert String to number
result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
at org.pentaho.di.trans.steps.calculator.Calculator.processRow(Calculator.java:179)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.pentaho.di.core.exception.KettleValueException:
resultType: 2; targetMeta: 1
Unexpected conversion error while converting value [result String] to a Number
result String : couldn’t convert String to number
result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
at org.pentaho.di.trans.steps.calculator.Calculator.calcFields(Calculator.java:624)
at org.pentaho.di.trans.steps.calculator.Calculator.processRow(Calculator.java:163)
… 2 more
Caused by: org.pentaho.di.core.exception.KettleValueException:
Unexpected conversion error while converting value [result String] to a Number
result String : couldn’t convert String to number
result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
at org.pentaho.di.core.row.value.ValueMetaBase.getNumber(ValueMetaBase.java:1993)
at org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3795)
at org.pentaho.di.trans.steps.calculator.Calculator.calcFields(Calculator.java:621)
… 3 more
Caused by: org.pentaho.di.core.exception.KettleValueException:
result String : couldn’t convert String to number
result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToNumber(ValueMetaBase.java:1017)
at org.pentaho.di.core.row.value.ValueMetaBase.getNumber(ValueMetaBase.java:1933)
… 5 more
Caused by: org.pentaho.di.core.exception.KettleValueException:
result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToNumber(ValueMetaBase.java:1010)
… 6 more
2021/05/10 12:00:35 - Calculate amounts.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Erro inesperado
2021/05/10 12:00:35 - Calculate amounts.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2021/05/10 12:00:35 - Calculate amounts.0 - Error while running the step
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - resultType: 2; targetMeta: 1
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - Unexpected conversion error while converting value [result String] to a Number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.trans.steps.calculator.Calculator.processRow(Calculator.java:179)
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2021/05/10 12:00:35 - Calculate amounts.0 - at java.base/java.lang.Thread.run(Thread.java:829)
2021/05/10 12:00:35 - Calculate amounts.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2021/05/10 12:00:35 - Calculate amounts.0 - resultType: 2; targetMeta: 1
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - Unexpected conversion error while converting value [result String] to a Number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.trans.steps.calculator.Calculator.calcFields(Calculator.java:624)
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.trans.steps.calculator.Calculator.processRow(Calculator.java:163)
2021/05/10 12:00:35 - Calculate amounts.0 - … 2 more
2021/05/10 12:00:35 - Calculate amounts.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2021/05/10 12:00:35 - Calculate amounts.0 - Unexpected conversion error while converting value [result String] to a Number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getNumber(ValueMetaBase.java:1993)
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3795)
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.trans.steps.calculator.Calculator.calcFields(Calculator.java:621)
2021/05/10 12:00:35 - Calculate amounts.0 - … 3 more
2021/05/10 12:00:35 - Calculate amounts.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToNumber(ValueMetaBase.java:1017)
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getNumber(ValueMetaBase.java:1933)
2021/05/10 12:00:35 - Calculate amounts.0 - … 5 more
2021/05/10 12:00:35 - Calculate amounts.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2021/05/10 12:00:35 - Calculate amounts.0 - result String : couldn’t convert String to number : non-numeric character found at position 1 for value [.50]
2021/05/10 12:00:35 - Calculate amounts.0 -
2021/05/10 12:00:35 - Calculate amounts.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToNumber(ValueMetaBase.java:1010)
2021/05/10 12:00:35 - Calculate amounts.0 - … 6 more
2021/05/10 12:00:36 - populateInvoiceManagement - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Erros detectados!
2021/05/10 12:00:36 - populateInvoiceManagement - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Erros detectados!
On centos then the web analytics opens but on ubuntu is giving 404 error.
Can someone help here.