cloudquery: Unable to use the OracleDB source plugin
Hi,
The following source config:
kind: source
spec:
name: "oracledb"
path: "cloudquery/oracledb"
version: "v1.1.1"
tables: ["*"]
destinations: ["postgresql_destination"]
spec:
connection_string: "oracle://user:pass@host:1521/service"
Produces the following error:
Error: failed to sync v1 source oracledb: rpc error: code = Internal desc = failed to init plugin: failed to create execution client for source plugin oracledb: failed to apply config to tables: tables include a pattern * with no matches.
I’ve verified that the user has access to multible tables in the db.
The database is OracleDb v19.
Relevant log output:
2023-05-25T13:42:02Z INF Start sync destinations=["file_destination","postgresql_destination"] module=cli source="oracledb (v1.1.1)" sync_time=2023-05-25T13:42:02Z
2023-05-25T13:42:02Z INF started call grpc.code=OK grpc.component=server grpc.method=Init grpc.method_type=unary grpc.service=cloudquery.source.v1.Source grpc.start_time=2023-05-25T15:42:02+02:00 grpc.time_ms=0 module=cli peer.address=@ protocol=grpc
2023-05-25T13:42:03Z ERR finished call grpc.code=Internal grpc.component=server grpc.error="rpc error: code = Internal desc = failed to init plugin: failed to create execution client for source plugin oracledb: failed to apply config to tables: tables include a pattern * with no matches" grpc.method=Init grpc.method_type=unary grpc.service=cloudquery.source.v1.Source grpc.start_time=2023-05-25T15:42:02+02:00 grpc.time_ms=234.306 module=cli peer.address=@ protocol=grpc
2023-05-25T13:42:03Z INF End sync destinations=["file_destination","postgresql_destination"] module=cli source="oracledb (v1.1.1)" sync_time=2023-05-25T13:42:02Z
2023-05-25T13:42:03Z INF Sending sync summary to analyticsv1.cloudquery.io:443 module=cli
2023-05-25T13:42:03Z INF waiting for destination plugin to terminate module=cli
2023-05-25T13:42:03Z INF destination plugin process exited with exit status 1 module=cli
2023-05-25T13:42:03Z INF waiting for destination plugin to terminate module=cli
2023-05-25T13:42:03Z INF destination plugin process exited with exit status 1 module=cli
2023-05-25T13:42:03Z INF waiting for source plugin to terminate module=cli
2023-05-25T13:42:03Z INF source plugin process exited with exit status 1 module=cli
2023-05-25T13:42:03Z ERR exiting with error error="failed to sync v1 source oracledb: rpc error: code = Internal desc = failed to init plugin: failed to create execution client for source plugin oracledb: failed to apply config to tables: tables include a pattern * with no matches" module=cli
About this issue
- Original URL
- State: closed
- Created a year ago
- Comments: 16 (8 by maintainers)
Commits related to this issue
- fix: List tables from `ALL_TABLES` with `TABLESPACE_NAME = 'USERS'` (#11163) #### Summary Fixes https://github.com/cloudquery/cloudquery/issues/10964 See explanation in https://github.com/c... — committed to cloudquery/cloudquery by erezrokah a year ago
- fix: Change list tables to exclude default namespaces except `USERS` (#11526) #### Summary Follow up to https://github.com/cloudquery/cloudquery/pull/11163. Hopefully fixes https://github.com... — committed to cloudquery/cloudquery by erezrokah a year ago
- fix: Filter out invisible columns (#11535) #### Summary Fixes https://github.com/cloudquery/cloudquery/issues/10964#issuecomment-1590962768 <!-- — committed to cloudquery/cloudquery by erezrokah a year ago
I get past the table listing issue now, so yes, I think this issue can be closed (ran into https://github.com/cloudquery/cloudquery/issues/11538 instead 😃)
Indeed, it seems like all the columns without
column_id
are invisible (adding the HIDDEN_COLUMN to the previously discussed query confirms this).And the inverse is also true: all columns that are not hidden always have a column_id.
From my perspective, we could filter out hidden columns altogether.
Yes, it does!