One List is not synching

Dec 29, 2011 at 7:13 PM

We are using SLAM 2.0 on SharePoint 2010.  I currently have a site that has two list that I need to perform the initial synch with.  Validation of the config file was successfull. I've activated SLAM successfully as shown below.  However, when I hit synch, only one table in the SQL database get's populated.  The other one does not.  No errors are shown in the diagnostics/messages.  I'm at a loss as to what to do next without errors displaying. The table that successfully synchs below is called the StrategicObjectives.  The table that fails to synch is called RNAProjects.   Any ideas?

 

LOG SHOWING ACTIVATION----------------------------------------------

12/29/2011 2:05:22 PM Information Activation Complete
12/29/2011 2:05:22 PM Information Update Table: begin if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListItemID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListItemID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListRelativeID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListRelativeID] [int] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'SoTitle') ALTER TABLE [SLAM].[StrategicObjectives] ADD [SoTitle] [varchar](255) not null; end
12/29/2011 2:05:22 PM Information Processing Strategic Objectives
12/29/2011 2:05:22 PM Information Update Table: begin if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListItemID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListItemID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListRelativeID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListRelativeID] [int] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ProjTitle') ALTER TABLE [SLAM].[RNAProjects] ADD [ProjTitle] [varchar](255) not null; end
12/29/2011 2:05:22 PM Information Processing RNA Projects
12/29/2011 2:05:22 PM Information Attached Event Handlers for List: AnnualBusinessPlanning - Strategic Objectives
12/29/2011 2:05:22 PM Information Attached Event Handlers for List: AnnualBusinessPlanning - RNA Projects
12/29/2011 2:05:22 PM Information Activation Initiated

-----------------------------------------------------------------------

LOG SHOWING SYNCH ----------------------------------------------

