Unable to extract data from SQL database server

Automation Studio
1

Hi,

While trying to execute a select database query the result of Success always returns False and the number of rows as 0 in Automation Studio.
image
The query execution works fine while directly connecting to the DB/ while running using microbots.

Automation logs have the below details.
co_module~SE_ACE inst_key~0 trans_key~0 trans_id~ req_id~ cust_id~ crossref_id~ workspacekey~Default datetime~2020-11-19T12:15:06.450+04:00 level~Info priority~0 srcmodule~WorkflowStudio.Execution.ExecutionAppDomainController method~Plugin_LaunchCompleted message~Launch status for application RPATest is LaunchCompleted description~NA userid~XXXX\XXXXX ipaddress~XX.XXX.XXX.XXX
co_module~SE_ACE inst_key~0 trans_key~0 trans_id~ req_id~ cust_id~ crossref_id~ workspacekey~Default datetime~2020-11-19T12:15:40.642+04:00 level~Error priority~0 srcmodule~EV.AE.Studio.ActivityLibrary.ExecuteDatabaseQueryActivity method~CacheMetadata errormessage~Object reference not set to an instance of an object. errordetails~ExceptionMessage - Object reference not set to an instance of an object.
ExceptionSource - EV.AE.Studio.ActivityLibrary
ExceptionTarget - Void ActivityCacheMetaData(System.Activities.NativeActivityMetadata)
StackTrace - Logging Stack Trace is disabled userid~XXXX\XXXXX ipaddress~XX.XXX.XXX.XXX

Kindly assist with the below error.

Regards,
Manoj Chacko

2

Hi,

Query you are to execute is it running from a standard editor from machine where AssistEdge Community Edition is installed.
Also, check if you are not passing null value in mandatory parameter

Regards,
Amit Anand

3

Hi Amit,

Yes the query is running from the standard editor when AE is installed.
Only one parameter is used where the query is being passed. However, the Test run is successful but the Success Status returns False.

Regards,
Manoj Chacko

4

Hi,

Are you getting required data from your query in the result set data table. Also, are getting error in logs only or also on Studio Error console.

Regards,
Amit Anand

5

Hi Amit,

We were able to find the root cause of the issue. For RPA17.6 Microsoft Office is a mandate to be installed on the server for the connectivity to be established with SQL Server. Also, a fix is available in the product where a new DLL is available to handle this scenario.

Thanks and regards,
Manoj Chacko