commentBlock = $("#comment_post_36340").find('.comment-blocks'); commentBlock.find('.loading').hide(); commentBlock.find('.see-all-comments').hide(); commentBlock.html("
<\/a>
\"it_user387957<\/a>
it_user387957<\/a>Senior Release Engineer at a retailer with 501-1,000 employees<\/span><\/div>
<\/span>Vendor<\/span><\/div>
<\/i><\/div>
<\/i>Report as inappropriate<\/a><\/div><\/div><\/div>

There has been one manual change I\'ve needed to make so far. Some components reported having version import failures. Our artifacts are pushed from Jenkins and should not be imported automatically. I went to each component and unchecked the option to import versions automatically.\n<\/p><\/div>

<\/i>Like<\/span>(0<\/span>)<\/a><\/i>Reply<\/span><\/a><\/div>
<\/div><\/div>
<\/a>
\"it_user387957<\/a>
it_user387957<\/a>Senior Release Engineer at a retailer with 501-1,000 employees<\/span><\/div>
<\/span>Vendor<\/span><\/div>
<\/i><\/div>
<\/i>Report as inappropriate<\/a><\/div><\/div><\/div>

The server did not start right away after the upgrade. We got the following error in the stdout log file (not deployserver.out).<\/p>\n\n

2016-09-02 08:54:28,521 INFO main com.urbancode.ds.UDeployServer - Starting Versioned File Storage...\n
2016-09-02 08:54:28,535 WARN RecordMetadataService org.hibernate.util.JDBCExceptionReporter - SQL Error: 1665, SQLState: HY000\n
2016-09-02 08:54:28,535 ERROR RecordMetadataService org.hibernate.util.JDBCExceptionReporter - Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.\n
2016-09-02 08:54:28,537 INFO main com.urbancode.ds.UDeployServer - done\n
Exception in thread \"RecordMetadataService\" org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update\n
...... more java dump<\/p>\n\n

Our DB team recognized this immediately and fixed the problem. The server started find after that.\n<\/p><\/div>

<\/i>Like<\/span>(0<\/span>)<\/a><\/i>Reply<\/span><\/a><\/div>
<\/div><\/div>
<\/a>
\"it_user387957<\/a>
it_user387957<\/a>Senior Release Engineer at a retailer with 501-1,000 employees<\/span><\/div>
<\/span>Vendor<\/span><\/div>
<\/i><\/div>
<\/i>Report as inappropriate<\/a><\/div><\/div><\/div>

We have done a test upgrade to UCD6.2. We did this last Thursday and Friday. We had an IBM consultation on site to help us. This was a great idea since we got clear instructions, quick resolution of problems which were few, and we learned a lot.<\/p>\n\n

My next several comments will cover the events of the upgrade. I\'ll add more as we uncover them. So far overall we\'ve been doing OK.<\/p>\n\n

It took 11 hours to do the DB migration. There were steps needed for each release from 4.8.4 (we started at 5.0.0.4 so there must have been a few more changes needed from 4.8.4). Don\'t let your version get that far behind :-). <\/p>\n\n

Here are all of the changes that had to be applied. Some steps took a very long time, so be patient.<\/p>\n\n

[upgrade] Applying 4.8 change: 52 - Adding support for HTTP property definitions\n
[upgrade] Applying 4.8 change: 53 - Indexing join column for finding latest versions by path/directory\n
[upgrade] Applying 4.8 change: 54 - Add placeholder property to ps_prop_def\n
[upgrade] Applying 4.8 change: 55\n
[upgrade] Applying 4.8 change: 56\n
[upgrade] Applying 5.0 change: 1 - Add type column to pl_plugin table\n
[upgrade] Applying 5.0 change: 2 - Add the pl_plugin_role table\n
[upgrade] Applying 5.0 change: 3 - Add role column to pl_plugin_command table\n
[upgrade] Applying 5.0 change: 4 - Migrate security schema from commons-security model to air-security\n
[upgrade] Applying 5.0 change: 5 - Migrate security schema from commons-security model to air-security\n
[upgrade] Applying 5.0 change: 6 - Migrate security schema from commons-security model to air-security\n
[upgrade] Applying 5.0 change: 7 - Load new security schema with pre-populated configuration\n
[upgrade] Applying 5.0 change: 8 - Remove role requirement columns from statuses\n
[upgrade] Applying 5.0 change: 9 - Updating mappings from live tasks to roles to use new security concepts\n
[upgrade] Applying 5.0 change: 10 - Incorporating user properties upgrade\n
[upgrade] Applying 5.0 change: 11 - Changing resource name uniqueness to be scoped by parent (1/2)\n
[upgrade] Applying 5.0 change: 12 - Changing resource name uniqueness to be scoped by parent (2/2)\n
[upgrade] Applying 5.0 change: 13 - Creating mapping table from environments to resources\n
[upgrade] Applying 5.0 change: 14 - Adding tags, converting existing resource roles to tags\n
[upgrade] Applying 5.0 change: 15 - Creating resource roles associated with components\n
[upgrade] Applying 5.0 change: 16 - Migrating resource groups to the new resource model\n
[upgrade] Applying 5.0 change: 17 - Changing all resource group security resources to resource resources\n
[upgrade] Applying 5.0 change: 18 - Convert various resource role usages to tag usage\n
[upgrade] Applying 5.0 change: 19 - Creating subresources with appropriate roles for all resources mapped to components\n
[upgrade] Applying 5.0 change: 20 - Removing resource groups\n
[upgrade] Applying 5.0 change: 21 - Removing join table between resources and roles\n
[upgrade] Applying 5.0 change: 22 - Adding a more defined relationship between resource roles and components\n
[upgrade] Applying 5.0 change: 23 - Adding ghosting to snapshots\n
[upgrade] Applying 5.0 change: 24 - Adding a path field to ds_resource\n
[upgrade] Applying 5.0 change: 25 - Populate the path field in ds_resource\n
[upgrade] Applying 5.0 change: 26 - Remove all references to task definition\n
[upgrade] Applying 5.0 change: 27 - Drop the task definition table\n
[upgrade] Applying 5.0 change: 28 - Adding resource templates\n
[upgrade] Applying 5.0 change: 29 - Reversing the direction of the relationship between resource roles and components\n
[upgrade] Applying 5.0 change: 30 - refactor unique constraints into indexes -- security\n
[upgrade] Applying 5.0 change: 31 - refactor unique constraints into indexes -- udeploy\n
[upgrade] Applying 5.0 change: 32 - refactor unique constraints into indexes -- property\n
[upgrade] Applying 5.0 change: 33 - Adding prepopulated resource roles\n
[upgrade] Applying 5.0 change: 34 - Adding ghosting of applications\n
[upgrade] Applying 5.0 change: 35 - Adding resource team inheritance\n
[upgrade] Applying 5.0 change: 36 - Adding environment blueprints\n
[upgrade] Applying 5.0 change: 37 - Adding a built-in role for agent placeholders\n
[upgrade] Applying 5.0 change: 38 - Removing Role Security Report\n
[upgrade] Applying 5.0 change: 39 - Ghost custom role reports in the database\n
[upgrade] Applying 5.0 change: 40 - removing licenses from agents\n
[upgrade] Applying 5.0 change: 41 - Adding cloud connections\n
[upgrade] Applying 5.0 change: 42 - Adding tracking of which blueprint was used to create an environment\n
[upgrade] Applying 5.0 change: 43 - refactor unique constraints into indexes -- security\n
[upgrade] Applying 5.0 change: 44 - Adding a built-in role for smartcloud logical nodes\n
[upgrade] Applying 5.0 change: 45 - Updating notification entries to work with new security model\n
[upgrade] Applying 5.0 change: 46 - Adding roles to statuses\n
[upgrade] Applying 5.0 change: 47 - Renaming Calendar Tab Action\n
[upgrade] Applying 5.0 change: 48 - Adding the processes action\n
[upgrade] Applying 5.0 change: 49 - Removing security from licenses\n
[upgrade] Applying 5.0 change: 50 - Adding tracking of a provisioned system ID in environments\n
[upgrade] Applying 5.0 change: 51 - Incorporate security upgrade to support licenses\n
[upgrade] Applying 5.0 change: 52 - removing the \"not null\" constraint from sec_user_property\n
[upgrade] Applying 5.0 change: 53 - Adding agentNamePatterns propdef to the Agent Placeholder resource role\n
[upgrade] Applying 5.0 change: 54 - Incorporating user session count change from security library\n
[upgrade] Applying 5.0 change: 55 - Adding missing entries to latest entry table\n
[upgrade] Applying 6.1 change: 1 - Add join table for Component tagging\n
[upgrade] Applying 6.1 change: 2 - Add join table for Agent tagging\n
[upgrade] Applying 6.1 change: 3 - Add join table for Application tagging\n
[upgrade] Applying 6.1 change: 4 - Add ghosting for inventory entries\n
[upgrade] Applying 6.1 change: 5 - Add table for cross process synchronization\n
[upgrade] Applying 6.1 change: 6 - Disable Deleted Security Resources\n
[upgrade] Applying 6.1 change: 7 - Adding property definitions to tasks\n
[upgrade] Applying 6.1 change: 8 - Add Source Config Plugin Table\n
[upgrade] Applying 6.1 change: 9 - Add support to specify integration agent on component\n
[upgrade] Applying 6.1 change: 10 - Add lock for auto integration\n
[upgrade] Applying 6.1 change: 11 - Add licensing info to Agent\n
[upgrade] Applying 6.1 change: 12 - Updating default inventory status colors\n
[upgrade] Applying 6.1 change: 13 - Remove old license table\n
[upgrade] Applying 6.1 change: 14 - Adding auth token tracking to source config execution\n
[upgrade] Applying 6.1 change: 15 - Reduce all 256 byte columns to 255 bytes\n
[upgrade] Applying 6.1 change: 16 - Reduce all 256 byte columns to 255 bytes in dependencies\n
[upgrade] Applying 6.1 change: 17 - Adding a sync row for creating security resources\n
[upgrade] Applying 6.1 change: 18 - Update sec_resource names\n
[upgrade] Applying 6.1 change: 19 - Add category column to sec_action\n
[upgrade] Applying 6.1 change: 20 - Adding a sync row for getting resource config entries\n
[upgrade] Applying 6.1 change: 21 - pl_plugin_command backwards compatibility\n
[upgrade] Applying 6.1 change: 22 - Make sec_action name index non-unique\n
[upgrade] Applying 6.1 change: 23 - Add missing indexed to foreign keys\n
[upgrade] Applying 6.1 change: 24 - Allow Desired Inventory without a request\n
[upgrade] Applying 6.1 change: 25 - Add artifact list permission\n
[upgrade] Applying 6.1 change: 26 - Add property context mapping index counter\n
[upgrade] Applying n1_6.0.2 change: 1 - Add dismiss attribute to license log entries\n
[upgrade] Applying n1_6.0.2 change: 2 - Adding integration failure tag to components\n
[upgrade] Applying n1_6.0.2 change: 3 - Add the \"map to environment\" resource permission\n
[upgrade] Applying n1_6.0.2 change: 4 - Add additional resource permissions\n
[upgrade] Applying n1_6.0.2 change: 5 - Add sub_tag column to pl_plugin_command\n
[upgrade] Applying n1_6.0.2 change: 6 - Changing status inactivation to status deletion\n
[upgrade] Applying n1_6.0.2 change: 7 - Changing config template inactivation to deletion\n
[upgrade] Applying n1_6.0.2 change: 8 - add component_tag_id column to ds_resource\n
[upgrade] Applying n1_6.0.2 change: 9 - Add copied activities\n
[upgrade] Applying n1_6.0.2 change: 10 - Removing database storage of server/agent messages\n
[upgrade] Applying n1_6.0.2 change: 11 - Adding sizeOnDisk column to Version to keep track of size.\n
[upgrade] Applying n1_6.0.2 change: 12 - Update numeric columns to integer\n
[upgrade] Applying n1_6.0.2 change: 13 - Add Component Type field to components\n
[upgrade] Applying n1_6.0.2 change: 14 - Setting artifact and WinRS agent settings to be ID instead of name references\n
[upgrade] Applying n1_6.0.2 change: 15 - Standardizing action names for cloud connections\n
[upgrade] Applying n1_6.0.2 change: 16 - Create lock table for ptr store\n
[upgrade] Applying n1_6.0.2 change: 17 - Make archived versions with size on disk to be 0\n
[upgrade] Applying n1_6.0.2 change: 18 - Create table for version upgrades\n
[upgrade] Applying n1_6.0.2 change: 19 - Adding a column for tracking errors encountered related to agents\n
[upgrade] Applying n1_6.0.2 change: 20 - Adding support for HTTP property definitions\n
[upgrade] Applying n1_6.0.2 change: 21 - Landscaper integration to create environments from blueprint\n
[upgrade] Applying n1_6.0.2 change: 22 - Splitting snapshot locked state into version and config locking\n
[upgrade] Applying n1_6.0.2 change: 23 - Adding index to pl_source_config_execution\n
[upgrade] Applying n1_6.0.2 change: 24 - Add ignorequalifiers column to components\n
[upgrade] Applying n1_6.0.2 change: 25 - Adding a table to track request performance\n
[upgrade] Applying n1_6.0.2 change: 26 - Adding ghosting support for authorization realms\n
[upgrade] Applying n1_6.0.2 change: 27 - Finding references to deleted users and setting them to admin.\n
[upgrade] Applying n1_6.0.2 change: 28 - Correcting references to resource roles from resource roles and components\n
[upgrade] Applying n1_6.0.2 change: 29 - Implementing timeouts for unacked plugin command requests.\n
[upgrade] Applying n1_6.0.2 change: 30 - Indexing audit records. (This update may take some time)\n
[upgrade] Applying n1_6.0.2 change: 31 - Updating Process Lock Tables\n
[upgrade] Applying n1_6.0.2 change: 32 - Making changes to support OAuth properties and scripted properties.\n
[upgrade] Applying n1_6.0.2 change: 33 - Disabling SSLv3\n
[upgrade] Applying n1_6.0.2 change: 34 - Adding IP address tracking to auditing\n
[upgrade] Applying n1_6.1.1 change: 1 - Adding a list of other permissible parent resource roles for resource roles\n
[upgrade] Applying n1_6.1.1 change: 2 - Allowing plugin commands to be associated with multiple resource roles\n
[upgrade] Applying n1_6.1.1 change: 3 - Adding a default resource name property setting to resource roles\n
[upgrade] Applying n1_6.1.1 change: 4 - Adding tracking of discovery commands executed on resources\n
[upgrade] Applying n1_6.1.1 change: 5 - Changing environment instance ID from integer to string\n
[upgrade] Applying n1_6.1.1 change: 6 - Add IPAS Logical Node resource role\n
[upgrade] Applying n1_6.1.1 change: 7 - Add default children for resource roles\n
[upgrade] Applying n1_6.1.1 change: 8 - Add foldername options for allowed parent roles\n
[upgrade] Applying n1_6.1.1 change: 9 - Adding resolveHttpValuesUrl to HttpPropInfo\n
[upgrade] Applying n1_6.1.1 change: 10 - Adding tracking of metadata associated with versioned objects\n
[upgrade] Applying n1_6.1.1 change: 11 - Remove extraneous allowed values\n
[upgrade] Applying n1_6.1.1 change: 12 - Moving Component Template tags to Component\n
[upgrade] Applying n1_6.1.1 change: 13 - Add tables for agent topology\n
[upgrade] Applying n1_6.1.1 change: 14 - Converting existing blueprints into resource templates\n
[upgrade] Applying n1_6.1.1 change: 15 - Adding prototype flag for resources in templates\n
[upgrade] Applying n1_6.1.1 change: 16 - Improving auth token cleanup (Adding index to DB, this may take a while)\n
[upgrade] Applying n1_6.1.1 change: 17 - Adding allowed resource names\n
[upgrade] Applying n1_6.1.1 change: 18 - Add Type to Discovery Execution Records\n
[upgrade] Applying n1_6.1.1 change: 19 - Add HATimer lock for LicenseCleaner\n
[upgrade] Applying n1_6.1.1 change: 20 - Adding indexes to cover some queries against calendars and component process requests\n
[upgrade] Applying n1_6.1.1 change: 21 - Adding indexes for trace ID on process requests\n
[upgrade] Applying n1_6.1.1 change: 22 - Adding more indexes for Source Config Plugin Executions\n
[upgrade] Applying n1_6.1.1 change: 23 - Track result of agent connection test\n
[upgrade] Applying n1_6.1.1 change: 24 - Add last modified time to snapshots, versions, applications, and components\n
[upgrade] Applying n1_6.1.1 change: 25 - Change data type of property context mapping index to facilitate use of timestamps instead of integers so we can avoid concurrency issues in HA setups.\n
[upgrade] Applying n1_6.1.1 change: 26 - Convert overlooked column from upgrade 25 to bigint.\n
[upgrade] Applying n1_6.1.1 change: 27 - Updated description of \"Manage Resource Roles\" option.\n
[upgrade] Applying n1_6.1.1 change: 28 - Add tables for halock\n
[upgrade] Applying n1_6.1.1 change: 29 - Adding tracking of stack execution for UCDP integration\n
[upgrade] Applying n1_6.1.1 change: 30 - Add missing foreign key indices\n
[upgrade] Applying n1_6.1.1 change: 31 - Change the column width of the blueprint and configuration in external environment table\n
[upgrade] Applying n1_6.2 change: 1 - Add security for Application Templates\n
[upgrade] Applying n1_6.2 change: 2 - Add security for Environment Templates\n
[upgrade] Applying n1_6.2 change: 3 - Add ability to set Application Template on Applications\n
[upgrade] Applying n1_6.2 change: 4 - Add ability to set Environment Template on Environments\n
[upgrade] Applying n1_6.2 change: 5 - Increase column length for object ID in the audit log\n
[upgrade] Applying n1_6.2 change: 6 - Add \"Create From Template\" permission for applications, components and environments\n
[upgrade] Applying n1_6.2 change: 7 - Fix workflow metadata trace ID collation\n
[upgrade] Applying n1_6.2 change: 8\n
[upgrade] Applying n1_6.2 change: 9 - Changes to indices to help with database performance\n
[upgrade] Applying n1_6.2 change: 10 - Adding indices from the security project\n
[upgrade] Applying n1_6.2 change: 11 - Adding indices from the inventory project\n
[upgrade] Applying n1_6.2 change: 12 - Adding indices from the property-sheets project\n
[upgrade] Applying n1_6.2 change: 13 - Give \"Create From Template\" permission for applications, components and environments to all roles that have \"Create\" permission for that type of entity\n
[upgrade] Applying n1_6.2 change: 14 - Changing environment instance ID from integer to string (DB2 only)\n
[upgrade] Applying n1_6.2.1 change: 1 - Add phone number field\n
[upgrade] Applying n1_6.2.1 change: 2 - Add locking mechanism for processes run upon version import\n
[upgrade] Applying n1_6.2.1 change: 3 - Add lock request creation date for FIFO ordering\n
[upgrade] Applying n1_6.2.1 change: 4 - Listing workflow traces for deletion\n
[upgrade] Applying n1_6.2.1 change: 5 - Add exec ack resend columns\n
[upgrade] Applying n1_6.2.1 change: 6 - Allow authentication realms to support multiple authorization realms\n
[upgrade] Applying n1_6.2.1 change: 7 - Cleaning API performance log\n
[upgrade] Applying n1_6.2.1 change: 8 - Adding ability to save information from Agent Relays\n
[upgrade] Applying n1_6.2.1 change: 9 - Adding last_contact field for Agent table\n
[upgrade] Applying n1_6.2.1 change: 10 - Adding index to improve resource tree performance (skipped in mysql)\n
[upgrade] Applying n1_6.2.1 change: 11 - Adding the ability to override cleanup settings on environment\n
[upgrade] Applying n1_6.2.1 change: 12 - Add new unique index for security performance\n
[upgrade] Applying n1_6.2.1 change: 13 - Adding relay_hostname field for Relay table\n
[upgrade] Applying n1_6.2.1 change: 14 - Adding index to relay_id field in Agent table\n<\/p><\/div>