I am getting an unexpected error, trying to migrate Business Contact Manger
to CRM 3.0. Here is the log. Can anyone help?
8/24/2007 9:56:11 AM------>Transitioning to next screen. From: Welcome
screen. To: PreconditionCheck screen.
8/24/2007 9:56:11 AM------>Connecting to Microsoft CRM
Arteco_Vision_Systems_MSCRM
8/24/2007 9:56:11 AM------>Checking that Microsoft CRM Data Migration Pack
is installed: Success
8/24/2007 9:56:11 AM------>Establishing connection to CDF database: Success
8/24/2007 9:56:11 AM------>Checking existence of EntityIdMap table in CDF
database: Success
8/24/2007 9:56:14 AM------>Getting Microsoft CRM business unit: Success
8/24/2007 9:56:14 AM------>Checking administrative privileges. Success.
8/24/2007 9:56:15 AM------>Checking Microsoft CRM user rights.
8/24/2007 9:56:16 AM------>Checking prerequisites: Success
8/24/2007 9:56:16 AM------>Transitioning to next screen. From:
PreconditionCheck screen. To: BCMSourceSelection screen.
8/24/2007 9:56:37 AM------>Verifying Outlook with Business Contact Manager
source: Success
8/24/2007 9:56:37 AM------>Transitioning to next screen. From:
BCMSourceSelection screen. To: UserMapping screen.
8/24/2007 9:56:37 AM------>Loading users from Microsoft CRM
8/24/2007 9:56:49 AM------>Transitioning to next screen. From: UserMapping
screen. To: TerritoryMapping screen.
8/24/2007 9:56:49 AM------>Loading territories from Microsoft CRM
8/24/2007 9:56:53 AM------>Transitioning to next screen. From:
TerritoryMapping screen. To: ConfigurationSummary screen.
8/24/2007 9:56:53 AM------>Selected mapping for users and territories
8/24/2007 9:56:53 AM------>The following territories will be mapped to
Microsoft CRM territories:
8/24/2007 9:56:53 AM------>* North to North
8/24/2007 9:56:53 AM------>* Southwest to Southwest
8/24/2007 9:56:53 AM------>* Northeast to East Coast
8/24/2007 9:56:53 AM------>* Southeast to East Coast
8/24/2007 9:56:53 AM------>* Northwest to Northwest
8/24/2007 9:56:53 AM------>* South to South
8/24/2007 9:56:53 AM------>* West to West
8/24/2007 9:56:53 AM------>* East to East Coast
8/24/2007 9:57:01 AM------>Transitioning to next screen. From:
ConfigurationSummary screen. To: ConfigureCRM screen.
8/24/2007 9:57:01 AM------>Initializing CDF database...
8/24/2007 9:57:09 AM------>Resolving Outlook with Business Contact Manager
configuration IDs to Microsoft CRM
8/24/2007 9:57:09 AM------>Reading transactional data...
8/24/2007 9:57:20 AM------>Reading data from Outlook with Business Contact
Manager entity: Account
8/24/2007 10:00:49 AM------>Reading data from Outlook with Business Contact
Manager entity: Contact
8/24/2007 10:00:49 AM------>Reading data from Outlook with Business Contact
Manager entity: Opportunity
8/24/2007 10:00:49 AM------>Reading data from Outlook with Business Contact
Manager entity: ActivityTask
8/24/2007 10:00:49 AM------>Reading data from Outlook with Business Contact
Manager entity: OpportunityProduct
8/24/2007 10:00:49 AM------>Reading data from Outlook with Business Contact
Manager entity: BusinessNote
8/24/2007 10:00:49 AM------>Reading data from Outlook with Business Contact
Manager entity: Document
8/24/2007 10:00:49 AM------>Reading data from Outlook with Business Contact
Manager entity: ActivityPhone
8/24/2007 10:00:49 AM------>System.Data.SqlClient.SqlException: Invalid
length parameter passed to the SUBSTRING function.
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.Common.DbDataAdapter.FillLoadDataRowChunk(SchemaMapping
mapping, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillFromReader(Object data, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords,
DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable)
at
Microsoft.Crm.Tools.BCMMigration.Components.BCMReader.ExecuteQuery(Request
objectRequest)
8/24/2007 10:00:49 AM------>Application Terminated: Unable to read data from
Outlook with Business Contact Manager.