I have used VIPReplace function in update data activity and tested it in two adobe client console environments. In one environment its running properly but in other its throwing below error-
XTK-170016 You are not authorized to use SQL expressions. 'VIPReplace' cannot be processed.
I have checked the console and server build version and both environment has same version as well.
Adobe Campaign v7 (7.0 build 8887)
(Application server: 7.0 build 8891)
Please help here.
Solved! Go to Solution.
The option XtkPassUnknownSQLFunctionsToRDBMS was already available with value 0 which I changed to 1 and now getting error as ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]'VIPReplace' is not a recognized built-in function name. SQLState: 37000