Write back error — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Write back error

Question
1
Views
0
Comments
Jack
Jack Rank 4 - Community Specialist
edited Aug 13, 2024 7:13PM in Oracle Analytics Cloud and Server

Hi

I am getting error while trying to writeback data to DB using writeback functionality.

I have used below update statement in the template and getting error as "The system was unable to generate appropriate SQL. Please contact your system administrator."

All columns are vachar and specified single quotes in the template. can any one suggest

UPDATE Table SET col4='@{4}' where col1 ='@{1}' AND col2= '@{2}' AND col3='@{3}'