search

felipebz / zpa

Parser and static code analysis tool for PL/SQL and Oracle SQL.
https://zpa.felipebz.com
GNU Lesser General Public License v3.0
211 stars 77 forks source link

Scanning of SQL files never complete #161

Closed flopma closed 2 years ago

flopma commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

Closing due to inactivity.