Excel To DataBase

Help Activities
1

Hello everybody.

I have a little problem with the Connect database activity.

My fisrt step is Use an Excel file
image

After that, i use Connect DataBase activity for SQL request
image
image

My problem is :

This activity works. But often i have an error message :

“Message d’erreur : Unable to read Excel file, Try again.”

Why is ramdon ? Do you have à solution or suggestion, so that this activity works every time?

It works 1 time out of 3 tries, this is a problem for my automation because this prevents it from turning properly.

I’m open to all proposals.

Thanks so much

2

Hi @DimitriLYR

Check below link for your reference

Hope this may help you

Thanks,
Srini

1 Like
3

I would recommend to get this fixed with some workarounds

  1. Use KILL PROCESS activity before to the use excel file and mention as “Excel” in PROCESS NAME property

  2. Put the activity (that is getting failed) inside ACTION Block or RETRY SCOPE activity and leave the conduit block empty
    Mention as 3-4 times as NUMBER OF RETIRES property

This will execute the same activity again if it fails
As you said this error is occurring intermittently

Hope this help

Cheers @DimitriLYR

1 Like
4

Hello, sorry for late.

Thanks for your answers.

I’m try your suggestions.

Thanks you so much.

1 Like
5

Let us know for any further clarification

If clarified then would recommend to close this topic

If not we can keep this discussion open

Cheers @DimitriLYR

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.