Hello,

Since our inception of Dynamics CRM over 2 years ago, users have not been
able to go offline. Now we are up to CRM 3.0 with Rollup1 and the DST patch.
I have narrowed the source down to the 'LeadBase' table having a field named
'Description' with a size of 7000. From another post which I cannot find
now, I read that fields in CRM cannot have a size greater than 4000. I have
found the table/field in our SQL 2005 DB, but am not very familiar with it.
Would anyone be able to inform me on how to adjust the 'Description' size
without losing or corrupting data (if this is what needs to be done)?

My boss will not let me update to CRM Rollup2 until this issue is resolved.

I have just started working with this company and the offline problem with
CRM is one of my first issues to tackle. When CRM was first deployed back in
2003/2004, data from ACT was imported and I believe this caused the problem.

Any information will be greatly appreciated.

Thanks in advance - Dan

Here is the error I get when trying to synchronize:

Failed move data for entity 'Lead' during action saInsert, countRows=51.
Contact your system administrator for assistance and try going offline again.

One more thing - We are NOT using SQL Server 2005 on this server. We have
SQL Server 2000 on the CRM server.

I'm making headway! I found this link:
http://www.microsoft.com/dynamics/cr...tsettings.mspx, which
explains how to set the Text In Row size on a database table.

****************
I still need to know if data will be lost or corrupt if I size down the real
LeadBase table column from 7000 to 4000 (CRM 3.0's limit - from what I've
read). I am sure I should probably backup the database prior to as well.
****************

I created a table called LeadBaseTEST in the CRM database; created a primary
key (uniqueidentifier - 16) and a Description column (ntext - 16). After I
created this, I followed the steps in the link above to change the
'Description' column to Text-in-Row with a size of 2000.

This change was successful, but I still need to know the effects of sizing
down a live column in the LeadBase table from 7000 to 4000.

OK.

I found that the attributes for "Description of Lead" states that there is a
Maximum Length of 2,000.
On the SQL 2000 Database, this column is set with a size of 7000.

PLEASE ANSWER THIS:

Can I change the size value in the SQL Database from 7000 to 2000 without
losing or corrupting any data??? Someone please answer me!!!

Any simple suggestions??? Someone please give me something...

Hi Dan,

If you are interested we can resolve the issues. Please contact me offline.

Regards,
Manick
manick.m@hotmail.com

"DynamicDan" wrote:

Hi,

I am having the exact same problem but with the Opportunity entity and
countRows=6

Did you ever find an answer? any help is greatly appricated!

"DynamicDan" wrote:

Apart from the 2 CRM patches kb 918108 and kb 923327 and also reducing the
value of the key
"HKEY_CURRENT_USER\Software\Microsoft\MSCRMClient\ OfflineRowsBatchSize" to
something like 100. If those still don't work, check the size of the Database
- SQL 2005 Express (comes with the V3C version) has a size limit of 4 GB and
the MSDE SQL 2000 (comes with the V 3.0 client) has a DB size limit of 2 GB.
(see:
http://www.microsoft.com/technet/pro...qlexpress.mspx ).
This can and has caused the saInsert error for us. I hope this helps someone.

"chrisbelfast" wrote: