Unable to TFS annotate

[Mickael Dance]

Hello,

We are trying to use the TechCognia TSql plugin on one of our project, build from TFS Our TFS is 2015, and SonarCube 6.2 Our project is a basic console application, with a folder with some table, procedures, and views in .sql We build the project with one build step: Perform a SonarQube analysis (SonarQube Scanner CLI) I have follow all the step describe here https://bitbucket.org/TechCognia/plugins/wiki/TechCognia%20TSql%20SonarQube%20Plugin I first build the project only with the console project, without SQL folder. Steps run successfully. But once I add the SQL folder, I've an error during the Build "Perform a SonarQube analysis" ("Get Sources" & "Post Job Cleanup" are OK):

2017-04-25T14:04:51.6501287Z ##[error]ERROR: Unable to TFS annotate the following file which is not in a mapped TFS workspace: D:/agent1/_work/1/s/ConsoleApplication1/SQL/REF_Account.sql

Does anybody have an idea of the problem? Thanks a lot in advance

[Team TechCognia]

Hi Mickael,

The message "Unable to TFS annotate" does not seem to originate from tsql plugin. We will further investigate on our side for any issues within the plugin.

Also are you using any scm plugin ? This looks more to do with SCM plugins or the availability of the file wheb compared with its workspace.

[Mickael Dance]

Hi,

That was my first thinking, but I tried to remove the SQL folder from my solution, and then I don't get any error. Errors appears once the plugin is used. Maybe there is another way to check if it is related to the plugin or not? For informations: - For TFS, the web server where SonarQube (and plugins) is installed is different than the build server - SVM provider is TFVC (buil log: "SCM provider for this project is: tfvc")

2017-04-25T14:04:51.1032440Z INFO: Quality profile for cs: Sonar way
2017-04-25T14:04:51.1032440Z INFO: Quality profile for tsql: SQLCodeGuard
2017-04-25T14:04:51.5407489Z INFO: Sensor Lines Sensor
2017-04-25T14:04:51.5407489Z INFO: Sensor Lines Sensor (done) | time=0ms
2017-04-25T14:04:51.5407489Z INFO: Sensor SCM Sensor
2017-04-25T14:04:51.5407489Z INFO: SCM provider for this project is: tfvc
2017-04-25T14:04:51.5407489Z INFO: 34 files to be analyzed

[Team TechCognia]

Hi Mickael,

We suspect, it might be related to the file, in this case it happens to be .sql.

Have you tried disabling the scm plugin for a while using sonar.scm.disabled=true

Reference : https://docs.sonarqube.org/display/SONAR/SCM+support