Scanning of SQL files never complete

[flopma]

Hello,

We have a weird issue on Sonarqube 8.9.2 (Z PL/SQL Analyzer 2.4.0 and also 3.1.1, sonarscanner 4.6.2.2472) where scanning of some SQL files never completes and could run forever. Running Sonarscanner with the extra parameter -X does not output meaningful data.

Is there another way to get trace logs of what is going on during the scans of those SQL files so we could have a hint of what is causing the endless scan?

Thanks a lot

[felipebz]

Hi,

The analysis log should be showing what file is is causing problems (something like x/x files analyzed, current file: xxx.sql). Unfortunately, finding the exact cause is not simple but you could test the file on the latest zpa-toolkit to check if it's already fixed.

If you can reproduce the problem on zpa-toolkit, you could try to remove parts of the code until you find the problematic part.

[felipebz]

Closing due to inactivity.