CException

I have bitnami fresh install on AWS.
After installing migration pro I receive this error.
I have tried using and not using memcache (any suggestions)
 
CException
 
Screen capture -- https://cl.ly/c7984a469a42
 

35 answers

Profile photo of Mall Staff 184060.00 $tone October 22, 2019
Public

Hi there,

Screen capture — https://cl.ly/c7984a469a42

Please re-check the cache configuration of our migration tool in the file at path: pub/ub-toool/protected/config/cache.php
Lets make sure the php memcahed was disabled.
Regards,
Mall.

#1
Profile photo of Mall Staff 184060.00 $tone October 24, 2019
Public

Hi there,

I have commented out the (cache area) 

No, please follow the default cache settings of our migration tool as in this screenshot (using Option 1): http://prntscr.com/pnc35d
 
In case you still need further help, please provide me information of your instance:

  • URL and Admin credentials of your M2 instance
  • SSH credentials of your M2 instance
  • Let me know the path to your M2 foder

I will help to check further and get back to you then.
 
PS. Please make sure you mark your reply private or simply switch this ticket to the private mode, then it’s safe to share your site info here. Only you and our technical team can access.
Regards,
Mall.
 

#3
Profile photo of Mall Staff 184060.00 $tone October 25, 2019
Public

Hi Jim,
 
I have checked your instance and didn’t see the issue you mentioned: https://cl.ly/c7984a469a42
But I noticed an issue on database connection: http://prntscr.com/pnu50y

That occurred because your site used database connection via socket (provided by Bitami) to handle for that, I have added more tweak code in our migration tool. For your information, I have changed in the database config file at: pub/ub-tool/protected/config/db.php
from:
//’connectionString’ => ‘mysql:host=/opt/bitnami/mysql/tmp/mysql.sock;port=3306;dbname=…’,
to:
‘connectionString’ => ‘mysql:bucket=/opt/bitnami/mysql/tmp/mysql.sock;port=3306;dbname=…’,
 
And now you can continue with other steps of our migration tool: http://prntscr.com/pnu71n
 
Regards,
Mall.

#5
Profile photo of Mall Staff 184060.00 $tone October 27, 2019
Public

Hi there,
Yes, we will consider to handle for special settings case of Bitnami server provider in next release version of our module.
Regards,
Mall.

#7
Profile photo of Mall Staff 184060.00 $tone October 28, 2019
Public

Hi there,

Undefined variable: port1

I have just added more tweak code in our module to fix for that issue. Please continue with databases setting in step #1 of our migration tool.
Regards,
Mall.

#9
Profile photo of jimpontoon 190.00 $tone October 30, 2019
Public

Thank you for tweaking the code.  
I did migrate but found I am missing customers (as well as I can’t see the default M1 store)
Image 2019-10-30 at 5.26.08 PM.png
M1 shows 29925 customers
Image 2019-10-30 at 5.33.01 PM.png
M2 after migration shows 7373 customers
Image 2019-10-30 at 5.33.41 PM.png
 
M2 Admin screen shows only one store
SQL shows storeid of 1 and 2
Image 2019-10-30 at 5.38.18 PM.png
 
Anything I can do to find the other customers?

#14
Profile photo of jimpontoon 190.00 $tone October 31, 2019
Public

 it appear that none of the products are showing or are editable via the backend? Any suggestions
Image 2019-10-30 at 9.21.03 PM.png
I can see images but cannot edit the products

Any suggestions

#17
Profile photo of Mall Staff 184060.00 $tone October 31, 2019
Public

Hi there,

M1 shows 29925 customers
….
M2 after migration shows 7373 customers
Anything I can do to find the other customers?

That is strange. Please try with the steps below to delta migrate customer again:

+ Run the following SQL in your M2 database:

UPDATE `ub_migrate_map_step_6` SET `created_time` = '2000-01-01 00:00:00', `offset` = 0 WHERE `entity_name` = 'customer_entity';

+ Once done, run the delta with ‘update’ mode in step #6:
php -f bin/ubdatamigration run --step=6 --mode=update
+ After finishing the migration in step #6, please reindex data and clean your M2 cache

I can see images but cannot edit the products

Please follow up my answer for this issue in this post.

Regards,
Mall.

 

 

#18
Profile photo of ubdev Staff 98350.00 $tone October 31, 2019
Public

Hi there, 
Yes, please follow up all steps as per our reply #18, and let us know how it goes once done.
Regards,
Ubertheme team

#20
Profile photo of Mall Staff 184060.00 $tone October 31, 2019
Public

Hi there,

Step 6 completed and I did a re-index as well as cleared the cache (also restarted apache)

Customer count still shows only 7373

That is strange. It seems your M1 database has some special cases in the customer data section. I need to take a closer look into your M1 database. But I couldn’t access your M1’s database via SSH credentials you provided: http://prntscr.com/pqfzfr
If you have phpMyadmin control to access your M1’s database, please provide me the access. I will help to check further and get back to you then.
PS. Please make sure you mark your reply private, or simply switch this ticket to the ‘private’ mode. Then it’s safe to share your info here. Only you and our technical team can access.
Regards,
Mall.

#23
Profile photo of Mall Staff 184060.00 $tone October 31, 2019
Public

Hi there,

Customer count still shows only 7373

I checked further into your instances and found the root cause of that issue as follows:
Your M1 database has total 22552 customers which belong to the customer group named ‘NOT LOGGED IN’:
http://prntscr.com/pqhgkb
http://prntscr.com/pqhiqi
And the missing customers issue you mentioned occurred because you had not checked to migrate the customer group named ‘NOT LOGGED IN’ yet.

Regarding The total ‘(0)’ on ‘NOT LOGGED IN’ you saw in the first time, that is an issue of our module when the customer group has ID = 0. I have added additional tweak code in our module to handle for that case and now you can see the correct total (22552)
https://prnt.sc/pqhkuc
Thus, to solve the issue you mentioned, you can do steps below:
+ Run again the following SQL in your M2 database:

UPDATE `ub_migrate_map_step_6` SET `created_time` = '2000-01-01 00:00:00', `offset` = 0 WHERE `entity_name` = 'customer_entity';

+ And then, back to the settings in step #6 of our module and check to migrate the customer group ‘NOT LOGGED IN’ and click ‘NEXT STEP’ to save the settings.
+ Once done, run the delta migration in step #6 with the ‘update’ mode:
php -f bin/ubdatamigration run --step=6 --mode=update

PS. Depending on the volume of your customers, it might take you a long time in this step.
Regards,
Mall.
 
 

#29
Profile photo of Mall Staff 184060.00 $tone October 31, 2019
Public

Hi there,

I ran the sql statement
then changed the setting on step 6 to include “not logged in”
And ran the “ubdatamigratin update” it only added 100 customers (ran really quick)

That is strange. Can you retry with steps as following:
+ Reset data migration in steps: #8, #7, #6
php -f bin/ubdatamigration reset --step=8
php -f bin/ubdatamigration reset --step=7
php -f bin/ubdatamigration reset --step=6
+ Once done, do settings and migrate data for steps: #6,#7,#8 again?
After you saved settings, you can run data migration for each step by run CLI command:
php -f bin/ubdatamigration run --step=6
php -f bin/ubdatamigration run --step=7
php -f bin/ubdatamigration run --step=8
+ And then, reindex the data after you finished data migration for above steps.
Regards,
Mall.
 

#31
Profile photo of ubdev Staff 98350.00 $tone October 31, 2019
Public

Hi there, 
Yes, please move forward with the process at your end. And let us know how it goes then. 
Regards,
Ubertheme team

#35

Please login or Register to Submit Answer

Written By

Comments