Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Error: MEAMSGID is not unique

From: al_potanin (2012-08-29 05:51)

Hi All,
Maximo 7.1.1.6 (WebSphere)
I've got an emergency and would appreciate your help!
Do you know how MEAMSGID field in MAXINTMSGTRK (DTL) is populated?
My interface to SAP fails: messages are not created for financial transactions because of following error:
ORA-00001: unique constraint (MAXIMO.MAXINTMSGTRKDTL_X1) violated
This index's script:
CREATE UNIQUE INDEX MAXIMO.MAXINTMSGTRKDTL_X1 ON MAXIMO.MAXINTMSGTRKDTL
(MEAMSGID, STATUS)...
So I assume that the functionality (sequence) that populates this field got out of sync and is trying to create messages with the same ID.
With regards,
Alexey
P.S. I also logged a call with IBM but they didn't come back to me yet.


From: al_potanin (2012-08-29 06:33)

It was probably the glitch in Maximo because after the restart the problem disappear.
--- In MAXIMO@yahoogroups.com, "al_potanin" <spivot@...> wrote:
>
> Hi All,
>
> Maximo 7.1.1.6 (WebSphere)
>
> I've got an emergency and would appreciate your help!
>
> Do you know how MEAMSGID field in MAXINTMSGTRK (DTL) is populated?
>
> My interface to SAP fails: messages are not created for financial transactions because of following error:
>
> ORA-00001: unique constraint (MAXIMO.MAXINTMSGTRKDTL_X1) violated
>
> This index's script:
> CREATE UNIQUE INDEX MAXIMO.MAXINTMSGTRKDTL_X1 ON MAXIMO.MAXINTMSGTRKDTL
> (MEAMSGID, STATUS)...
>
> So I assume that the functionality (sequence) that populates this field got out of sync and is trying to create messages with the same ID.
>
> With regards,
> Alexey
>
> P.S. I also logged a call with IBM but they didn't come back to me yet.
>