12/29/2011 2:08:24 PM Information Data Synchronization Complete
12/29/2011 2:08:24 PM Information Data Synchronization Cleanup: RNA Projects
12/29/2011 2:08:24 PM Information Number of items removed from RNAProjects: 0
12/29/2011 2:08:24 PM Information Update Table: begin if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListItemID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListItemID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListRelativeID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListRelativeID] [int] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ProjTitle') ALTER TABLE [SLAM].[RNAProjects] ADD [ProjTitle] [varchar](255) not null; end
12/29/2011 2:08:24 PM Information Processing RNA Projects
12/29/2011 2:08:24 PM Information Data Synchronization Cleanup: Strategic Objectives
12/29/2011 2:08:24 PM Information Number of items removed from StrategicObjectives: 0
12/29/2011 2:08:24 PM Information Update Table: begin if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListItemID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListItemID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListRelativeID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListRelativeID] [int] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'SoTitle') ALTER TABLE [SLAM].[StrategicObjectives] ADD [SoTitle] [varchar](255) not null; end
12/29/2011 2:08:24 PM Information Processing Strategic Objectives
12/29/2011 2:08:24 PM Information Data Synchronization Processing: Strategic Objectives
12/29/2011 2:08:24 PM Information Update LI Associations Complete - Strategic Objectives List: Strategic Objectives ListItem: People & Culture, 6f9ad222-55b7-49a5-b2d1-525225ebde94
12/29/2011 2:08:24 PM Information Update LI Associations - Strategic Objectives List: Strategic Objectives ListItem: People & Culture, 6f9ad222-55b7-49a5-b2d1-525225ebde94
12/29/2011 2:08:24 PM Information Update LI Complete - Strategic Objectives List: Strategic Objectives ListItem: People & Culture, 6f9ad222-55b7-49a5-b2d1-525225ebde94
12/29/2011 2:08:24 PM Information Update Item: update [SLAM].[StrategicObjectives] set [ListItemID] = '6f9ad222-55b7-49a5-b2d1-525225ebde94',[ListID] = '42058c91-2bb6-4b68-ae38-637c648bc962',[ListRelativeID] = 4,[SoTitle] = 'People & Culture' where ListItemID = '6f9ad222-55b7-49a5-b2d1-525225ebde94'
12/29/2011 2:08:24 PM Information Update Location: update [SLAM].[SiteCollection] set [ServerRelativeUrl] = '/seniorstaff' where [SiteCollectionID] = '22f17216-c147-4405-9b0c-1abb0d14fc21' if @@ROWCOUNT < 1 insert into [SLAM].[SiteCollection] select '22f17216-c147-4405-9b0c-1abb0d14fc21', '/seniorstaff' update [SLAM].[Site] set [Name] = 'AnnualBusinessPlanning', [Title] = 'Annual Business Planning', [Url] = '/AnnualBusinessPlanning', [SiteCollectionID] = '22f17216-c147-4405-9b0c-1abb0d14fc21' where [SiteID] = '534b0c17-5450-4759-89e7-b7f86c0ca00e' if @@ROWCOUNT < 1 insert into [SLAM].[Site] (SiteID, Name, Title, Url, SiteCollectionID) values ('534b0c17-5450-4759-89e7-b7f86c0ca00e', 'AnnualBusinessPlanning', 'Annual Business Planning', '/AnnualBusinessPlanning', '22f17216-c147-4405-9b0c-1abb0d14fc21') update [SLAM].[List] set [DefaultViewUrl] = '/Lists/Strategic Objectives/AllItems.aspx', [NewFormUrl] = '/Lists/Strategic Objectives/NewForm.aspx', [EditFormUrl] = '/Lists/Strategic Objectives/EditForm.aspx', [DisplayFormUrl] = '/Lists/Strategic Objectives/DispForm.aspx', [SiteID] = '534b0c17-5450-4759-89e7-b7f86c0ca00e' where [ListID] = '42058c91-2bb6-4b68-ae38-637c648bc962' if @@ROWCOUNT < 1 insert into [SLAM].[List] select '42058c91-2bb6-4b68-ae38-637c648bc962', '/Lists/Strategic Objectives/AllItems.aspx', '/Lists/Strategic Objectives/NewForm.aspx', '/Lists/Strategic Objectives/EditForm.aspx', '/Lists/Strategic Objectives/DispForm.aspx', '534b0c17-5450-4759-89e7-b7f86c0ca00e'
12/29/2011 2:08:24 PM Information Update LI Start - Strategic Objectives List: Strategic Objectives ListItem: People & Culture, 6f9ad222-55b7-49a5-b2d1-525225ebde94
12/29/2011 2:08:24 PM Information Update LI Associations Complete - Strategic Objectives List: Strategic Objectives ListItem: Efficiency/Expense Management, 80c12ddc-fce2-4924-b0d8-cf8f57875a75
12/29/2011 2:08:24 PM Information Update LI Associations - Strategic Objectives List: Strategic Objectives ListItem: Efficiency/Expense Management, 80c12ddc-fce2-4924-b0d8-cf8f57875a75
12/29/2011 2:08:24 PM Information Update LI Complete - Strategic Objectives List: Strategic Objectives ListItem: Efficiency/Expense Management, 80c12ddc-fce2-4924-b0d8-cf8f57875a75
12/29/2011 2:08:24 PM Information Update Item: update [SLAM].[StrategicObjectives] set [ListItemID] = '80c12ddc-fce2-4924-b0d8-cf8f57875a75',[ListID] = '42058c91-2bb6-4b68-ae38-637c648bc962',[ListRelativeID] = 3,[SoTitle] = 'Efficiency/Expense Management' where ListItemID = '80c12ddc-fce2-4924-b0d8-cf8f57875a75'
12/29/2011 2:08:24 PM Information Update Location: update [SLAM].[SiteCollection] set [ServerRelativeUrl] = '/seniorstaff' where [SiteCollectionID] = '22f17216-c147-4405-9b0c-1abb0d14fc21' if @@ROWCOUNT < 1 insert into [SLAM].[SiteCollection] select '22f17216-c147-4405-9b0c-1abb0d14fc21', '/seniorstaff' update [SLAM].[Site] set [Name] = 'AnnualBusinessPlanning', [Title] = 'Annual Business Planning', [Url] = '/AnnualBusinessPlanning', [SiteCollectionID] = '22f17216-c147-4405-9b0c-1abb0d14fc21' where [SiteID] = '534b0c17-5450-4759-89e7-b7f86c0ca00e' if @@ROWCOUNT < 1 insert into [SLAM].[Site] (SiteID, Name, Title, Url, SiteCollectionID) values ('534b0c17-5450-4759-89e7-b7f86c0ca00e', 'AnnualBusinessPlanning', 'Annual Business Planning', '/AnnualBusinessPlanning', '22f17216-c147-4405-9b0c-1abb0d14fc21') update [SLAM].[List] set [DefaultViewUrl] = '/Lists/Strategic Objectives/AllItems.aspx', [NewFormUrl] = '/Lists/Strategic Objectives/NewForm.aspx', [EditFormUrl] = '/Lists/Strategic Objectives/EditForm.aspx', [DisplayFormUrl] = '/Lists/Strategic Objectives/DispForm.aspx', [SiteID] = '534b0c17-5450-4759-89e7-b7f86c0ca00e' where [ListID] = '42058c91-2bb6-4b68-ae38-637c648bc962' if @@ROWCOUNT < 1 insert into [SLAM].[List] select '42058c91-2bb6-4b68-ae38-637c648bc962', '/Lists/Strategic Objectives/AllItems.aspx', '/Lists/Strategic Objectives/NewForm.aspx', '/Lists/Strategic Objectives/EditForm.aspx', '/Lists/Strategic Objectives/DispForm.aspx', '534b0c17-5450-4759-89e7-b7f86c0ca00e'
12/29/2011 2:08:24 PM Information Update LI Start - Strategic Objectives List: Strategic Objectives ListItem: Efficiency/Expense Management, 80c12ddc-fce2-4924-b0d8-cf8f57875a75
12/29/2011 2:08:24 PM Information Update LI Associations Complete - Strategic Objectives List: Strategic Objectives ListItem: Grow Responsibly, 9735b1c6-fa7d-4e51-895a-d6b47d27ddd1
12/29/2011 2:08:24 PM Information Update LI Associations - Strategic Objectives List: Strategic Objectives ListItem: Grow Responsibly, 9735b1c6-fa7d-4e51-895a-d6b47d27ddd1
12/29/2011 2:08:24 PM Information Update LI Complete - Strategic Objectives List: Strategic Objectives ListItem: Grow Responsibly, 9735b1c6-fa7d-4e51-895a-d6b47d27ddd1
12/29/2011 2:08:24 PM Information Update Item: update [SLAM].[StrategicObjectives] set [ListItemID] = '9735b1c6-fa7d-4e51-895a-d6b47d27ddd1',[ListID] = '42058c91-2bb6-4b68-ae38-637c648bc962',[ListRelativeID] = 2,[SoTitle] = 'Grow Responsibly' where ListItemID = '9735b1c6-fa7d-4e51-895a-d6b47d27ddd1'
12/29/2011 2:08:24 PM Information Update Location: update [SLAM].[SiteCollection] set [ServerRelativeUrl] = '/seniorstaff' where [SiteCollectionID] = '22f17216-c147-4405-9b0c-1abb0d14fc21' if @@ROWCOUNT < 1 insert into [SLAM].[SiteCollection] select '22f17216-c147-4405-9b0c-1abb0d14fc21', '/seniorstaff' update [SLAM].[Site] set [Name] = 'AnnualBusinessPlanning', [Title] = 'Annual Business Planning', [Url] = '/AnnualBusinessPlanning', [SiteCollectionID] = '22f17216-c147-4405-9b0c-1abb0d14fc21' where [SiteID] = '534b0c17-5450-4759-89e7-b7f86c0ca00e' if @@ROWCOUNT < 1 insert into [SLAM].[Site] (SiteID, Name, Title, Url, SiteCollectionID) values ('534b0c17-5450-4759-89e7-b7f86c0ca00e', 'AnnualBusinessPlanning', 'Annual Business Planning', '/AnnualBusinessPlanning', '22f17216-c147-4405-9b0c-1abb0d14fc21') update [SLAM].[List] set [DefaultViewUrl] = '/Lists/Strategic Objectives/AllItems.aspx', [NewFormUrl] = '/Lists/Strategic Objectives/NewForm.aspx', [EditFormUrl] = '/Lists/Strategic Objectives/EditForm.aspx', [DisplayFormUrl] = '/Lists/Strategic Objectives/DispForm.aspx', [SiteID] = '534b0c17-5450-4759-89e7-b7f86c0ca00e' where [ListID] = '42058c91-2bb6-4b68-ae38-637c648bc962' if @@ROWCOUNT < 1 insert into [SLAM].[List] select '42058c91-2bb6-4b68-ae38-637c648bc962', '/Lists/Strategic Objectives/AllItems.aspx', '/Lists/Strategic Objectives/NewForm.aspx', '/Lists/Strategic Objectives/EditForm.aspx', '/Lists/Strategic Objectives/DispForm.aspx', '534b0c17-5450-4759-89e7-b7f86c0ca00e'
12/29/2011 2:08:23 PM Information Update LI Start - Strategic Objectives List: Strategic Objectives ListItem: Grow Responsibly, 9735b1c6-fa7d-4e51-895a-d6b47d27ddd1
12/29/2011 2:08:23 PM Information Update LI Associations Complete - Strategic Objectives List: Strategic Objectives ListItem: Mission & Brand, c941fea0-f715-44b7-8c78-94a995751089
12/29/2011 2:08:23 PM Information Update LI Associations - Strategic Objectives List: Strategic Objectives ListItem: Mission & Brand, c941fea0-f715-44b7-8c78-94a995751089
12/29/2011 2:08:23 PM Information Update LI Complete - Strategic Objectives List: Strategic Objectives ListItem: Mission & Brand, c941fea0-f715-44b7-8c78-94a995751089
12/29/2011 2:08:23 PM Information Update Item: update [SLAM].[StrategicObjectives] set [ListItemID] = 'c941fea0-f715-44b7-8c78-94a995751089',[ListID] = '42058c91-2bb6-4b68-ae38-637c648bc962',[ListRelativeID] = 1,[SoTitle] = 'Mission & Brand' where ListItemID = 'c941fea0-f715-44b7-8c78-94a995751089'
12/29/2011 2:08:23 PM Information Update Location: update [SLAM].[SiteCollection] set [ServerRelativeUrl] = '/seniorstaff' where [SiteCollectionID] = '22f17216-c147-4405-9b0c-1abb0d14fc21' if @@ROWCOUNT < 1 insert into [SLAM].[SiteCollection] select '22f17216-c147-4405-9b0c-1abb0d14fc21', '/seniorstaff' update [SLAM].[Site] set [Name] = 'AnnualBusinessPlanning', [Title] = 'Annual Business Planning', [Url] = '/AnnualBusinessPlanning', [SiteCollectionID] = '22f17216-c147-4405-9b0c-1abb0d14fc21' where [SiteID] = '534b0c17-5450-4759-89e7-b7f86c0ca00e' if @@ROWCOUNT < 1 insert into [SLAM].[Site] (SiteID, Name, Title, Url, SiteCollectionID) values ('534b0c17-5450-4759-89e7-b7f86c0ca00e', 'AnnualBusinessPlanning', 'Annual Business Planning', '/AnnualBusinessPlanning', '22f17216-c147-4405-9b0c-1abb0d14fc21') update [SLAM].[List] set [DefaultViewUrl] = '/Lists/Strategic Objectives/AllItems.aspx', [NewFormUrl] = '/Lists/Strategic Objectives/NewForm.aspx', [EditFormUrl] = '/Lists/Strategic Objectives/EditForm.aspx', [DisplayFormUrl] = '/Lists/Strategic Objectives/DispForm.aspx', [SiteID] = '534b0c17-5450-4759-89e7-b7f86c0ca00e' where [ListID] = '42058c91-2bb6-4b68-ae38-637c648bc962' if @@ROWCOUNT < 1 insert into [SLAM].[List] select '42058c91-2bb6-4b68-ae38-637c648bc962', '/Lists/Strategic Objectives/AllItems.aspx', '/Lists/Strategic Objectives/NewForm.aspx', '/Lists/Strategic Objectives/EditForm.aspx', '/Lists/Strategic Objectives/DispForm.aspx', '534b0c17-5450-4759-89e7-b7f86c0ca00e'
12/29/2011 2:08:23 PM Information Update LI Start - Strategic Objectives List: Strategic Objectives ListItem: Mission & Brand, c941fea0-f715-44b7-8c78-94a995751089
12/29/2011 2:08:23 PM Information Updating data from List: /seniorstaff/AnnualBusinessPlanning/Lists/Strategic Objectives for StrategicObjectives
12/29/2011 2:08:23 PM Information Populating data for StrategicObjectives from site
12/29/2011 2:08:23 PM Information Populating data for StrategicObjectives
12/29/2011 2:08:23 PM Information Update Table: begin if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListItemID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListItemID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListRelativeID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListRelativeID] [int] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'SoTitle') ALTER TABLE [SLAM].[StrategicObjectives] ADD [SoTitle] [varchar](255) not null; end
12/29/2011 2:08:23 PM Information Prep table for synchronization: StrategicObjectives
12/29/2011 2:08:23 PM Information Processing Strategic Objectives
12/29/2011 2:08:23 PM Information Data Synchronization Processing: RNA Projects
12/29/2011 2:08:23 PM Information Updating data from List: /seniorstaff/AnnualBusinessPlanning/Lists/RNA Projects for RNAProjects
12/29/2011 2:08:23 PM Information Populating data for RNAProjects from site
12/29/2011 2:08:23 PM Information Populating data for RNAProjects
12/29/2011 2:08:22 PM Information Update Table: begin if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListItemID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListItemID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ListRelativeID') ALTER TABLE [SLAM].[RNAProjects] ADD [ListRelativeID] [int] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.RNAProjects' and c.column_name = 'ProjTitle') ALTER TABLE [SLAM].[RNAProjects] ADD [ProjTitle] [varchar](255) not null; end
12/29/2011 2:08:22 PM Information Prep table for synchronization: RNAProjects
12/29/2011 2:08:22 PM Information Processing RNA Projects
12/29/2011 2:08:22 PM Information Data Synchronization initiated
12/29/2011 2:05:22 PM Information Activation Complete
12/29/2011 2:05:22 PM Information Update Table: begin if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListItemID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListItemID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListID] [uniqueidentifier] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'ListRelativeID') ALTER TABLE [SLAM].[StrategicObjectives] ADD [ListRelativeID] [int] not null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.StrategicObjectives' and c.column_name = 'SoTitle') ALTER TABLE [SLAM].[StrategicObjectives] ADD [SoTitle] [varchar](255) not null; end
Developer
Dec 29, 2011 at 7:28 PM

