Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
Replies
9 replies
Answers
2 answers
Subscribers
8 subscribers
Views
6279 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
How are the existing processes affected when new columns are added to the CDT an
ashleyb
over 9 years ago
How are the existing processes affected when new columns are added to the CDT and View?
We will be adding columns and changing data types to the database but are not sure of the extent of the impact that it will have on our in-flight processes.
Has anyone done this before -- any advice?...
OriginalPostID-130724
OriginalPostID-130724
Discussion posts and replies are publicly visible
Parents
0
Eduardo Fuentes
Appian Employee
over 9 years ago
This was designed that way so running instances don't break when changes are made to the CDT. Keep in mind that any sub-process node which hasn't started the process yet will launch a new instance using the updated CDT if Impact Analysis is executed.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Arun Theja Muthyalu
Certified Lead Developer
over 5 years ago
in reply to
Eduardo Fuentes
Hi
Eduardo Fuentes
,
Then how to update the process variable type to the latest version of the CDT in the active instances?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
josep
over 5 years ago
in reply to
Arun Theja Muthyalu
Hello Arun,
Are you running into an issue?
From this link
docs.appian.com/.../Generating_Database_Tables_from_CDTs.html
"... running processes cannot be updated to use the latest version of a CDT. Therefore, changes to a CDT, its underlying database structure, or related artifacts such as rules and sub-processes may cause the running processes to behave unexpectedly."
That is why it is important to try to keep the process to be short living instances and restartable.
If you already have the CDT's updated and running process instances running and facing an issue please tell us more to help you better. for example how much instances? how was the change of your CDT?
Jose
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Arun Theja Muthyalu
Certified Lead Developer
over 5 years ago
in reply to
josep
I have added two new columns to the existing CDT. I am facing no errors as of now. I have around 200 active instances.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Arun Theja Muthyalu
Certified Lead Developer
over 5 years ago
in reply to
josep
I have added two new columns to the existing CDT. I am facing no errors as of now. I have around 200 active instances.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
0
chandu
A Score Level 2
over 5 years ago
in reply to
Arun Theja Muthyalu
Hi Arun,
Suppose you have CDT and it has 4 fields and there are 200 active instances runing on it.
Now you added two more columns,untill you refer these two more columns in process instances all the active Instances will
not fail.
If you have redesigned the subprocess and used the newly added columns, In this case the new subprocess always use the
new version of the CDT and Existing Instances still continue to work.
If you have used any where in SAIL, then the sail code will fails in the active process instances since the SAIL updates directly take impact.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
0
Arun Theja Muthyalu
Certified Lead Developer
over 5 years ago
in reply to
chandu
Hi,
Thanks for the reply. I am trying to understand how can I update the process variable with the latest version of CDT in all the active instances. Because we have tasks already generated from these active process instances before the deployment. So all these tasks point to the earlier version of the CDT which doesn’t have these two newly added fields. So when the task is submitted, NULLS are being written to these new fields.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandu
A Score Level 2
over 5 years ago
in reply to
Arun Theja Muthyalu
Hi Arun,
Please go through the link,
docs.appian.com/.../Process_Upgrade.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel