Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Honored Contributor.. winnielee Honored Contributor..
Honored Contributor..
635 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

Tags (1)
0 Likes
1 Reply
Piku Absent Member.
Absent Member.

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.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.