When you just save an item in RNA Projects does it get saved in the table?

Dec 29, 2011 at 7:33 PM

Good catch.  I tried saving an item and it did get saved to the table.  The list has 173 existing items.  Any ideas on how to get those into the table initially or why its not loading them with the synch?  I've also included the simple config file that I'm using as my test for this situation.

 

<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
 <ConnectionStrings Default="SLAM">
  <add Name="SLAM" ConnectionString="Database=SLAMDB;Data Source=DBSERVER; User ID=SLAM; Password=SOMEPW" />
 </ConnectionStrings>

 <!--<TypeIdDefinitions>
  <add Name="Global" SqlType="varchar(25)" IsPrimaryKey="true" NameFormat="{TableName}ID" ValueFormat="Int" ReplaceSharePointIds="true" />
  <add Name="GlobalWithSharePointIDs" SqlType="varchar(25)" IsPrimaryKey="true" NameFormat="{TableName}ID" ValueFormat="Hex" ReplaceSharePointIds="false" />
 </TypeIdDefinitions>-->

 <DataMapping DataSchema="SLAM" SiteCollection="seniorstaff">

  <List Site="AnnualBusinessPlanning" Name="RNA Projects" TableName="RNAProjects" ActivationOrder="1">
   <Fields>
    <Field Name="Title" SqlType="varchar(255)" Column="ProjTitle" SPType="Text" Required="true"></Field>
  
    
   </Fields>
  </List>
  <List Site="AnnualBusinessPlanning" Name="Strategic Objectives" TableName="StrategicObjectives" ActivationOrder="2">
   <Fields>
    <Field Name="Title" SqlType="varchar(255)" Column="SoTitle" SPType="Text" Required="true"></Field>
   </Fields>
  </List>

 </DataMapping>
