...
Info | ||
---|---|---|
| ||
This a sequential list of revision updates which that need additional activities in order to successfully upgrade the revision of your production installation. If you are interested by in a summary by release please read Data Migration by releases |
...
If you are an end-user and a committer who has done something that does not allow you to follow this simple set of steps, please contribute something better, or at the very least complain so committers will better understand your needs.
Committers should make an entry in this list if your revision causes a need for any manual data migration or other update steps in production instances:
- A file change which need needs additional unload/reload/convert activities
- Any tables which can be deleted(dropped) because they are not used anymore.
- Any other required activity to keep your production site operational
Note |
---|
Old Data migration services has have been removed from the ofbiz-framework trunk at r#1792182 and r#1792788 |
...
R587127:refactored party content
...
R691362 Fix an issue in artifactInfo reported on user ML
R1805961 "Manage life span of marketing related
R691380 Some changes related to GeoPoint have slipped in in r691362
R1805961 "Manage life span of marketing related
- Drop the SimpleTaxLookup from you production DB (subsidiary as it's probably already not used)
- upgrade to at least R691380 and restart the system.
...
This script should be run intially initially to move values from square_footage to facility_size and set the Uom
UPDATE Facility SET facility_size=square_footage;
UPDATE Facility SET facility_size_uom_id='AREA_ft2';
then the square_footage column might be removed
ALTER TABLE Facility DROP COLUMN square_footage;
...
If you have open production runs before the upgrade then production run costs will not be computed when the order is finalized; in fact, after the upgrade, the system will clone WorkEffortCostCalc from the routing definition to the production run and will only consider the cloned records when the production run is finalized.
...
Before doing this upgrade, make a backup of your framework/images/webapp/images directory because the existing subdirectories will be deleted because of a reorganization. After the upgrade, if you restore these dictories directories your system will work again and images can be found. Mor info at:
Jira | ||||||
---|---|---|---|---|---|---|
|
...
This affects the upgrade of the productKeyword entity. If the content can be re-generated, just run the generate keywords program, if you want to keep the content then see the service: migrateProductKeyword in the file: applications/product/servicedef/services_upgrade.xml for more information
...
- export the GeoPoint entity with webtools export.
- drop the table
- restart the system.
- Import the exported file
R1647271 Refactoring of Visit/Visitor/ServerHit* (and related) entities in order to be able to maintain them in a database separate from the main transactional database:
...
I quickly tried this in EntitySQLProcessor it does not work. We need instead to provide a migrateWebSitePathAlias migrating service.
R1743656 "Wrong field type for fromDate and thruDate of CustomTimePeriod entity." Jiraserver ASF JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key OFBIZ-5740
server | ASF JIRA |
---|---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
serverId | 5aa69414-a9e9-3523-82ec-879b028fb15b |
key | OFBIZ-5740 |
...
Updated sql-type for date-time and time field in fieldtypemysql.xml file,
OFBiz type | old mySql data-type | new mysql data-type |
---|---|---|
date-time | DATETIME | DATETIME(3) |
time | TIME | TIME(3) |
Please upgrade mysql to at least 5.6.4 or higher.
After upgrade run 'generateMySqlFileWithAlterTableForTimestamps' service, groupName is required field for this service,
It will generate sql SQL file with alter query statement for date-time and time field at location "${ofbiz.home}/runtime/tempfiles/<groupName>.sql"
You can use execute sql a SQL statement from any of the mysql batch command.
...
ALTER TABLE PRODUCT DROP MANUFACTURER_PARTY_ID;
R1805961 "Manage life span of marketing related
...
entities
Jira | ||||||
---|---|---|---|---|---|---|
|
This added the fromDate, and thruDate fields to the MarketingCampaignPrice, MarketingCampaignPromo, MarketingCampaignRole entities, fromDate is a PK field.
...
BEGIN;
UPDATE marketing_campaign_price SET from_date='2000-01-01 00:00:00';
ALTER TABLE marketing_campaign_price
DROP CONSTRAINT pk_marketing_campaign_price,
ADD CONSTRAINT pk_marketing_campaign_price PRIMARY KEY (marketing_campaign_id, product_price_rule_id, from_date);
COMMIT;
BEGIN;
UPDATE marketing_campaign_promo SET from_date='2000-01-01 00:00:00';
ALTER TABLE marketing_campaign_promo
DROP CONSTRAINT pk_marketing_campaign_promo,
ADD CONSTRAINT pk_marketing_campaign_promo PRIMARY KEY (marketing_campaign_id, product_promo_id, from_date);
COMMIT;
BEGIN;
UPDATE marketing_campaign_role SET from_date='2000-01-01 00:00:00';
ALTER TABLE marketing_campaign_role
DROP CONSTRAINT pk_marketing_campaign_role,
ADD CONSTRAINT pk_marketing_campaign_role PRIMARY KEY (marketing_campaign_id, party_id, role_type_id, from_date);
COMMIT;
...
R1809396: Fixed ShipmentGatewayConfig and PaymentGatewayConfig entities as we fixed type entities to follow a naming convention.
Jira | ||||||||
---|---|---|---|---|---|---|---|---|
|
...
Code Block |
---|
UPDATE security_group_permission SET from_date='2000-01-01 00:00:00'; ALTER TABLE security_group_permission DROP PRIMARY KEY ADD PRIMARY KEY (group_id, permission_id, from_date) |
R1858479: Marital Status not managed properly in Person entity Jira server ASF JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 5aa69414-a9e9-3523-82ec-879b028fb15b key OFBIZ-10921
Person entity's maritalStatus field has been changed from indicator to Enumeration to manage various classification of legal marital status.
After upgrate migrateMaritalStatusFromIndicatorToEnum service can be used to upgrade existing data of maritalStatus field to the new maritalStatusEnumId.