|
|
Description: "ExactTarget.OMM.FunctionExecutionException: An error occurred when attempting to execute an upsertData function call. See inner exception for details.\r\n Error Code: OMM_FUNC_EXEC_ERROR\r\n - from Jint --> \r\n\r\n --- inner exception 1---\r\n\r\nExactTarget.OMM.OMMException: An error occurred when attempting to execute an update of the database. See inner exception for details.\r\n\r\n StackID: 11\r\n EnterpriseID: 514004562\r\n ClientID: 514006878\r\n Client Database ID: 11217\r\n Account Type: BUSINESS_UNIT\r\n JobID: 0\r\n MachineName: ATL1S11PGS242\r\n\r\nSql Text:\r\nUPDATE [C514006878].[Double_OptIn] SET [optin_confirmed] = @p0_0 \r\nWHERE [EmailAddress] = @p0_1;\r\nIF @@ROWCOUNT = 0\r\n\tINSERT INTO [C514006878].[Double_OptIn] ([EmailAddress],[optin_confirmed])\r\n\t VALUES (@p0_2,@p0_3);\r\n\r\nSql Parameters:\r\n 0: [DateTime] @p0_0 = 11/21/2024 11:58:51 AM\r\n 1: [NVarChar] @p0_1 = \r\n 2: [NVarChar] @p0_2 = \r\n 3: [DateTime] @p0_3 = 11/21/2024 11:58:51 AM\r\n\r\n Error Code: OMM_SQL_UPDATE_ERR\r\n - from OMMCommon --> \r\n\r\n --- inner exception 2---\r\n\r\nSystem.Data.SqlClient.SqlException: \r\n\r\nError[0]: -- Number: 515 Class: 16 State: 2 Source: .Net SqlClient Data Provider Server: ATL1S11C015I01.XT.LOCAL\\I01,10001 Line: 4\r\n Message: Cannot insert the value NULL into column 'SubscriberKey', table 'ExactTarget11217.C514006878.Double_OptIn'; column does not allow nulls. INSERT fails. \r\n\r\nError[1]: -- Number: 3621 Class: 0 State: 0 Source: .Net SqlClient Data Provider Server: ATL1S11C015I01.XT.LOCAL\\I01,10001 Line: 4\r\n Message: The statement has been terminated.\r\n\r\n HelpLink.ProdName: Microsoft SQL Server\r\n HelpLink.ProdVer: 15.00.4390\r\n HelpLink.EvtSrc: MSSQLServer\r\n HelpLink.EvtID: 515\r\n HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink\r\n HelpLink.LinkId: 20476\r\n - from .Net SqlClient Data Provider\r\n\r\n\r\n\r\n\r\n\r\n"
|