This project is read-only.

Error in Diagnostic log but new line correctly inserted?

Feb 25, 2010 at 2:58 PM

hello ;  thanks for these tools !!

i have a problem:

When i add an item (just one!)  in my list "Projects" the item is correctly inserted in the Slam associated table but i have an error message (duplicate key)  in the Diagnostics control panel!

I don't understand this problem..Can you help me?

thanks

paste of the error message :

2/25/2010 3:42:29 PM Exception System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Projets'. Cannot insert duplicate key in object 'SLAM.Projets'. The statement has been terminated. 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.InsertItem(String tableSchema, String tableName, Hashtable values) at AWS.SLAM.Data.SqlDataServices.Insert(String typeName, Hashtable values) at AWS.SLAM.Events.ListItemCreator.Create(SPListItem listItem)

Coordinator
Feb 25, 2010 at 6:59 PM

Would you mind posting the contents of your slam.config?

Feb 26, 2010 at 8:38 AM

 

 thank you for your help.

i paste below my slam.config:   

 <?xml version="1.0" encoding="utf-8" ?>

<Configuration>
  <ConnectionStrings Default="SLAM">
    <add Name="SLAM" ConnectionString="Database=xxx;Data Source=xxxxx;User;Password=xxxxxxx" />
  </ConnectionStrings>

 

  <DataMapping DataSchema="SLAM">

 

    <!--//Liste:Users //-->
    <ContentType Name="Person" TableName="Users" ActivationOrder="3">
      <Fields>
        <Field Name="Account" Column="Account" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Title" Column="Name" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Department" Column="Department" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
      </Fields>
    </ContentType>

 

    <!--//Liste:Affaires //-->
    <List Site="/evids/methods/" Name="Affaires" ActivationOrder="5">
      <Fields>
        <Field Name="Affaire" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Task name" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
      </Fields>
    </List>

 

    <!--//Liste:Avions //-->
    <List Site="/evids/methods/" Name="Avions" ActivationOrder="6">
      <Fields>
        <Field Name="Avion" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
      </Fields>
    </List>

 

    <!--//Liste:Phases //-->
    <List Site="/evids/methods/" Name="Phases" ActivationOrder="7">
      <Fields>
        <Field Name="Phase" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
      </Fields>
    </List>

 

    <!--//Liste:Services //-->
    <List Site="/evids/methods/" Name="Services" ActivationOrder="8">
      <Fields>
        <Field Name="Service" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
      </Fields>
    </List>

 

    <!--//Liste:Portefeuille //-->
    <List Site="/evids/methods/" Name="Portefeuille-groupes" ActivationOrder="9">
      <Fields>
        <Field Name="Portefeuille" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
      </Fields>
    </List>

 

    <!--//Liste:Projets //-->
    <List Site="/evids/methods/" Name="Projets" ActivationOrder="10">
      <Fields>
        <Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Produit" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="SousProduit" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Projet" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Description" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="RP" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Rsu" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Rar" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="RU" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Etat" SqlType="varchar(255)" SPType="Choice" Required="false"></Field>
        <Field Name="DT/SDT" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Affaire" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Avion" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Client" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="ProjetID" SqlType="varchar(255)" SPType="Text" Required="false"></Field>

        <!--<Field SqlType="int" SPType="Text" Required="false"></Field>-->
         <Field Name="Phase" SPType="Lookup" AssociatedList="Phases" AssociationName="ProjetsToPhases"></Field>
        <Field Name="Client" SPType="Lookup" AssociatedList="Services" AssociationName="ProjetsToServices"></Field>
        <Field Name="Avion" SPType="Lookup" AssociatedList="Avions" AssociationName="ProjetsToAvions"></Field>
        <Field Name="Affaire" SPType="Lookup" AssociatedList="Affaires" AssociationName="ProjetsToAffaires"></Field>
        <Field Name="Portefeuille Groupe" SPType="Lookup" AssociatedList="Portefeuille-groupes" AssociationName="ProjetsToPortefeuillegroupes"></Field>
      </Fields>
    </List>

 

 

    <!--//Liste:Pointages //-->  
    <List Site="/evids/methods/" Name="Pointages" ActivationOrder="11">
      <Fields>
        <Field Name="Title" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <!--<Field SqlType="varchar(255)" SPType="Text" Required="false"></Field>-->
        <Field Name="Todaydate" SqlType="datetime" SPType="DateTime" Required="false"></Field>
        <!--Laisser la charge en varchar car pblm de . ou , suivant config SqlServer-->
        <Field Name="Charge (H)" SqlType="varchar(255)" SPType="Number" Required="false"></Field>
        <Field Name="Collaborateur" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Annee" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Mois" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <!--<Field SqlType="int" SPType="Calculated" Required="false"></Field>
        <Field SqlType="int" SPType="Calculated" Required="false"></Field>-->
        <Field Name="Produit" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="SSProduitProjet" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="PeriodePrecDeb" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="ProjetID" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Phase" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
        <Field Name="Service" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
      </Fields>
    </List>

 

 

  </DataMapping>
