Error occurring in Python Activity

Help Activities
, ,
1

Hi guys! The script as below runs well within Pycharm.

The image shows a Python script in PyCharm where a connection to a database is established, and data is fetched and printed, with the console displaying a set of JSON records. (Captioned by AI)
The image shows a Python script in PyCharm where a connection to a database is established, and data is fetched and printed, with the console displaying a set of JSON records. (Captioned by AI)2560×1466 384 KB

It encounters error within UiPath. There is no useful info.

The image shows a software interface with debugging information for a Python method, highlighting an error and displaying related code and exception details. (Captioned by AI)
The image shows a software interface with debugging information for a Python method, highlighting an error and displaying related code and exception details. (Captioned by AI)1920×1147 179 KB

I adjust the code so that it can run within UiPath.

The image shows a dual-screen setup displaying a Python script in a code editor and a UiPath automation project with a JSON deserialization task. (Captioned by AI)
The image shows a dual-screen setup displaying a Python script in a code editor and a UiPath automation project with a JSON deserialization task. (Captioned by AI)1920×1150 159 KB

It seems that PyADOmd package is related to .NET which causes the error, I guess.
And my intention is to retrieve data from Powerbi desktop using python script.
Thanks in advanced!

2

@donfeng91

The issue is your .net library as suspected

Currently UiPath uses .net 5+ and messaging.callcontext is not available..

You might need to change the library for it to work as it uses .net 4.8

ideally it might not work ,unless you use a lower version python package(UiPath) and python version then as lower version of python version needs lower .net runtime it might work

Cheers

3

Thanks for your sharing.
I’ve tried to lower relatives. Failed.
At last, use PowerBI python visual object to invoke PyADOmd and PowerShell.

1 Like