Data error with migration from V4 to V5

Self-Hosted | v5
1

Hi, I have successfully migrated data from V4 to V5 but can see the following errors when doing the following command: ninja:check-data

2021-01-31 01:55:02 2021-01-31 01:55:02 Running CheckData...
2021-01-31 01:55:02 # 10 B H Ltd - 0000 - Balance Failure - Invoice Balances = 375 Client Balance = 55.000000 Ledger Balance = 55.000000
2021-01-31 01:55:02 # 11 S D - 0001 - Balance Failure - Invoice Balances = 5 Client Balance = 0.000000 Ledger Balance = 0.000000
2021-01-31 01:55:02 # 12 G D - 0002 - Balance Failure - Invoice Balances = 40 Client Balance = 0.000000 Ledger Balance = 0.000000
2021-01-31 01:55:02 # 14 P D - 0004 - Balance Failure - Invoice Balances = 2 Client Balance = 0.000000 Ledger Balance = 0.000000
2021-01-31 01:55:02 # 15 L R Ltd - 0005 - Balance Failure - Invoice Balances = 52.98 Client Balance = 0.000000 Ledger Balance = 0.000000
2021-01-31 01:55:02 5 clients with incorrect balances
2021-01-31 01:55:02 0 clients with incorrect invoice balances
2021-01-31 01:55:02 0 clients with incorrect paid to dates
2021-01-31 01:55:02 B H Ltd - 10 - calculated client balances do not match 375.000000 - 55.
2021-01-31 01:55:02 S D - 11 - calculated client balances do not match 5.000000 - 0.
2021-01-31 01:55:02 G D - 12 - calculated client balances do not match 40.000000 - 0.
2021-01-31 01:55:02 P D - 14 - calculated client balances do not match 2.000000 - 0.
2021-01-31 01:55:02 L R Ltd - 15 - calculated client balances do not match 52.980000 - 0.
2021-01-31 01:55:02 5 clients with incorrect client balances
2021-01-31 01:55:02 0 contacts without a contact_key
2021-01-31 01:55:02 0 clients without any contacts
2021-01-31 01:55:02 0 clients without a single primary contact
2021-01-31 01:55:02 0 users with duplicate oauth ids
2021-01-31 01:55:02 1 failed jobs
2021-01-31 01:55:02 Done: FAILURE
2

Hi,

Are you able to review the data in v4/v5 to see where the differences are?

@david any thoughts on how to best debug this?

3

@DylanPedro can you confirm the migration completed? in v5, go to storage/logs/laravel.log it will have the output of the migration. You’ll want to check that it got all the way through the entities and finished with a Completed notification.

4

Hi David,

Looks like it did complete:

[2021-01-31 13:46:40] production.INFO: Importing account  
[2021-01-31 13:46:40] production.INFO: Importing company  
[2021-01-31 13:46:40] production.INFO: the path /storage/go3MNtaSEezDJwpWJPEnCJr8coYuPalZ/BCnSvsmjNkdN03yRBFijWgqAxUcM5vQ0UXMBTNwx.png  
[2021-01-31 13:46:40] production.INFO: Importing users  
[2021-01-31 13:46:40] production.INFO: Importing payment_terms  
[2021-01-31 13:46:40] production.INFO: Importing tax_rates  
[2021-01-31 13:46:40] production.INFO: Importing clients  
[2021-01-31 13:46:41] production.INFO: Importing company_gateways  
[2021-01-31 13:46:41] production.INFO: Importing client_gateway_tokens  
[2021-01-31 13:46:41] production.INFO: Importing vendors  
[2021-01-31 13:46:41] production.INFO: Importing projects  
[2021-01-31 13:46:41] production.INFO: Importing products  
[2021-01-31 13:46:41] production.INFO: Importing credits  
[2021-01-31 13:46:41] production.INFO: Importing invoices  
[2021-01-31 13:46:42] production.INFO: Importing recurring_invoices  
[2021-01-31 13:46:42] production.INFO: Importing quotes  
[2021-01-31 13:46:42] production.INFO: Importing payments  
[2021-01-31 13:46:42] production.INFO: Importing expense_categories  
[2021-01-31 13:46:42] production.INFO: Importing task_statuses  
[2021-01-31 13:46:42] production.INFO: in task statuses  
[2021-01-31 13:46:42] production.INFO: finished task statuses  
[2021-01-31 13:46:42] production.INFO: Importing expenses  
[2021-01-31 13:46:42] production.INFO: Importing tasks  
[2021-01-31 13:46:42] production.INFO: Importing documents  
[2021-01-31 13:46:44] production.INFO: Completed🚀🚀🚀🚀🚀 at 2021-01-31 13:46:44
5

@DylanPedro are you able to join us on slack so we can debug further?

http://slack.invoiceninja.com