topic Data OLEDB - Open Action Hangs Indefinitely in Digital Exchange

Data OLEDB - Open Action Hangs Indefinitely

JezreelFernande — Mon, 02 Nov 2020 07:37:00 GMT

Hi,

Need your expertise on one issue we are facing with DATA - OLEDB Object.

Scenario: Process was opening an excel file and retrieving data using OLEDB for further processing.

Process Sequence:
1. Set Connection
2. Open <- This is where the issue happens. No exception message from BP. Process is only in warning state in control room indefinitely. No error messages showing on the Windows Event Logs. Issue is happening randomly and does not happen during development and debug mode.
3. Get Collection
4. Close

Question:
1. Did any of you encounter the same issue, how did you solve this type of issue?
2. Any other ideas on how to perform a root cause analysis on the issue, as the logs does not show much of information?
3. Is there a way to place a timeout on the open command so that it will throw an exception, and create an exception workflow?

Thanks a lot for your advices.

------------------------------
Jezreel Fernandez
RPA Developer
Jabil Singapore
------------------------------

RE: Data OLEDB - Open Action Hangs Indefinitely

ewilson — Mon, 02 Nov 2020 18:06:00 GMT

Hi @Jezreel Fernandez,

Can you provide some background on the contents of the Excel you're trying to open? How large is the file? How many rows/columns are in it? What are the RAM and CPU specs of the runtime resources you're using? I'm wondering if perhaps you're running into an issue of resource consumption.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Data OLEDB - Open Action Hangs Indefinitely

JezreelFernande — Tue, 03 Nov 2020 02:41:00 GMT

Hi @ewilson,

Thanks for the response.

To answer your questions:
1. The excel file only contains 1 worksheet with a simple table content (consist of basic table for header and data) 26 column and 413 rows (1st row is the header).
2. The file is around 119 Kb only.
3. We run the process in an 8gb RAM, Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20 GHz 2.19 GHz (2 processors) on Windows 10 Enterprise 64 bit ver 1709 build.

------------------------------
Jezreel Fernandez
RPA Developer
Jabil Singapore
Asia/Hong_Kong
------------------------------

RE: Data OLEDB - Open Action Hangs Indefinitely

NileshJadhavBP — Tue, 03 Nov 2020 18:22:00 GMT

Hi,

which version of excel you are using ? have you using correct connection string?

For correct connection string check below link.

https://www.connectionstrings.com/excel/

I hope it will help you

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------

RE: Data OLEDB - Open Action Hangs Indefinitely

JezreelFernande — Wed, 04 Nov 2020 01:15:00 GMT

Thanks @Nilesh Jadhav for the feedback

We are currently using Excel 2016 and this connection string "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="& <file path> &" ;Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=1';"

Based on the behavior of the process, it is running properly, for discussion sake let 's say maybe 99/100. That last 1 is due this issue happening.

Regards,

------------------------------
Jezreel Fernandez
RPA Developer
Jabil Singapore
Asia/Hong_Kong
------------------------------

RE: Data OLEDB - Open Action Hangs Indefinitely

ewilson — Wed, 04 Nov 2020 15:55:00 GMT

@Jezreel Fernandez,

Any chance of sharing an example of your Excel? I'd like to run some tests against it if possible.

Cheers,

------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------

RE: Data OLEDB - Open Action Hangs Indefinitely

JezreelFernande — Thu, 05 Nov 2020 00:52:00 GMT

@ewilson,

Unfortunately, I can't share it. The file consists of sensitive information. Is there a chance you can test it out using dummy excel data replicating the scenario I mentioned above? - "excel file only contains 1 worksheet with a simple table content (consist of basic table for header and data) 26 column and 413 rows (1st row is the header)"

Regards,

------------------------------
Jezreel Fernandez
RPA Developer
Jabil Singapore
Asia/Hong_Kong
------------------------------