This discussion is archived
1 Reply Latest reply: Dec 7, 2012 6:08 AM by mathieu.d RSS

oracle.toplink.exceptions.DatabaseException Internal Exception

948857 Newbie
Currently Being Moderated
Hi ,

I have two bpel,which works in publish subscribe model.bpel1 is in 10 g which publishes to the queue and bpel2 is in 11g which subscribes from same queue.All the configurations are checked and it's correct.But when i am triggering bpel1 from 10g,bpel 2 in 11g is not subscribing ,and if I go to Fault and Rejected Messages in EM ,the below error is showing up:


*Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.6.0) (Build 111018)): oracle.toplink.exceptions.DatabaseException Internal Exception: java.sql.BatchUpdateException: ORA-12899: value too large for column "SOAUAT_SOAINFRA"."COMPOSITE_INSTANCE"."CONVERSATION_ID" (actual: 101, maximum: 100) Error Code: 12899*

Can anyone help how to resolve the issue.
  • 1. Re: oracle.toplink.exceptions.DatabaseException Internal Exception
    mathieu.d Explorer
    Currently Being Moderated
    From the exception it seems to be a field limitation in the database.
    You could try to set a custom conversation ID (when calling the other BPEL) having a length less than 100 in order to workaround this incompatibility ?

    I won't recommend you to extend the database field length but it's obviously an other option (with unknown impacts)

    regards,
    mathieu

    Edited by: mathieu.d on 7 déc. 2012 06:07

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points