devon_seitz
09/10/2021, 2:32 PMdouwe_maan
09/10/2021, 2:33 PMtap-oracle
devon_seitz
09/10/2021, 2:34 PMvisch
09/10/2021, 2:37 PMdevon_seitz
09/10/2021, 6:01 PMdevon_seitz
09/10/2021, 7:12 PMCannot list the selected attributes: Catalog discovery failed: command ['/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/bin/tap-oracle', '--config', '/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/run/tap-oracle/tap.12165e1b-1fb4-4add-8324-839aa366f54c.config.json', '--discover'] returned 1
devon_seitz
09/10/2021, 7:12 PMdouwe_maan
09/10/2021, 7:16 PMmeltano invoke tap-oracle --discover
and see if it prints an error?devon_seitz
09/10/2021, 7:17 PMdevon_seitz
09/10/2021, 7:17 PM(.venv) Devons-GeniusRx-Laptop:grx_meltano devon.seitz$ meltano invoke tap-oracle --discover
INFO starting discovery
INFO dsn: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=206.227.246.65)(PORT=5056))(CONNECT_DATA=(SID=dwmmpp01)))
INFO fetching row counts
INFO fetching tables:
SELECT owner, table_name
FROM all_tables
WHERE owner != 'SYS' []
INFO fetching views
INFO fetching column info
INFO fetching pk constraints
CRITICAL ORA-00942: table or view does not exist
Traceback (most recent call last):
File "/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/bin/tap-oracle", line 8, in <module>
sys.exit(main())
File "/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/lib/python3.7/site-packages/tap_oracle/__init__.py", line 565, in main
raise exc
File "/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/lib/python3.7/site-packages/tap_oracle/__init__.py", line 562, in main
main_impl()
File "/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/lib/python3.7/site-packages/tap_oracle/__init__.py", line 552, in main_impl
do_discovery(conn_config, filter_schemas)
File "/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/lib/python3.7/site-packages/tap_oracle/__init__.py", line 346, in do_discovery
catalog = discover_columns(connection, table_info, filter_schemas)
File "/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/lib/python3.7/site-packages/tap_oracle/__init__.py", line 283, in discover_columns
cols)
File "/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/lib/python3.7/site-packages/tap_oracle/__init__.py", line 200, in produce_column_metadata
database_name = get_database_name(connection)
File "/Users/devon.seitz/Desktop/datascience_repo/grx_meltano/.meltano/extractors/tap-oracle/venv/lib/python3.7/site-packages/tap_oracle/__init__.py", line 189, in get_database_name
rows = cur.execute("SELECT name FROM v$database").fetchall()
cx_Oracle.DatabaseError: ORA-00942: table or view does not exist
devon_seitz
09/10/2021, 7:18 PMdevon_seitz
09/10/2021, 7:18 PMdevon_seitz
09/10/2021, 7:21 PMvisch
09/10/2021, 7:24 PMSELECT name FROM v$database
You need access to the v$database table
I did a cheeky thing in tap_oracle here https://gitlab.com/autoidm/tap-oracle/-/blob/main/tap_oracle/__init__.py#L232 to get around this as if you are filtering by schemas you don't really need to query that tablevisch
09/10/2021, 7:25 PMdevon_seitz
09/10/2021, 7:27 PMdevon_seitz
09/10/2021, 7:27 PMdevon_seitz
09/10/2021, 7:33 PMvisch
09/10/2021, 7:33 PMdouwe_maan
09/10/2021, 7:34 PM