’Failed to move Related Activities to the Contact’ - Ошибка преобразования обращения в сделку
40 views
Skip to first unread message
Vitovt
Dec 6, 2012, 1:04:25 PM12/6/12
to vtiger-...@googlegroups.com
Всем привет.
В нас в компании возникла следующая нерпиятность:
Fatal error: Uncaught exception 'WebServiceException' with message 'Failed to move Related Activities to the Contact' in
/home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm/include/Webservices/ConvertLead.php:228 Stack trace: #0
/home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm/modules/Leads/LeadConvertToEntities.php(43): vtws_convertlead('2x9183', '19x529', '', false, Array, 'Contacts', Object(Users)) #1
/home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm/index.php(753): include('/home/allinone/...') #2 {main} thrown in
/home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm/include/Webservices/ConvertLead.php on line 228
При этом контакт создается, а сделка нет. И обращение не удаляется, как преобразованное.
Вернувшись назад стрелкой в браузере, выполнив преобразование снова - все проходит ок.
В результате получается два контакта и одна сделка. Сделка принадлежит второму контакту.
Не могу понять, в чем причина ?
SalesPlatform vtiger CRM - 5.3.0-201207
Подскажите, кто сталкивался с подобрым ?
Спасибо.
--
Sincerely,
Vitalii Titskiy
+38(063) 854-64-45
+38(067) 713-51-08
http://www.facebook.com/vitovt
Детские товары для спорта, развития и безопасности с доставкой по всей Украине.
http://kryhitka.com/
Детские спортуголки с доставкой по России:
http://kryhitka.ru/
Vitovt
Dec 9, 2012, 7:09:52 AM12/9/12
to vtiger-...@googlegroups.com
Повключал дебаги и отловил еще подробностей.
Когда неудачная конверсия, она заканчивается вот таким:
(mysql): select * from vtiger_crmentityrel where crmid='247'
(mysql): select * from vtiger_crmentityrel where relcrmid='247'
(mysql): select * from vtiger_campaignleadrel where leadid='247'
(mysql): UPDATE vtiger_modcomments SET related_to='9656' WHERE related_to='247'
(mysql): select * from vtiger_seactivityrel where crmid='247'
(mysql): select setype from vtiger_crmentity where crmid='9629'
(mysql): delete from vtiger_seactivityrel where crmid='247'
(mysql): insert into vtiger_seactivityrel(crmid,activityid) values ('','9629')
1452: Cannot add or update a child row: a foreign key constraint fails (`allinone_vtiger4`.`vtiger_seactivityrel`, CONSTRAINT `fk_2_vtiger_seactivityrel` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE)
Fatal error: Uncaught exception 'WebServiceException' with message 'Failed to move Related Activities to the Contact' in /home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm4/include/Webservices/ConvertLead.php:228 Stack trace: #0 /home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm4/modules/Leads/LeadConvertToEntities.php(43): vtws_convertlead('2x247', '19x1', '', false, Array, 'Contacts', Object(Users)) #1 /home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm4/index.php(753): include('/home/allinone/...') #2 {main} thrown in/home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm4/include/Webservices/ConvertLead.php on line 228
(mysql): select * from vtiger_crmentityrel where relcrmid='247'
(mysql): select * from vtiger_campaignleadrel where leadid='247'
(mysql): UPDATE vtiger_modcomments SET related_to='9656' WHERE related_to='247'
(mysql): select * from vtiger_seactivityrel where crmid='247'
(mysql): select setype from vtiger_crmentity where crmid='9629'
(mysql): delete from vtiger_seactivityrel where crmid='247'
(mysql): insert into vtiger_seactivityrel(crmid,activityid) values ('','9629')
1452: Cannot add or update a child row: a foreign key constraint fails (`allinone_vtiger4`.`vtiger_seactivityrel`, CONSTRAINT `fk_2_vtiger_seactivityrel` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE)
ADOConnection._Execute(insert into vtiger_seactivityrel(crmid,activityid) values ('','9629')) % line 842, file: adodb.inc.php
ADOConnection.Execute(insert into vtiger_seactivityrel(crmid,activityid) values (?,?), Array[2]) % line 468, file: PearDatabase.php
PearDatabase.pquery(insert into vtiger_seactivityrel(crmid,activityid) values (?,?), Array[2]) % line 700, file: Utils.php
vtws_getRelatedActivities(247, , 9656, 9656) % line 226, file: ConvertLead.php
vtws_convertlead(2x247, 19x1, , false, Array[4], Contacts, Object:Users) % line 43, file: LeadConvertToEntities.php
Fatal error: Uncaught exception 'WebServiceException' with message 'Failed to move Related Activities to the Contact' in /home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm4/include/Webservices/ConvertLead.php:228 Stack trace: #0 /home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm4/modules/Leads/LeadConvertToEntities.php(43): vtws_convertlead('2x247', '19x1', '', false, Array, 'Contacts', Object(Users)) #1 /home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm4/index.php(753): include('/home/allinone/...') #2 {main} thrown in/home/allinone/domains/crm.kryhitka.com/public_html/vtigercrm4/include/Webservices/ConvertLead.php on line 228
При успешной конвертации - этот этап успешно проскакивает:
(mysql): select * from vtiger_crmentityrel where crmid='4333'
(mysql): select * from vtiger_crmentityrel where relcrmid='4333'
(mysql): select * from vtiger_campaignleadrel where leadid='4333'
(mysql): UPDATE vtiger_modcomments SET related_to='9626' WHERE related_to='4333'
(mysql): select * from vtiger_seactivityrel where crmid='4333'
(mysql): select * from vtiger_ws_entity where name='Potentials'
(mysql): SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (2)
(mysql): select distinct block,vtiger_field.tabid,name,blocklabel from vtiger_field inner join vtiger_blocks on vtiger_blocks.blockid=vtiger_field.block inner join vtiger_tab on vtiger_tab.tabid=vtiger_field.tabid where displaytype != 3 and vtiger_tab.name in ('Potentials') and vtiger_field.presence in (0,2) order by block
(mysql): select * from vtiger_crmentityrel where relcrmid='4333'
(mysql): select * from vtiger_campaignleadrel where leadid='4333'
(mysql): UPDATE vtiger_modcomments SET related_to='9626' WHERE related_to='4333'
(mysql): select * from vtiger_seactivityrel where crmid='4333'
(mysql): select * from vtiger_ws_entity where name='Potentials'
(mysql): SELECT tabid, fieldname, fieldid, fieldlabel, columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (2)
(mysql): select distinct block,vtiger_field.tabid,name,blocklabel from vtiger_field inner join vtiger_blocks on vtiger_blocks.blockid=vtiger_field.block inner join vtiger_tab on vtiger_tab.tabid=vtiger_field.tabid where displaytype != 3 and vtiger_tab.name in ('Potentials') and vtiger_field.presence in (0,2) order by block
И т.д.
Вот полные логи конвертаций:
Спасибо всем, кто выскажет хоть какие-то идеи!
Reply all
Reply to author
Forward
0 new messages