Not authorized to use SQL expressions

Forum|Forum|5 years ago
May 27, 2020
3 の返信
8332 ビュー

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,

このトピックへの返信は締め切られました。

ベストアンサー Milan_Vucetic

Hi @tejashriw155148 ,

just follow this guide: https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/api/adding-additional-sql-functions.html

Regards,

Milan

DavidKangni

Community Advisor

Hi,

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

Thanks

David

David Kangni

tejashriw155148作成者

Level 4

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,