<< Click to Display Table of Contents >> Data Migration |
![]() ![]() ![]() |
Data migration is mainly for users who are using MPP. If you choose to change to VooltDB, you can migrate existing data in MPP with one click.
Log in to the yonghong BI system with the admin user or admin role user, and open the management system-vooltDB management-data migration page:
The following table describes the page information of the data migration page:
Name |
Description |
MPP Data Mart Folder |
The name of the bazaar folder that has been saved in MPP. |
Migration Version |
The last time the folder entered MPP. |
Status |
The status of the current folder is: not migrated, migrated, migrated successfully. |
Operation |
The operations that can be performed on the current market folder are: start migration, stop. |
The buttons on the data migration page can perform corresponding operations on the market folder. The function of each button is described below:
[Start Migration] There are two buttons to start migration: start migration separately behind each market folder, and start migration at the top of the page. Click the start migration of a single market folder, and it will only affect the selected The bazaar folders are migrated. If you click Start migration at the top of the page, the system will automatically migrate all bazaar folders in sequence.
[Stop Migration] The Stop Migration button at the top of the page will be grayed out if no task is in progress. If there is a migration task currently in progress, the button will be highlighted. Clicking it will stop all current migration operations.
[Stop] After a single data folder starts to migrate, the start migration button at the back of the folder will change to "Stop". After clicking the stop button, the migration task will be stopped.
The data migration task can be performed multiple times. If the migration task fails or the data is re-entered into the market, you only need to perform the migration operation again for the changed market folder.
[Common errors when performing migration]:
When performing migration, an error "Waiting for job@XXX timeout" is reported
The default timeout time of YonghongBI’s MPP data mart data query task is "mpp.scheduler.exec.timeout=900000". When performing a large data migration task, this time may be exceeded. It is recommended to set this parameter before performing data migration Add it to the "bi.properties" file and set it to "1800000".