x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 74 subscribers
  • Views 306 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
MichalPoncak

Mail Merge not working for Opportunity entity (no errors)

Posted By

Hello,

When running a mail merge within opportunity, the output file contains raw fields in brackets without any data.

Additionally, i also checked log files and couldn't find anything.

Please note that this issue occurs only for Opportunity entity.

I have tried to reinstall everyhting except my database. - this didnt work for me.

Is there a way to "repair" it without loosing my data? - What tables are being used by mail merge?

Any solutions or suggestions are very welcome.

CRM version:

7.2 e. 2

EwareSQL.log:==================================================================================================================

Oct 17 2014 17:03:03.275 2028 10784 3 execsql,time,sql 15 UPDATE Activity SET Acty_UpdatedDate = '20141017 17:03:03', Acty_LastAction = '20141017 17:03:03' WHERE acty_SID='55378376432552' AND acty_UserID = 1

Oct 17 2014 17:03:03.282 2028 10784 3 fselectsql,time,sql 0 select * from MailMergeNestedInfo WITH (NOLOCK) where mmni_EntityName = N'Opportunity'
Oct 17 2014 17:03:03.284 2028 10784 3 fqopen,time,sql 0 SELECT syscolumns.name AS CuVi_ColName FROM syscolumns, sysobjects WHERE syscolumns.id = sysobjects.id AND sysobjects.name = N'VMAILMERGEOPPORTUNITY' ORDER BY syscolumns.name

Oct 17 2014 17:03:03.319 2028 10784 3 fqopen,time,sql 0 SELECT syscolumns.name AS CuVi_ColName FROM syscolumns, sysobjects WHERE syscolumns.id = sysobjects.id AND sysobjects.name = N'vQuoteOpportunityItems' ORDER BY syscolumns.name

Oct 17 2014 17:03:03.349 2028 10784 3 fqopen,time,sql 15 SELECT syscolumns.name AS CuVi_ColName FROM syscolumns, sysobjects WHERE syscolumns.id = sysobjects.id AND sysobjects.name = N'vsearchlistuser' ORDER BY syscolumns.name

Oct 17 2014 17:03:03.454 2028 10784 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (user_smm_access='Y')
Oct 17 2014 17:03:03.469 2028 10784 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Solutions' or WkRl_Entity = N'Solutions') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:03.480 2028 10784 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Cases' or WkRl_Entity = N'Cases') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:03.490 2028 10784 3 fselectsql,time,sql 16 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Opportunity' or WkRl_Entity = N'Opportunity') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:03.517 2028 10784 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Lead' or WkRl_Entity = N'Lead') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:03.535 2028 10784 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is not null)
Oct 17 2014 17:03:03.543 2028 10784 3 fselectsql,time,sql 0 SELECT CObj_TableId, Cobj_TargetTable, Bord_Name FROM Custom_Screenobjects INNER JOIN Custom_Tables on CObj_CustomTableIdFK = bord_tableId WHERE cobj_name = N'ReportsTabGroup' AND cobj_type = N'TabGroup' AND CObj_Deleted IS NULL
Oct 17 2014 17:03:03.549 2028 10784 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (user_per_admin=3)
Oct 17 2014 17:03:03.554 2028 10784 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is null)
Oct 17 2014 17:03:03.556 2028 10784 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is not null)
Oct 17 2014 17:03:03.735 2028 10320 3 execsql,time,sql 0 DELETE FROM Locks WHERE Lock_CreatedBy=1 and Lock_DeviceID is null

Oct 17 2014 17:03:03.742 2028 10320 3 fqopen,time,sql 0 SELECT * FROM vMailMergeOpportunity WHERE Oppo_OpportunityId = 6

