Clarity

  • Private Community

  • 1.  How to query Initiated Process Messages

    Posted Feb 25, 2013 05:25 AM
    Hello,
    I'd like to query Initiated Process Messages from database. Which table holds this information?
    Thanks,
    Martin


  • 2.  RE: How to query Initiated Process Messages

    Posted Feb 25, 2013 06:03 AM
    Martin

    bpm_run_processes contains the information about the process Intances.

    -Gurjeet


  • 3.  RE: How to query Initiated Process Messages

    Posted Feb 25, 2013 06:08 AM
      |   view attached
    Thank you for your reply, but in that table I can't found information I need.
    To clarify what I really need see the screenshot below:


  • 4.  RE: How to query Initiated Process Messages

    Posted Feb 25, 2013 06:15 AM
    Check out this thread; has an ERD of the tables you need to look at I think...

    Need BPM Process Table Technical Reference


  • 5.  RE: How to query Initiated Process Messages
    Best Answer

    Posted Feb 25, 2013 06:57 AM
    >
    To clarify what I really need see the screenshot below:

    This will provide you all the information as per screenshot

    SELECT * from bpm_errors e
    WHERE e.process_instance_id = ID from BPM_RUN_PROCESSES


    I hope this will help you.

    -Gurjeet


    Edit : Exception_Trace2 is what you are looking for.


  • 6.  RE: How to query Initiated Process Messages

    Posted Feb 25, 2013 07:10 AM
    That's it.
    thanks