Description
The following error might be observed on the Confluent Cloud UI for Microsoft SQL Server Source Connectors:
Task is being killed because it was not assigned a table nor a query to execute. If run in table mode please make sure that the tables exist on the database. If the table does exist on the database, we recommend using the fully qualified table name.
Applies To
Confluent Cloud
Microsoft SQL Server Source Connector
Cause
This error message from Confluent Connect indicates that a task within your connector has been terminated because it was not properly configured to read data from a specific table or query in your database.
Resolution
We suggest checking with your Microsoft SQL Server DBA directly to check the following potential causes:
- Double-check that the table you've specified in your connector configuration exists in your database.
- Make sure the database connection user has sufficient permissions to access the tables.
- Ensure you are using the correct fully qualified table name (for example, <schema_name>.<table _name>), including the database name if necessary.