Hi,
When I use the test data transfer tool in the production environments of several customers to export the data, I receive 18 errors on different tables.
The message we receive in the DPlog.xml is this:
"System.Data.SqlClient.SqlException (0x80131904): Cannot resolve the collation conflict between ""SQL_Latin1_General_CP1_CI_AS"" and ""Latin1_General_CI_AS"" in the UNION operation. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.Dynamics.AX.Dataport.Extensions.ExecuteScalar[T](IDbConnection connection, String commandText, Object[] arguments) in d:\bt\104740\Source\DataPort\Dataport\Library\Extensions.cs:line 126 at Microsoft.Dynamics.AX.Dataport.SqlHelper.GetFieldById(IDbConnection connection, Int64 fieldId, Int64 tableId) in d:\bt\104740\Source\DataPort\Dataport\Library\SqlHelper.cs:line 1281 at Microsoft.Dynamics.AX.Dataport.DataportQueue.GetReferencedFieldsElement(IEnumerable`1 ids, IDbConnection connection, SqlTableName tableName) in d:\bt\104740\Source\DataPort\Dataport\Model\DataportQueue.cs:line 476 at Microsoft.Dynamics.AX.Dataport.DataportQueue.WriteTableMetadata(IDbConnection connection, SqlTableName table, String folder) in d:\bt\104740\Source\DataPort\Dataport\Model\DataportQueue.cs:line 386 at Microsoft.Dynamics.AX.Dataport.DataportQueue.<>c__DisplayClass8.<>c__DisplayClassc.<ProcessItem>b__7() in d:\bt\104740\Source\DataPort\Dataport\Model\DataportQueue.cs:line 240 at Microsoft.Dynamics.AX.Dataport.Functional.<>c__DisplayClass1.<Retry>b__0() in d:\bt\104740\Source\DataPort\Dataport\Library\Functional.cs:line 28 at Microsoft.Dynamics.AX.Dataport.DataportQueue.<>c__DisplayClass8.<ProcessItem>b__6(Object state) in d:\bt\104740\Source\DataPort\Dataport\Model\DataportQueue.cs:line 260 ClientConnectionId:a1205d53-99d2-4ce2-901c-4e3560adfbd5"
The database has as collation Latin1_General_CI_AS.
Does anyone have a clue why the export direction gives this error?
One of the 18 tables is DirPartyTable, so the export/import utility is useless at this moment.
Thank you!
Philippe
