I am trying to run a SQL query using PI OLEDB Provider. When I am specifying a hard-coded parameter for extended descriptor, it is giving me output but when I am using a RIGHT function, the query is giving the below error.
'PIOLEDB' failed with no error message available, result code: DB_E_PARAMNOTOPTIONAL(0x80040E10).
Query With Error -
Any suggestions for work around would be highly appreciated.