Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
6 subscribers
Views
1764 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
We have to make some changes to the structure of several related tables in our M
judym598
Certified Senior Developer
over 10 years ago
We have to make some changes to the structure of several related tables in our MySQL DB in our production environment (i.e., change the character length of a column). These tables are associated with CDTs that are used in a number of process models and rules. What's the best way to make these changes to avoid 'breaking' our process models and rules. Does this make sense?
1. Update the table structures first.
2. Republish each of the related data types (CDTs)
3. Run Impact Analysis and follow steps to update process models
4. Re-verify Data Store (?)
5. Export updated DS, CDTs (which technically shouldn't have changed since the column and data type is the same), PMs, rules, etc.
6. When importing the updated DS, CDTs, PMs, rules, etc. - Run the data scripts that will update the table structures FIRST.
Please advise if I have any of these steps out of order or if I'm missing any (such as - do I need to delete the CDTand reimport the XSD file ...
OriginalPostID-141861
OriginalPostID-141861
Discussion posts and replies are publicly visible
Parents
0
PhilB
A Score Level 1
over 10 years ago
You may wish to check the JPA annotations in the CDTs as you are able to define a field length for a field in a CDT which is then used if you allow Appian to create the database tables. It's likely that option isn't used, but it's definitely worth checking.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
PhilB
A Score Level 1
over 10 years ago
You may wish to check the JPA annotations in the CDTs as you are able to define a field length for a field in a CDT which is then used if you allow Appian to create the database tables. It's likely that option isn't used, but it's definitely worth checking.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data