08/12/2021 15:54:39 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Offer_Upsert
Line : 97
Data source : f91c8e464e214b89a356a21a92e29812_0_15543200
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Offer_Upsert (cDal.Offer_Upsert), ligne 97
Procédure locale save (WIN_OFFER_FORM.PROCEDURE.save), ligne 125
Clic sur btn_convert (WIN_OFFER_FORM.btn_convert), ligne 11
Procédure locale AddRow (WIN_INT_OFFER_HOME.PROCEDURE.AddRow), ligne 5
Clic sur BTN_Add (WIN_INT_OFFER_HOME.WIN_INT_OFFER_HOME.BTN_Add), ligne 1
Error message : 70010	-	Erreur (doublon) de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e2f
Description: 
SQL State: 01000
SQL Error Number: 3621
 
Sous-erreur n°1
Description: 
SQL State: 23000
SQL Error Number: 515
 
L'exécution de la requête suivante a échoué :
set nocount on 

declare @id int = 271
declare @date smalldatetime = CONVERT(DATETIME,N'20211208',103)
declare @date_validity smalldatetime = CONVERT(DATETIME,N'20211208',103)

exec dbo.Offer_Upsert  @id output,
N'ref', 
3, 
@date, 
@date_validity, 

N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 a\cf0\par
}
', 
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 b\cf0\par
}
', 
1, 
548, 
1347, 

1348, 
1, 
NULL, 
NULL, 
NULL, 

NULL, 
NULL,
NULL, 
NULL, 
NULL,

NULL,
NULL, 
0,
1,
0,

3,
NULL,
1,
NULL,
N'Livraison',

N'Installation uwuuuuwuwwuwuwuwuwu',
NULL,
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
'

set nocount off

select @id as 'id'
SQL statement : 
set nocount on 

declare @id int = 271
declare @date smalldatetime = CONVERT(DATETIME,N'20211208',103)
declare @date_validity smalldatetime = CONVERT(DATETIME,N'20211208',103)

exec dbo.Offer_Upsert  @id output,
N'ref', 
3, 
@date, 
@date_validity, 

N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 a\cf0\par
}
', 
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 b\cf0\par
}
', 
1, 
548, 
1347, 

1348, 
1, 
NULL, 
NULL, 
NULL, 

NULL, 
NULL,
NULL, 
NULL, 
NULL,

NULL,
NULL, 
0,
1,
0,

3,
NULL,
1,
NULL,
N'Livraison',

N'Installation uwuuuuwuwwuwuwuwuwu',
NULL,
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
'

set nocount off

select @id as 'id'



08/12/2021 15:57:05 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Offer_Upsert
Line : 97
Data source : b288afaec68b4065b102288c61f0a8b2_-65536_15570102
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Offer_Upsert (cDal.Offer_Upsert), ligne 97
Procédure locale save (WIN_OFFER_FORM.PROCEDURE.save), ligne 125
Clic sur btn_convert (WIN_OFFER_FORM.btn_convert), ligne 11
Procédure locale AddRow (WIN_INT_OFFER_HOME.PROCEDURE.AddRow), ligne 5
Clic sur BTN_Add (WIN_INT_OFFER_HOME.WIN_INT_OFFER_HOME.BTN_Add), ligne 1
Error message : 70010	-	Erreur (doublon) de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e2f
Description: 
SQL State: 01000
SQL Error Number: 3621
 
Sous-erreur n°1
Description: 
SQL State: 23000
SQL Error Number: 515
 
L'exécution de la requête suivante a échoué :
set nocount on 

declare @id int = 271
declare @date smalldatetime = CONVERT(DATETIME,N'20211208',103)
declare @date_validity smalldatetime = CONVERT(DATETIME,N'20211208',103)

exec dbo.Offer_Upsert  @id output,
N'ref', 
3, 
@date, 
@date_validity, 

N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 a\cf0\par
}
', 
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 b\cf0\par
}
', 
1, 
548, 
1347, 

1348, 
1, 
NULL, 
NULL, 
NULL, 

NULL, 
NULL,
NULL, 
NULL, 
NULL,

NULL,
NULL, 
0,
1,
0,

3,
NULL,
1,
NULL,
N'Livraison',

N'Installation uwuuuuwuwwuwuwuwuwu',
NULL,
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
'

set nocount off

select @id as 'id'
SQL statement : 
set nocount on 

declare @id int = 271
declare @date smalldatetime = CONVERT(DATETIME,N'20211208',103)
declare @date_validity smalldatetime = CONVERT(DATETIME,N'20211208',103)

exec dbo.Offer_Upsert  @id output,
N'ref', 
3, 
@date, 
@date_validity, 

N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 a\cf0\par
}
', 
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 b\cf0\par
}
', 
1, 
548, 
1347, 

1348, 
1, 
NULL, 
NULL, 
NULL, 

NULL, 
NULL,
NULL, 
NULL, 
NULL,

NULL,
NULL, 
0,
1,
0,

3,
NULL,
1,
NULL,
N'Livraison',

N'Installation uwuuuuwuwwuwuwuwuwu',
NULL,
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
'

set nocount off

select @id as 'id'