</Configuration>

Dec 29, 2011 at 7:39 PM

One other thing to note, is that if I run the synch after having added an item, it deletes the item from the SQL table.

Dec 30, 2011 at 2:01 PM

Good catch. I tried saving an item and it did get saved to the table. The list has 173 existing items. Any ideas on how to get those into the table initially or why its not loading them with the synch? I've also included the simple config file that I'm using as my test for this situation.

<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<ConnectionStrings Default="SLAM">
<add Name="SLAM" ConnectionString="Database=SLAMDB;Data Source=DBSERVER; User ID=SLAM; Password=SOMEPW" />
</ConnectionStrings>

<!--<TypeIdDefinitions>
<add Name="Global" SqlType="varchar(25)" IsPrimaryKey="true" NameFormat="{TableName}ID" ValueFormat="Int" ReplaceSharePointIds="true" />
<add Name="GlobalWithSharePointIDs" SqlType="varchar(25)" IsPrimaryKey="true" NameFormat="{TableName}ID" ValueFormat="Hex" ReplaceSharePointIds="false" />
</TypeIdDefinitions>-->

<DataMapping DataSchema="SLAM" SiteCollection="seniorstaff">

<List Site="AnnualBusinessPlanning" Name="RNA Projects" TableName="RNAProjects" ActivationOrder="1">
<Fields>
<Field Name="Title" SqlType="varchar(255)" Column="ProjTitle" SPType="Text" Required="true"></Field>


</Fields>
</List>
<List Site="AnnualBusinessPlanning" Name="Strategic Objectives" TableName="StrategicObjectives" ActivationOrder="2">
<Fields>
<Field Name="Title" SqlType="varchar(255)" Column="SoTitle" SPType="Text" Required="true"></Field>
</Fields>
</List>

</DataMapping>
</Configuration>

One other thing to note, is that if I run the synch after having added an item, it deletes the item from the SQL table.

Michael L. Richards - IEEE CSDA, MCTS

Application Technical Designer

Royal Neighbors of America

230 16th St.

Rock Island, IL 61201

Phone: 309-732-8365

From: brjenkins [email removed]
Sent: Thursday, December 29, 2011 2:29 PM
To: Michael Richards
Subject: Re: One List is not synching [SLAM:284506]

From: brjenkins

When you just save an item in RNA Projects does it get saved in the table?

Developer
Jan 4, 2012 at 2:16 PM

I've just updated the wsp and source that includes logging that was not previously there when synching a list.  It will not immediately resolve your issue, but I'm hoping you'll see an exception logged now and will be obvious what the problem is.