Error not a valid line offset for pointer in plsql code

SonarQube Server / Community Build
,
1

i’m try run sonar scanner in plsql code project and i get the following error on log:

java.lang.IllegalArgumentException: Unable to highlight file [moduleKey=Project1:1, relative=src/main/resources/db/Outros/TRUNCATE_TABLE_TAB1092092.sql, basedir=/home/sonar/AppDB]
        at org.sonar.api.batch.sensor.highlighting.internal.DefaultHighlighting.highlight(DefaultHighlighting.java:96)
        at org.sonar.api.batch.sensor.highlighting.internal.DefaultHighlighting.highlight(DefaultHighlighting.java:36)
        at com.sonar.plsql.A.A.A(Unknown Source)
        at com.sonar.plsql.A.A.A(Unknown Source)
        at com.sonar.oracle.O.A(Unknown Source)
        at com.sonar.oracle.O.A(Unknown Source)
        at com.sonar.oracle.O.A(Unknown Source)
        at com.sonar.oracle.O.A(Unknown Source)
        at com.sonar.oracle.Q.A(Unknown Source)
        at com.sonar.plsql.plugin.I.execute(Unknown Source)
        at org.sonar.scanner.sensor.SensorWrapper.analyse(SensorWrapper.java:53)
        at org.sonar.scanner.phases.SensorsExecutor.executeSensor(SensorsExecutor.java:57)
        at org.sonar.scanner.phases.SensorsExecutor.execute(SensorsExecutor.java:49)
        at org.sonar.scanner.phases.AbstractPhaseExecutor.execute(AbstractPhaseExecutor.java:78)
        at org.sonar.scanner.scan.ModuleScanContainer.doAfterStart(ModuleScanContainer.java:184)
        at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:142)
        at org.sonar.core.platform.ComponentContainer.execute(ComponentContainer.java:127)
        at org.sonar.scanner.scan.ProjectScanContainer.scan(ProjectScanContainer.java:241)
        at org.sonar.scanner.scan.ProjectScanContainer.scanRecursively(ProjectScanContainer.java:236)
        at org.sonar.scanner.scan.ProjectScanContainer.scanRecursively(ProjectScanContainer.java:234)
        at org.sonar.scanner.scan.ProjectScanContainer.doAfterStart(ProjectScanContainer.java:226)
        at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:142)
        at org.sonar.core.platform.ComponentContainer.execute(ComponentContainer.java:127)
        at org.sonar.scanner.task.ScanTask.execute(ScanTask.java:47)
        at org.sonar.scanner.task.TaskContainer.doAfterStart(TaskContainer.java:86)
        at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:142)
        at org.sonar.core.platform.ComponentContainer.execute(ComponentContainer.java:127)
        at org.sonar.scanner.bootstrap.GlobalContainer.executeTask(GlobalContainer.java:115)
        at org.sonar.batch.bootstrapper.Batch.executeTask(Batch.java:118)
        at org.sonarsource.scanner.api.internal.batch.BatchIsolatedLauncher.execute(BatchIsolatedLauncher.java:62)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.sonarsource.scanner.api.internal.IsolatedLauncherProxy.invoke(IsolatedLauncherProxy.java:60)
        at com.sun.proxy.$Proxy0.execute(Unknown Source)
        at org.sonarsource.scanner.api.EmbeddedScanner.doExecute(EmbeddedScanner.java:240)
        at org.sonarsource.scanner.api.EmbeddedScanner.runAnalysis(EmbeddedScanner.java:151)
        at org.sonarsource.scanner.cli.Main.runAnalysis(Main.java:110)
        at org.sonarsource.scanner.cli.Main.execute(Main.java:72)
        at org.sonarsource.scanner.cli.Main.main(Main.java:60)
Caused by: java.lang.IllegalArgumentException: 117 is not a valid line offset for pointer. File [moduleKey=Project1:1, relative=src/main/resources/db/Outros/TRUNCATE_TABLE_TAB1092092.sql, basedir=/home/sonar/AppDB] has 114 character(s) at line 1
        at org.sonar.api.internal.google.common.base.Preconditions.checkArgument(Preconditions.java:145)
        at org.sonar.api.batch.fs.internal.DefaultInputFile.checkValid(DefaultInputFile.java:215)
        at org.sonar.api.batch.fs.internal.DefaultInputFile.newPointer(DefaultInputFile.java:206)
        at org.sonar.api.batch.fs.internal.DefaultInputFile.newRange(DefaultInputFile.java:237)
        at org.sonar.api.batch.sensor.highlighting.internal.DefaultHighlighting.highlight(DefaultHighlighting.java:94)
        ... 40 more

The file in log contains the following plsql code:

------------------------------------------------ VERSÃO  = 0.1 --------------------------------------------------
--

*/ --------------------------------------------------------------------------------------------------------------
--
BEGIN
        TRUNCATE TABLE TAB1092092;
END;
/
2

Hi,

Just to fill in the background for the folks who can actually help you on this topic: what’s your SonarQube version?

 
Ann

3

Hi G Ann,

SonarQube version: 6.0
Sonar scanner version: 2.6.1

4

Hi,

That’s a really old version & we’re not going to be able to help you with it. You should upgrade to 8.2, which is the current version, or at least 7.9.2, the current LTS, at your earliest convenience.

 
Ann