Not authorized to use SQL expressions

Avatar

Avatar

tejashriw155148

Avatar

tejashriw155148

tejashriw155148

27-05-2020

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,

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

Milan_Vucetic
MVP

28-05-2020

Answers (2)

Answers (2)

Avatar

Avatar

tejashriw155148

Avatar

tejashriw155148

tejashriw155148

28-05-2020

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

Avatar

DavidKangni

MVP

Avatar

DavidKangni

MVP

DavidKangni
MVP

27-05-2020

Hi,

 

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

 

Thanks

David