Not authorized to use SQL expressions

[#1]

Hi,

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.

Thanks,

[#2 · Accepted solution]

Hi @tejashriw155148 ,

just follow this guide: https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/api/addin...

Regards,

Milan

[#3]

Hi @DavidKangni 

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

Thanks,

[#4]

Hi,

Add this option XtkPassUnknownSQLFunctionsToRDBMS and set it as integer with value equal to 1

Thanks

David