SQL update issue in v8 | Community
Skip to main content
Level 2
January 24, 2024
Solved

SQL update issue in v8

  • January 24, 2024
  • 2 replies
  • 1734 views

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+"' ");

Best answer by _Manoj_Kumar_

Hello @kumar_27 

 

The SQL code looks correct to me. But it seems the temporary table does not exist.

2 replies

_Manoj_Kumar_
Community Advisor
_Manoj_Kumar_Community AdvisorAccepted solution
Community Advisor
January 25, 2024

Hello @kumar_27 

 

The SQL code looks correct to me. But it seems the temporary table does not exist.

     Manoj     Find me on LinkedIn
isahore
Community Advisor
Community Advisor
January 25, 2024

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

Level 2
January 29, 2024

Hi,

 

I'm facing the same issue and I have used change data source and i'm still facing some other issue

 

 

isahore
Community Advisor
Community Advisor
January 29, 2024

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