Postgresql error while sql execution | Community
Skip to main content
H
Haricharan
Level 2
January 29, 2024
Solved

Postgresql error while sql execution

  • January 29, 2024
  • 2 replies
  • 1506 views

Hi Guys, I'm facing the postgresql error while SQL execution to update the table name. Let me know why i'm facing this error and i can execute the same SQL in V7 and i'm facing the issue while executing the same in V8

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by isahore

Hi @haricharan,

 

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 if there are no other syntax errors.

 

Let me know if that helped.

 

BR,

Ishan

2 replies

AkshayAnand
Community Advisor
AkshayAnandCommunity Advisor
Community Advisor
January 29, 2024

Hi @haricharan 

 

The error states that the temp table you are trying to access is invalid, could you check the temp table name by enabling the SQL logs in the properties of the workflow.

Hope this helps!

You can try inserting the value through JavaScript write method also. For reference.

 

Thanks

Akshay

H
HaricharanAuthor
Level 2
January 29, 2024

I have checked the SQL logs and re-run the workflow but the sql logs looks empty.

 

AkshayAnand
Community Advisor
AkshayAnandCommunity Advisor
Community Advisor
January 29, 2024

Hi @haricharan 

 

Could you please check if the checkbox is "checked".

 

linking the documentation for reference.

 

Thanks

Akshay

isahore
Community Advisor
isahoreCommunity AdvisorAccepted solution
Community Advisor
January 29, 2024

Hi @haricharan,

 

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 if there are no other syntax errors.

 

Let me know if that helped.

 

BR,

Ishan

H
HaricharanAuthor
Level 2
January 30, 2024

Hi Ishan,

 

This is working fine but the thing is while using memodescription to populate the table inside the delivery, its not working!

 

But using any other field to populate the value its working!

 

Terms & ConditionsAccessibility statement

Loading footer...