Oct 17 2014 17:03:07.841 2028 10320 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (user_smm_access='Y')
Oct 17 2014 17:03:07.857 2028 10320 3 fselectsql,time,sql 16 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Solutions' or WkRl_Entity = N'Solutions') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:07.869 2028 10320 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Cases' or WkRl_Entity = N'Cases') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:07.880 2028 10320 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Opportunity' or WkRl_Entity = N'Opportunity') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:07.908 2028 10320 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Lead' or WkRl_Entity = N'Lead') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:07.926 2028 10320 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is not null)
Oct 17 2014 17:03:07.934 2028 10320 3 fselectsql,time,sql 0 SELECT CObj_TableId, Cobj_TargetTable, Bord_Name FROM Custom_Screenobjects INNER JOIN Custom_Tables on CObj_CustomTableIdFK = bord_tableId WHERE cobj_name = N'ReportsTabGroup' AND cobj_type = N'TabGroup' AND CObj_Deleted IS NULL
Oct 17 2014 17:03:07.940 2028 10320 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (user_per_admin=3)
Oct 17 2014 17:03:07.944 2028 10320 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is null)
Oct 17 2014 17:03:07.946 2028 10320 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is not null)
Oct 17 2014 17:03:07.980 2028 2324 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (user_smm_access='Y')
Oct 17 2014 17:03:07.995 2028 2324 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Solutions' or WkRl_Entity = N'Solutions') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:08.006 2028 2324 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Cases' or WkRl_Entity = N'Cases') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:08.017 2028 2324 3 fselectsql,time,sql 0 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Opportunity' or WkRl_Entity = N'Opportunity') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:08.044 2028 2324 3 fselectsql,time,sql 16 select * from vWorkflowRulesTransitionInfo WITH (NOLOCK) where (COALESCE(wkrl_workflowid, 0) = 0 or ( Work_Enabled = N'y' and (not wktr_transitionid = 0))) and ( WkRl_Table = N'Lead' or WkRl_Entity = N'Lead') AND (WkRl_Channel = 12 OR COALESCE(WkRl_Channel, 0) = 0) AND WkRl_RuleType = N'New' ORDER BY WkRl_Order
Oct 17 2014 17:03:08.061 2028 2324 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is not null)
Oct 17 2014 17:03:08.068 2028 2324 3 fselectsql,time,sql 0 SELECT CObj_TableId, Cobj_TargetTable, Bord_Name FROM Custom_Screenobjects INNER JOIN Custom_Tables on CObj_CustomTableIdFK = bord_tableId WHERE cobj_name = N'ReportsTabGroup' AND cobj_type = N'TabGroup' AND CObj_Deleted IS NULL
Oct 17 2014 17:03:08.073 2028 2324 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (user_per_admin=3)
Oct 17 2014 17:03:08.078 2028 2324 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is null)
Oct 17 2014 17:03:08.080 2028 2324 3 fselectsql,time,sql 0 SELECT User_UserID FROM vUsers WITH (NOLOCK) WHERE User_UserID = 1 AND (User_EmarketingUserId is not null)

ewaressql.log:==================================================================================================================

Oct 17 2014 17:04:37.050 2028 13048 3 execsql,time,sql 0 UPDATE Activity SET Acty_Duration = DATEDIFF(MI, Acty_Login, COALESCE(Acty_Logout,'20141017 17:04:37')) WHERE Acty_LogoutMethod IS NULL

Oct 17 2014 17:04:57.515 12424 12760 3 fqopen,time,sql 0 SELECT * FROM Custom_EmailAddress WHERE EmSe_EMServiceID = 5

Oct 17 2014 17:04:57.519 12424 12760 3 fqopen,time,sql 0 SELECT Parm_Value FROM Custom_SysParams WHERE Parm_Name = N'DocStore'

Oct 17 2014 17:04:57.693 12424 12760 3 execsql,time,sql 16 UPDATE Custom_EmailAddress SET EmSe_LastCheckTime = '20141017 17:04:57' WHERE EmSe_EMServiceID = 5

Oct 17 2014 17:04:57.704 12424 12760 3 fqopen,time,sql 0 SELECT * FROM Custom_EmailAddress WHERE EmSe_EMServiceID = 7

Oct 17 2014 17:04:57.714 12424 12760 3 fqopen,time,sql 0 SELECT Parm_Value FROM Custom_SysParams WHERE Parm_Name = N'DocStore'

Oct 17 2014 17:04:57.796 12424 12760 3 execsql,time,sql 0 UPDATE Custom_EmailAddress SET EmSe_LastCheckTime = '20141017 17:04:57' WHERE EmSe_EMServiceID = 7

