Upgrading to Business Central can sometimes throw unexpected errors, and one such error we recently encountered involved a DML statement issue with the 'Access Control' table. Here, we’ll walk you through the problem and how we resolved it.
The Error
During an upgrade attempt from BC14 to BC23,
the Event log reported the following error related to the 'Access Control'
table:
The
target table 'BC14PROD_UPG.dbo.Access Control’ of the DML statement cannot have
any enabled triggers if the statement contains an OUTPUT clause without INTO
clause.
Investigation
and Findings
Upon investigating the error, we discovered
that the 'Access Control' table had several triggers enabled. Triggers in SQL
Server are special types of stored procedures that automatically run when
specific actions occur in the database.
Resolution
The upgrade process failed because the DML
statement included an OUTPUT clause without an INTO clause, which conflicted
with the enabled triggers. To resolve this, we deleted the triggers on the
'Access Control' table.
Steps to
Resolve the Error
1. Identify Triggers: First, identify any triggers associated with the 'Access Control'
table.
2. Delete Triggers: Next, delete the identified triggers.
3. Re-run the Upgrade: After deleting the triggers, we re-ran the upgrade process, which completed successfully.
Conclusion
If you
encounter the DML statement error during your BC upgrade, check for
and remove any triggers on the associated table. This straightforward
solution allowed our upgrade to proceed without further issues.
We hope
this insight helps others facing similar upgrade challenges. If you have any
questions or need further assistance, feel free to reach out in the comments
below.
Happy
upgrading!
