Hello,
We have Ms SQL Server 2005 serving our Ms CRM 3.0.
When we try to install/sync Offline Client, we sometimes get error:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
saInsert failed for entity 'entity_name', batchRows=1 with exception
System.Data.SqlClient.SqlException: Could not find row in sysindexes for
database ID 2, object ID 553769030, index ID 255. Run DBCC CHECKTABLE on
sysindexes.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I have investigated the problem with CrmTrace and have found that
{guid}.bcp file, produced by our server and delivered by sync process to
the client's folder, can not be inserted into MSDE.
Here the sql statements, that should be executed by sync process (taken
from CrmTrace log):
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
create table #tempNew_AlertBase (CreatedBy uniqueidentifier, CreatedOn
datetime, DeletionStateCode int, ModifiedBy uniqueidentifier, ModifiedOn
datetime, New_AlertId uniqueidentifier NOT NULL, OwningBusinessUnit
uniqueidentifier, StateCode int NOT NULL, StatusCode int, VersionNumber
timestamp, OwningUser uniqueidentifier)
BULK INSERT #tempNew_AlertBase FROM 'C:\Documents and
Settings\username\Application
Data\Microsoft\MSCRM\BCP\{76172936-6288-DC11-9E8A-001708576EFC}.bcp'
WITH (DATAFILETYPE = 'native', FORMATFILE = 'C:\Documents and
Settings\username\Application
Data\Microsoft\MSCRM\BCP\FMT\New_AlertBase.fmt')
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
These statements fails with error "Could not find row in sysindexes for
database ID 2, object ID 553769030, index ID 255. Run DBCC CHECKTABLE on
sysindexes."
But these statements has been executed well on another SQL 2005 server.
Is there any chance to run offline client against Ms SQL 2005 server?
Thanks,
Alex.