Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PostProcessing step #310

Closed
diazwatson opened this issue May 30, 2017 · 2 comments
Closed

PostProcessing step #310

diazwatson opened this issue May 30, 2017 · 2 comments
Labels

Comments

@diazwatson
Copy link
Contributor

I am using the tool to migrate only customers with their addresses from CE 1.7.0.0 to EE 2.1.4.
No need to migrate anything else therefore I have removed all extra steps in the config file:

<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
    <steps mode="data">
        <step title="Data Integrity Step">
            <integrity>Migration\Step\DataIntegrity\Integrity</integrity>
        </step>
        <step title="Customer Attributes Step">
            <integrity>Migration\Step\Customer\Integrity</integrity>
            <data>Migration\Step\Customer\Data</data>
            <volume>Migration\Step\Customer\Volume</volume>
        </step>
        <step title="PostProcessing Step">
            <data>Migration\Step\PostProcessing\Data</data>
        </step>
    </steps>
    <steps mode="delta">
        <step title="Customer Attributes Step">
            <delta>Migration\Step\Customer\Delta</delta>
            <volume>Migration\Step\Customer\Volume</volume>
        </step>
    </steps>
<options>
        <map_file>etc/ce-to-ee/1.7.0.0/map.xml</map_file>
        <customer_map_file>etc/ce-to-ee/map-customer.xml</customer_map_file>
        <customer_document_groups_file>etc/ce-to-ee/customer-document-groups.xml.dist</customer_document_groups_file>
        <customer_attribute_groups_file>etc/ce-to-ee/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
        <delta_document_groups_file>etc/ce-to-ee/deltalog.xml</delta_document_groups_file>
        <map_document_groups>etc/ce-to-ee/map-document-groups.xml.dist</map_document_groups>
        <class_map>etc/ce-to-ee/class-map.xml</class_map>
        <bulk_size>0</bulk_size>
        <direct_document_copy>0</direct_document_copy>
        <source_prefix />
        <dest_prefix />
        <auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
        <log_file>migration.log</log_file>
        <progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
        <upgrade_customer_password_hash>1</upgrade_customer_password_hash>
        <edition_migrate>ce-to-ee</edition_migrate>
        <edition_number>1.7.0.0</edition_number>
        <init_statements_source>SET NAMES utf8;</init_statements_source>
        <init_statements_destination>SET NAMES utf8;</init_statements_destination>
        <crypt_key>zzz454519134f5ee</crypt_key>
    </options>

So far it seems to migrates most of the data as expected but in the PostProcessing Step it fails telling me that the query was empty.

[2017-05-30 00:47:39][INFO][mode: data][stage: integrity check][step: Data Integrity Step]: started
[2017-05-30 00:47:39][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
[2017-05-30 00:47:39][INFO][mode: data][stage: setup triggers][step: Stage]: started
[2017-05-30 01:04:02][INFO][mode: data][stage: data migration][step: Customer Attributes Step]: started
[2017-05-30 01:04:06][INFO][mode: data][stage: volume check][step: Customer Attributes Step]: started
100% [============================] Remaining Time: 1 sec
[2017-05-30 01:04:36][WARNING]: Mismatch of entities in the document: customer_entity
[2017-05-30 01:04:36][WARNING]: Volume Check failed
[2017-05-30 01:04:59][INFO][mode: data][stage: data migration][step: PostProcessing Step]: started
0% [>---------------------------] Remaining Time: 1 sec

SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty, query was:

It looks like
vendor/magento/data-migration-tool/src/Migration/Step/PostProcessing/Model/EavLeftoverData.php:76 returns nothing and therefore the query is empty.

  • Is PostProcessing Step part of Eav Step or/and Map Step and because I removed those steps it fails?

  • What PostProcessing Step is for?

Can somebody give me a hand to understand this?
Thanks

@victor-v-rad
Copy link
Collaborator

The tool was built to migrate all at once. Migrating only customers might not work out without such errors. I believe you can safely remove "PostProcessing Step" also if you want to migrate only customers.

@diazwatson
Copy link
Contributor Author

Thanks for your reply @victor-v-rad
Could you briefly explain what PostProcessing Step is for?

I've been looking at the code and it seems to be the step in charge of validating EAV after migration, is it all what it does?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants