I configure everything and get a successful connec...
# getting-startedw
wesseljt
06/30/2023, 1:09 PMI configure everything and get a successful connection to the sql db - and the --list comand works ( I can tell I'm selecting what I wanted) but I can't get any data out
wesseljt
06/30/2023, 1:10 PMmeltano_yml.yaml
wesseljt
06/30/2023, 1:12 PM Copy code
→ $ meltano run tap-mssql target-jsonlwesseljt
06/30/2023, 1:12 PMdoes not output a file to the output/ directory
wesseljt
06/30/2023, 1:12 PMand on every other run it fails without changing anything...
wesseljt
06/30/2023, 1:14 PM Copy code
2023-06-30T13:12:54.432740Z [info ] raise Exception( cmd_type=elb consumer=False name=tap-mssql producer=True stdio=stderr string_id=tap-mssql
2023-06-30T13:12:54.432959Z [info ] Exception: only INCREMENTAL, LOG_BASED and FULL TABLE replication methods are supported cmd_type=elb consumer=False name=tap-mssql producer=True stdio=stderr string_id=tap-mssql
2023-06-30T13:12:54.501005Z [info ] Incremental state has been updated at 2023-06-30 13:12:54.500896.
2023-06-30T13:12:54.510813Z [error ] Extractor failed
2023-06-30T13:12:54.511214Z [error ] Block run completed. block_type=ExtractLoadBlocks err=RunnerError('Extractor failed') exit_codes={<PluginType.EXTRACTORS: 'extractors'>: 1} set_number=0 success=False
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.
Run invocation could not be completed as block failed: Extractor failedwesseljt
06/30/2023, 1:14 PMthanks in advance for any help someone can provide!
j
joshua_janicas
06/30/2023, 1:26 PMYou may need quotes around your
FULL TABLEw
wesseljt
06/30/2023, 1:27 PMhmm - ya I tried that but let me try again
wesseljt
06/30/2023, 1:29 PMya - didn't work. It also only errors every other time with that message - but I don't get any data either time
wesseljt
06/30/2023, 1:30 PMthis works fine (everytime)
Copy code
meltano select tap-mssql --listwesseljt
06/30/2023, 1:31 PMI'm looking through this older post right now
wesseljt
06/30/2023, 1:31 PMwesseljt
06/30/2023, 1:33 PMadding this post as well to have it here https://meltano.slack.com/archives/C01TCRBBJD7/p1657115223238799
r
Reuben (Matatika)
06/30/2023, 1:33 PMThere is another thread here. I had the same issue today but was able to resolve it with
metadataReuben (Matatika)
06/30/2023, 1:36 PMFeel like adding
FULL TABLEw
wesseljt
06/30/2023, 1:38 PMso I see
FULL_TABLEFULL TABLEwesseljt
06/30/2023, 1:38 PMtried both and still struggling a bit
r
Reuben (Matatika)
06/30/2023, 1:51 PMYeah, I think what you set is dependent on the tap variant you are using. Somewhat confusingly, the tap error message references
FULL TABLEFULL_TABLEw
wesseljt
06/30/2023, 1:57 PMOk - awesome! Here is my working config
j
joshua_janicas
06/30/2023, 1:58 PMThat exception message should def be changed 😆
w
wesseljt
06/30/2023, 1:59 PMmeltano.yml
r
Reuben (Matatika)
06/30/2023, 2:00 PMNice!
w
wesseljt
06/30/2023, 2:01 PMThanks so much for the help!
r
Reuben (Matatika)
06/30/2023, 2:09 PMhttps://github.com/wintersrd/pipelinewise-tap-mssql/pull/36 Hope they accept it! 😅