08/12/2021 15:57:28 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Offer_Upsert
Line : 97
Data source : 8d9daa3f269143db9cb99735f068c811_-65536_15572494
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Offer_Upsert (cDal.Offer_Upsert), ligne 97
Procédure locale save (WIN_OFFER_FORM.PROCEDURE.save), ligne 125
Clic sur btn_convert (WIN_OFFER_FORM.btn_convert), ligne 11
Procédure locale AddRow (WIN_INT_OFFER_HOME.PROCEDURE.AddRow), ligne 5
Clic sur BTN_Add (WIN_INT_OFFER_HOME.WIN_INT_OFFER_HOME.BTN_Add), ligne 1
Error message : 70010	-	Erreur (doublon) de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e2f
Description: 
SQL State: 01000
SQL Error Number: 3621
 
Sous-erreur n°1
Description: 
SQL State: 23000
SQL Error Number: 515
 
L'exécution de la requête suivante a échoué :
set nocount on 

declare @id int = 271
declare @date smalldatetime = CONVERT(DATETIME,N'20211208',103)
declare @date_validity smalldatetime = CONVERT(DATETIME,N'20211208',103)

exec dbo.Offer_Upsert  @id output,
N'ref', 
3, 
@date, 
@date_validity, 

N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 a\cf0\par
}
', 
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 b\cf0\par
}
', 
1, 
548, 
1347, 

1348, 
1, 
NULL, 
NULL, 
NULL, 

NULL, 
NULL,
NULL, 
NULL, 
NULL,

NULL,
NULL, 
0,
1,
0,

3,
NULL,
1,
NULL,
N'Livraison',

N'Installation uwuuuuwuwwuwuwuwuwu',
NULL,
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
'

set nocount off

select @id as 'id'
SQL statement : 
set nocount on 

declare @id int = 271
declare @date smalldatetime = CONVERT(DATETIME,N'20211208',103)
declare @date_validity smalldatetime = CONVERT(DATETIME,N'20211208',103)

exec dbo.Offer_Upsert  @id output,
N'ref', 
3, 
@date, 
@date_validity, 

N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 a\cf0\par
}
', 
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 b\cf0\par
}
', 
1, 
548, 
1347, 

1348, 
1, 
NULL, 
NULL, 
NULL, 

NULL, 
NULL,
NULL, 
NULL, 
NULL,

NULL,
NULL, 
0,
1,
0,

3,
NULL,
1,
NULL,
N'Livraison',

N'Installation uwuuuuwuwwuwuwuwuwu',
NULL,
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
'

set nocount off

select @id as 'id'



08/12/2021 15:58:27 [NETBEE-05] [NetBee] [] [C:\Mes Projets\Ubiquistyle\Exe\Exécutable Windows 32 bits]
Form name : cDal.Offer_Upsert
Line : 97
Data source : 9c725613191447cc9ef658908578c5c7_0_15582641
Stack : Méthode add_log_entry_SQL (cLog.add_log_entry_SQL), ligne 29
Méthode _sqlExec (cSql._sqlExec), ligne 22
Méthode ExecuteQuery (cSql.ExecuteQuery), ligne 22
Méthode Offer_Upsert (cDal.Offer_Upsert), ligne 97
Procédure locale save (WIN_OFFER_FORM.PROCEDURE.save), ligne 125
Clic sur btn_convert (WIN_OFFER_FORM.btn_convert), ligne 11
Procédure locale AddRow (WIN_INT_OFFER_HOME.PROCEDURE.AddRow), ligne 5
Clic sur BTN_Add (WIN_INT_OFFER_HOME.WIN_INT_OFFER_HOME.BTN_Add), ligne 1
Error message : 70010	-	Erreur (doublon) de l'accès natif SQLAZURE.
Numéro d'erreur = 117 
 
SQL Server a renvoyé l'erreur 80040e2f
Description: 
SQL State: 01000
SQL Error Number: 3621
 
Sous-erreur n°1
Description: 
SQL State: 23000
SQL Error Number: 515
 
L'exécution de la requête suivante a échoué :
set nocount on 

declare @id int = 271
declare @date smalldatetime = CONVERT(DATETIME,N'20211208',103)
declare @date_validity smalldatetime = CONVERT(DATETIME,N'20211208',103)

exec dbo.Offer_Upsert  @id output,
N'ref', 
3, 
@date, 
@date_validity, 

N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 a\cf0\par
}
', 
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 b\cf0\par
}
', 
1, 
548, 
1347, 

1348, 
1, 
NULL, 
NULL, 
NULL, 

NULL, 
NULL,
NULL, 
NULL, 
NULL,

NULL,
NULL, 
0,
1,
0,

3,
NULL,
1,
NULL,
N'Livraison',

N'Installation uwuuuuwuwwuwuwuwuwu',
NULL,
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
'

set nocount off

select @id as 'id'
SQL statement : 
set nocount on 

declare @id int = 271
declare @date smalldatetime = CONVERT(DATETIME,N'20211208',103)
declare @date_validity smalldatetime = CONVERT(DATETIME,N'20211208',103)

exec dbo.Offer_Upsert  @id output,
N'ref', 
3, 
@date, 
@date_validity, 

N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 a\cf0\par
}
', 
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\colortbl ;\red121\green122\blue137;}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\cf1\f0\fs23 b\cf0\par
}
', 
1, 
548, 
1347, 

1348, 
1, 
NULL, 
NULL, 
NULL, 

NULL, 
NULL,
NULL, 
NULL, 
NULL,

NULL,
NULL, 
0,
1,
0,

3,
NULL,
1,
NULL,
N'Livraison',

N'Installation uwuuuuwuwwuwuwuwuwu',
NULL,
N'{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil\fprq2\fcharset0 Roboto;}}
{\*\generator Riched20 10.0.19041}\viewkind4\uc1 
\pard\f0\fs23\par
}
'

set nocount off

select @id as 'id'



