Dashboard and Sonar FAQ

I keep getting an error on ./sonar start

You can try to start Sonar by launching this command in $DASHBOARD_HOME:

  java -Djava.awt.headless=true -XX:MaxPermSize=128m -server -Xmx512m -Xms256m -cp lib/*:extensions/jdbc-driver/derby/*:extensions/jdbc-driver/mssql/*:extensions/jdbc-driver/mysql/*:extensions/jdbc-driver/oracle/*:extensions/jdbc-driver/postgresql.*:. org.sonar.application.StartServer

Sonar starts but then stops

This FAQ is for older versions of the Lingoport Dashboard. Systems installed after May 2018 no longer use port 9000 and this may no longer be applicable.

After starting Sonar, check the status multiple times. Sometimes, it will say that it started, but then quit after a few seconds.

> /var/lib/jenkins/lingoport/dashboard-server-5.6.1/bin/linux-x86-64/sonar.sh start
Starting SonarQube...
Started SonarQube.

> /var/lib/jenkins/lingoport/dashboard-server-5.6.1/bin/linux-x86-64/sonar.sh status
SonarQube is running (13880).
> /var/lib/jenkins/lingoport/dashboard-server-5.6.1/bin/linux-x86-64/sonar.sh status
SonarQube is running (13880).
> /var/lib/jenkins/lingoport/dashboard-server-5.6.1/bin/linux-x86-64/sonar.sh status
SonarQube is not running.

Check to see if the process is still up, even though Sonar thinks it is down. If there is no output, the process is not running.

> fuser 9000/tcp
9090/tcp:            14118
> fuser 9001/tcp
9010/tcp:            13905

Kill the processes using the following commands:

> fuser -k 9000/tcp
9090/tcp:            14118
> fuser -k 9001/tcp
9010/tcp:            13905

And start the sonar process again and check the status multiple times.

> /var/lib/jenkins/lingoport/dashboard-server-5.6.1/bin/linux-x86-64/sonar.sh start
Starting SonarQube...
Started SonarQube.

> /var/lib/jenkins/lingoport/dashboard-server-5.6.1/bin/linux-x86-64/sonar.sh status
SonarQube is running (13880).

Unable to read and import the source file: What do I do?

I'm getting this error when importing files using the Dashboard_Update.sh:

ERROR: Error during Sonar runner execution
ERROR: Unable to execute Sonar
ERROR: Caused by: Unable to read and import the source file : 'FILENAME HERE' with the charset : 'UTF-8'.
ERROR: Caused by: Unable to persist : SnapshotSource[snapshot_id=120719,data=<?php
[...]                                                                                                                                            ERROR: Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [org.sonar.api.database.model.SnapshotSource]                                                                                                                                       ERROR: Caused by: could not insert: [org.sonar.api.database.model.SnapshotSource]                                                                                                                                         ERROR: Caused by: Incorrect string value: '\xF0\x9F\x8F\x81  ...' for column 'data' at row 1

This indicates that the import part of the Dashboard is trying to read a file with an encoding (here UTF-8) which is not the encoding of the file to read, or the file is corrupted for that encoding.

Some possible solutions:

• Exclude the offending file(s) from being imported using sonar-project.properties sonar.exclusions=com/example/tests/**,com/example/package2/*.java.
• Change the encoding of the Dashboard import using sonar-project.properties sonar.sourceEncoding=Cp1252 or whatever is the right encoding for the project.