Skip to main content
Level 2
Jan 24, 2024 9:42 AM UTC
Solved

SQL update issue in v8

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

Manoj_Kumar
Manoj_KumarAccepted solution
Community Advisor
Jan 25, 2024 12:33 AM UTC

Hello @kumar_27 

 

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

Manoj  | https://themartech.pro

9 replies

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
Jan 25, 2024 12:33 AM UTC

Hello @kumar_27 

 

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

Translate
Manoj  | https://themartech.pro
isahore
Community Advisor
Community Advisor
Jan 25, 2024 3:19 PM UTC

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

Translate
Level 2
Jan 29, 2024 8:44 AM UTC

Hi,

 

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

 

 

Translate
isahore
Community Advisor
Community Advisor
Jan 29, 2024 9:16 AM UTC

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

Translate