GenerateAnniversaryRemindings process error

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 0

Like

5 comments

Is GenerateAnniversaryRemindings an out of the box process?

Julius,

 

yes.

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

Show all comments