Slam doesn't synchronize data of different lists with the same name in different tables


My system has two identical sites with three identical lists in each.
I configured one site, and everything was ok. now i am configuring the other site, and i am using TableName to have different tables for the lists in different sites.
Now when i hit synchronize it shows me an error. I don't know where does SLAM found this Column Name "AktivitetetMOFListItemID"
atached i am sending my config file
Data Synchronization Processing: Aktivitetet
8/20/2010 2:40:58 PM Exception System.Data.SqlClient.SqlException: Invalid column name 'AktivitetetMOFListItemID'. Invalid column name 'AktivitetetMOFListItemID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) at System.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo methodInfo, Object[] parameters) at System.Data.Linq.DataContext.ExecuteCommand(String command, Object[] parameters) at AWS.SLAM.Data.SqlDataRepository.AddAssociationTableSynchronizationObjects(String tableSchema, String tableName, String firstTypeName, String secondTypeName) at AWS.SLAM.Activation.SqlDataSynchronizeTypeProcessor.Process(String sharepointSiteLocation, IDictionary`2 parameters) at AWS.SLAM.Administration.Synchronization.DoSynchronization(SPSite site, String typeName, String typeId, String typeSiteCollection, String typeSite)

file attachments


norina wrote Aug 23, 2010 at 7:37 AM

I understood now Slam doesn't synchronize data of different lists with the same name in different tables. They all go in the same table.
Is it a bug or what?


wrote Aug 23, 2010 at 8:27 AM

wrote Feb 14, 2013 at 8:19 PM

ibertrand wrote Nov 7, 2013 at 6:01 PM

Any update to this? I am running into the same issue having multiple list with the same names on different list. When I check the configuration, it find unmatched columns that do not belong to the site it is listing.

Site: 1 --> List: Project Documents --> Column: DocumentNumber
Site: 2 --> List: Project Documents --> Column: DN

The configuration states the DocumentNumber is on Site 2 and unmatched.

brjenkins wrote Nov 7, 2013 at 8:21 PM

You should use the TableName attribute of the List node and set the name directly of the table to receive items of that list.