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

Help Studio
, ,
1

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

Error_SQL_Connection
Error_SQL_Connection1372×303 62.4 KB

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

2

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

3

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