Hello,
I upgraded the CRM 7.0 to CRM 7.2 and the system mostly work fine but the Exchange Integration. Here is the summary based on what I've found:
1. The synchronization of contacts works fine; the synchronization of tasks and appointments doesn't work (see logs below).
2. If the system is upgraded with out of the box database including demo data, the Exchange Integration works fine running 7.2; if the system is upgraded with client's database, the synchronization of tasks and appointments doesn't work.
3. I suspect there are issues with client's database so I changed the collation for Exchange related tables from SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS but the same issues remain; I then deleted EcngIntegration and EcngSyncDigestEntry table records, set up a new EWS connection successfully, but the same issues remain.
ExchangeSync log file:
ERROR [http-apr-10009-exec-2]: 09-Mar-2014 22:01:02.311 com.sage.scrm.model.error.SageSynchronizationException: com.sage.scrm.model.error.SageDataAccessException: Data access failure.
ERROR [http-apr-10009-exec-6]: 09-Mar-2014 22:01:03.544 url: http://<server name>/sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=36c037b0-ddc6-4f0f-ae33-6484e62d87d1, error: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=36c037b0-ddc6-4f0f-ae33-6484e62d87d1 failed: 500, action: ESTABLISHING_CONNECTION_CRM_ENDPOINT
ERROR [http-apr-10009-exec-10]: 09-Mar-2014 22:03:07.235 com.sage.scrm.model.error.SageSynchronizationException: com.sage.scrm.model.error.SageDataAccessException: Data access failure.
ERROR [http-apr-10009-exec-4]: 09-Mar-2014 22:03:08.906 url: http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=e1d8cb9f-95ae-4e7f-a7f5-919be9abb41f, error: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=e1d8cb9f-95ae-4e7f-a7f5-919be9abb41f failed: 500, action: ESTABLISHING_CONNECTION_CRM_ENDPOINT
ERROR [http-apr-10009-exec-1]: 09-Mar-2014 22:05:27.687 com.sage.scrm.model.error.SageSynchronizationException: com.sage.scrm.model.error.SageDataAccessException: Data access failure.
ERROR [http-apr-10009-exec-9]: 09-Mar-2014 22:05:29.627 url: http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=ef770176-3db4-4aa7-acb1-d728399e66e6, error: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=ef770176-3db4-4aa7-acb1-d728399e66e6 failed: 500, action: ESTABLISHING_CONNECTION_CRM_ENDPOINT
ERROR [http-apr-10009-exec-5]: 09-Mar-2014 22:12:53.788 com.sage.scrm.model.error.SageSynchronizationException: com.sage.scrm.model.error.SageDataAccessException: Data access failure.
ERROR [http-apr-10009-exec-4]: 09-Mar-2014 22:12:55.410 url: http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=d7cf4d21-e516-4b24-bdf0-5c5dee45deee, error: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=d7cf4d21-e516-4b24-bdf0-5c5dee45deee failed: 500, action: ESTABLISHING_CONNECTION_CRM_ENDPOINT
ExchangeSynchronization log file:
2014-03-09/22:01:02.324/MDT [SyncEngine thread] ERROR com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>/sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=36c037b0-ddc6-4f0f-ae33-6484e62d87d1 failed: 500
2014-03-09/22:03:07.241/MDT [SyncEngine thread] ERROR com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=e1d8cb9f-95ae-4e7f-a7f5-919be9abb41f failed: 500
2014-03-09/22:05:27.692/MDT [SyncEngine thread] ERROR com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=ef770176-3db4-4aa7-acb1-d728399e66e6 failed: 500
2014-03-09/22:12:53.794/MDT [SyncEngine thread] ERROR com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=d7cf4d21-e516-4b24-bdf0-5c5dee45deee failed: 500
ExchangeSyncEngineStackTrace log file:
2014-03-09/22:01:02.325/MDT [SyncEngine thread] ERROR com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>/sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=36c037b0-ddc6-4f0f-ae33-6484e62d87d1 failed: 500
com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=36c037b0-ddc6-4f0f-ae33-6484e62d87d1 failed: 500
at com.sage.scrm.syncengine.exchange.engine.SynchronisationProcess.execute(SynchronisationProcess.java:202)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.synchroniseResourceOneWay(SynchronisationThread.java:296)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.synchroniseResourcesOneWay(SynchronisationThread.java:281)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run(SynchronisationThread.java:173)
at java.lang.Thread.run(Unknown Source)
Caused by: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=36c037b0-ddc6-4f0f-ae33-6484e62d87d1 failed: 500
at com.sage.scrm.syncengine.exchange.sdata.SCRMEndpoint.sendToSyncTarget(SCRMEndpoint.java:199)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationProcess.execute(SynchronisationProcess.java:169)
... 4 more
Caused by: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=36c037b0-ddc6-4f0f-ae33-6484e62d87d1 failed: 500
at com.sage.crm.httpconsumer.HttpConsumer.doPostPut(HttpConsumer.java:981)
at com.sage.crm.httpconsumer.HttpConsumer.doPost(HttpConsumer.java:776)
at com.sage.crm.httpconsumer.HttpConsumer.doPost(HttpConsumer.java:748)
at com.sage.scrm.syncengine.exchange.sdata.SCRMEndpoint.sendToSyncTarget(SCRMEndpoint.java:191)
... 5 more
2014-03-09/22:03:07.242/MDT [SyncEngine thread] ERROR com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=e1d8cb9f-95ae-4e7f-a7f5-919be9abb41f failed: 500
com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=e1d8cb9f-95ae-4e7f-a7f5-919be9abb41f failed: 500
at com.sage.scrm.syncengine.exchange.engine.SynchronisationProcess.execute(SynchronisationProcess.java:202)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.synchroniseResourceOneWay(SynchronisationThread.java:296)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.synchroniseResourcesOneWay(SynchronisationThread.java:281)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run(SynchronisationThread.java:173)
at java.lang.Thread.run(Unknown Source)
Caused by: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=e1d8cb9f-95ae-4e7f-a7f5-919be9abb41f failed: 500
at com.sage.scrm.syncengine.exchange.sdata.SCRMEndpoint.sendToSyncTarget(SCRMEndpoint.java:199)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationProcess.execute(SynchronisationProcess.java:169)
... 4 more
Caused by: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=e1d8cb9f-95ae-4e7f-a7f5-919be9abb41f failed: 500
at com.sage.crm.httpconsumer.HttpConsumer.doPostPut(HttpConsumer.java:981)
at com.sage.crm.httpconsumer.HttpConsumer.doPost(HttpConsumer.java:776)
at com.sage.crm.httpconsumer.HttpConsumer.doPost(HttpConsumer.java:748)
at com.sage.scrm.syncengine.exchange.sdata.SCRMEndpoint.sendToSyncTarget(SCRMEndpoint.java:191)
... 5 more
2014-03-09/22:05:27.692/MDT [SyncEngine thread] ERROR com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=ef770176-3db4-4aa7-acb1-d728399e66e6 failed: 500
com.sage.scrm.syncengine.core.engine.error.SageSyncEngineException: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=ef770176-3db4-4aa7-acb1-d728399e66e6 failed: 500
at com.sage.scrm.syncengine.exchange.engine.SynchronisationProcess.execute(SynchronisationProcess.java:202)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.synchroniseResourceOneWay(SynchronisationThread.java:296)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.synchroniseResourcesOneWay(SynchronisationThread.java:281)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationThread.run(SynchronisationThread.java:173)
at java.lang.Thread.run(Unknown Source)
Caused by: com.sage.scrm.syncengine.exchange.engine.model.error.SageSDataEndpointException: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=ef770176-3db4-4aa7-acb1-d728399e66e6 failed: 500
at com.sage.scrm.syncengine.exchange.sdata.SCRMEndpoint.sendToSyncTarget(SCRMEndpoint.java:199)
at com.sage.scrm.syncengine.exchange.engine.SynchronisationProcess.execute(SynchronisationProcess.java:169)
... 4 more
Caused by: com.sage.crm.httpconsumer.error.SageHttpConsumerException: POST on http://<server name>//sdata/crmj/crmExchange/-/tasks/$syncTarget?trackingId=ef770176-3db4-4aa7-acb1-d728399e66e6 failed: 500
at com.sage.crm.httpconsumer.HttpConsumer.doPostPut(HttpConsumer.java:981)
at com.sage.crm.httpconsumer.HttpConsumer.doPost(HttpConsumer.java:776)
at com.sage.crm.httpconsumer.HttpConsumer.doPost(HttpConsumer.java:748)
at com.sage.scrm.syncengine.exchange.sdata.SCRMEndpoint.sendToSyncTarget(SCRMEndpoint.java:191)
... 5 more
Thanks,