Issues with Syncing after Successful Manual Validation and Sync

Apr 21, 2010 at 9:06 AM

I'm having an issue that after Validation and manual syncing in which there are no error reported and all items appear in the database as expected when the sharepoint list has a new item added or existing item changed the database does not update.  Furthermore no entry is made of a transaction in the SLAM log.  I at first suspected it might be a DataType issue but as you can see in the configuration file below its a fairly straight forward list and all data types have been matched up between SQL, Sharepoint and the Configuration file.  Im not sure where to start looking for the problem since their dont appear to be any errors to work from anywhere.

 

Here is the configuration file.

<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
  <ConnectionStrings Default="SLAM">
    <add Name="SLAM" ConnectionString="Database=slam;Data Source=MA-MOSS01;User Id=XXXX;Password=XXXXXXX" />
  </ConnectionStrings>

   <DataMapping DataSchema="SLAM">
 
 <List Site="Operations" Name="Product Inventory" ActivationOrder="2">
  <Fields>
   <Field Name="Product" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
   <Field Name="Barcode" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
  </Fields>
 </List>

  </DataMapping>
 
</Configuration>

 

Any help would be greatly appriciated

Developer
Apr 21, 2010 at 10:55 AM

Did you activate slam? It looks like maybe the event handlers aren't attached which is one of the things that happens on activate.

Try setting slam's logging to verbose, then activating and seeing what you get in the slam message table.

Allan