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

Most upvoted comments

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!