Hello All ,
am using "insert in to " activity to insert record in to database table -1 . but the db has a trigger , the trigger will insert data in to table -2 when ever data is inserted into table -1 . it's because of the this trigger am getting the following error . @Anonymous
{
"error": {
"code": 502,
"source": "asia-001.azure-apim.net",
"clientRequestId": "2a0b7819-5ae0-4c2b-bc10-fa33bf5108bc",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "The target table 'dbo.InvoiceRaw' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.\r\nclientRequestId: 2a0b7819-5ae0-4c2b-bc10-fa33bf5108bc",
"error": {
"message": "The target table 'dbo.InvoiceRaw' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause."
},
"source": "sql-sea.azconn-sea-001.p.azurewebsites.net"
}
}
}