Dear team,
we receive the next error when GenerateAnniversaryRemindings process is run:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Terrasoft.Common.DublicateDataException: Duplicates data in object "Reminding". at Terrasoft.Core.Entities.Entity.Load(Select select, IDictionary`2 columnMap) at Terrasoft.Core.Entities.Entity.InternalFetchFromDB(IEnumerable`1 columnsToFetch, IDictionary`2 conditions, Boolean useDisplayValues, Boolean performValuesCleanup) at Terrasoft.Core.Entities.Entity.FetchFromDB(EntitySchemaColumn conditionColumn, Object conditionValue, Boolean useDisplayValues) at Terrasoft.Configuration.BaseAnniversaryReminding.DeleteNotActualAnniversaryRemindings(String anniversarySchemaName) at Terrasoft.Configuration.BaseAnniversaryReminding.GenerateRemindings(Select select, String anniversarySchemaName) at Terrasoft.Configuration.BaseAnniversaryReminding.ExecuteQueries() --- End of inner exception stack trace --- at Terrasoft.Core.Process.GenerateAnniversaryRemindingsMethodsWrapper.GenerateRemindingExecute(ProcessExecutingContext context) at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)
Please advise, what columns are taken into accounts when selecting data from dbo.Reminding and how to fix this issue?
Thanks, Iuliia
Like
Can you please check if there are any duplicate ids in Reminding table?
Use this query:
SELECT ID,
COUNT(*) occurrences
FROM Reminding
GROUP BY id
HAVING
COUNT(*) > 1;
Best regards,
Angela
Angela Reyes,
specified by you query returns 0 results. But grouping by
ContactId, Subjectid, Remindtime or different combinations of these columns returns non-empty list. I didn't check all the columns of the table Reminding as it's a cumbersome task, especially taking into account different combinations.
Iuliia Diakiv,
Unfortunately, it is impossible to determine the root cause of the issue without having access to the application and the database. Therefore, please contact technical support in order to resolve the issue.
Please do not forget to provide the support team with a backup of the database.
Best regards,
Norton