I have created a SQL to UPDATE from outsystems to an external DB (Postgres) and when I execute the Test SQL, I get the following error.
When I copy the target table in the external DB to local and execute the Test SQL with the exact same SQL, it passes without any problem.
I think it is probably a communication problem between Outsystems and Postgres, but if there is a solution, please let me know.
Translated with DeepL
Error message
[Database returned the following error:
Error in advanced query UpdateMaster: 42703: column "outsystems" of relation "m_hoge" does not exist]
You need to check extension that you are using for external database into integration studio and also check configuration of this extension into service center to make sure logical database is mapped correctly to connection string.
You can do that :
- Open service center
- Go to Factory then Extension
- Find your extension and click it
- Move to Operation tab and check
Hi Takuma,
from the error message it refers that column does not exist or the update statement is not correct.
If you could share the statement maybe we could help you better.
Regards
Hi carl,
All columns that exist in the table are listed in the SQL, but the error message is trying to reference a column called "outsystems" that should not exist in the external DB table.
I would like to know the cause of this.
The image is not the actual UPDATE SQL, but if I run TestSql with this type of SQL, I get error 42703.
Hello,
Can you check executed SQL tab after clicking test and get error. You will find actual SQL statement that is used in your update query. Please check it if it contains something wrong.
Hello Mostafa,I checked the SQL executed and found the following SQL executed.
The table name is prefixed with "outsystems".
I think this is the cause, but how can I fix it to execute the SQL to the external DB?