rohit_amarnath
03/30/2021, 2:28 PMdocker exec -it meltano meltano --log-level=debug invoke --dump=catalog tap-salesforce
errors out with
meltano.cli.utils.CliError: expected str, bytes or os.PathLike object, not NoneType
Full Trace:
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/meltano/cli/__init__.py", line 43, in main
cli(obj={"project": None})
File "/usr/local/lib/python3.6/site-packages/click/core.py", line 829, in __call__
return self.main(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/click/core.py", line 782, in main
rv = self.invoke(ctx)
File "/usr/local/lib/python3.6/site-packages/click/core.py", line 1259, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "/usr/local/lib/python3.6/site-packages/click/core.py", line 1066, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "/usr/local/lib/python3.6/site-packages/click/core.py", line 610, in invoke
return callback(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/meltano/cli/params.py", line 23, in decorate
return func(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/meltano/cli/params.py", line 57, in decorate
func(project, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/meltano/cli/select.py", line 53, in select
show(project, extractor, show_all=flags["all"])
File "/usr/local/lib/python3.6/site-packages/meltano/cli/select.py", line 85, in show
list_all = select_service.list_all(session)
File "/usr/local/lib/python3.6/site-packages/meltano/core/select_service.py", line 51, in list_all
catalog = self.load_catalog(session)
File "/usr/local/lib/python3.6/site-packages/meltano/core/select_service.py", line 45, in load_catalog
catalog_json = invoker.dump("catalog")
File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin_invoker.py", line 195, in dump
with self._invoke():
File "/usr/local/lib/python3.6/contextlib.py", line 81, in __enter__
return next(self.gen)
File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin_invoker.py", line 167, in _invoke
with self.plugin.trigger_hooks("invoke", self, args):
File "/usr/local/lib/python3.6/contextlib.py", line 81, in __enter__
return next(self.gen)
File "/usr/local/lib/python3.6/site-packages/meltano/core/behavior/hookable.py", line 70, in trigger_hooks
self.__class__.trigger(self, f"before_{hook_name}", *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/meltano/core/behavior/hookable.py", line 97, in trigger
raise err
File "/usr/local/lib/python3.6/site-packages/meltano/core/behavior/hookable.py", line 89, in trigger
hook_func(target, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin/singer/tap.py", line 214, in discover_catalog_hook
self.discover_catalog(plugin_invoker, exec_args)
File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin/singer/tap.py", line 255, in discover_catalog
self.run_discovery(plugin_invoker, catalog_path)
File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin/singer/tap.py", line 280, in run_discovery
universal_newlines=True,
File "/usr/local/lib/python3.6/site-packages/meltano/core/plugin_invoker.py", line 183, in invoke
return subprocess.Popen(popen_args, **popen_options, env=popen_env)
File "/usr/local/lib/python3.6/subprocess.py", line 729, in __init__
restore_signals, start_new_session)
File "/usr/local/lib/python3.6/subprocess.py", line 1275, in _execute_child
env_list.append(k + b'=' + os.fsencode(v))
File "/usr/local/lib/python3.6/os.py", line 800, in fsencode
filename = fspath(filename) # Does type-checking of `filename`.
TypeError: expected str, bytes or os.PathLike object, not NoneType
taylor
03/30/2021, 2:30 PMrohit_amarnath
03/30/2021, 2:30 PMrohit_amarnath
03/30/2021, 2:31 PMversion: 1
send_anonymous_usage_stats: false
project_id: 2a7d19e2-5c53-42b6-a741-7a28dad03cd2
discovery_url: false
plugins:
extractors:
- name: tap-salesforce
variant: meltano
pip_url: git+<https://gitlab.com/meltano/tap-salesforce.git>
config:
client_id: xxx
start_date: '2021-03-01T00:00:00Z'
rohit_amarnath
03/30/2021, 2:32 PMrohit_amarnath
03/30/2021, 2:32 PMrohit_amarnath
03/30/2021, 2:33 PMaaronsteers
03/30/2021, 2:44 PMrohit_amarnath
03/30/2021, 2:46 PMrohit_amarnath
03/30/2021, 2:46 PMrohit_amarnath
03/30/2021, 2:48 PM.
instead of the full urlrohit_amarnath
03/30/2021, 2:49 PMrohit_amarnath
03/30/2021, 2:49 PMaaronsteers
03/30/2021, 2:53 PMrohit_amarnath
03/30/2021, 2:53 PMrohit_amarnath
03/30/2021, 2:53 PMrohit_amarnath
03/30/2021, 2:57 PMmeltano.cli.utils.CliError: Could not dump catalog: Could not find catalog file /projects/extract/tap-salesforce.catalog.json
rohit_amarnath
03/30/2021, 3:04 PMrohit_amarnath
03/30/2021, 3:04 PMrohit_amarnath
03/30/2021, 3:04 PMtaylor
03/30/2021, 3:06 PMaaronsteers
03/30/2021, 3:36 PMdouwe_maan
03/30/2021, 3:58 PMexpected str, bytes or os.PathLike object, not NoneType
error or are we debugging Could not find catalog file /projects/extract/tap-salesforce.catalog.json
now?rohit_amarnath
03/30/2021, 4:40 PMrohit_amarnath
03/30/2021, 4:40 PMrohit_amarnath
03/30/2021, 4:40 PMdocker run --rm --name meltano --env MELTANO_CLI_LOG_LEVEL=debug --env MELTANO_LOG_LEVEL=debug--rm -d --platform linux/amd64 -v `pwd`:/projects -p 5000:5000 -w /projects meltano/meltano
rohit_amarnath
03/30/2021, 4:41 PMrohit_amarnath
03/30/2021, 4:42 PMpwd
directory contents:rohit_amarnath
03/30/2021, 4:42 PMREADME.md
analyze
env.json
extract
load
meltano.yml
model
notebook
orchestrate
requirements.txt
site.json
transform
douwe_maan
03/30/2021, 4:59 PMTraceback (most recent call last):
for meltano.cli.utils.CliError: expected str, bytes or os.PathLike object, not NoneType
, do you see a line starting with Invoking:
? I'd like to know what the failing subprocess.run
is being called withdouwe_maan
03/30/2021, 5:01 PMsubprocess.run
fails when any env var is passed with a None
value, and your env dump shows "source_up": None,
. Where is that env var coming from?rohit_amarnath
03/30/2021, 5:02 PMsource_up
is from direnvrohit_amarnath
03/30/2021, 5:02 PMrohit_amarnath
03/30/2021, 5:02 PMrohit_amarnath
03/30/2021, 5:03 PMrohit_amarnath
03/30/2021, 5:04 PMrohit_amarnath
03/30/2021, 5:04 PMdouwe_maan
03/30/2021, 5:08 PMNone
values automatically. Would you mind creating an issue for that?rohit_amarnath
03/30/2021, 5:09 PMrohit_amarnath
03/30/2021, 5:19 PMdouwe_maan
03/30/2021, 5:21 PMrohit_amarnath
03/30/2021, 5:22 PMrohit_amarnath
03/30/2021, 7:54 PMrohit_amarnath
03/30/2021, 7:55 PMrohit_amarnath
03/30/2021, 7:55 PMrohit_amarnath
03/30/2021, 7:56 PM[2021-03-30 19:55:13,794] [23|MainThread|gunicorn.error] [CRITICAL] WORKER TIMEOUT (pid:473)
aaronsteers
03/30/2021, 7:56 PMaaronsteers
03/30/2021, 7:56 PMaaronsteers
03/30/2021, 7:57 PMrohit_amarnath
03/30/2021, 7:58 PMrohit_amarnath
03/30/2021, 7:58 PMrohit_amarnath
03/30/2021, 7:59 PMaaronsteers
03/30/2021, 8:08 PMrohit_amarnath
03/30/2021, 8:09 PMaaronsteers
03/30/2021, 8:10 PMaaronsteers
03/30/2021, 8:11 PMrohit_amarnath
03/30/2021, 8:57 PMrohit_amarnath
03/30/2021, 8:57 PMdocker exec -it meltano meltano --log-level=debug select tap-salesforce --list --all
rohit_amarnath
03/30/2021, 8:57 PMdouwe_maan
03/30/2021, 8:57 PMrohit_amarnath
03/30/2021, 8:58 PMtap.properties.json
was created at 4:08rohit_amarnath
03/30/2021, 8:58 PMrohit_amarnath
03/30/2021, 8:59 PMdouwe_maan
03/30/2021, 8:59 PMdouwe_maan
03/30/2021, 9:00 PMrohit_amarnath
03/30/2021, 9:00 PMrohit_amarnath
03/30/2021, 9:00 PMrohit_amarnath
03/30/2021, 9:00 PMrohit_amarnath
03/30/2021, 9:01 PMrohit_amarnath
03/31/2021, 6:51 PMrohit_amarnath
03/31/2021, 9:32 PMrohit_amarnath
03/31/2021, 9:33 PMTAP_SALESFORCE__SELECT
MELTANO_EXTRACT__SELECT
cause the list to be filtered?douwe_maan
04/01/2021, 4:00 PMselect
properties affect which streams and properties are selected in the generated catalog: https://meltano.com/docs/integration.html#extractor-catalog-generation
You can use meltano select tap-salesforce --list
to learn what is currently selected.
That doesn't explain why the pipeline would run for so long without showing any output thoughdouwe_maan
04/01/2021, 4:00 PMdouwe_maan
04/01/2021, 4:01 PMtap-salesforce (out)
lines in the log with SCHEMA or RECORD messages?rohit_amarnath
04/01/2021, 4:48 PMrohit_amarnath
04/01/2021, 4:49 PMrohit_amarnath
04/01/2021, 4:55 PMdocker exec -it meltano meltano --log-level=debug select tap-salesforce --list
[2021-04-01 16:54:05,093] [1553|MainThread|root] [DEBUG] Creating engine <meltano.core.project.Project object at 0x4002294e48>@sqlite:////projects/.meltano/meltano.db
[2021-04-01 16:54:08,110] [1553|MainThread|root] [DEBUG] Created configuration at /projects/.meltano/run/tap-salesforce/tap.config.json
[2021-04-01 16:54:08,114] [1553|MainThread|root] [DEBUG] Could not find tap.properties.json in /projects/.meltano/extractors/tap-salesforce/tap.properties.json, skipping.
[2021-04-01 16:54:08,121] [1553|MainThread|root] [DEBUG] Could not find tap.properties.cache_key in /projects/.meltano/extractors/tap-salesforce/tap.properties.cache_key, skipping.
[2021-04-01 16:54:08,125] [1553|MainThread|root] [DEBUG] Could not find state.json in /projects/.meltano/extractors/tap-salesforce/state.json, skipping.
[2021-04-01 16:54:08,127] [1553|MainThread|root] [DEBUG] Cached catalog is outdated, running discovery...
[2021-04-01 16:54:08,134] [1553|MainThread|root] [DEBUG] Invoking: ['/projects/.meltano/extractors/tap-salesforce/venv/bin/tap-salesforce', '--config', '/projects/.meltano/run/tap-salesforce/tap.config.json', '--discover']
[2021-04-01 16:54:08,134] [1553|MainThread|root] [DEBUG] Env: {'SALESFORCE_URL': '<https://tes> <-snip-> 'VIRTUAL_ENV': '/projects/.meltano/extractors/tap-salesforce/venv'}
rohit_amarnath
04/01/2021, 4:55 PMrohit_amarnath
04/01/2021, 4:55 PMrohit_amarnath
04/01/2021, 4:56 PMdouwe_maan
04/01/2021, 5:18 PMrohit_amarnath
04/01/2021, 5:32 PMrohit_amarnath
04/01/2021, 5:33 PMrohit_amarnath
04/01/2021, 5:33 PMdouwe_maan
04/01/2021, 5:42 PMmeltano ui
output right? I assume when you were running the pipelines earlier you were using meltano elt
? Can you share the full output for one of those meltano elt
runs? Even if it looks uninteresting or stops suddenly, the place where it stops could be enlighteningrohit_amarnath
04/01/2021, 5:45 PMrohit_amarnath
04/01/2021, 5:45 PMdouwe_maan
04/01/2021, 5:45 PMmeltano invoke tap-salesforce --discover
, does that show the same behavior? Or do you see the massive catalog printed?rohit_amarnath
04/01/2021, 6:47 PMrohit_amarnath
04/01/2021, 6:48 PMrohit_amarnath
04/01/2021, 6:50 PMdouwe_maan
04/01/2021, 6:50 PMrohit_amarnath
04/01/2021, 6:50 PMrohit_amarnath
04/01/2021, 6:51 PM[2021-04-01 18:49:45,081] [1656|MainThread|root] [DEBUG] Env: {'SALESFORCE_URL': '<https://test.salesforce.com/services/Soap/u/>', <-snip-> 'VIRTUAL_ENV': '/projects/.meltano/extractors/tap-salesforce/venv'}
INFO Attempting login via OAuth2
INFO OAuth2 login successful
INFO Starting new login timer
rohit_amarnath
04/01/2021, 6:52 PMrohit_amarnath
04/01/2021, 6:52 PMrohit_amarnath
04/01/2021, 6:52 PMrohit_amarnath
04/01/2021, 6:52 PMrohit_amarnath
04/01/2021, 6:53 PMtaylor
04/01/2021, 7:13 PMdouwe_maan
04/01/2021, 8:38 PMmeltano invoke tap-salesforce --discover
still didn't complete? Did you see any more Starting new login timer
log lines after that? I wonder if the tap has a bug somewhere where it doesn't stop the timer once discovery is completed, and just keeps the timer going indefinitelyrohit_amarnath
04/01/2021, 9:17 PMrohit_amarnath
04/01/2021, 9:18 PMrohit_amarnath
04/01/2021, 9:18 PMINFO Attempting login via OAuth2
INFO OAuth2 login successful
INFO Starting new login timer
INFO Attempting login via OAuth2
INFO OAuth2 login successful
INFO Starting new login timer
INFO Attempting login via OAuth2
INFO OAuth2 login successful
INFO Starting new login timer
INFO Attempting login via OAuth2
INFO OAuth2 login successful
INFO Starting new login timer
INFO Attempting login via OAuth2
INFO OAuth2 login successful
INFO Starting new login timer
INFO Attempting login via OAuth2
INFO OAuth2 login successful
INFO Starting new login timer
rohit_amarnath
04/01/2021, 9:18 PMrohit_amarnath
04/01/2021, 9:18 PMrohit_amarnath
04/01/2021, 9:19 PMrohit_amarnath
04/01/2021, 9:20 PMrohit_amarnath
04/01/2021, 9:23 PMrohit_amarnath
04/01/2021, 9:24 PMrohit_amarnath
04/01/2021, 9:26 PMrohit_amarnath
04/01/2021, 9:27 PMUID PID PPID C STIME TTY TIME CMD
root 1 0 0 Mar31 ? 00:00:08 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/meltano ui
root 23 1 0 Mar31 ? 00:02:21 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/gunicorn --config python:meltano.api.wsgi --pid /projects/.meltano/run/g
root 426 1 0 Mar31 ? 00:00:40 [tap-salesforce] <defunct>
root 438 1 0 Mar31 ? 00:00:55 /usr/bin/qemu-x86_64 /projects/.meltano/extractors/tap-salesforce/venv/bin/python /projects/.meltano/extractors/tap-salesforce/ven
root 498 1 0 Mar31 ? 00:00:26 [tap-salesforce] <defunct>
root 527 1 0 Mar31 ? 00:00:06 [tap-salesforce] <defunct>
root 537 1 0 Mar31 ? 00:00:56 /usr/bin/qemu-x86_64 /projects/.meltano/extractors/tap-salesforce/venv/bin/python /projects/.meltano/extractors/tap-salesforce/ven
root 675 0 0 Mar31 pts/0 00:00:07 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/meltano --log-level=debug select tap-salesforce --list --all
root 695 675 0 Mar31 pts/0 00:00:54 /usr/bin/qemu-x86_64 /projects/.meltano/extractors/tap-salesforce/venv/bin/python /projects/.meltano/extractors/tap-salesforce/ven
root 1108 0 0 Mar31 pts/1 00:00:09 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/meltano --log-level=debug select tap-salesforce --list --all
root 1127 1108 0 Mar31 pts/1 00:00:47 /usr/bin/qemu-x86_64 /projects/.meltano/extractors/tap-salesforce/venv/bin/python /projects/.meltano/extractors/tap-salesforce/ven
root 1337 23 0 03:53 ? 00:00:06 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/gunicorn --config python:meltano.api.wsgi --pid /projects/.meltano/run/g
root 1339 23 0 03:53 ? 00:00:06 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/gunicorn --config python:meltano.api.wsgi --pid /projects/.meltano/run/g
root 1341 23 0 03:53 ? 00:00:06 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/gunicorn --config python:meltano.api.wsgi --pid /projects/.meltano/run/g
root 1343 23 0 03:53 ? 00:00:06 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/gunicorn --config python:meltano.api.wsgi --pid /projects/.meltano/run/g
root 1573 1 0 16:57 ? 00:00:29 [tap-salesforce] <defunct>
root 1618 0 0 18:52 pts/2 00:00:00 /usr/bin/qemu-x86_64 /bin/bash
root 1656 1618 0 18:53 pts/2 00:00:07 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/meltano --log-level=debug invoke tap-salesforce --discover
root 1671 1656 0 18:53 pts/2 00:00:33 /usr/bin/qemu-x86_64 /projects/.meltano/extractors/tap-salesforce/venv/bin/python /projects/.meltano/extractors/tap-salesforce/ven
root 1769 0 0 21:22 pts/3 00:00:00 /usr/bin/qemu-x86_64 /bin/bash
root 1777 1769 5 21:22 pts/3 00:00:07 /usr/bin/qemu-x86_64 /usr/local/bin/python /usr/local/bin/meltano --log-level=debug select tap-salesforce --list --all
root 1792 1777 16 21:23 pts/3 00:00:22 /usr/bin/qemu-x86_64 /projects/.meltano/extractors/tap-salesforce/venv/bin/python /projects/.meltano/extractors/tap-salesforce/ven
root 1802 0 0 21:25 pts/4 00:00:00 /usr/bin/qemu-x86_64 /bin/bash
root 1812 1802 0 Mar30 ? 00:00:00 /bin/ps -ef
rohit_amarnath
04/01/2021, 9:27 PMrohit_amarnath
04/01/2021, 9:27 PMrohit_amarnath
04/02/2021, 3:03 PMdouwe_maan
04/02/2021, 7:37 PMdan_ladd
04/02/2021, 7:39 PMrohit_amarnath
04/02/2021, 7:39 PMrohit_amarnath
04/02/2021, 7:41 PMdan_ladd
04/02/2021, 7:43 PM<https://gitlab.com/meltano/tap-salesforce.git>
which seems to be the same variant you are already usingdouwe_maan
04/02/2021, 7:46 PMrohit_amarnath
04/02/2021, 7:48 PMrohit_amarnath
04/02/2021, 7:48 PMrohit_amarnath
04/02/2021, 8:03 PMdouwe_maan
04/02/2021, 9:30 PMpip_url
back to point at the main repo and get the latest version by running meltano install extractor tap-salesforce
!rohit_amarnath
04/02/2021, 11:07 PMdan_ladd
04/12/2021, 3:18 AMtaylor
04/12/2021, 1:58 PM