When a FileEvent or DB Event task is run by a user who does not have Write access to the SQL variable referenced, the Even fails with the following error message:
Error : U00011363 Type conversion between Value 1('Text') and Value 2('Number') is not supported!
This is caused by a defect in the AutomationEngine component
Release : 12.x
Component : AUTOMATION ENGINE
The issue has been fixed from v12.3.4 which can be downloaded from the link below.
Give the User Write(W) privileges and authorization to the SQL Variable object(s)