Hello World {"message":"An error occurred when attempting to execute an InsertData function call. See inner exception for details.","description":"ExactTarget.OMM.FunctionExecutionException: An error occurred when attempting to execute an InsertData 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: 4\r\n EnterpriseID: 1466423\r\n ClientID: 1466423\r\n Client Database ID: 470\r\n Account Type: ENTERPRISE_2\r\n JobID: 0\r\n MachineName: LAS1S04PGS212\r\n\r\nSql Text:\r\nINSERT INTO [C1466423].[Newsletter_Default_Mapping_V2_PROD] ([Masthead],[PremiumStatus],[SubscriptionStatus],[LocalBrandName],[NewsletterId],[IsActive],[Brand],[CreatedDate],[CreatedBy],[UpdatedDate],[UpdatedBy])\r\n VALUES (@p0_0,@p0_1,@p0_2,@p0_3,@p0_4,@p0_5,@p0_6,@p0_7,@p0_8,@p0_9,@p0_10);\r\n\r\nSql Parameters:\r\n 0: [NVarChar] @p0_0 = ADV\r\n 1: [NVarChar] @p0_1 = ESSENTIALS\r\n 2: [NVarChar] @p0_2 = CANCELLED\r\n 3: [NVarChar] @p0_3 = \r\n 4: [NVarChar] @p0_4 = ADV_PREM-AM\r\n 5: [Bit] @p0_5 = False\r\n 6: [NVarChar] @p0_6 = TheAdvertiser\r\n 7: [DateTime] @p0_7 = 7/3/2023 12:00:00 AM\r\n 8: [NVarChar] @p0_8 = NW\r\n 9: [DateTime] @p0_9 = 7/3/2023 12:00:00 AM\r\n 10: [NVarChar] @p0_10 = NW\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: 2627 Class: 14 State: 1 Source: .Net SqlClient Data Provider Server: LAS1P03C164I06.XT.LOCAL\\I06,10001 Line: 1\r\n Message: Violation of PRIMARY KEY constraint 'PK_F8643CF6700B427C814A677A8674E2F1'. Cannot insert duplicate key in object 'C1466423.Newsletter_Default_Mapping_V2_PROD'. The duplicate key value is (ADV, ESSENTIALS, CANCELLED, , ADV_PREM-AM). \r\n\r\nError[1]: -- Number: 3621 Class: 0 State: 0 Source: .Net SqlClient Data Provider Server: LAS1P03C164I06.XT.LOCAL\\I06,10001 Line: 1\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: 2627\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"} |