CRM 4.0 Client can't go offline

Discussion:

(too old to reply)

Sergio

2008-10-20 09:47:00 UTC

We have this problem long time ago and we are desperate.

Problem description:
The CRM 4.0 can't go Offline, the error text is "A SQL Server error
occurred. Try this action again .If the problem
continues, check the Microsoft Dynamics CRM Community for solutions...".
Seems that the ticket ID between the Server and Client is lost. If we run
the Diagnostic Tool and fix the Synchronization, it work again but the next
day we have the same issue.

I have found this Hotfix
http://support.microsoft.com/?scid=kb%3Ben-us%3B951301&x=7&y=15.
Unfortunately it didn't work for me.

I don't know if is important but every night we load records in the crm
database with Scribe.

Server Info:
Windows 2003 Server R2 64 Bits

Cliente Info:
Windows XP 32 bits (Now i can't remember if is a Professional or Home version)

The text of the Diagnostic Tool Report is:
<DiagnosticCheck>

<Type>Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCheck</Type>
<Title>Comprobación de la suscripción de sincronización sin
conexión.</Title>
<Status>Fixed</Status>
<Details>Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheckException: Es
posible que la suscripción de sincronización sin conexión esté dañada. Para
corregir este problema, puede que Microsoft Dynamics CRM deba volver a
sincronizar algunas suscripciones. La nueva sincronización puede tardar mucho
tiempo en completarse. at
Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCheck.Execute(BackgroundWorker
backgroundWorker) at
Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheck.DeepExecute(BackgroundWorker backgroundWorker)</Details>
</DiagnosticCheck>
- <DiagnosticCheck>

<Type>Microsoft.Crm.Outlook.Diagnostics.OutlookRecordSynchingDiagnosticCheck</Type>
<Title>Comprobación de la sincronización reciente con Outlook.</Title>
<Status>Passed</Status>
</DiagnosticCheck>
</DiagnosticCheck>
- <DiagnosticCheck>

The spanish text say: "Is possible that the suscription of the
synchronization without conection is damaged. To fix this problem, is
possible that Microsoft Dynamics CRM need to synchronize again many
suscriptions. The new synchronization can take many time to finish"

Please help,
Thanks.

Sergio

2008-10-29 09:58:01 UTC

Permalink

More Info:

When I fix the problem (using: Diagnostic Tool or Crm Assistant or simply
reassigning to the user his own role again) it works fine until end of the
day. But the next day appear again the same problem.
I have see that every day, the server make the MSCRMKeyArchiveManager, could
be that this services crash my server-users relationship?

Thanks

Post by Sergio
We have this problem long time ago and we are desperate.
The CRM 4.0 can't go Offline, the error text is "A SQL Server error
occurred. Try this action again .If the problem
continues, check the Microsoft Dynamics CRM Community for solutions...".
Seems that the ticket ID between the Server and Client is lost. If we run
the Diagnostic Tool and fix the Synchronization, it work again but the next
day we have the same issue.
I have found this Hotfix
http://support.microsoft.com/?scid=kb%3Ben-us%3B951301&x=7&y=15.
Unfortunately it didn't work for me.
I don't know if is important but every night we load records in the crm
database with Scribe.
Windows 2003 Server R2 64 Bits
Windows XP 32 bits (Now i can't remember if is a Professional or Home version)
<DiagnosticCheck>
<Type>Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCheck</Type>
<Title>Comprobación de la suscripción de sincronización sin
conexión.</Title>
<Status>Fixed</Status>
<Details>Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheckException: Es
posible que la suscripción de sincronización sin conexión esté dañada. Para
corregir este problema, puede que Microsoft Dynamics CRM deba volver a
sincronizar algunas suscripciones. La nueva sincronización puede tardar mucho
tiempo en completarse. at
Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCheck.Execute(BackgroundWorker
backgroundWorker) at
Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheck.DeepExecute(BackgroundWorker backgroundWorker)</Details>
</DiagnosticCheck>
- <DiagnosticCheck>
<Type>Microsoft.Crm.Outlook.Diagnostics.OutlookRecordSynchingDiagnosticCheck</Type>
<Title>Comprobación de la sincronización reciente con Outlook.</Title>
<Status>Passed</Status>
</DiagnosticCheck>
</DiagnosticCheck>
- <DiagnosticCheck>
The spanish text say: "Is possible that the suscription of the
synchronization without conection is damaged. To fix this problem, is
possible that Microsoft Dynamics CRM need to synchronize again many
suscriptions. The new synchronization can take many time to finish"
Please help,
Thanks.

Sergio

2008-10-29 10:09:01 UTC

Permalink

Event on the CRM Client:

MSCRMOfflineSync
Event Id: 6000

An error occurred during Offline Synchronization. Try going offline again,
or restart Microsoft Outlook. SoapException happened Server was unable to
process request..
Detail <error>
<code>0x80044150</code>
<description>Generic SQL error.</description>
<type>Platform</type>
</error>
Stack Trace Info:
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at Microsoft.Crm.SdkTypeProxy.CrmService.Execute(Request Request)
at
Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.DoPrepareSync(Int32
callPriority)
at
Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.Sync(ITransferDataProvider transferDataProvider, Int32 callPriority)
at Microsoft.Crm.Application.SMWrappers.OfflineSync.SyncThreadMethod() .

Sergio

2008-11-11 13:32:02 UTC

Permalink

We reinstalled the CRM on the server and it works for few days. But now,
again the same problem, the clients cant disconnect from server and get the
error of the first post (SQL Server error...)

The error starts at 00:00 each day and is solved changing the role of the
user (until the next day). We have contacted with Microsoft and they dont
know how to fix it yet. Is a really annoying issue because is in production
on our customer environment.

The server give some ASP.NET warnings and other errors like
MSCRMAsyncService. In all of them, the common point is that it says that the
user NT AUTHORITY\Network service cannot initialize session in SQL.

Anyone knows what can we try?

A temporal solution could to automatically change the role each day at 03:00
A.M for example but when I tried it in the SQL user/rol database table, the
problem was not solved so I deduce that when you change the role in CRM
interface, internally it is changing more that one table. Anyone knows
anything about that?

Thank you all.

Bye.

Post by Sergio
MSCRMOfflineSync
Event Id: 6000
An error occurred during Offline Synchronization. Try going offline again,
or restart Microsoft Outlook. SoapException happened Server was unable to
process request..
Detail <error>
<code>0x80044150</code>
<description>Generic SQL error.</description>
<type>Platform</type>
</error>
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at Microsoft.Crm.SdkTypeProxy.CrmService.Execute(Request Request)
at
Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.DoPrepareSync(Int32
callPriority)
at
Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.Sync(ITransferDataProvider transferDataProvider, Int32 callPriority)
at Microsoft.Crm.Application.SMWrappers.OfflineSync.SyncThreadMethod() .

Satish

2008-11-26 13:34:30 UTC

Permalink

Please try with this solution
1. This error can appear when your CRM and SQL installation are not
English
2. You must change the default language in SQL Server to the login
used to access to CRM AppPool (in my case was NT AUTHORITY / Network
Service) to English.
3. It have no consecuencies in the CRM application.
4. Is not neccesary reset the server.

Regards
Satish

Post by Sergio
We reinstalled the CRM on the server and it works for few days. But now,
again the same problem, the clients cant disconnect from server and get the
error of the first post (SQL Server error...)
The error starts at 00:00 each day and is solved changing the role of the
user (until the next day). We have contacted with Microsoft and they dont
know how to fix it yet. Is a really annoying issue because is in production
on our customer environment.
The server give some ASP.NET warnings and other errors like
MSCRMAsyncService. In all of them, the common point is that it says that the
user NT AUTHORITY\Network service cannot initialize session in SQL.
Anyone knows what can we try?
A temporal solution could to automatically change the role each day at 03:00
A.M for example but when I tried it in the SQL user/rol database table, the
problem was not solved so I deduce that when you change the role in CRM
interface, internally it is changing more that one table. Anyone knows
anything about that?
Thank you all.
Bye.

Post by Sergio
MSCRMOfflineSync
Event Id: 6000
An error occurred during Offline Synchronization. Try going offline again,
or restart Microsoft Outlook. SoapException happened Server was unable to
process request..
Detail <error>
<code>0x80044150</code>
<description>Generic SQL error.</description>
<type>Platform</type>
</error>
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClien tMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at Microsoft.Crm.SdkTypeProxy.CrmService.Execute(Request Request)
at
Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.DoPrepareSync(Int32
callPriority)
at
Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.Sync(ITransferDataPr ovider transferDataProvider, Int32 callPriority)
at Microsoft.Crm.Application.SMWrappers.OfflineSync.SyncThreadMethod() .

Post by Sergio
We have this problem long time ago and we are desperate.
The CRM 4.0 can't go Offline, the error text is "A SQL Server error
occurred. Try this action again .If the problem
continues, check the Microsoft Dynamics CRM Community for solutions...".
Seems that the ticket ID between the Server and Client is lost. If we run
the Diagnostic Tool and fix the Synchronization, it work again but the next
day we have the same issue.
I have found this Hotfix
http://support.microsoft.com/?scid=kb%3Ben-us%3B951301&x=7&y=15.
Unfortunately it didn't work for me.
I don't know if is important but every night we load records in the crm
database with Scribe.
Windows 2003 Server R2 64 Bits
Windows XP 32 bits (Now i can't remember if is a Professional or Home version)
<DiagnosticCheck>
<Type>Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCh eck</Type>
<Title>Comprobación de la suscripción de sincronización sin
conexión.</Title>
<Status>Fixed</Status>
<Details>Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheckException: Es
posible que la suscripción de sincronización sin conexión esté dañada. Para
corregir este problema, puede que Microsoft Dynamics CRM deba volver a
sincronizar algunas suscripciones. La nueva sincronización puede tardar mucho
tiempo en completarse. at
Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCheck.Ex ecute(BackgroundWorker
backgroundWorker) at
Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheck.DeepExecute(BackgroundWor ker backgroundWorker)</Details>
</DiagnosticCheck>
- <DiagnosticCheck>
<Type>Microsoft.Crm.Outlook.Diagnostics.OutlookRecordSynchingDiagnosticChec k</Type>
<Title>Comprobación de la sincronización reciente con Outlook.</Title>
<Status>Passed</Status>
</DiagnosticCheck>
</DiagnosticCheck>
- <DiagnosticCheck>
The spanish text say: "Is possible that the suscription of the
synchronization without conection is damaged. To fix this problem, is
possible that Microsoft Dynamics CRM need to synchronize again many
suscriptions. The new synchronization can take many time to finish"
Please help,
Thanks.

Sergio

2008-11-26 13:53:01 UTC

Permalink

Yes, finally I solved it with Microsoft collaboration. The solution was the
same that you have say.
Sorry I forgot to publish the solution here.

Thank you.

Post by Sergio
MSCRMOfflineSync
Event Id: 6000
An error occurred during Offline Synchronization. Try going offline again,
or restart Microsoft Outlook. SoapException happened Server was unable to
process request..
Detail <error>
<code>0x80044150</code>
<description>Generic SQL error.</description>
<type>Platform</type>
</error>
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClien tMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at Microsoft.Crm.SdkTypeProxy.CrmService.Execute(Request Request)
at
Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.DoPrepareSync(Int32
callPriority)
at
Microsoft.Crm.Application.Outlook.OfflineSync.SyncData.Sync(ITransferDataPr ovider transferDataProvider, Int32 callPriority)
at Microsoft.Crm.Application.SMWrappers.OfflineSync.SyncThreadMethod() .

Post by Sergio
We have this problem long time ago and we are desperate.
The CRM 4.0 can't go Offline, the error text is "A SQL Server error
occurred. Try this action again .If the problem
continues, check the Microsoft Dynamics CRM Community for solutions....".
Seems that the ticket ID between the Server and Client is lost. If we run
the Diagnostic Tool and fix the Synchronization, it work again but the next
day we have the same issue.
I have found this Hotfix
http://support.microsoft.com/?scid=kb%3Ben-us%3B951301&x=7&y=15.
Unfortunately it didn't work for me.
I don't know if is important but every night we load records in the crm
database with Scribe.
Windows 2003 Server R2 64 Bits
Windows XP 32 bits (Now i can't remember if is a Professional or Home version)
<DiagnosticCheck>
<Type>Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCh eck</Type>
<Title>Comprobación de la suscripción de sincronización sin
conexión.</Title>
<Status>Fixed</Status>
<Details>Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheckException: Es
posible que la suscripción de sincronización sin conexión esté dañada. Para
corregir este problema, puede que Microsoft Dynamics CRM deba volver a
sincronizar algunas suscripciones. La nueva sincronización puede tardar mucho
tiempo en completarse. at
Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCheck.Ex ecute(BackgroundWorker
backgroundWorker) at
Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheck.DeepExecute(BackgroundWor ker backgroundWorker)</Details>
</DiagnosticCheck>
- <DiagnosticCheck>
<Type>Microsoft.Crm.Outlook.Diagnostics.OutlookRecordSynchingDiagnosticChec k</Type>
<Title>Comprobación de la sincronización reciente con Outlook..</Title>
<Status>Passed</Status>
</DiagnosticCheck>
</DiagnosticCheck>
- <DiagnosticCheck>
The spanish text say: "Is possible that the suscription of the
synchronization without conection is damaged. To fix this problem, is
possible that Microsoft Dynamics CRM need to synchronize again many
suscriptions. The new synchronization can take many time to finish"
Please help,
Thanks.

gilberto girini

2010-10-06 16:11:29 UTC

Permalink

Can you show the solution ?
Thank you
Best regard.

Post by Sergio
We have this problem long time ago and we are desperate.
The CRM 4.0 can't go Offline, the error text is "A SQL Server error
occurred. Try this action again .If the problem
continues, check the Microsoft Dynamics CRM Community for solutions...".
Seems that the ticket ID between the Server and Client is lost. If we run
the Diagnostic Tool and fix the Synchronization, it work again but the next
day we have the same issue.
I have found this Hotfix
http://support.microsoft.com/?scid=kb%3Ben-us%3B951301&x=7&y=15.
Unfortunately it didn't work for me.
I don't know if is important but every night we load records in the crm
database with Scribe.
Windows 2003 Server R2 64 Bits
Windows XP 32 bits (Now i can't remember if is a Professional or Home version)
<DiagnosticCheck>
<Type>Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCheck</Type>
<Title>Comprobaci??n de la suscripci??n de sincronizaci??n sin
conexi??n.</Title>
<Status>Fixed</Status>
<Details>Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheckException: Es
posible que la suscripci??n de sincronizaci??n sin conexi??n est?? da??ada. Para
corregir este problema, puede que Microsoft Dynamics CRM deba volver a
sincronizar algunas suscripciones. La nueva sincronizaci??n puede tardar mucho
tiempo en completarse. at
Microsoft.Crm.Outlook.Diagnostics.OfflineSyncSubscriptionDiagnosticCheck.Execute(BackgroundWorker
backgroundWorker) at
Microsoft.Crm.Outlook.Diagnostics.DiagnosticCheck.DeepExecute(BackgroundWorker backgroundWorker)</Details>
</DiagnosticCheck>
- <DiagnosticCheck>
<Type>Microsoft.Crm.Outlook.Diagnostics.OutlookRecordSynchingDiagnosticCheck</Type>
<Title>Comprobaci??n de la sincronizaci??n reciente con Outlook.</Title>
<Status>Passed</Status>
</DiagnosticCheck>
</DiagnosticCheck>
- <DiagnosticCheck>
The spanish text say: "Is possible that the suscription of the
synchronization without conection is damaged. To fix this problem, is
possible that Microsoft Dynamics CRM need to synchronize again many
suscriptions. The new synchronization can take many time to finish"
Please help,
Thanks.

Post by Sergio
When I fix the problem (using: Diagnostic Tool or Crm Assistant or simply
reassigning to the user his own role again) it works fine until end of the
day. But the next day appear again the same problem.
I have see that every day, the server make the MSCRMKeyArchiveManager, could
be that this services crash my server-users relationship?
Thanks

Post by Sergio
Yes, finally I solved it with Microsoft collaboration. The solution was the
same that you have say.
Sorry I forgot to publish the solution here.
Thank you.

Post by Satish
Please try with this solution
1. This error can appear when your CRM and SQL installation are not
English
2. You must change the default language in SQL Server to the login
used to access to CRM AppPool (in my case was NT AUTHORITY / Network
Service) to English.
3. It have no consecuencies in the CRM application.
4. Is not neccesary reset the server.
Regards
Satish
he
on
the
he
again,
to
lien tMessage message, WebResponse response, Stream responseStream, Boolean=
asyncCall)
tring
)
t32
taPr ovider transferDataProvider, Int32 callPriority)
thod() .
.".
run
e next
rm
version)
sticCh eck</Type>
on: Es
=E9 da=F1ada. Para
a
rdar mucho
eck.Ex ecute(BackgroundWorker
undWor ker backgroundWorker)</Details>
icChec k</Type>
.</Title>
Submitted via EggHeadCafe - Software Developer Portal of Choice
JustCode Visual Studio Development Add-In by Telerik
http://www.eggheadcafe.com/tutorials/aspnet/d174b33a-d86e-48e7-b381-fcd1938b6775/justcode-visual-studio-development-addin-by-telerik.aspx