Swiftpage

Useful details on: https://community.sagecrm.com/user_community/f/84/p/9017/25172.aspx#25172

In CRM the tomcat server communicates with the Swiftpage server to get your "Account Status".

There should be a SwiftPageIntegrationLog in your CRM\Logs folder where you'll see the xml response from the Swiftpage server, in your case it could be something like: <AccountStatus>Cancelled</AccountStatus>

Run this query against the CRM database and check what it returns:

SELECT EmAc_Deleted,EmAc_Status from EmarketingAccount WITH (NOLOCK)

It's possible that the user in CRM\tomcat\webapps\crmSPSyncEngine\WEB-INF\syncengine.properties folder does not have admin rights in CRM.

In that file check these 2 lines:

syncengine.crmuser= syncengine.crmpassword=

make sure the username and password specified here matches one of the results from this query you can run on the database:

SELECT User_Logon, User_Password FROM Users WHERE User_Per_Admin = 3

If not copy the username and the encrypted password from the database into the syncengine.properties file & restart the apache tomcat service.

check the syncengine.properties file and see if you have these 2 lines in there:

1. tomcat url

syncengine.configurationurl=#ENDPOINT_URL#

If so change it to:

1. tomcat url

syncengine.configurationurl=http://localhost:10009/crmj

That's assuming your tomcat port is 10009 and your install name is crm.

You can check the tomcat port in the file tomcat\conf\server.xml you'll see a line like:

<Connector port="10009" protocol="HTTP/1.1" redirectPort="8443" maxThreads="300"/>

You'll need to restart tomcat after making these changes for them to take effect.

---

Troubleshooting

====

1. The server name or address could not be resolved

The server name is incorrect in the dbo.Custom_SysParams table. This can happen if you have created the database on one machine and then copied it on to another.

In SQL run the following:-

Query the table select * from dbo.Custom_SysParams where parm_name = 'servernames' order by parm_name

To update the table change the parm_value to the correct server name

Note: you have to have the semi-colon (;) at the end

update dbo.Custom_SysParams set parm_value = 'YOURSERVERNAME;' where parm_name = 'servernames' Once correct you may need to do a metadata refresh or an IISRESET

2. There was a problem executing command on Swiftpage. There was an exception while executing SwiftPage command : An invalid response XML was returned from SPSynchEngine