The PL/SQL issues from the sonarqube server are not shown in the problems tab, even though the log of sonarlint says “Found 10 issues”.
Can anybody help?
Hello, thank you for your question.
Could you please:
This should help us troubleshoot why these issues don’t appear.
Hello, here is the verbose log
[Debug - 09:38:14.916] Queuing analysis of file 'file:///c:/gitrepos/backend-60/ICIS/sch_jaehrliche_schadeneinrichtung.pkb' (version 1)
[Debug - 09:38:14.939] GET 200 https://sonarqube.project.de:9100/api/system/status | response time=21ms
[Debug - 09:38:14.939] Downloaded server infos in 21ms
[Debug - 09:38:14.939] Incremental taint issue sync is not supported. Skipping.
[Debug - 09:38:14.962] GET 200 https://sonarqube.project.de:9100/api/system/status | response time=21ms
[Debug - 09:38:14.962] Downloaded server infos in 18ms
[Debug - 09:38:15.056] GET 200 https://sonarqube.project.de:9100/api/rules/search.protobuf?repositories=roslyn.sonaranalyzer.security.cs,javasecurity,jssecurity,phpsecurity,pythonsecurity,tssecurity&f=repo&s=key&ps=500&p=1 | response time=92ms
[Debug - 09:38:15.056] Page downloaded in 92ms
[Debug - 09:38:15.106] GET 200 https://sonarqube.project.de:9100/api/issues/search.protobuf?statuses=OPEN,CONFIRMED,REOPENED&types=VULNERABILITY&componentKeys=de.project%3Abackend-60%3AICIS%2Fsch_jaehrliche_schadeneinrichtung.pkb&rules=jssecurity%3AS2631%2Croslyn.sonaranalyzer.security.cs%3AS2078%2Ctssecurity%3AS2076%2Croslyn.sonaranalyzer.security.cs%3AS2076%2Cjavasecurity%3AS2083%2Cjssecurity%3AS5146%2Cjssecurity%3AS5147%2Croslyn.sonaranalyzer.security.cs%3AS3649%2Cpythonsecurity%3AS2091%2Ctssecurity%3AS5144%2Ctssecurity%3AS2631%2Ctssecurity%3AS5146%2Cjssecurity%3AS3649%2Cphpsecurity%3AS5167%2Ctssecurity%3AS5147%2Cjavasecurity%3AS3649%2Cphpsecurity%3AS2083%2Cpythonsecurity%3AS5167%2Croslyn.sonaranalyzer.security.cs%3AS5144%2Croslyn.sonaranalyzer.security.cs%3AS5145%2Croslyn.sonaranalyzer.security.cs%3AS5146%2Croslyn.sonaranalyzer.security.cs%3AS2631%2Cjssecurity%3AS2083%2Ctssecurity%3AS6105%2Cjavasecurity%3AS5144%2Cpythonsecurity%3AS5131%2Croslyn.sonaranalyzer.security.cs%3AS2083%2Cjavasecurity%3AS2078%2Cjavasecurity%3AS2076%2Cjavasecurity%3AS5146%2Ctssecurity%3AS5131%2Cjavasecurity%3AS5145%2Ctssecurity%3AS5696%2Cjavasecurity%3AS2631%2Ctssecurity%3AS5334%2Cphpsecurity%3AS2091%2Cpythonsecurity%3AS5135%2Cpythonsecurity%3AS5334%2Cjssecurity%3AS6096%2Cjavasecurity%3AS5131%2Cjssecurity%3AS5883%2Cjavasecurity%3AS5334%2Cjavasecurity%3AS5135%2Croslyn.sonaranalyzer.security.cs%3AS2091%2Cphpsecurity%3AS5144%2Cphpsecurity%3AS5146%2Ctssecurity%3AS5883%2Cphpsecurity%3AS5145%2Cpythonsecurity%3AS2631%2Cphpsecurity%3AS2631%2Cpythonsecurity%3AS2078%2Cpythonsecurity%3AS2076%2Cpythonsecurity%3AS3649%2Ctssecurity%3AS6096%2Croslyn.sonaranalyzer.security.cs%3AS6096%2Cpythonsecurity%3AS5144%2Cphpsecurity%3AS3649%2Cjssecurity%3AS5131%2Cpythonsecurity%3AS5146%2Cpythonsecurity%3AS5145%2Croslyn.sonaranalyzer.security.cs%3AS5167%2Cjavasecurity%3AS2091%2Cjssecurity%3AS6105%2Cjavasecurity%3AS6096%2Cjssecurity%3AS5696%2Ctssecurity%3AS2083%2Cjssecurity%3AS5334%2Cpythonsecurity%3AS2083%2Cphpsecurity%3AS5131%2Cjavasecurity%3AS5167%2Cphpsecurity%3AS5135%2Cphpsecurity%3AS2078%2Cphpsecurity%3AS5335%2Cphpsecurity%3AS2076%2Cphpsecurity%3AS5334%2Ctssecurity%3AS3649%2Cjssecurity%3AS5144%2Croslyn.sonaranalyzer.security.cs%3AS5131%2Cjssecurity%3AS2076%2Croslyn.sonaranalyzer.security.cs%3AS5135%2Croslyn.sonaranalyzer.security.cs%3AS5334&branch=master&ps=500&p=1 | response time=48ms
[Debug - 09:38:15.107] Page downloaded in 49ms
[Debug - 09:38:15.107] Wrote 0 taint issues in store | took 0ms
[Debug - 09:38:15.982] Cached SCM ignore status for file 'file:///c:/gitrepos/backend-60/ICIS/sch_jaehrliche_schadeneinrichtung.pkb': Not ignored
[Info - 09:38:15.985] Analyzing file 'file:///c:/gitrepos/backend-60/ICIS/sch_jaehrliche_schadeneinrichtung.pkb'...
[Debug - 09:38:15.985] Analysis triggered with configuration:
[
projectKey: de.project:backend-60
baseDir: c:\gitrepos\backend-60
extraProperties: {sonar.cfamily.compile-commands=}
moduleKey: file:///c:/gitrepos/backend-60
inputFiles: [
file:///c:/gitrepos/backend-60/ICIS/sch_jaehrliche_schadeneinrichtung.pkb (UTF-8) [plsql]
]
]
[Debug - 09:38:15.989] * cpp: 354 active rules
[Debug - 09:38:15.990] Rule common-cpp:DuplicatedBlocks is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.990] Rule cpp:S5527 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.991] Rule cpp:S4830 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.991] * css: 23 active rules
[Debug - 09:38:15.992] * c: 187 active rules
[Debug - 09:38:15.992] Rule common-c:DuplicatedBlocks is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.992] Rule c:S5527 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.993] Rule c:S4830 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.993] * js: 142 active rules
[Debug - 09:38:15.994] Rule jssecurity:S5146 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.994] Rule jssecurity:S5147 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.994] Rule jssecurity:S3649 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.994] Rule jssecurity:S6096 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.994] Rule jssecurity:S5883 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.994] Rule jssecurity:S5131 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.995] Rule jssecurity:S6105 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.995] Rule jssecurity:S5144 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.995] Rule jssecurity:S2631 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.995] Rule jssecurity:S2083 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.995] Rule jssecurity:S5696 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.995] Rule jssecurity:S5334 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.995] Rule jssecurity:S2076 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.995] * py: 128 active rules
[Debug - 09:38:15.995] Rule pythonsecurity:S2091 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.996] Rule pythonsecurity:S5131 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.996] Rule pythonsecurity:S5135 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.996] Rule pythonsecurity:S2631 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.996] Rule pythonsecurity:S2078 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.996] Rule pythonsecurity:S2076 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.996] Rule pythonsecurity:S2083 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.996] Rule pythonsecurity:S5167 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.997] Rule pythonsecurity:S5334 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.997] Rule pythonsecurity:S3649 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.997] Rule pythonsecurity:S5144 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.997] Rule pythonsecurity:S5146 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.997] Rule pythonsecurity:S5145 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.998] * apex: 38 active rules
[Debug - 09:38:15.998] * plsql: 130 active rules
[Debug - 09:38:15.998] * java: 437 active rules
[Debug - 09:38:15.998] Rule javasecurity:S5167 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.999] Rule javasecurity:S5144 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.999] Rule javasecurity:S5146 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.999] Rule javasecurity:S5145 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.999] Rule common-java:DuplicatedBlocks is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.999] Rule javasecurity:S5131 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.999] Rule javasecurity:S5135 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.999] Rule javasecurity:S2091 is enabled on the server, but not available in SonarLint
[Debug - 09:38:15.999] Rule javasecurity:S2083 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.000] Rule javasecurity:S2078 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.000] Rule javasecurity:S2076 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.000] Rule javasecurity:S5334 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.000] Rule javasecurity:S3649 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.000] Rule javasecurity:S2631 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.000] Rule javasecurity:S6096 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.001] * web: 27 active rules
[Debug - 09:38:16.001] * xml: 6 active rules
[Debug - 09:38:16.001] * php: 126 active rules
[Debug - 09:38:16.001] Rule phpsecurity:S2083 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.001] Rule common-php:DuplicatedBlocks is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.001] Rule phpsecurity:S2091 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.001] Rule phpsecurity:S2631 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.001] Rule phpsecurity:S2078 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.001] Rule phpsecurity:S5335 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.001] Rule phpsecurity:S2076 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.001] Rule phpsecurity:S5334 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] Rule phpsecurity:S5167 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] Rule phpsecurity:S5144 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] Rule phpsecurity:S5146 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] Rule phpsecurity:S5145 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] Rule phpsecurity:S3649 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] Rule phpsecurity:S5131 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] Rule phpsecurity:S5135 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] * ts: 132 active rules
[Debug - 09:38:16.002] Rule tssecurity:S5144 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.002] Rule tssecurity:S5146 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S5147 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S6105 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S5131 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S5883 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S2083 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S2076 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S2631 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S5696 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S5334 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S6096 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] Rule tssecurity:S3649 is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.003] * yaml: 19 active rules
[Debug - 09:38:16.004] Rule yaml:HyphensCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:CommentsCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:IndentationCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:OctalValuesCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:TrailingSpacesCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:ColonsCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:CommasCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:ParsingErrorCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:KeyDuplicatesCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.004] Rule yaml:LineLengthCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.005] Rule yaml:CommentsIndentationCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.005] Rule yaml:EmptyLinesCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.005] Rule yaml:NewLinesCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.005] Rule yaml:BracketsCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.005] Rule yaml:EmptyValuesCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.005] Rule yaml:TruthyCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.005] Rule yaml:DocumentStartCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.005] Rule yaml:NewLineAtEndOfFileCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.006] Rule yaml:BracesCheck is enabled on the server, but not available in SonarLint
[Debug - 09:38:16.040] Start analysis
[Info - 09:38:16.055] Index files
[Debug - 09:38:16.055] Language of file 'file:///c:/gitrepos/backend-60/ICIS/sch_jaehrliche_schadeneinrichtung.pkb' is set to 'PL/SQL'
[Info - 09:38:16.056] 1 file indexed
[Debug - 09:38:16.101] 'JavaSquidSensor' skipped because there is no related files in the current project
[Debug - 09:38:16.101] 'Apex Sensor' skipped because there is no related files in the current project
[Debug - 09:38:16.101] 'CFamily' skipped because there is no related files in the current project
[Debug - 09:38:16.101] 'XML Sensor' skipped because there is no related files in the current project
[Debug - 09:38:16.101] 'JavaXmlSensor' skipped because one of the required properties is missing
[Debug - 09:38:16.101] 'PHP sensor' skipped because there is no related files in the current project
[Debug - 09:38:16.102] 'Analyzer for "php.ini" files' skipped because there is no related files in the current project
[Debug - 09:38:16.102] 'JavaScript analysis' skipped because there is no related files in the current project
[Debug - 09:38:16.102] 'TypeScript analysis' skipped because there is no related files in the current project
[Debug - 09:38:16.102] 'JavaScript inside YAML analysis' skipped because there is no related files in the current project
[Debug - 09:38:16.102] Execute Sensor: CSS Rules
[Info - 09:38:16.102] No CSS, PHP, HTML or VueJS files are found in the project. CSS analysis is skipped.
[Debug - 09:38:16.102] Execute Sensor: HTML
[Debug - 09:38:16.102] Execute Sensor: Sonar Secrets Detection Sensor
[Debug - 09:38:16.107] Execute Sensor: PL/SQL Sensor
[Debug - 09:38:16.107] Setting filesystem encoding: UTF-8
[Info - 09:38:16.115] 1 source files to be analyzed
[Debug - 09:38:16.227] Initializing metadata of file file:///c:/gitrepos/backend-60/ICIS/sch_jaehrliche_schadeneinrichtung.pkb
[Info - 09:38:16.265] 1/1 source files have been analyzed
[Debug - 09:38:16.266] 'Python Sensor' skipped because there is no related files in the current project
[Debug - 09:38:16.268] fetchServerIssues projectKey=de.project:backend-60, ideFilePath=ICIS/sch_jaehrliche_schadeneinrichtung.pkb, branchName=master
[Debug - 09:38:16.282] GET 200 https://sonarqube.project.de:9100/api/system/status | response time=13ms
[Debug - 09:38:16.282] Downloaded server infos in 12ms
[Debug - 09:38:16.305] GET 200 https://sonarqube.project.de:9100/batch/issues?key=de.project%3Abackend-60%3AICIS%2Fsch_jaehrliche_schadeneinrichtung.pkb&branch=master | response time=21ms
[Debug - 09:38:16.306] Downloaded issues in 22ms
[Debug - 09:38:16.345] Wrote 10 issues in store | took 39ms
[Info - 09:38:16.363] Found 10 issues
[Debug - 09:38:19.268] GET 200 https://sonarqube.project.de:9100/api/developers/search_events?projects=de.project%3Abackend-60&from=2023-01-27T09%3A38%3A19%2B0100 | response time=52ms
[Debug - 09:39:19.238] GET 200 https://sonarqube.project.de:9100/api/developers/search_events?projects=de.project%3Abackend-60&from=2023-01-27T09%3A38%3A19%2B0100 | response time=29ms
[Debug - 09:40:19.228] GET 200 https://sonarqube.project.de:9100/api/developers/search_events?projects=de.project%3Abackend-60&from=2023-01-27T09%3A38%3A19%2B0100 | response time=19ms
Folder file:///c%3A/gitrepos/backend-60 is now on branch master
[Debug - 09:40:36.932] Folder file:///c:/gitrepos/backend-60 is now on branch master.
[Debug - 09:40:36.973] GET 200 https://sonarqube.project.de:9100/api/system/status | response time=12ms
[Debug - 09:40:36.973] Downloaded server infos in 12ms
[Debug - 09:40:36.973] Incremental issue sync is not supported. Skipping.
[Debug - 09:40:36.997] GET 200 https://sonarqube.project.de:9100/api/system/status | response time=22ms
[Debug - 09:40:36.997] Downloaded server infos in 22ms
[Debug - 09:40:36.997] Incremental taint issue sync is not supported. Skipping.
[Debug - 09:41:19.218] GET 200 https://sonarqube.project.de:9100/api/developers/search_events?projects=de.project%3Abackend-60&from=2023-01-27T09%3A38%3A19%2B0100 | response time=19ms
Hey,
I don’t see anything surprising in the logs, especially I see the following lines:
[Debug - 09:38:16.345] Wrote 10 issues in store | took 39ms
[Info - 09:38:16.363] Found 10 issues
…which indicate that indeed, 10 issues have been detected in this file.
Could it be that you have filters set in your “Problems” view in VSCode? These can be configured using the “funnel” icon:
[EDIT]
And one more thing: if the issues have the “INFO” severity in SonarQube, they will be reported with the “Hint” severity in VSCode and thus they won’t appear in the “Problems” view (although they will be highlighted in the source code):
Okay,
thanks for your help. The issues in the example file are all “INFO” and I havent seen the hints “…” in the source code.