</Configuration>

Feb 26, 2010 at 9:07 AM

I just made the last update (1.3.0.0) but my problem is always here.

I don't understand ; i have the same problem when i manually insert a new item in the list "Pointages" . new line in correctly inserted but i have this strange Exception in the log ?

paste of log ( after a new line in "Pointages" list and a new line in "Projects" list ) :

2/26/2010 9:56:29 AM

Exception

System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Projets'. Cannot insert duplicate key in object 'SLAM.Projets'. The statement has been terminated. 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.InsertItem(String tableSchema, String tableName, Hashtable values) at AWS.SLAM.Data.SqlDataServices.Insert(String typeName, Hashtable values) at AWS.SLAM.Events.ListItemCreator.Create(SPListItem listItem)

2/26/2010 9:54:43 AM

Exception

System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Pointages'. Cannot insert duplicate key in object 'SLAM.Pointages'. The statement has been terminated. 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.InsertItem(String tableSchema, String tableName, Hashtable values) at AWS.SLAM.Data.SqlDataServices.Insert(String typeName, Hashtable values) at AWS.SLAM.Events.ListItemCreator.Create(SPListItem listItem)

2/26/2010 9:50:41 AM

Information

Activation Complete

2/26/2010 9:50:40 AM

Information

Update Table: begin if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'Title') ALTER TABLE [SLAM].[Pointages] ADD [Title] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'Todaydate') ALTER TABLE [SLAM].[Pointages] ADD [Todaydate] [datetime] null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'ChargeH') ALTER TABLE [SLAM].[Pointages] ADD [ChargeH] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'Collaborateur') ALTER TABLE [SLAM].[Pointages] ADD [Collaborateur] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'Annee') ALTER TABLE [SLAM].[Pointages] ADD [Annee] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'Mois') ALTER TABLE [SLAM].[Pointages] ADD [Mois] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'Produit') ALTER TABLE [SLAM].[Pointages] ADD [Produit] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'SSProduitProjet') ALTER TABLE [SLAM].[Pointages] ADD [SSProduitProjet] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'PeriodePrecDeb') ALTER TABLE [SLAM].[Pointages] ADD [PeriodePrecDeb] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'ProjetID') ALTER TABLE [SLAM].[Pointages] ADD [ProjetID] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'Phase') ALTER TABLE [SLAM].[Pointages] ADD [Phase] [varchar](255) null; if NOT EXISTS( select 1 FROM information_schema.columns c WHERE (c.table_schema + '.' + c.table_name) = 'SLAM.Pointages' and c.column_name = 'Service') ALTER TABLE [SLAM].[Pointages] ADD [Service] [varchar](255) null; end

2/26/2010 9:50:40 AM

Information

Processing Pointages

 

Developer
Feb 26, 2010 at 6:10 PM

To your web.config add:

<system.diagnostics>
    <switches>
      <add name="SLAMLogger" value="4" />
    </switches>
  </system.diagnostics>

(level under <configuration>, same as <system.web>)

 

This will make slam log all information messages.  If the duplicate row error is occurring every time you create an item you can see just what is happening.  Maybe it is running twice?  You will see an event when the SLAM process begins like "Create LI Start" so you can see if it happens more than once. 

