topic ERROR: Internal : Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression. in Product Forum

ERROR: Internal : Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression.

SourabhSharma — Wed, 15 Mar 2023 18:21:37 GMT

HI all,

I am using oledb to update the records in excel sheet using update query. it was working fine.

but now it's throwing error: ERROR: Internal : Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression.

I just want to know what could be the possible causes? can anyone please help. ?

Thanks

Re: ERROR: Internal : Could not execute code stage because exception thrown by code stage: Data type mismatch in criteria expression.

Mukeshh_k — Wed, 15 Mar 2023 19:56:29 GMT

Hi Sourabh Sharma,

It seems there are issues with your Data column format - Kindly check the format of your column in the excel sheet- Try making all the columns format as Text and retry it, it should be able to perform the update.

Regards

Mukesh