Expand my Community achievements bar.

SOLVED

Not authorized to use SQL expressions

Avatar

Level 4

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,

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
3 Replies

Avatar

Community Advisor

Hi,

 

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

 

Thanks

David



David Kangni

Avatar

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,

Avatar

Correct answer by
Community Advisor