Data Migration Wizard für Microsoft Outlook with Business Contact

23/08/2007 - 19:22 von R. Neumann | Report spam
Habe ein Problem mit der Datenmigration von Business Contact Manager 2.0 auf
Dynamics CRM 3.0 , und zwar bricht der Migration Wizard mit einem
unerwarteten Fehler ab.
Im LOG-FILE (am Ende eingefügt) fand sich ein Hinweis das es sich auf den
import der Activities bezieht.

Wenn ich die Activities vor dem Import manuell aus der Datenbak lösche, dann
làuft der Wizard durch und alle Kontakte sind ordnungsgemàß ins CRM migriert,
aber dass reicht mir nicht. Ohne die Activities ist ein CRM System irgendwie
sinnlos.
Der Server ist ein SBS Premium Edition mit SQL 2005 und den aktuellen
Updates, SP´s und Rollup`s.

Ich denke ich bin nicht der einzige mit diesem Problem, da ich in diversen
Foren meine Fehlermeldung entdeckt habe nur leider nie eine Lösung dafür.

LOG-FILE:
(* sind von mir)

16.08.2007 17:59:02>Transitioning to next screen. From: Welcome
screen. To: PreconditionCheck screen.
16.08.2007 17:59:02>Connecting to Microsoft CRM
*****_Industrievertretungen_MSCRM
16.08.2007 17:59:02>Checking that Microsoft CRM Data Migration Pack is
installed: Success
16.08.2007 17:59:02>Establishing connection to CDF database: Success
16.08.2007 17:59:02>Checking existence of EntityIdMap table in CDF
database: Success
16.08.2007 17:59:05>Getting Microsoft CRM business unit: Success
16.08.2007 17:59:05>Checking administrative privileges. Success.
16.08.2007 17:59:06>Checking Microsoft CRM user rights.
16.08.2007 17:59:07>Checking prerequisites: Success
16.08.2007 17:59:07>Transitioning to next screen. From:
PreconditionCheck screen. To: BCMSourceSelection screen.
16.08.2007 17:59:30>Verifying Outlook with Business Contact Manager
source: Success
16.08.2007 17:59:30>Transitioning to next screen. From:
BCMSourceSelection screen. To: UserMapping screen.
16.08.2007 17:59:30>Loading users from Microsoft CRM
16.08.2007 18:04:29>User: acdc with logon acdc is not a valid user in
Active Directory
16.08.2007 18:04:29>User: Besucher with logon Besucher is not a valid
user in Active Directory
16.08.2007 18:04:29>User: Hinz with logon Hinz is not a valid user in
Active Directory
16.08.2007 18:04:30>User: Jekel with logon Jekel is not a valid user
in Active Directory
16.08.2007 18:04:30>User: koenig with logon koenig is not a valid user
in Active Directory
16.08.2007 18:04:30>User: König with logon König is not a valid user
in Active Directory
16.08.2007 18:04:30>User: Ramones with logon Ramones is not a valid
user in Active Directory
16.08.2007 18:04:30>User: Stockburger with logon Stockburger is not a
valid user in Active Directory
16.08.2007 18:04:30>User: temp with logon temp is not a valid user in
Active Directory
16.08.2007 18:04:30>Transitioning to next screen. From: UserMapping
screen. To: UserMappingWarning screen.
16.08.2007 18:04:45>Transitioning to previous screen. From:
UserMappingWarning screen. To: UserMapping screen.
16.08.2007 18:04:45>Loading users from Microsoft CRM
16.08.2007 18:05:30>Transitioning to next screen. From: UserMapping
screen. To: TerritoryMapping screen.
16.08.2007 18:05:30>Loading territories from Microsoft CRM
16.08.2007 18:05:30>No territories were found in Microsoft CRM.
16.08.2007 18:05:44>Transitioning to next screen. From:
TerritoryMapping screen. To: ConfigurationSummary screen.
16.08.2007 18:05:44>Selected mapping for users and territories
16.08.2007 18:05:44>The following users will be mapped to existing
Microsoft CRM users:
16.08.2007 18:05:44>* acdc = *****\MaxM
16.08.2007 18:05:44>* temp = *****\MaxM
16.08.2007 18:05:44>* koenig = *****\MaxM
16.08.2007 18:05:44>* Besucher = *****\MaxM
16.08.2007 18:05:44>* König = *****\MaxM
16.08.2007 18:05:44>* Ramones = *****\MaxM
16.08.2007 18:05:44>* Jekel = *****\MaxM
16.08.2007 18:05:44>* Hinz = *****\MaxM
16.08.2007 18:05:44>* Stockburger = *****\MaxM
16.08.2007 18:05:44>* Administrator = *****\Administrator
16.08.2007 18:05:44>The following territories will be mapped to
Microsoft CRM territories:
16.08.2007 18:05:44>* Nordosten to <Create New>
16.08.2007 18:05:44>* Osten to <Create New>
16.08.2007 18:05:44>* Nordwesten to <Create New>
16.08.2007 18:05:44>* Süden to <Create New>
16.08.2007 18:05:44>* Westen to <Create New>
16.08.2007 18:05:44>* Südwesten to <Create New>
16.08.2007 18:05:44>* Norden to <Create New>
16.08.2007 18:05:44>* Südosten to <Create New>
16.08.2007 18:05:48>Transitioning to next screen. From:
ConfigurationSummary screen. To: ConfigureCRM screen.
16.08.2007 18:05:48>Creating territory in Microsoft CRM: Success: Norden
16.08.2007 18:05:48>Creating territory in Microsoft CRM: Success: Süden
16.08.2007 18:05:48>Creating territory in Microsoft CRM: Success: Osten
16.08.2007 18:05:48>Creating territory in Microsoft CRM: Success: Westen
16.08.2007 18:05:48>Creating territory in Microsoft CRM: Success:
Nordosten
16.08.2007 18:05:48>Creating territory in Microsoft CRM: Success:
Nordwesten
16.08.2007 18:05:48>Creating territory in Microsoft CRM: Success:
Südosten
16.08.2007 18:05:48>Creating territory in Microsoft CRM: Success:
Südwesten
16.08.2007 18:05:50>Creating drop-down list (picklist) value in
Microsoft CRM: Success ownershipcode
16.08.2007 18:05:55>Creating drop-down list (picklist) value in
Microsoft CRM: Success preferredcontactmethodcode
16.08.2007 18:05:57>Initializing CDF database...
16.08.2007 18:06:01>Resolving Outlook with Business Contact Manager
configuration IDs to Microsoft CRM
16.08.2007 18:06:01>Reading transactional data...
16.08.2007 18:09:19>Reading data from Outlook with Business Contact
Manager entity: Account
16.08.2007 18:19:36>Reading data from Outlook with Business Contact
Manager entity: Contact
16.08.2007 18:19:36>Reading data from Outlook with Business Contact
Manager entity: Opportunity
16.08.2007 18:19:37>Reading data from Outlook with Business Contact
Manager entity: ActivityTask
16.08.2007 18:19:37>Reading data from Outlook with Business Contact
Manager entity: OpportunityProduct
16.08.2007 18:19:38>Reading data from Outlook with Business Contact
Manager entity: BusinessNote
16.08.2007 18:19:38>Reading data from Outlook with Business Contact
Manager entity: Document
16.08.2007 18:19:38>Reading data from Outlook with Business Contact
Manager entity: ActivityPhone
16.08.2007 18:19:38>System.Data.SqlClient.SqlException: Es wurde ein
ungültiger Làngenparameter an die SUBSTRING-Funktion übergeben.
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)
16.08.2007 18:19:38>Application Terminated: Unable to read data from
Outlook with Business Contact Manager.


MFG R. Neumann
 

Lesen sie die antworten

#1 Tobias Redelberger \(MVP - SBS\)
24/08/2007 - 11:11 | Warnen spam
Hi "Mr. Neumann",

nur mal so aus der Hüfte:

16.08.2007 18:19:38>Reading data from Outlook with Business Contact
Manager entity: ActivityPhone
16.08.2007 18:19:38>System.Data.SqlClient.SqlException: Es wurde ein
ungültiger Làngenparameter an die SUBSTRING-Funktion übergeben.



Kann es sich um ein falsch eingegebenes (bzw. zu langes) Format bei den
Telephonnummern im Business Contact Manager handeln?

Möglicher Fehler (hier: "/"):

09722 / 4835

Besser:

+49 (9722) 4835


S.a.: Kanonisches Adressformat für Telefonnummern
http://www.microsoft.com/technet/pr...x?mfr=true


Tobias Redelberger
StarNET Services (HomeOffice)
Schoenbornstr. 57
D-97440 Werneck
Tel: +49 (9722) 4835
Mobil: +49 (179) 25 98 341
Email:

Ähnliche fragen