SQL update issue in v8

[Kumar_27]

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_ · Accepted solution]

Hello @Kumar_27 

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

[isahore]

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

[Haricharan]

Hi,

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

[isahore]

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

[Haricharan]

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

[Haricharan]

Hi,

Any update on this, please let me know I'm running out of time.

[isahore]

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

[Haricharan]

Hi @isahore 

I have updated the queryDef schema name and im still facing the postgreSQL error.

[isahore]

@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