Also, does it happen on update?

Mar 1, 2010 at 10:27 AM

hi thank you for your help.

i activate the full log . I dont' understand . it's there twice INSERT command but i've just manually create juste One item 'ztest7' in 'projets' list.
(a workflow is associated to this list "Projets" that update one field (ProjetID) on create and update.)

in botton on list log for just an update of this same project..

 3/1/2010 11:05:13 AM Information Update LI Associations Complete - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:05:13 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToPortefeuillegroupes
3/1/2010 11:05:13 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToAffaires
3/1/2010 11:05:13 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToAvions
3/1/2010 11:05:13 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToServices
3/1/2010 11:05:13 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToPhases
3/1/2010 11:05:13 AM Information Update LI Associations - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:05:13 AM Information Update LI Complete - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:05:13 AM Information Update Item: update [SLAM].[Projets] set [ListItemID] = '9ede7123-dc28-43e2-a3c8-a80ae9d8a61b',[ListID] = 'f6203141-e350-4ddc-83b3-8222ebd46f2a',[ListRelativeID] = 1593,[Title] = 'edit',[Produit] = 'ztest7',[SousProduit] = 'ztest7',[Projet] = 'ztest7',[Description] = '',[RP] = '',[Rsu] = '',[Rar] = '',[RU] = '',[Etat] = 'Inactif',[DTSDT] = '',[Affaire] = '0;#',[Avion] = '',[Client] = '0;#',[ProjetID] = '677' where ListItemID = '9ede7123-dc28-43e2-a3c8-a80ae9d8a61b'
3/1/2010 11:05:13 AM Information Update LI Start - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:05:12 AM Exception System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_Projets'. Cannot insert duplicate key in object 'SLAM.Projets'. The statement has been terminated. 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.InsertItem(String tableSchema, String tableName, Hashtable values) at AWS.SLAM.Data.SqlDataServices.Insert(String typeName, Hashtable values) at AWS.SLAM.Events.ListItemCreator.Create(SPListItem listItem)
3/1/2010 11:05:12 AM Information Insert Item: insert into [SLAM].[Projets] ([ListItemID],[ListID],[ListRelativeID],[Title],[Produit],[SousProduit],[Projet],[Description],[RP],[Rsu],[Rar],[RU],[Etat],[DTSDT],[Affaire],[Avion],[Client],[ProjetID]) values ('9ede7123-dc28-43e2-a3c8-a80ae9d8a61b','f6203141-e350-4ddc-83b3-8222ebd46f2a',1593,'edit','ztest7','ztest7','ztest7','','','','','','Inactif','','0;#','','0;#','677')
3/1/2010 11:05:12 AM Information Update LI Associations Complete - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:05:12 AM Information Create LI Start - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:05:12 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToPortefeuillegroupes
3/1/2010 11:05:12 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToAffaires
3/1/2010 11:05:12 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToAvions
3/1/2010 11:05:12 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToServices
3/1/2010 11:05:12 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToPhases
3/1/2010 11:05:12 AM Information Update LI Associations - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:05:12 AM Information Update LI Complete - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:05:12 AM Information Insert Item: insert into [SLAM].[Projets] ([ListItemID],[ListID],[ListRelativeID],[Title],[Produit],[SousProduit],[Projet],[Description],[RP],[Rsu],[Rar],[RU],[Etat],[DTSDT],[Affaire],[Avion],[Client],[ProjetID]) values ('9ede7123-dc28-43e2-a3c8-a80ae9d8a61b','f6203141-e350-4ddc-83b3-8222ebd46f2a',1593,'edit','ztest7','ztest7','ztest7','','','','','','Inactif','','0;#','','0;#','677')
3/1/2010 11:05:12 AM Information Update Item: update [SLAM].[Projets] set [ListItemID] = '9ede7123-dc28-43e2-a3c8-a80ae9d8a61b',[ListID] = 'f6203141-e350-4ddc-83b3-8222ebd46f2a',[ListRelativeID] = 1593,[Title] = 'edit',[Produit] = 'ztest7',[SousProduit] = 'ztest7',[Projet] = 'ztest7',[Description] = '',[RP] = '',[Rsu] = '',[Rar] = '',[RU] = '',[Etat] = 'Inactif',[DTSDT] = '',[Affaire] = '0;#',[Avion] = '',[Client] = '0;#',[ProjetID] = '677' where ListItemID = '9ede7123-dc28-43e2-a3c8-a80ae9d8a61b'
3/1/2010 11:05:12 AM Information Update LI Start - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:00:57 AM Information Update LI Associations Complete - Projets List: Projets ListItem: edit, cbd2f6a9-961e-4de2-bdb0-50fb2f5cf10e

 And Now JUST an Update ... it seems that all commands are doubled? (but no exception in this case)

 

