Every incoming transmission giving an error


I'm using medelson opensourse AS2 1.1 build 49.

We've been using it here for years with basically no problems. But as of a coule of days ago, every transmission that comes gives an error message at the bottom of the screen.

Here's a copy of the message:
LogAccessDB.log: integrity constraint violation: unique constraint or index violation; SYS_PK_10109 table: MESSAGELOG

I looked around the net and mendelson itself, but can't find anything helpful.

I can setup users, create the certs, the basic stuff. Mendelson was already setup when I started working here so I really don't have much knowledge of it. I am a programmer and an IT guy, but can't find any database in mendelson, or specifically the setup of it where I can check for constraint violation as I would in SQL.

If anyone knows what's causing this, how to fix it, or even is able to point me someplace in Mendelson where to look, it would be appreciated.

Thanks for any help

Steve S





In case anyone else comes across this, this is what caused it and how to fix it.

I found that the messages coming into our inbox was hung in a pending folder.

Once I took them out of the folder and manually moved them into our live folder, all the constraint errors went away.

Steve S