Oct 17 2014 17:04:58.016 4664 3800 3 fselectsql,time,sql 0 SELECT id FROM sysobjects WITH (NOLOCK) WHERE name = N'vSentinel' AND xtype = N'V'
Oct 17 2014 17:04:58.026 4664 3800 3 fselectsql,time,sql 0 SELECT Parm_Value FROM Custom_SysParams WHERE parm_name = N'KeywordFullIndexStart'
Oct 17 2014 17:04:58.035 4664 3800 3 fselectsql,time,sql 15 Select Parm_Name, Parm_Value From Custom_Sysparams WITH (NOLOCK) where Parm_Name = N'MetadataVersion' OR Parm_Name = N'SysLockedTime' OR Parm_Name = N'SysLockedByUsrID' ORDER BY Parm_Name
Oct 17 2014 17:04:58.048 4664 3800 3 fqopen,time,sql 0 SELECT ColP_ColName, FdSe_Permissions FROM Custom_Edits, FieldSecurity WHERE ColP_ColPropsID = FdSe_ColPropsID AND FdSe_Deleted IS NULL ORDER BY ColP_ColName, FdSe_SecType, FdSe_RecordID

Oct 17 2014 17:04:58.077 12424 11468 3 execsql,time,sql 0 UPDATE Activity SET Acty_Duration = DATEDIFF(MI, Acty_Login, COALESCE(Acty_Logout,'20141017 17:04:58')) WHERE Acty_LogoutMethod IS NULL

Oct 17 2014 17:04:58.103 4664 3800 3 fselectsql,time,sql 0 SELECT Parm_Value FROM Custom_SysParams WHERE parm_name = N'KeywordIndexInterval'
Oct 17 2014 17:04:58.107 4664 3800 3 fselectsql,time,sql 0 SELECT Parm_Value FROM Custom_SysParams WHERE parm_name = N'KeywordIncrIndexStart'
Oct 17 2014 17:04:58.108 4664 3800 3 fselectsql,time,sql 0 SELECT count(CuVi_ViewName) as FCount FROM custom_views WHERE CuVi_Options & 16 <> 0
Oct 17 2014 17:04:58.109 4664 3800 3 fselectsql,time,sql 0 SELECT CuVi_ViewName,CuVi_Entity FROM custom_views WHERE CuVi_Options & 16 <> 0
Oct 17 2014 17:04:58.153 4664 3800 3 fselectsql,time,sql 31 SELECT Comm_CommunicationId, comm_UpdatedDate, comm_bcc, comm_cc, comm_crmonly, comm_description, comm_docdir, comm_docname, comm_email, comm_emaillinkscreated, comm_from, comm_isstub, comm_location, comm_note, comm_replyto, comm_subject, comm_targetlistid, comm_to, comp_accnts_activation, comp_accnts_other, comp_accnts_serial_no, comp_accounts_user, comp_accounts_version, comp_blank, comp_emailaddress, comp_faxareacode, comp_faxcountrycode, comp_faxnumber, comp_intforeignid, comp_librarydir, comp_name, comp_no_of_companies, comp_payroll_accountno, comp_payroll_serialno, comp_payslips, comp_pegasus_customer_code, comp_phoneareacode, comp_phonecountrycode, comp_phonenumber, comp_version, comp_website, pers_department, pers_emailaddress, pers_facebookid, pers_fakeemail, pers_fakeemailfinal, pers_fakefirstname, pers_fakelastname, pers_faxareacode, pers_faxcountrycode, pers_faxnumber, pers_fbprofile, pers_firstname, pers_fullname, pers_intforeignid, pers_lastname, pers_librarydir, pers_linkedinid, pers_linkedinpublicprofile, pers_linkedinurl, pers_liprofile, pers_middlename, pers_phoneareacode, pers_phonecountrycode, pers_phonenumber, pers_suffix, pers_title, pers_website FROM vSearchListCommunication WITH (NOLOCK) WHERE comm_UpdatedDate > '20141017 16:59:46' ORDER BY Comm_CommunicationId
Oct 17 2014 17:04:58.164 4664 3800 3 execsql,time,sql 16 UPDATE Custom_SysParams SET Parm_Value=N'41929.711784',Parm_UpdatedDate = '20141017 17:04:58' Where Parm_Name = N'KeywordIncrIndexStart'

