https://linen.dev logo
Join Slack
Powered by
Hi, I seem to be alright using the extractor 'tap-...
# troubleshooting
c
Hi, I seem to be alright using the extractor 'tap-mssql' locally but when I try to run this on Azure Agent I get the following error and no other information. It strange as the loader and utilities install fine. What could this be? I have tried installing Rust but that doesn't seem to resolve the issue and other loader and utilities are installing fine.
Copy code
2025-02-26T14:42:31.691407Z [info ] Environment 'staging' is active
2025-02-26T14:42:32.053791Z [info ] Installing extractor 'tap-mssql'
2025-02-26T14:42:32.136840Z [info ] Installing loader 'target-postgres'
2025-02-26T14:42:32.199421Z [info ] Installing utility 'dbt-postgres'
2025-02-26T14:43:08.433158Z [info ] Installed loader 'target-postgres'
2025-02-26T14:43:27.593616Z [info ] Installed utility 'dbt-postgres'
2025-02-26T14:44:16.917966Z [info ] Logged pip install output to C:\a\3\s\elt\app.meltano\logs\pip\extractors\tap-mssql\pip.log
2025-02-26T14:44:16.918339Z [error ] Extractor 'tap-mssql' could not be installed: Failed to install plugin 'tap-mssql'.
2025-02-26T14:44:16.918563Z [info ] Collecting tap-mssql
Copy code
2025-02-26T14:44:16.918339Z [error ] Extractor 'tap-mssql' could not be installed: Failed to install plugin 'tap-mssql'.
a
Are you running on Windows or linux host locally and in cloud?
c
You're really going to want to look at the data in the pip log file I suspect C:\a\3\s\elt\app.meltano\logs\pip\extractors\tap-mssql\pip.log
c
Windows. Got it working but now seems to failing due fatal error C1083: Cannot open include file: 'sqlfront.h': No such file or directory.
Seem that it stop working today but see there is an pymssql update today - 2.3.4
2025-04-02T17:14:27,389   src\pymssql\_mssql.c(1286): fatal error C1083: Cannot open include file: 'sqlfront.h': No such file or directory
2025-04-02T17:14:27,772   error: command 'C:\\Program Files\\Microsoft Visual Studio\\2022\\Professional\\VC\\Tools\\MSVC\\14.40.33807\\bin\\HostX86\\x64\\cl.exe' failed with exit code 2
2025-04-02T17:14:28,156   ERROR: Building wheel for pymssql (pyproject.toml) exited with 1
2025-04-02T17:14:28,165   [bold magenta]full command[/]: [blue]'C:\_git\property\NorthStar.Property.ELT.LivingSectorsData\elt\app\.meltano\extractors\tap-mssql\venv\Scripts\python.exe' 'C:\_git\property\NorthStar.Property.ELT.LivingSectorsData\elt\app\.meltano\extractors\tap-mssql\venv\Lib\site-packages\pip\_vendor\pyproject_hooks\_in_process\_in_process.py' build_wheel 'C:\Users\BROWNCRA\AppData\Local\Temp\tmp6qfdj4td'[/]
2025-04-02T17:14:28,166   [bold magenta]cwd[/]: C:\Users\BROWNCRA\AppData\Local\Temp\pip-install-lu7ttykv\pymssql_56c72b6a3e4640e78f76cfbe2c11537a
2025-04-02T17:14:28,166   Building wheel for pymssql (pyproject.toml): finished with status 'error'
2025-04-02T17:14:28,168   ERROR: Failed building wheel for pymssql
I believe its related to a dependency issue with the 
tap-mssql
package, specifically due to an update to 
pymssql
on April 1st. Both versions 2.3.3 and 2.3.4 are causing compatibility issues. . The challenge is that Meltano will automatically pull in the latest version of a package if no specific version is defined. To resolve this, I created a 
requirements.txt
file specifying the exact version I need for 
pymssql
, and performed an install using that file. This should use that define version . However, for some reason, it is still downloading and using 
pymssql
version 2.3.4
I finally got it working with the help of the 50th suggestion from AI! There was nothing in the documentation or community forums that pointed to this solution. I had to add the following to the 
pip_url
Copy code
pip_url: tap-mssql pymssql==2.3.2
This fixed the issue and got everything running. Not the greatest resolution though
7 Views
Open in Slack
PreviousNext
Powered by