Error: Connect to database: Expression Activity type 'VisualBasicValue`1' requires compilation in order to run. Please ensure that the workflow has been compiled

Hello,
I am facing this error while config the connect to database activity.


Error: Connect to database: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.

Hi @Aastha_Singh

Just re-enter the expression | Double quotation "

In windows legacy, it seems double quote is normalized and any double quote characer is accepted. However, at this time, in windows (.net6) ,in fact, only " (0x22) is accepted to express string literal. To make matter worse, it seems to occur only compiling. (Expression validator don’t raise an alert.)

Regards
Gokul

HI @Aastha_Singh

Remove all the Double quotes used in the activity and replace the double quotes manually by typing and try again

Regards
Sudharsan