x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 18 replies
  • Subscribers 74 subscribers
  • Views 1903 views
  • Users 0 members are here
Browse Forums
Announcements
106
topics
32
replies
General Discussion
6k
topics
18k
replies
andy.griffiths@cwlsystems.co.uk

Swiftpage account has been cancelled error

Posted By

Normal 0 false false false EN-GB X-NONE X-NONE

Any help here would be appreciated;
We are currently using Sage CRM V7.1.d.1 with Swiftpage and getting the following error when accessing the E-marketing tab in marketing.
"Swiftpage account has been cancelled. E-marketing functionality is disabled"
The account is not cancelled (as checked by Sage)
Passwords have not changed
When accessing Administration->E-mail and Documents->E-marketing Configuration
I get the message; "E-marketing Account Status: Active"
And generally in the admin area everything seems to work as it should.
Any suggestions?
Thanks
Andy

  • 0

    Hi Andy,

    When you click on that tab 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: Cancelled

    If that's the case then you will need to contact Swiftpage support and ask them to re-enable your account: www.swiftpageconnect.com/.../swiftpage-connect.htm

    If there's something different in the SwiftPageIntegrationLog let me know.

  • 0

    Hi Kevin

    The system says "ACTIVE" in that log?

    Thanks

    Andy

  • 0

    OK can you also run this query against the CRM database and check what it returns:

    SELECT EmAc_Deleted,EmAc_Status from EmarketingAccount WITH (NOLOCK)

  • 0

    Hi Kevin

    I get;

    NULL inactive

    Regards

    Andy

  • 0

    OK so it looks like the status of your account is coming back correctly from Swiftpage but it is not being written to your database.

    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.

  • 0

    Are there any errors appearing in any of the log files in the CRM\Emarketing Integration directory?

  • 0

    Loading metadata...

    MetaDataStore >>> metadata loading time: 13218(millisec)

    DatabaseInfo >>> database info loading time: 2610(millisec)

    TranslationsStore >>> translations loading time: 11766(millisec)

    TranslationsStore >>> hardcoded translations ('slanames') loading time: 31(millisec)

    SDataService Store >>> metadata loading time: 125(millisec)

    SystemSettingsStore >>> SysParams load time: 157(millisec)

    GCRM metaDataStore >>> metadata loading time: 297(millisec)

    Exchange metaDataStore >>> metadata loading time: 265(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.UpdateAccountInfoThread.run(UpdateAccountInfoThread.java:97)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.setConnectionConfiguration(SyncCampaignTargetGroupThread.java:199)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.run(SyncCampaignTargetGroupThread.java:103)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 7 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignResultsThread.run(SyncCampaignResultsThread.java:42)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.syncFromSCRM(SyncCallListsThread.java:388)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.run(SyncCallListsThread.java:86)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getCallLists?Synch=Y

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    SystemSettingsStore >>> SysParams load time: 47(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    DatabaseInfo >>> database info loading time: 3141(millisec)

    MetaDataStore >>> metadata reload time: 218(millisec)

    GCRM metaDataStore >>> metadata reload time: 188(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    TranslationsStore >>> translations loading time: 4328(millisec)

    TranslationsStore >>> hardcoded translations ('slanames') loading time: 31(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.UpdateAccountInfoThread.run(UpdateAccountInfoThread.java:97)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.setConnectionConfiguration(SyncCampaignTargetGroupThread.java:199)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.run(SyncCampaignTargetGroupThread.java:103)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 7 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignResultsThread.run(SyncCampaignResultsThread.java:42)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.syncFromSCRM(SyncCallListsThread.java:388)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.run(SyncCallListsThread.java:86)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getCallLists?Synch=Y

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.UpdateAccountInfoThread.run(UpdateAccountInfoThread.java:97)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.setConnectionConfiguration(SyncCampaignTargetGroupThread.java:199)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.run(SyncCampaignTargetGroupThread.java:103)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 7 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignResultsThread.run(SyncCampaignResultsThread.java:42)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.syncFromSCRM(SyncCallListsThread.java:388)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.run(SyncCallListsThread.java:86)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getCallLists?Synch=Y

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.UpdateAccountInfoThread.run(UpdateAccountInfoThread.java:97)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.setConnectionConfiguration(SyncCampaignTargetGroupThread.java:199)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.run(SyncCampaignTargetGroupThread.java:103)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 7 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignResultsThread.run(SyncCampaignResultsThread.java:42)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.syncFromSCRM(SyncCallListsThread.java:388)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.run(SyncCallListsThread.java:86)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getCallLists?Synch=Y

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    DatabaseInfo >>> database info loading time: 5422(millisec)

    MetaDataStore >>> metadata reload time: 531(millisec)

    GCRM metaDataStore >>> metadata reload time: 203(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    TranslationsStore >>> translations loading time: 3234(millisec)

    TranslationsStore >>> hardcoded translations ('slanames') loading time: 32(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 31(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 31(millisec)

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.UpdateAccountInfoThread.run(UpdateAccountInfoThread.java:97)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.setConnectionConfiguration(SyncCampaignTargetGroupThread.java:199)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignTargetGroupThread.run(SyncCampaignTargetGroupThread.java:103)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 7 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.utils.SPConnectionConfigurationHelper.getConfiguration(SPConnectionConfigurationHelper.java:89)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCampaignResultsThread.run(SyncCampaignResultsThread.java:42)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getAccountConfiguration

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    Exception in thread "SyncEngine thread" java.lang.IllegalArgumentException

    at java.net.URI.create(Unknown Source)

    at org.apache.http.client.methods.HttpGet.(HttpGet.java:69)

    at com.sage.scrm.core.httpconsumer.HttpConsumer.doGet(HttpConsumer.java:535)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.syncFromSCRM(SyncCallListsThread.java:388)

    at com.sage.scrm.syncengine.emarketing.scheduler.SyncCallListsThread.run(SyncCallListsThread.java:86)

    at java.lang.Thread.run(Unknown Source)

    Caused by: java.net.URISyntaxException: Illegal character in fragment at index 13: #ENDPOINT_URL#/$service/getCallLists?Synch=Y

    at java.net.URI$Parser.fail(Unknown Source)

    at java.net.URI$Parser.checkChars(Unknown Source)

    at java.net.URI$Parser.parse(Unknown Source)

    at java.net.URI.(Unknown Source)

    ... 6 more

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    DatabaseInfo >>> database info loading time: 3656(millisec)

    MetaDataStore >>> metadata reload time: 422(millisec)

    GCRM metaDataStore >>> metadata reload time: 250(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    TranslationsStore >>> translations loading time: 484(millisec)

    TranslationsStore >>> hardcoded translations ('slanames') loading time: 109(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    DatabaseInfo >>> database info loading time: 2953(millisec)

    MetaDataStore >>> metadata reload time: 454(millisec)

    GCRM metaDataStore >>> metadata reload time: 234(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    TranslationsStore >>> translations loading time: 1844(millisec)

    TranslationsStore >>> hardcoded translations ('slanames') loading time: 31(millisec)

    SystemSettingsStore >>> SysParams load time: 15(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

  • 0

    Sorry about that, I can see an error concerning ENDPOINT_URL#/$service/getAccountConfiguration

    I thought I'd send it all

  • 0

    No worries, better too much than too little.

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

    #tomcat url
    syncengine.configurationurl=#ENDPOINT_URL#

    If so change it to:

    #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:

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

  • 0

    All done, no idea how to restart tomcat?

  • 0

    Same error, although I have found this in "20130226spnighttask.log"

    2013-02-26/15:32:38.440/GMT [http-10009-1] ERROR com.sage.scrm.syncengine.emarketing.webservice.model.UpdateAccountInfoModel.getData com.sage.scrm.syncengine.emarketing.communication.handler.errors.SPHandlerException: Command returned error: ERROR Password is incorrect

  • 0

    That's probably referring to the EmAc_Password field on the EmarketingAccount table in CRM.

    Have you raised a case for this issue with your local support team?

    There seems to be a couple of issues here it would probably be resolved quicker if somebody logged on and had a look.

  • 0

    stdout in now error free

    Loading metadata...

    MetaDataStore >>> metadata loading time: 12828(millisec)

    DatabaseInfo >>> database info loading time: 3172(millisec)

    TranslationsStore >>> translations loading time: 11516(millisec)

    TranslationsStore >>> hardcoded translations ('slanames') loading time: 47(millisec)

    SDataService Store >>> metadata loading time: 140(millisec)

    SystemSettingsStore >>> SysParams load time: 110(millisec)

    GCRM metaDataStore >>> metadata loading time: 203(millisec)

    Exchange metaDataStore >>> metadata loading time: 313(millisec)

    SystemSettingsStore >>> SysParams load time: 0(millisec)

    SystemSettingsStore >>> SysParams load time: 16(millisec)

  • 0

    Yes, call logged been waiting over a week

  • 0

    I'll follow up with that have you got a case reference number?

  • 0

    Hi Kevin it's

    LTK1212104682781X

*Community Hub is the new name for Sage City