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]  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,
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)
— 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?