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.
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.
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.
>