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" ?>
<add Name="SLAM" ConnectionString="Database=slam;Data Source=MA-MOSS01;User Id=XXXX;Password=XXXXXXX" />
<List Site="Operations" Name="Product Inventory" ActivationOrder="2">
<Field Name="Product" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
<Field Name="Barcode" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
Any help would be greatly appriciated