Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

SMTPmail issue

Regular Advisor

SMTPmail issue

Anyone received the error log below? My customers can't received the email and not sure what happened

 

Server]The statement has been terminated.
3736( 3608) 05/27/2014 23:48:57 RTE I Row Number = 1, Column number = -1
3736( 3608) 05/27/2014 23:48:57 RTE E API=SQLExecute [in _vExecute], Statement=INSERT INTO EVENTOUTM1 ("DESCRIPTOR","EVTYPE","EVTIME","EVSYSSEQ","EVUSRSEQ") VALUES(?,?,?,?,?)
3736( 3608) 05/27/2014 23:48:57 RTE E file:(eventout) key:(evsysseq=0000000000067077) (axces.email,add)
3736( 3608) 05/27/2014 23:48:57 RTE E The record being added contains a duplicate key (axces.email,add)
3736( 3608) 05/27/2014 23:48:57 RTE I dbInsert: The record being added contains a duplicate key
3736( 3608) 05/27/2014 23:48:57 RTE I dbInsert: file:(eventout) key:(evsysseq=0000000000067077)
3736( 3608) 05/27/2014 23:48:57 RAD W Unrecoverable error in application: axces.email on panel add
3736( 3608) 05/27/2014 23:48:57 RTE E Error: SQL State: 23000-2601 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.EVENTOUTM1' with unique index 'EVENTOUTM1CD1BBE3B'.
3736( 3608) 05/27/2014 23:48:57 RTE I Row Number = 1, Column number = -1
3736( 3608) 05/27/2014 23:48:57 RTE E Error: SQL State: 01000-3621 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
3736( 3608) 05/27/2014 23:48:57 RTE I Row Number = 1, Column number = -1
3736( 3608) 05/27/2014 23:48:57 RTE E API=SQLExecute [in _vExecute], Statement=INSERT INTO EVENTOUTM1 ("DESCRIPTOR","EVTYPE","EVTIME","EVSYSSEQ","EVUSRSEQ") VALUES(?,?,?,?,?)
3736( 3608) 05/27/2014 23:48:57 RTE E file:(eventout) key:(evsysseq=0000000000067077) (axces.email,add)
3736( 3608) 05/27/2014 23:48:57 RTE E The record being added contains a duplicate key (axces.email,add)
3736( 3608) 05/27/2014 23:48:57 RTE I dbInsert: The record being added contains a duplicate key
3736( 3608) 05/27/2014 23:48:57 RTE I dbInsert: file:(eventout) key:(evsysseq=0000000000067077)
3736( 3608) 05/27/2014 23:48:57 RAD W Unrecoverable error in application: axces.email on panel add

1 REPLY
Highlighted
Honored Contributor Honored Contributor

Re: SMTPmail issue

Hi,

As error clearly saying that SM is not able to insert the new row in eventout table due to duplicate evsysseq=0000000000067077.

Hence go to eventout table by typing eventout in command line and search for this record, here either delete or take the unload od this and the delete if found not much important.
It will be just another mail for some user you can check it by reading the content of evfields.
After delete check what happens.
However it is not supposed to happen but can try above.


hth,
____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.