Oct 17 2014 17:04:58.257 4664 3800 3 fselectsql,time,sql 63 SELECT Comp_CompanyId, comp_UpdatedDate, acc_intforeignid, acc_librarydir, acc_name, addr_address1, addr_address2, addr_address3, addr_address4, addr_address5, addr_city, addr_intforeignid, addr_postcode, addr_state, addr_uszipplusfour, comp_accnts_activation, comp_accnts_other, comp_accnts_serial_no, comp_accounts_user, comp_accounts_version, comp_blank, comp_emailaddress, comp_faxareacode, comp_faxcountrycode, comp_faxfullnumber, comp_faxnumber, comp_intforeignid, comp_librarydir, comp_name, comp_no_of_companies, comp_payroll_accountno, comp_payroll_serialno, comp_payslips, comp_pegasus_customer_code, comp_phoneareacode, comp_phonecountrycode, comp_phonenumber, comp_version, comp_website, pers_department, pers_emailaddress, pers_facebookid, pers_fakeemail, pers_fakeemailfinal, pers_fakefirstname, pers_fakelastname, pers_faxareacode, pers_faxcountrycode, pers_faxfullnumber, pers_faxnumber, pers_fbprofile, pers_firstname, pers_fullname, pers_intforeignid, pers_lastname, pers_librarydir, pers_linkedinid, pers_linkedinpublicprofile, pers_linkedinurl, pers_liprofile, pers_middlename, pers_phoneareacode, pers_phonecountrycode, pers_phonenumber, pers_suffix, pers_title, pers_website FROM vSearchListCompany WITH (NOLOCK) WHERE comp_UpdatedDate > '20141017 16:59:46' ORDER BY Comp_CompanyId
Oct 17 2014 17:04:58.320 4664 3800 3 fselectsql,time,sql 47 SELECT Pers_PersonId, pers_UpdatedDate, addr_address1, addr_address2, addr_address3, addr_address4, addr_address5, addr_city, addr_intforeignid, addr_postcode, addr_state, addr_uszipplusfour, comp_accnts_activation, comp_accnts_other, comp_accnts_serial_no, comp_accounts_user, comp_accounts_version, comp_blank, comp_emailaddress, comp_faxareacode, comp_faxcountrycode, comp_faxnumber, comp_intforeignid, comp_librarydir, comp_name, comp_no_of_companies, comp_payroll_accountno, comp_payroll_serialno, comp_payslips, comp_pegasus_customer_code, comp_phoneareacode, comp_phonecountrycode, comp_phonenumber, comp_version, comp_website, pers_department, pers_emailaddress, pers_facebookid, pers_fakeemail, pers_fakeemailfinal, pers_fakefirstname, pers_fakelastname, pers_faxareacode, pers_faxcountrycode, pers_faxfullnumber, pers_faxnumber, pers_fbprofile, pers_firstname, pers_fullname, pers_intforeignid, pers_lastname, pers_librarydir, pers_linkedinid, pers_linkedinpublicprofile, pers_linkedinurl, pers_liprofile, pers_middlename, pers_phoneareacode, pers_phonecountrycode, pers_phonenumber, pers_suffix, pers_title, pers_website FROM vSearchListPerson WITH (NOLOCK) WHERE pers_UpdatedDate > '20141017 16:59:46' ORDER BY Pers_PersonId
Oct 17 2014 17:04:58.378 4664 3800 3 fselectsql,time,sql 46 SELECT Case_CaseId, case_UpdatedDate, addr_address1, addr_address2, addr_address3, addr_address4, addr_address5, addr_city, addr_intforeignid, addr_postcode, addr_state, addr_uszipplusfour, case_customerref, case_description, case_problemnote, case_progressnote, case_referenceid, case_serialnumber, case_solutionnote, comp_accnts_activation, comp_accnts_other, comp_accnts_serial_no, comp_accounts_user, comp_accounts_version, comp_blank, comp_emailaddress, comp_faxareacode, comp_faxcountrycode, comp_faxnumber, comp_intforeignid, comp_librarydir, comp_name, comp_no_of_companies, comp_payroll_accountno, comp_payroll_serialno, comp_payslips, comp_pegasus_customer_code, comp_phoneareacode, comp_phonecountrycode, comp_phonenumber, comp_version, comp_website, pers_department, pers_emailaddress, pers_facebookid, pers_fakeemail, pers_fakeemailfinal, pers_fakefirstname, pers_fakelastname, pers_faxareacode, pers_faxcountrycode, pers_faxnumber, pers_fbprofile, pers_firstname, pers_intforeignid, pers_lastname, pers_librarydir, pers_linkedinid, pers_linkedinpublicprofile, pers_linkedinurl, pers_liprofile, pers_middlename, pers_phoneareacode, pers_phonecountrycode, pers_phonenumber, pers_suffix, pers_title, pers_website FROM vKeywordSearchListCase WITH (NOLOCK) WHERE case_UpdatedDate > '20141017 16:59:46' ORDER BY Case_CaseId
Oct 17 2014 17:04:58.427 4664 3800 3 fselectsql,time,sql 47 SELECT Oppo_OpportunityId, oppo_UpdatedDate, comp_accnts_activation, comp_accnts_other, comp_accnts_serial_no, comp_accounts_user, comp_accounts_version, comp_blank, comp_emailaddress, comp_faxareacode, comp_faxcountrycode, comp_faxnumber, comp_intforeignid, comp_librarydir, comp_name, comp_no_of_companies, comp_payroll_accountno, comp_payroll_serialno, comp_payslips, comp_pegasus_customer_code, comp_phoneareacode, comp_phonecountrycode, comp_phonenumber, comp_version, comp_website, oppo_customerref, oppo_description, oppo_note, oppo_progressnote, oppo_whyneed, pers_department, pers_emailaddress, pers_facebookid, pers_fakeemail, pers_fakeemailfinal, pers_fakefirstname, pers_fakelastname, pers_faxareacode, pers_faxcountrycode, pers_faxnumber, pers_fbprofile, pers_firstname, pers_intforeignid, pers_lastname, pers_librarydir, pers_linkedinid, pers_linkedinpublicprofile, pers_linkedinurl, pers_liprofile, pers_middlename, pers_phoneareacode, pers_phonecountrycode, pers_phonenumber, pers_suffix, pers_title, pers_website FROM vKeywordSearchListOpportunity WITH (NOLOCK) WHERE oppo_UpdatedDate > '20141017 16:59:46' ORDER BY Oppo_OpportunityId
Oct 17 2014 17:04:58.435 4664 3800 3 fselectsql,time,sql 0 SELECT Lead_LeadId, lead_UpdatedDate, lead_addressuszipplusfour, lead_companyaddress1, lead_companyaddress2, lead_companyaddress3, lead_companyaddress4, lead_companycity, lead_companymatch, lead_companyname, lead_companypostcode, lead_companystate, lead_companywebsite, lead_description, lead_details, lead_personemail, lead_personfaxareacode, lead_personfaxcountrycode, lead_personfaxnumber, lead_personfirstname, lead_personlastname, lead_personmiddlename, lead_personphoneareacode, lead_personphonecountrycode, lead_personphonenumber, lead_persontitle, lead_progressnote, lead_reasonnotinterested, lead_what_version FROM vKeywordSearchListLead WITH (NOLOCK) WHERE lead_UpdatedDate > '20141017 16:59:46' ORDER BY Lead_LeadId
Oct 17 2014 17:04:58.476 4664 3800 3 fselectsql,time,sql 47 SELECT Acc_AccountId, acc_UpdatedDate, acc_intforeignid, acc_librarydir, acc_name, addr_address1, addr_address2, addr_address3, addr_address4, addr_address5, addr_city, addr_intforeignid, addr_postcode, addr_state, addr_uszipplusfour, comp_accnts_activation, comp_accnts_other, comp_accnts_serial_no, comp_accounts_user, comp_accounts_version, comp_blank, comp_emailaddress, comp_faxareacode, comp_faxcountrycode, comp_faxnumber, comp_intforeignid, comp_librarydir, comp_name, comp_no_of_companies, comp_payroll_accountno, comp_payroll_serialno, comp_payslips, comp_pegasus_customer_code, comp_phoneareacode, comp_phonecountrycode, comp_phonenumber, comp_version, comp_website, pers_department, pers_emailaddress, pers_facebookid, pers_fakeemail, pers_fakeemailfinal, pers_fakefirstname, pers_fakelastname, pers_faxareacode, pers_faxcountrycode, pers_faxfullnumber, pers_faxnumber, pers_fbprofile, pers_firstname, pers_fullname, pers_intforeignid, pers_lastname, pers_librarydir, pers_linkedinid, pers_linkedinpublicprofile, pers_linkedinurl, pers_liprofile, pers_middlename, pers_phoneareacode, pers_phonecountrycode, pers_phonenumber, pers_suffix, pers_title, pers_website FROM vSearchListAccount WITH (NOLOCK) WHERE acc_UpdatedDate > '20141017 16:59:46' ORDER BY Acc_AccountId
Oct 17 2014 17:04:58.543 4664 3800 3 fselectsql,time,sql 62 SELECT Orde_OrderQuoteId, orde_UpdatedDate, acc_intforeignid, acc_librarydir, acc_name, addr_address1, addr_address2, addr_address3, addr_address4, addr_address5, addr_city, addr_postcode, addr_state, comp_emailaddress, comp_name, oppo_description, oppo_note, orde_billaddress, orde_description, orde_intforeignid, orde_payterms, orde_poref, orde_reference, orde_repricingstatus, orde_shipaddress, orde_synchmessage, orde_taxrate, pers_emailaddress, pers_firstname, pers_lastname FROM vOrderOppo WITH (NOLOCK) WHERE orde_UpdatedDate > '20141017 16:59:46' ORDER BY Orde_OrderQuoteId
Oct 17 2014 17:04:58.609 4664 3800 3 fselectsql,time,sql 63 SELECT Quot_OrderQuoteId, quot_UpdatedDate, acc_intforeignid, acc_librarydir, acc_name, addr_address1, addr_address2, addr_address3, addr_address4, addr_address5, addr_city, addr_postcode, addr_state, comp_emailaddress, comp_name, oppo_description, oppo_note, pers_emailaddress, pers_firstname, pers_lastname, quot_billaddress, quot_description, quot_intforeignid, quot_payterms, quot_poref, quot_reference, quot_repricingstatus, quot_shipaddress, quot_synchmessage, quot_taxrate FROM vQuoteOppos WITH (NOLOCK) WHERE quot_UpdatedDate > '20141017 16:59:46' ORDER BY Quot_OrderQuoteId
Oct 17 2014 17:04:58.611 4664 3800 3 fselectsql,time,sql 0 SELECT * FROM vNotificationBackups WHERE LiBc_Library_BackupID=-1 ORDER BY LiBc_Library_BackupID
Oct 17 2014 17:04:59.156 4664 3800 3 execsql,time,sql 0 UPDATE Custom_SysParams SET Parm_Value=N'41929.711796',Parm_UpdatedDate = '20141017 17:04:59' Where Parm_Name = N'KeywordIncrIndexFinish'

