Hi team,
I am unable to update temp table in using sql update script in v8
error:
PGS-220000 PostgreSQL error: ERROR: relation "wkf471730_534_2" does not exist LINE 1: Update WKF471730_534_2
The same code working in another instance but my instance only not working.
Any SQL update restriction in this instance?
@ParthaSarathy please help on this.
My code :
sqlExec("update "+vars.tableName +" set sCname ='"+New_Campaign_Name+"' where iInpk='"+result.inpk+"' ");
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @Kumar_27,
To update temp table data in ACC v8 using the above script, you must use the "change data source" activity, and select "default data source" in the activity. Then your script should work fine..
Let me know if that helped.
BR,
Ishan
Hi,
I'm facing the same issue and I have used change data source and i'm still facing some other issue
Views
Replies
Total Likes
Hi @Haricharan,
This error seems to be related to the Snowflake sql rights. Can you share the workflow activity settings and your exact code?
BR,
Ishan
Views
Replies
Total Likes
Hi,
Please find the attached screenshot for the reference and let me know what has to be done from my side to resolve this issue
Views
Replies
Total Likes
Hi,
Any update on this, please let me know I'm running out of time.
Views
Replies
Total Likes
Hi @Haricharan,
You are getting an error in your select queryDef itself, and that is happening because you are trying to query from the temp:query schema, whereas the schema changes to something like temp:changeDataSource when you change the data source. Please check your js inbound transition to know the correct temp schema name.
BR,
Ishan
Views
Replies
Total Likes
Views
Replies
Total Likes
@Haricharan, if you look at the error it says that the column you are trying to update "mmemodescription" in the temp table does not exist.
Make sure that you add this column in your workflow additional data in order to manipulate using the sqlExec statement.
BR,
Ishan
Views
Likes
Replies