# Parse-Error while SQL Code Quality Scan with SonarQube **URL:** \ **Category:** SonarQube Server / Community Build\ **Tags:** sonarqube\ **Created:** [August 18, 2020, 8:09am UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691 "2020-08-18T08:09:00Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![upendaravireni](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/upendaravireni/32/23186_2.png) [@upendaravireni](https://community.sonarsource.com/u/upendaravireni)\ **Post date:** [August 18, 2020, 8:09am UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/1 "2020-08-18T08:09:00Z")
Hi Team, I’m using Redgate SQL source control 7 for versioning our SQL code in SSMS(SQL server 2016) and Redgate SQL change automation:build/release tasks for build/release pipelines in Azure Devops. I added Sonarqube tasks for static code analysis. Run code analysis took time to analyze full code(1200+ files) and given Parse errors in almost all the files. Our Dev team able to parse those objects in SSMS. Request you help me resolving this issues and let me know if you need more details. Thanks, Upendar ---
**Author:** ![pynicolas](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/pynicolas/32/675_2.png) [@pynicolas](https://community.sonarsource.com/u/pynicolas)\ **Post date:** [August 18, 2020, 8:33am UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/2 "2020-08-18T08:33:49Z")
Can you share the analysis logs from the start and until the first parsing error is logged? ---
**Author:** ![upendaravireni](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/upendaravireni/32/23186_2.png) [@upendaravireni](https://community.sonarsource.com/u/upendaravireni)\ **Post date:** [August 18, 2020, 1:36pm UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/3 "2020-08-18T13:36:02Z")
[SQLParseError\_Upendar.txt](https://community.sonarsource.com/uploads/short-url/nWZgg6hGRRgGXJ6HZT7QGgp77Fl.txt) (2.1 MB) PFA full log of run code analysis step in build pipeline ---
**Author:** ![pynicolas](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/pynicolas/32/675_2.png) [@pynicolas](https://community.sonarsource.com/u/pynicolas)\ **Post date:** [August 18, 2020, 4:22pm UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/4 "2020-08-18T16:22:03Z")
Your .sql files are analyzed with PL/SQL analyzer. That’s the default for .sql files. You should set up your project to analyze .sql files with the TSQL analyzer by adjusting `sonar.tsql.file.suffixes` and `sonar.plsql.file.suffixes`. You can do that through the UI in Administration -\> General Settings -\> Languages: - For “PL/SQL”, remove the “sql” suffix - For “T-SQL”, add the “sql” suffix See the [documentation](https://docs.sonarqube.org/latest/analysis/languages/tsql/). ---
**Author:** ![upendaravireni](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/upendaravireni/32/23186_2.png) [@upendaravireni](https://community.sonarsource.com/u/upendaravireni)\ **Post date:** [August 18, 2020, 4:53pm UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/5 "2020-08-18T16:53:20Z")
Can you please tell me we need to do this changes in SSMS or Azure Devops pipeline or sonarqube project ? ---
**Author:** ![upendaravireni](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/upendaravireni/32/23186_2.png) [@upendaravireni](https://community.sonarsource.com/u/upendaravireni)\ **Post date:** [August 19, 2020, 8:03am UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/6 "2020-08-19T08:03:40Z")
Can we add any additional properties reg. this issue in Prepare Analysis Configuration task ? If yes, please let us know ---
**Author:** ![SrinivasP](https://avatars.discourse-cdn.com/v4/letter/s/7ab992/32.png) [@SrinivasP](https://community.sonarsource.com/u/SrinivasP)\ **Post date:** [August 19, 2020, 8:17am UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/7 "2020-08-19T08:17:01Z")
You need to add sonar.tsql.file.suffixes in sonar.properties and do language suffix chnages in Sonarqube administration. Administration -\> General Settings -\> Languages: ---
**Author:** ![upendaravireni](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/upendaravireni/32/23186_2.png) [@upendaravireni](https://community.sonarsource.com/u/upendaravireni)\ **Post date:** [August 20, 2020, 10:00am UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/8 "2020-08-20T10:00:00Z")
I updated accordingly, now TSQL analyzer able to analyze .sql files. Thanks for your suggestion ---
**Author:** ![system](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/system/32/31083_2.png) [@system](https://community.sonarsource.com/u/system)\ **Post date:** [April 8, 2021, 8:58am UTC](https://community.sonarsource.com/t/parse-error-while-sql-code-quality-scan-with-sonarqube/29691/9 "2021-04-08T08:58:56Z")
Closed on April 8, 2021, 8:58am UTC This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.