Hi. I’m trying to use the tap-mssql tap (singer-io...
# troubleshootingb
blake_hughes
06/09/2022, 12:59 PMHi. I’m trying to use the tap-mssql tap (singer-io variant) to pull data from an Azure SQL Server database but am getting this error:
2022-06-09T125216.197235Z [error ] Extraction failed code=1 job_id=2022-06-09T125059--tap-mssql--target-redshift message=ImportError: dlopen(/Users/bhughes/Documents/repos/data.architecture/meltano/azure_edw_2_rs2/.meltano/extractors/tap-mssql/venv/lib/python3.8/site-packages/pymssql/_mssql.cpython-38-darwin.so, 0x0002): symbol not found in flat namespace ‘_iconv’ name=meltano run_id=42edb584-1d18-4d83-9395-9da6983bb63b
Any help would be greatly appreciated.
v
visch
06/09/2022, 1:01 PMhttps://hub.meltano.com/extractors/tap-mssql recommends pipeline wise, maybe try that?
Also your meltano.yml and the command you ran to get the exception helps a lot
b
blake_hughes
06/09/2022, 1:06 PMI started out with that one, but it resulted in the same error.
blake_hughes
06/09/2022, 1:07 PMFyi, I’m on MacOS.
blake_hughes
06/10/2022, 4:42 PMFyi, I got it working by running Meltano via Docker instead of a local install. I roughly followed the instructions here: https://gitlab.com/meltano/meltano/-/issues/2863#note_640094463. Had to run the config commands from the command line for Meltano to recognize them (instead of pulling from Meltano.yml):
Copy code
meltano config tap-mssql set user <user>
meltano config tap-mssql set password <passwd>
meltano config tap-mssql set database <database>
meltano config tap-mssql set port <port>
meltano config tap-mssql set host <host>c
christoph
06/10/2022, 11:40 PMApparently the issue should have been fixed in the
pymssqlpymssql