Delete orphans in cataloginventory_stock_item
When I try to migrate delta, I get this error:
user:~/www$ bin/magento migrate:delta vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.4/config.xml
...shortened...
[2019-01-17 12:03:51][WARNING]: Mismatch of entities in the document: m2_inventory_source_item Source: 2889 Destination: 2861
[2019-01-17 12:03:51][WARNING]: Volume Check failed
It reads source table has 2889 rows, destination table has 2861 rows, a difference of 28 rows.
In M1 database I ran this query:
select * from cataloginventory_stock_item where product_id not in (select entity_id from catalog_product_entity)
Result: 28 rows. Is it safe to delete these rows?
Related: Possible orphans in cataloginventory_stock_item?
magento2 magento2-migration-tool magento2.3 delta-migration
New contributor
add a comment |
When I try to migrate delta, I get this error:
user:~/www$ bin/magento migrate:delta vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.4/config.xml
...shortened...
[2019-01-17 12:03:51][WARNING]: Mismatch of entities in the document: m2_inventory_source_item Source: 2889 Destination: 2861
[2019-01-17 12:03:51][WARNING]: Volume Check failed
It reads source table has 2889 rows, destination table has 2861 rows, a difference of 28 rows.
In M1 database I ran this query:
select * from cataloginventory_stock_item where product_id not in (select entity_id from catalog_product_entity)
Result: 28 rows. Is it safe to delete these rows?
Related: Possible orphans in cataloginventory_stock_item?
magento2 magento2-migration-tool magento2.3 delta-migration
New contributor
looks safe to delete the rows. but backup first
– Marius♦
29 mins ago
add a comment |
When I try to migrate delta, I get this error:
user:~/www$ bin/magento migrate:delta vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.4/config.xml
...shortened...
[2019-01-17 12:03:51][WARNING]: Mismatch of entities in the document: m2_inventory_source_item Source: 2889 Destination: 2861
[2019-01-17 12:03:51][WARNING]: Volume Check failed
It reads source table has 2889 rows, destination table has 2861 rows, a difference of 28 rows.
In M1 database I ran this query:
select * from cataloginventory_stock_item where product_id not in (select entity_id from catalog_product_entity)
Result: 28 rows. Is it safe to delete these rows?
Related: Possible orphans in cataloginventory_stock_item?
magento2 magento2-migration-tool magento2.3 delta-migration
New contributor
When I try to migrate delta, I get this error:
user:~/www$ bin/magento migrate:delta vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.4/config.xml
...shortened...
[2019-01-17 12:03:51][WARNING]: Mismatch of entities in the document: m2_inventory_source_item Source: 2889 Destination: 2861
[2019-01-17 12:03:51][WARNING]: Volume Check failed
It reads source table has 2889 rows, destination table has 2861 rows, a difference of 28 rows.
In M1 database I ran this query:
select * from cataloginventory_stock_item where product_id not in (select entity_id from catalog_product_entity)
Result: 28 rows. Is it safe to delete these rows?
Related: Possible orphans in cataloginventory_stock_item?
magento2 magento2-migration-tool magento2.3 delta-migration
magento2 magento2-migration-tool magento2.3 delta-migration
New contributor
New contributor
edited 12 secs ago
Jam
New contributor
asked 31 mins ago
JamJam
12
12
New contributor
New contributor
looks safe to delete the rows. but backup first
– Marius♦
29 mins ago
add a comment |
looks safe to delete the rows. but backup first
– Marius♦
29 mins ago
looks safe to delete the rows. but backup first
– Marius♦
29 mins ago
looks safe to delete the rows. but backup first
– Marius♦
29 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Jam is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f258197%2fdelete-orphans-in-cataloginventory-stock-item%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Jam is a new contributor. Be nice, and check out our Code of Conduct.
Jam is a new contributor. Be nice, and check out our Code of Conduct.
Jam is a new contributor. Be nice, and check out our Code of Conduct.
Jam is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f258197%2fdelete-orphans-in-cataloginventory-stock-item%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
looks safe to delete the rows. but backup first
– Marius♦
29 mins ago