3/1/2010 11:22:29 AM Information Update LI Associations Complete - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:22:29 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToPortefeuillegroupes
3/1/2010 11:22:29 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToAffaires
3/1/2010 11:22:29 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToAvions
3/1/2010 11:22:29 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToServices
3/1/2010 11:22:29 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToPhases
3/1/2010 11:22:29 AM Information Update LI Associations - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:22:29 AM Information Update LI Complete - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:22:29 AM Information Update Item: update [SLAM].[Projets] set [ListItemID] = '9ede7123-dc28-43e2-a3c8-a80ae9d8a61b',[ListID] = 'f6203141-e350-4ddc-83b3-8222ebd46f2a',[ListRelativeID] = 1593,[Title] = 'edit',[Produit] = 'ztest7bis',[SousProduit] = 'ztest7bis',[Projet] = 'ztest7bis',[Description] = '',[RP] = '',[Rsu] = '',[Rar] = '',[RU] = '',[Etat] = 'Inactif',[DTSDT] = '',[Affaire] = '0;#',[Avion] = '',[Client] = '0;#',[ProjetID] = '677' where ListItemID = '9ede7123-dc28-43e2-a3c8-a80ae9d8a61b'
3/1/2010 11:22:29 AM Information Update LI Start - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:22:28 AM Information Update LI Associations Complete - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:22:28 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToPortefeuillegroupes
3/1/2010 11:22:28 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToAffaires
3/1/2010 11:22:28 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToAvions
3/1/2010 11:22:28 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToServices
3/1/2010 11:22:28 AM Information Update LI Delete Associations - For: Projets Type: ProjetsToPhases
3/1/2010 11:22:28 AM Information Update LI Associations - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:22:28 AM Information Update LI Complete - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b
3/1/2010 11:22:28 AM Information Update Item: update [SLAM].[Projets] set [ListItemID] = '9ede7123-dc28-43e2-a3c8-a80ae9d8a61b',[ListID] = 'f6203141-e350-4ddc-83b3-8222ebd46f2a',[ListRelativeID] = 1593,[Title] = 'edit',[Produit] = 'ztest7bis',[SousProduit] = 'ztest7bis',[Projet] = 'ztest7bis',[Description] = '',[RP] = '',[Rsu] = '',[Rar] = '',[RU] = '',[Etat] = 'Inactif',[DTSDT] = '',[Affaire] = '0;#',[Avion] = '',[Client] = '0;#',[ProjetID] = '677' where ListItemID = '9ede7123-dc28-43e2-a3c8-a80ae9d8a61b'
3/1/2010 11:22:28 AM Information Update LI Start - Projets List: Projets ListItem: edit, 9ede7123-dc28-43e2-a3c8-a80ae9d8a61b

 

 

Developer
Mar 1, 2010 at 12:53 PM

Try removing the workflow and trying it.  My guess is that the workflow, when you change the list item, is causing SLAM to fire again before the first SLAM thread is finished.  In your workflow, you'll need to disable events.

Allan

Mar 5, 2010 at 9:29 AM

Hi ;

I have only 'Sharepoint Designer' worflow associated with my 'projet' list and in this case it's not possible to disable events ?

My sharepoint designer Workflow make only 'Update' for particulars fields.

It's not to serious for the moment I'll leave things like that..

A big 'Thank' for yous help . This tools is very useful

++

Lionel