Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
Toggling Autonumber property after creating an Entity without Identifier field
Community
›
Forums
›
Technology & Integration
Toggling Autonumber property after creating an Entity without Identifier field
New Post
New Post
Pedro Gonçalves
Posted on 2015-07-02
Pedro Gonçalves
Rank: #23
Posted on 2015-07-02
DataModelTest_oml_and_error..zip
Hello again,
Performing the following steps generates an Internal Error in Service Studio:
1. Create a new Entity
2. Delete Id attribute
3. Publish eSpace
4. Add a new Id attribute
5. Set it as autonumber
6. Publish eSpace
The final eSpace is in attach as well as the error
Generic SQL Error. Cannot update identity column 'ID'.
Why does the platform try to update the Identifier attribute in step 6, knowing it is set as Autonumber?
(from the attached error stack...)
...
UPDATE [SISIPASGO].DBO.[OSUSR_966_ENTITYX]
SET [ID]=0
...
Kilian Hekhuis
mvp_badge
mvp_label
Posted on 2015-07-06
Kilian Hekhuis
mvp_badge
mvp_label
Rank: #9
Posted on 2015-07-06
Solution
Hi Pedro,
I don't have an answer to your question, but why are you posting questions to this forum when you are, according to your profile, OutSystems staff?
Solution
Pedro Gonçalves
Posted on 2015-07-06
Pedro Gonçalves
Rank: #23
Posted on 2015-07-06
Solution
Hi Killian,
Though I am OutSystems staff, I too have questions :) Furthermore, Community members would certainly benefit from these, I hope, as anyone else developing with the platform and looking for answers.
Cheers!
Solution
Kilian Hekhuis
mvp_badge
mvp_label
Posted on 2015-07-06
Kilian Hekhuis
mvp_badge
mvp_label
Rank: #9
Posted on 2015-07-06
Solution
Hi Pedro,
I understand. I just thought you'd have secret backchannels to gain information :).
Solution
Tiago Neves
mvp_badge
mvp_label
Posted on 2015-07-06
Tiago Neves
mvp_badge
mvp_label
Rank: #75
Posted on 2015-07-06
Solution
When possible, please do it ;)
Cheers!
Solution
João Pedro Abreu
mvp_badge
mvp_label
Posted on 2015-07-07
João Pedro Abreu
mvp_badge
mvp_label
Rank: #52
Posted on 2015-07-07
Solution
The platform doen't support adding an identity column to an existing table. If you need to do that, you'll have to force the platform to create a new table, by cutting + pasting the entity, or by dropping the existing table via the database's management tool.
Why is that not supported? Like, most things that aren't, it probably was considered an edge use case.
Solution
Pedro Gonçalves
Posted on 2015-07-08
Pedro Gonçalves
Rank: #23
Posted on 2015-07-08
Solution
Sounds plausible, João. Indeed, in our scenario, we were mapping legacy tables to the Platform's local data model. So instead of recreating all the entities one-by-one, a quick option was to first map them through Integration Studio, then copy-pasting them into local entities through Service Studio. Since a first publish was performed before setting up the right Identifiers we came across this issue. On the second project we're already doing it the right way to avoid this.
Solution
Souri Roy
Posted on 17 Jan
Souri Roy
Rank: #8563
Posted on 17 Jan
Solution
João Pedro Abreu
wrote:
The platform doen't support adding an identity column to an existing table. If you need to do that, you'll have to force the platform to create a new table, by cutting + pasting the entity, or by dropping the existing table via the database's management tool.
Why is that not supported? Like, most things that aren't, it probably was considered an edge use case.
Thank you so much. It helped me as well. Cheers.
Solution
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...