54
Views
10
Comments
Solved
How to update colum of External Database in Integration Studio
Question
Application Type
Reactive

Hi, all

I have a question.

I used A5 SQL and added a logical name and Reload all database information.
Then, from Integration studio, select applicable table and refresh Entity and Publish.

However, the Entity attribute in Service Studio does not changed.
What was wrong?

I would appreciate it if you could teach me.


Regards,
Sammy

UserImage.jpg
Masugorou A
Solution

Hi all

I was able to solve it by 「changing the current schema」 of A5SQL. 
Thank you all for your guidance.

Best regards,

Sammy


2025-06-28 01-52-12
Marco Mateo

Hi Sammy,


What do you mean by 'Service Studio does not changed'?

did you publish your update on integration studio and refresh dependencies on consumer module?

UserImage.jpg
Masugorou A

Hi @Marco Mateo

I appreciate your reply
Please excuse my lack of explanation. 

Entity attribute name does not changed though I published update on integration studio and refresh dependencies.

Regards,

Sammy

2025-06-28 01-52-12
Marco Mateo

Hi,

You can try to publish a solution. Create a solution that includes all modules that uses you extension module then publish the solution.

Hope this works

2024-06-08 15-17-54
Nawaz Khan

We faced similar issue that the entities were not updating in service studio while we added the some relations in DB level.

In order to reflect entities update in service studio, you need to update the entities from integration studio and then publish the integration studio changes first and refresh the dependencies in service studio.

Hope this will resolve your issue


UserImage.jpg
Masugorou A

@Nawaz Khan

I appreciate your reply.

I right-click Entity and Refresh Entity on the same screen and publish, but "Original Name" column is not changed.
From Service Studio, refresh dependencies and Publish but Entity Attribute hasn't been updated.

Regards,

Sammy


2025-08-03 07-20-35
Mythily - EONE

Hi Sammy,

Whether the change in attribute name is reflecting in Integration Studio, by right click and refresh.

Can you please check and confirm

Thanks


UserImage.jpg
Masugorou A

Hi @Mythily - EONE 

I appreciate your reply.

I right-clicked and refresh Entity but the attribute name has not changed…


Regards,

Sammy

2024-06-08 15-17-54
Nawaz Khan

@Sammy A Not sure what exactly issue you are facing. If you could share some code then it would be easy to resolve.

I have tried same, I change the attribute of a table and after refresh it worked and I can get the updated attribute in integration studio. Once I got the values in integration studio I just need to build the extension, publish and then refresh the dependencies where this extension required to use.

Please make sure that you are checking the correct table (table from the extension) not from the one defined in Service Studio through 'DATA' Tab.

if you are not getting any error and everything is building fine then my observation is that you are targeting same table through extension which is already defined through service studio while you are expecting after updating the extension Outsystem will update the table which is defined through service Studio so it will not work. In this case you have two tables in Outsystems, 1st defined through Service Studio and 2nd through extension. You have to check the table defined in extension and I hope you we get updated attributes

Hope it will help

2024-08-01 09-19-00
Mohd Shuaib

Maybe you need to check your original database if the changes are successfully applied there.

UserImage.jpg
Masugorou A
Solution

Hi all

I was able to solve it by 「changing the current schema」 of A5SQL. 
Thank you all for your guidance.

Best regards,

Sammy


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.