Symptom:
Cannot create a record in Delivery destinations (BT_DPA_AOT_ReportDestinations). AOT object ID: 13, 2.
The record already exists.
Solution:
The unique index for the BottomLine tables is RecID. Run the following SQL statement on your AX database. Replace DATABASE with the name of your AX database.
IF OBJECT_ID(‘DATABASE.dbo.[BT_DPA_AOT_ReportDestinations]’, ‘U’) IS NOT NULL
BEGIN
UPDATE SystemSequences
SET NEXTVAL = 1 + (SELECT MAX(RecID) FROM BT_DPA_AOT_ReportDestinations)
WHERE TABID = (SELECT [TABLEID] FROM [SQLDICTIONARY] WHERE [Name] = ‘BT_DPA_AOT_ReportDestinations’ AND [FieldID]=0)
END
IF OBJECT_ID(‘DATABASE.dbo.[BT_DPA_AOT_Reports]’, ‘U’) IS NOT NULL
BEGIN
UPDATE SystemSequences
SET NEXTVAL = 1 + (SELECT MAX(RecID) FROM BT_DPA_AOT_Reports)
WHERE TABID = (SELECT [TABLEID] FROM [SQLDICTIONARY] WHERE [Name] = ‘BT_DPA_AOT_Reports’ AND [FieldID]=0)
END
IF OBJECT_ID(‘DATABASE.dbo.[BT_DPA_AOT_ReportProcesses]’, ‘U’) IS NOT NULL
BEGIN
UPDATE SystemSequences
SET NEXTVAL = 1 + (SELECT MAX(RecID) FROM BT_DPA_AOT_ReportProcesses)
WHERE TABID = (SELECT [TABLEID] FROM [SQLDICTIONARY] WHERE [Name] = ‘BT_DPA_AOT_ReportProcesses’ AND [FieldID]=0)
END
Leave A Comment