Oct 17 2014 17:05:37.067 2028 13048 3 execsql,time,sql 16 UPDATE Activity SET Acty_Duration = DATEDIFF(MI, Acty_Login, COALESCE(Acty_Logout,'20141017 17:05:37')) WHERE Acty_LogoutMethod IS NULL

  • 0

    Michal

    What type of template are you using? Are you using an HTML template you created your self? Did you paste this in from another source?

    Is the template a word document? Is it a new template you created? Did you follow the instructions about creating a new Word template?

    See: community.sagecrm.com/.../sage-crm-7-2-how-mail-merge-works.aspx

  • 0

    Hi Jeff,

    I tried to use both types but the result was the same. All templates used were containing only 1 or 3 fields.

    I have restored the CRM on a different machine but the issue was the same.

    In SQL view called vMailMergeOpportunity i have replaced the code with "select * from opportunity" - [this didnt help either. The output was the same so i have restored the view to its original state]

    I have also tried to reinstall the CRM except the database. When i have reinstalled the database then the mail merge was working fine - but obviously all data is lost during this process so this is not an option for us.

    Yes. I followed the instructions. (adding merge field to a word doc by "quick parts>field>mergefield" and saving it as doc or docx - i tried both)

    Clearly, this issue resides in database. If any, what tables are used by Mail Merge? I could only see 1 table containing info about child views.

    When using Component Wizard for creating a custom entity a log will be produced. By using this log, I was able to acquire a list of tables used for this process.

    By checking all tables mentioned in the log I was still unable to resolve this issue. Still, there are no error messages of any kind.

    Could anyone provide any suggestions please?

    Regards,

    Michal

*Community Hub is the new name for Sage City