Hi All, is there anyone have idea about this? my tap is bing-ads and target is redshift

If you scroll up from there, do you get any more specific error message? The only thing I see of note from your log is “Extractor failed” with a “}” symbol.

nope just this message

@mohsin I would set your log level to debug by doing this:

meltano --log-level=debug elt ...

```meltano | INFO Incremental state has been updated at 2021-03-18 202345.698878. meltano | DEBUG Incremental state: {'bookmarks': {'accounts': {'last_record': '2021-02-23T212900.960000+00:00'}, '141559394_ad_performance_report': {'request_id': '1238132885391'}, '141559394_keyword_performance_report': {'request_id': '1238132885442'}}} meltano | DEBUG Deleted configuration at /home/ubuntu/dev-meltano/bing-to-postgres/meltano-bing-topostgres/.meltano/run/elt/2021-03-18T202303--tap-bing-ads--target-redshift/bff5d897-cf63-4ce1-ac38-68d9005a9e8b/target.config.json meltano | DEBUG Deleted configuration at /home/ubuntu/dev-meltano/bing-to-postgres/meltano-bing-topostgres/.meltano/run/elt/2021-03-18T202303--tap-bing-ads--target-redshift/bff5d897-cf63-4ce1-ac38-68d9005a9e8b/tap.config.json meltano | ERROR Extraction failed (1): } meltano | DEBUG ELT could not be completed: Extractor failed Traceback (most recent call last): File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/cli/elt.py", line 236, in _run_elt await _run_extract_load(elt_context, output_logger) File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/cli/elt.py", line 274, in _run_extract_load await singer_runner.run( File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/core/runner/singer.py", line 253, in run await self.invoke( File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/core/runner/singer.py", line 227, in invoke raise RunnerError("Extractor failed", {PluginType.EXTRACTORS: tap_code}) meltano.core.runner.RunnerError: Extractor failed The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/cli/elt.py", line 224, in _redirect_output yield File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/cli/elt.py", line 245, in _run_elt raise CliError(f"ELT could not be completed: {err}") from err meltano.cli.utils.CliError: ELT could not be completed: Extractor failed meltano | ELT could not be completed: Extractor failed [2021-03-18 202345,815] [31668|MainThread|meltano.cli.utils] [DEBUG] ELT could not be completed: Extractor failed Traceback (most recent call last): File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/cli/elt.py", line 236, in _run_elt await _run_extract_load(elt_context, output_logger) File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/cli/elt.py", line 274, in _run_extract_load await singer_runner.run( File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/core/runner/singer.py", line 253, in run await self.invoke( File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/core/runner/singer.py", line 227, in invoke raise RunnerError("Extractor failed", {PluginType.EXTRACTORS: tap_code}) meltano.core.runner.RunnerError: Extractor failed The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/cli/__init__.py", line 43, in main cli(obj={"project": None}) File "/usr/lib/python3/dist-packages/click/core.py", line 764, in call return self.main(*args, **kwargs) File "/usr/lib/python3/dist-packages/click/core.py", line 717, in main rv = self.invoke(ctx) File "/usr/lib/python3/dist-packages/click/core.py", line 1137, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/usr/lib/python3/dist-packages/click/core.py", line 956, in invoke return ctx.invoke(self.callback, **ctx.params) File "/usr/lib/python3/dist-packages/click/core.py", line 555, in invoke return callback(*args, **kwargs) File "/home/ubuntu/.local/lib/python3.8/site-packages/meltano/cli/params.py", line 23, in decorate return func(*args, **kwargs) File "/home/ubuntu/.local/lib/py…

Hmmm still not much there... looks like it's failing at the

bing-taps

but that's all I can gather. Have you gotten this working before?

Yeah, nothing from the logs pop out to me either - it looks like the tap is failing without much information on the root of the error. If you are able to execute the tap directly, that also might be worthwhile for debugging purposes. Do you mind opening an issue for us in the Meltano project, along with these full logs? Issues · meltano / Meltano · GitLab

i am familiar with this tap, i’ll create an issue

Is there any additional error output from the tap (prefixed with

tap-bing-ads

) before these initial

meltano

lines?

nope

@mohsin Does this mean you got it working? What was the issue with the

campaign_performance_report

stream?

i don’t know what is the issue actually is, but face error as i shared above in the logs..

I'm not seeing an error in those logs, it says "Extract & load complete!" at the bottom suggesting everything went right!

check the above screenshot

The

meltano               | ERROR Extraction failed (1): }

line in the failing output suggests that the last line output by the tap was

}

. In the full failing output for

meltano --log-level=debug elt ...

, do you see any lines prefixed with

tap-bing-ads

or

tap-bing-ads (out)

that may help us figure out what's going wrong there?