How to fix this error: failure happend in source side.

Question

How to fix this error: failure happend in source side.

Dhanush Narayanan 21

IMG_adf_error.jpg I have attached the error screenshot here please help me to understand and fix this issue as soon as possible.

Dhanush Narayanan 21 Reputation points

2023-01-13T04:00:04.3366667+00:00
Hi Bjoern Peters!

Good da, Thanks for you reply. so yup i'm adding the steps and the activity fallowing.

created LS for BQ and AZ_SQL

created datasets for both and also tables in AZ_SQL.

created lookup Activity to read config file which has multiple source table name and dest table name.

based on the table name I passing the src and sink values in parameters.

once lookup activity reads the multiple src and sink infos(TBL names) i'll filter based on the names by querying in filter activity.

the for each tbl category i've created foreach activity to iterate and pass the required table names to required copy activity settings panel.

i'm getting the error here in the copy activity which moves data from BQ to AZ_SQL.

here again i'm attaching the clear snap of the error BQ_AZ_SQL_ERROR_COPY.png. Please help to fix this as soon as possible.

Thanks,

Dhanush Narayanan M
Bjoern Peters 8,921 Reputation points

2023-01-13T08:25:48.78+00:00

Hi Dhanush,

When does this error happen during what kind of activity?

How do have this action configured?

We need a little more information (and a better screenshot of that error - it is really hard to read)

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!
Bjoern Peters 8,921 Reputation points

2023-01-13T13:49:49.23+00:00

Hi Dhanush,

from your screenshot and your explanation, it seems to be an ODBC driver issue.

Could you please check if BigQuery ODBC driver is installed where SHIR is installed?
If not, kindly do the same and see if that helps.

Link to download ODBC driver is: [https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

Once the installation or Upgrade completes consider restarting system.

2 answers

Your answer

Dhanush Narayanan 21 Reputation points

2023-01-13T04:00:04.3366667+00:00

Hi Bjoern Peters!

Good da, Thanks for you reply. so yup i'm adding the steps and the activity fallowing.

created LS for BQ and AZ_SQL

created datasets for both and also tables in AZ_SQL.

created lookup Activity to read config file which has multiple source table name and dest table name.

based on the table name I passing the src and sink values in parameters.

once lookup activity reads the multiple src and sink infos(TBL names) i'll filter based on the names by querying in filter activity.

the for each tbl category i've created foreach activity to iterate and pass the required table names to required copy activity settings panel.

i'm getting the error here in the copy activity which moves data from BQ to AZ_SQL.

here again i'm attaching the clear snap of the error BQ_AZ_SQL_ERROR_COPY.png. Please help to fix this as soon as possible.

Thanks,

Dhanush Narayanan M
Bjoern Peters 8,921 Reputation points

2023-01-13T08:25:48.78+00:00

Hi Dhanush,

When does this error happen during what kind of activity?

How do have this action configured?

We need a little more information (and a better screenshot of that error - it is really hard to read)

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!
Bjoern Peters 8,921 Reputation points

2023-01-13T13:49:49.23+00:00

Hi Dhanush,

from your screenshot and your explanation, it seems to be an ODBC driver issue.

Could you please check if BigQuery ODBC driver is installed where SHIR is installed?
If not, kindly do the same and see if that helps.

Link to download ODBC driver is: [https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

Once the installation or Upgrade completes consider restarting system.

Answer 1

Alberto Morillo 35,406 MVP Volunteer Moderator

Could you please try to follow the steps provided in this article and let us know if that solve the issue.

Dhanush Narayanan 21 Reputation points

2023-01-13T04:36:54.1233333+00:00

Hi Alberto!

yeah for BQ confiq the other one working on that side but i know all those steps we have followed and the pipeline was ran at that time and moved to prd in prd it's working now seems
ShaikMaheer-MSFT 38,631 Reputation points Microsoft Employee Moderator

2023-01-13T08:30:57.6166667+00:00

Hi Dhanush Narayanan, If above answer helps, then kindly marking it as Accepted Answer. Accepted answer help community as well.

If above answer not helps, then kindly share more details on your implementation. Error screenshot also unclear. Is your dataset linked services are configured correctly? Are you able to see Test Connection is good? Kindly share more details on your implementation along with screenshots to understand it better.

Answer 2

Dhanush Narayanan 21

Hi @Alberto Morillo & @Bjoern Peters

good day, is there any way to fix this error. please assist me to fix this issue.

Thanks,

Dhanush Narayanan M

Alberto Morillo 35,406 Reputation points MVP Volunteer Moderator

2023-01-20T04:00:11.2066667+00:00

Danush, Shaik is requesting more details for better help you with this issue. Please provide more detail about the problem

Share via

How to fix this error: failure happend in source side.

2 answers

Your answer