SMTPmail issue (192 Views)
Reply
Regular Advisor
winnielee
Posts: 139
Registered: ‎09-29-2012
Message 1 of 2 (192 Views)

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

Honored Contributor
Piku
Posts: 4,013
Registered: ‎06-17-2010
Message 2 of 2 (156 Views)

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.
http://h30499.www3.hp.com/t5/Tips-and-Tricks/Kudos-what-where-how-and-why/m-p/5677925#U5677925
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.