Error in execution of Oracle simple query


#1

Hi,
I’m trying to execute a simple oracle query and UiPath Studio was returning the error below:

11:42:34:326 => [ERROR] [UiPath.Workflow.Logging.StudioTraceListener] [27] System.Activities.InvalidWorkflowException: The workflow has validation errors. Review and resolve them first. —> System.Activities.InvalidWorkflowException: The following errors were encountered while processing the workflow tree:
‘DynamicActivity’: The private implementation of activity ‘1: DynamicActivity’ has the following validation error: Compiler error(s) encountered processing expression "“Select sh_cod_abi,
sh_dta_rif,
sh_cod_dip_host,
sh_cod_tc_host,
sh_cod_cli_host,
sh_cod_sc_host,
sh_sottocat_conto_host,
sh_cod_patrim,
sh_imp_saldo_eu,
sh_imp_saldo_do,
sh_cod_div_saldo,
sh_dta_scad_vincolo,
sh_dta_ult_variaz_saldo,
sh_cod_cdr,
sh_cod_blocco
From dw_hs_saldi_host_gg
Where sh_dta_rif = to_date (’” + today.AddDays(-2).ToString(“yyyyMMdd”) + "’,‘yyyymmdd’) and
sh_cod_tc_host = ‘0B9’ and
sh_cod_sc_host In (‘X’,‘Z’) and
sh_imp_saldo_eu <> ‘0’ “”.
String constants must end with a double quote.

at System.Activities.Validation.ActivityValidationServices.ThrowIfViolationsExist(IList`1 validationErrors, ExceptionReason reason)
at System.Activities.WorkflowInspectionServices.CacheMetadata(Activity rootActivity, LocationReferenceEnvironment hostEnvironment)
at UiPath.Workflow.ViewModels.MainViewModel.IsWorkflowValid()
— End of inner exception stack trace —

I’ve tried to double the quote of strings constants but without any effect.
Can anyone give me some hints?

Thanks
Mugur