Author Topic: how to migrate 3rd party activiy history data to 2.0 database after upgradation? (Read 3358 times)

rampkrm · April 02, 2008, 05:54:27 am

I have upgraded civicrm from 1.9 to 2.0.2, while upgrading i got a warning saying that "we are unable to migrate activity hisotory data because of some 3rd party modules activity history included".

i ignored this and continued the process. after upgradation everything works fine except civievent. when i clicks civievent in administer civicrm dash board it gives a blank screen.

remianing parts of civievent is working fine like civievent page etc..

i didn't find any manual process to migrate 3rd party acivity history data, help me in finding the procedure.

for your reference i changed my php momory limit to 80mb.

Donald Lobo · April 02, 2008, 01:12:14 pm

check: http://wiki.civicrm.org/confluence/display/CRMDOC/Migrate+3rd+Party+Activity+History+Records+to+2.0

for details and an example

lobo

depace · April 03, 2008, 02:41:02 am

hi lobo .. do you think because of the activity history the CiviEvent (http://www.abc.com/civicrm/event?reset=1) page is not opening up ?? (it shows blank). But other event pages are coming good. There are abt 29 records.....

jeff porter · April 03, 2008, 07:23:39 am

To shed more light on this, what we are seeing are timeouts on

Maximum execution time of 30 seconds exceeded in Array.php on line 52
Address.php on line 165,

Suspect a db call never comes back?

Dave Greenberg · April 03, 2008, 11:37:32 am

Jeff - this is happening on the CiviEvent dashboard page, after upgrading to 2.0? (http://<your_site>/civicrm/event?reset=1)
Are there any other symptoms / issues on the upgraded site?

Donald Lobo · April 03, 2008, 01:21:16 pm

can u enable your mysql query log and mysql slow query log and see the queries being generated for the page being loaded. specifically can u check which query takes a long time and why

lobo

depace · April 04, 2008, 01:43:14 am

we enabled both mysql query log and mysql slow query log.... it is not logging any queries in mysql low query log...

depace · April 04, 2008, 01:44:43 am

Quote from: Dave Greenberg on April 03, 2008, 11:37:32 am

Jeff - this is happening on the CiviEvent dashboard page, after upgrading to 2.0? (http://<your_site>/civicrm/event?reset=1)
Are there any other symptoms / issues on the upgraded site?

hey Dave....
yes ... its happening after we upgraded the site from civi 1.8 to 1.9 to 2.0. ....
there are no other issues in the site except the blank page for CiviEvent dashboard...

rampkrm · April 04, 2008, 02:23:37 am

lobo,

we enabled sql query log and its big (size 1.8mb) to attach in forum. plz give email id to send it.

Chris Burgess · April 04, 2008, 07:30:06 am

A look at rampkrm's logfile shows nearly 7000 entries trying to look up

Code: [Select]

SELECT id, region_id FROM civicrm_country WHERE ( civicrm_country.id = 1228 )
Here's a chunk of the logfile:

Code: [Select]

azumi:~/Desktop chris$ cat snippet.log 
		      3 Query       SELECT count(id) as total_events
                  FROM   civicrm_event 
                  WHERE  civicrm_event.is_active=1
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT * 
 FROM civicrm_option_group 
 
 WHERE (  civicrm_option_group.name  = 'event_type' )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT     civicrm_event.id as id, civicrm_event.title as event_title, civicrm_event.is_public as is_public,
           civicrm_event.max_participants as max_participants, civicrm_event.start_date as start_date,
           civicrm_event.end_date as end_date, civicrm_event.is_map as is_map,
           civicrm_option_value.label as event_type, count(civicrm_participant.id) as participants
FROM       civicrm_event
LEFT JOIN  civicrm_participant  ON
 ( civicrm_event.id = civicrm_participant.event_id AND
   civicrm_participant.is_test = 0                 AND
   civicrm_participant.status_id IN ( 1, 2 ) )
LEFT JOIN  civicrm_option_value ON ( civicrm_event.event_type_id = civicrm_option_value.value )
WHERE      civicrm_event.is_active = 1     AND
           civicrm_event.domain_id = 1    AND
           civicrm_option_value.option_group_id = 14
GROUP BY   civicrm_event.id
ORDER BY   civicrm_event.end_date DESC
LIMIT      0, 10
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT * 
 FROM civicrm_phone 
 
 
 
 
 ORDER BY is_primary desc, location_type_id desc, id asc
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT * 
 FROM civicrm_email 
 
 
 
 
 ORDER BY is_primary desc, location_type_id desc, id asc
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT * 
 FROM civicrm_im 
 
 
 
 
 ORDER BY is_primary desc, location_type_id desc, id asc
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT * 
 FROM civicrm_openid 
 
 
 
 
 ORDER BY is_primary desc, location_type_id desc, id asc
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT * 
 FROM civicrm_address
080404  4:32:34	      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, abbreviation  
 FROM civicrm_state_province 
 
 
 
 
 ORDER BY abbreviation
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_state_province 
 
 
 
 
 ORDER BY name
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, iso_code  
 FROM civicrm_country 
 
 
 
 
 ORDER BY iso_code
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_country 
 
 WHERE ( iso_code IN ('AD', 'AE', 'AF', 'AG', 'AI', 'AL', 'AM', 'AN', 'AO', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AW', 'AZ', 'BA', 'BB', 'BD', 'BE', 'BF', 'BG', 'BH', 'BI', 'BJ', 'BM', 'BN', 'BO', 'BR', 'BS', 'BT', 'BV', 'BW', 'BY', 'BZ', 'CA', 'CC', 'CD', 'CF', 'CG', 'CH', 'CI', 'CK', 'CL', 'CM', 'CN', 'CO', 'CR', 'CS', 'CU', 'CV', 'CX', 'CY', 'CZ', 'DE', 'DJ', 'DK', 'DM', 'DO', 'DZ', 'EC', 'EE', 'EG', 'EH', 'ER', 'ES', 'ET', 'FI', 'FJ', 'FK', 'FM', 'FO', 'FR', 'GA', 'GB', 'GD', 'GE', 'GF', 'GH', 'GI', 'GL', 'GM', 'GN', 'GP', 'GQ', 'GR', 'GS', 'GT', 'GU', 'GW', 'GY', 'HK', 'HM', 'HN', 'HR', 'HT', 'HU', 'ID', 'IE', 'IL', 'IN', 'IO', 'IQ', 'IR', 'IS', 'IT', 'JM', 'JO', 'JP', 'KE', 'KG', 'KH', 'KI', 'KM', 'KN', 'KP', 'KR', 'KW', 'KY', 'KZ', 'LA', 'LB', 'LC', 'LI', 'LK', 'LR', 'LS', 'LT', 'LU', 'LV', 'LY', 'MA', 'MC', 'MD', 'MG', 'MH', 'MK', 'ML', 'MM', 'MN', 'MO', 'MP', 'MQ', 'MR', 'MS', 'MT', 'MU', 'MV', 'MW', 'MX', 'MY', 'MZ', 'NA', 'NC', 'NE', 'NF', 'NG', 'NI', 'NL', 'NO', 'NP', 'NR', 'NU', 'NZ', 'OM', 'PA', 'PE', 'PF', 'PG', 'PH', 'PK', 'PL', 'PM', 'PN', 'PR', 'PS', 'PT', 'PW', 'PY', 'QA', 'RE', 'RO', 'RU', 'RW', 'SA', 'SB', 'SC', 'SD', 'SE', 'SG', 'SH', 'SI', 'SJ', 'SK', 'SL', 'SM', 'SN', 'SO', 'SR', 'ST', 'SV', 'SY', 'SZ', 'TC', 'TD', 'TF', 'TG', 'TH', 'TJ', 'TK', 'TL', 'TM', 'TN', 'TO', 'TR', 'TT', 'TV', 'TW', 'TZ', 'UA', 'UG', 'UM', 'US', 'UY', 'UZ', 'VA', 'VC', 'VE', 'VG', 'VI', 'VN', 'VU', 'WF', 'WS', 'YE', 'YT', 'ZA', 'ZM', 'ZW') )  
 
 
 ORDER BY name
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, region_id  
 FROM civicrm_country 
 
 WHERE (  civicrm_country.id = 1228 )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_worldregion 
 
 
 
 
 ORDER BY id
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_county 
 
 
 
 
 ORDER BY id
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT * 
 FROM civicrm_preferences 
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, region_id  
 FROM civicrm_country 
 
 WHERE (  civicrm_country.id = 1228 )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_worldregion 
 
 
 
 
 ORDER BY id
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, region_id  
 FROM civicrm_country 
 
 WHERE (  civicrm_country.id = 1228 )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_worldregion 
 
 
 
 
 ORDER BY id
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, region_id  
 FROM civicrm_country 
 
 WHERE (  civicrm_country.id = 1228 )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_worldregion 
 
 
 
 
 ORDER BY id
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, region_id  
 FROM civicrm_country 
 
 WHERE (  civicrm_country.id = 1228 )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_worldregion 
 
 
 
 
 ORDER BY id
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, region_id  
 FROM civicrm_country 
 
 WHERE (  civicrm_country.id = 1228 )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_worldregion 
 
 
 
 
 ORDER BY id
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, region_id  
 FROM civicrm_country 
 
 WHERE (  civicrm_country.id = 1228 )
		      3 Init DB     fpwr_civicrm20
		      3 Query       SELECT  id, name  
 FROM civicrm_worldregion 
 
 
 
 
 ORDER BY id

... it goes on like that.

Hope that helps someone help rampkrm identify the issue!

Donald Lobo · April 04, 2008, 11:03:47 am

Can you please contact us on IRC. We'll need ssh access to your machine. looks like some code is looping forever.

did u try resetting 'config_backend' in civicrm_domain and see if that fixes/addresses the issue

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: how to migrate 3rd party activiy history data to 2.0 database after upgradation? (Read 3358 times)

rampkrm

how to migrate 3rd party activiy history data to 2.0 database after upgradation?

Donald Lobo

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradation?

depace

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradat

jeff porter

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradat

Dave Greenberg

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradat

Donald Lobo

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradation?

depace

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradat

depace

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradat

rampkrm

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradat

Chris Burgess

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradat

Donald Lobo

Re: how to migrate 3rd party activiy history data to 2.0 database after upgradation?