Hello-We are Progress 10.2B007 (will be upgrading this fall when the newest version of our ERP software is released).
My understanding has been that we should be able to add new fields to existing tables while the database is online. We have done so many times in the past by loading a .df that contains the new fields...only the new fields, no other changes referenced in the .df.
A few months ago, after adding some fields online, CRC errors were being thrown in programs using that table. I found it odd, but it hadn't happened before and it was only on our development system. I chalked it up to something I must have done wrong, recompiled all of the code and moved on.
Today it happened again. So I am digging into it more. I loaded a .df file and selected the option to apply the changes on line. Everything loaded with no errors. Then the CRC errors started happening. I verified that my .df only contained new fields and nothing else. If my memory serves me correctly, I believe the table that this happened with today is the same one I encountered this with in the past. I cannot see anything obviously different about this table compared to others.
Any thoughts on why this happened? We can certainly do all schema changes offline, but our company runs 24x7 and any additional downtime that isn't needed is frowned upon and from everything I've read in the doc, we should be able to do this.
Thanks.
My understanding has been that we should be able to add new fields to existing tables while the database is online. We have done so many times in the past by loading a .df that contains the new fields...only the new fields, no other changes referenced in the .df.
A few months ago, after adding some fields online, CRC errors were being thrown in programs using that table. I found it odd, but it hadn't happened before and it was only on our development system. I chalked it up to something I must have done wrong, recompiled all of the code and moved on.
Today it happened again. So I am digging into it more. I loaded a .df file and selected the option to apply the changes on line. Everything loaded with no errors. Then the CRC errors started happening. I verified that my .df only contained new fields and nothing else. If my memory serves me correctly, I believe the table that this happened with today is the same one I encountered this with in the past. I cannot see anything obviously different about this table compared to others.
Any thoughts on why this happened? We can certainly do all schema changes offline, but our company runs 24x7 and any additional downtime that isn't needed is frowned upon and from everything I've read in the doc, we should be able to do this.
Thanks.