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!
Release : 12.x
Component : AUTOMATION ENGINE
This is caused by a defect in the AutomationEngine component
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)