Hi Josh,

This sounds like a known issue that has been raised with us previously. There is a fix for this issue expected in 7.2F. Please contact your local support office for the date of this patch release in your region.

Regards,

Kevin

Hi Kevin,

thanks for letting us know. I have been beating my head against a wall on this for some time now.

Do you have any information on this known issue that i can read up on to compare issues.?

Do you know if there will be a way to remove all the duplicate entries in the database? AS we send out over 5000 emails a week with this system, the duplicates have really started clogging up the database and we are having to perform far more maintenance than we used to to keep performance up on the SQL server. It also slows down views, and mobile access on mobile devices for users.

Regards,

Josh

There is a way to remove the duplicate entries. We have the same issue and so I found a way to remove the incorrect entries. We are on 7.2f1 as of last night so don't know if it is truly resolved yet or not.

The way I found to remove the incorrect links requires a little SQL knowledge and some manual digging. To get the SQL for the dynamic groups look at the UI and pull up the SQL from the right hand menu of the dynamic group. If you have any trouble following this let me know and I will assist. We've use this several times to delete the incorrect links from the SP integration.

/* Run the below query and find the communicationID that needs unlinked from people who didn't actually receive it*/

select comm_communicationid, comm_from, comm_subject from communication where comm_subject like '%E-marketing%AFPM%'

/* Run this query to find the DDid for the static group

If is not a static group but dynamic you will need to open CRM go to the group

and click the SQL button on the right to get the query for the not in portion of the update statement */

select repo_name, repo_ddcategoryid from custom_reports

/* set values here or if dynamic group use the other statement */

DECLARE @commid int

DECLARE @ddid int

DECLARE @sql text

SET @commid =

SET @ddid =

SET @sql = ''

-- static group

--update comm_link set cmli_deleted=1

--where cmli_comm_communicationid = @commid

--and cmli_comm_personid not in (SELECT DISTINCT Pers_PersonId

-- FROM DData, DDField, vpersonlist

-- WHERE Pers_PersonId = DData.DData_EntityID AND DData.DData_FieldID = DDField.DDFld_FieldID

-- AND DDField.DDFld_CategoryID = @ddid AND DData.DData_ShortStr IN (N'Excluded', N'Included'))

-- dynamic group

--update comm_link set cmli_deleted=1

--where cmli_comm_communicationid = @commid

--and cmli_comm_personid not in (@SQL)

You could also provide my post above to a Business partner to perform for you.

Thanks Brad,

i will pass onto my business partner to run and see if this helps. As of a few days ago i am also on 7.2.f.1 which seems to have caused more harm than good. E-marketing no longer retrieves the results from swiftpage. Have you experienced this also since the update? If i log into the swiftpage backend, i see the reports sitting there but they have not synced to CRM.

Josh

Hi Josh,

It sounds like either the syncengine username or password in the syncengine.properties file which is held in "\CRM\tomcat\webapps\crmSPSyncEngine\WEB-INF" directory are incorrect.

This user needs to be both a CRM admin user and an E-Marketing user and the password should be the same as the hashed value in the user_password column of the Users table in CRM. Make sure there are no whitespaces after the password in the syncengine.properties file.

That section of the file should look something like this:

syncengine.crmuser=admin
syncengine.crmpassword=^FHAOICGIFJDLAHNDHPNPPHBMHBOPPIFHLCGJPHCM

You will need to restart the tomcat service for it to pick up any changes to this file.

Once you've followed those steps, see this article on how to fix up any past email blast with statistics that aren't syncing: community.sagecrm.com/.../935.536-17176-old-swiftpage-data-not-synced-into-crm.aspx

Regards,

Kevin