Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Not authorized to use SQL expressions

tejashriw155148
Level 4
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
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor
3 Replies
DavidKangni
Community Advisor
Community Advisor

Hi,

 

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

 

Thanks

David

tejashriw155148
Level 4
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,

Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor