Error "BAD IL FORMAT" while compiling but run normally

Help Studio
, ,
1

So i get Error while compiling flow:

“Bad IL format. The format of the file ‘C:\Users\username.nuget\packages\UiPath.database.activities\1.7.0\lib/net5.0-windows7.0/runtimes/win-x64/native/Microsoft.Data.SqlClient.SNI.dll’ is invalid”

But the flow running normally after the compile finished.

I’m aware of this post:
Bad IL format. The Format Of The File ‘C:\Users\username.nuget\packages\uipath.database.activities\1.7.0\lib/net5.0-windows7.0/runtimes/win-x64/native/Microsoft.Data.SqlClient.SNI.dll’ Is Invalid.

That post said the error related to UiPath.Database.Activities package version 1.7.0 (also observed with 1.7.1)
and suggest to:

  • Go to the database activity properties and update the Provider Name from “System.Data.SqlClient” to “Microsoft.Data.SqlClient”

But i’m currently using this provider (also using UiPath.Database.Activities package version 1.7.1) :

“Oracle.ManagedDataAccess.Client”

any idea how to get rid the compile error? it is annoying

1 Like
2

@wija

Did you try the second approach in above link

Cheers

1 Like
3

I did reinstall datatabse package, the compile error still persist.

If i delete the .dll file said in the link above, i can’t run the project at all.

1 Like