Sonarqube Jenkins Property file for PLSQL code analysis

Hi Team,

We are using sonarqube developer edition sonarqube-8.2.0.32929 to analyse our PLSQL scripts .
We integrated the Sonarqube with the Jenkins and created a freestyle project to analyse our plsql scripts.We stored all my plsql script files locally, We want to configure the sonarqube to analyse those scripts.
We are using the below Analysis properties. while I am building the project, it is getting failed with the error message as “Tasks support was removed in SonarQube 7.6.”
Am I missing something or is there any problem with the property file?

#Required Metadata
sonar.projectKey=my:sqltestkey
sonar.projectName=mysqltest
sonar.projectVersion=1.0
sonar.projectDescription=PL/SQL demo
sonar.sources=C:/Users/Ganesh/Desktop/sqlscripts
sonar.language=plsql
sonar.sourceEncoding=UTF-8

Regards
Ganesh.

M

Hello @PalmLeaf_Co,

Did you try to upgrade your “SonarScanner for Jenkins” to the latest version?

I believe you should try to separate the problems and first confirm that you are able to scan locally and send the data to your SonarQube 8.2 DE before trying to use the Jenkins integration.

I would suggest the following:

sonar.host.url=https://changeme.io
sonar.login=changeme
sonar.password=changeme

sonar.projectKey=my:firstsqlproject
sonar.projectName=First PLSQL Project
sonar.projectVersion=1.0
sonar.projectDescription=PL/SQL demo
sonar.sources=.
sonar.sourceEncoding=UTF-8
# if you really want only the SQL files to be scanned, add this:
sonar.inclusions=**/*.sql
# sonar.language=plsql : don't put that, this is useless with SQ 8.2
  • run sonar-scanner command from the root of your folder

Alex

Hi Alex,

I can able to run the scan locally and the analyzed results are updated in the sonarqube.I downloaded the source code in the local folder and installed the sonarscanner cli and added the sonar-project.properties file in the folder.
Regards
Ganesh.M

Hi,


I have the latest version of SonarScanner for Jenkins.

Regards
Ganesh. M

Ganesh,

You scan command appears to state:

sonar-scanner.bat “scan plsql file”

Wherever you’ve added “scan plsql file” in your config – get rid of it. :slight_smile:

Hi Colin,

Thanks I removed the “scan plsql file” from the configuration.It works now.Thanks :slight_smile:

Regards
Ganesh. M