Bug 1048741

Summary: Instance Log in business-central displays logs in random order for the same timestamp
Product: [Retired] JBoss BPMS Platform 6 Reporter: Toshiya Kobayashi <tkobayas>
Component: Business CentralAssignee: Mauricio Salatino <msalatin>
Status: CLOSED CURRENTRELEASE QA Contact: Marek Baluch <mbaluch>
Severity: medium Docs Contact:
Priority: high    
Version: 6.0.0CC: kverlaen, lpetrovi, rrajasek
Target Milestone: ER2   
Target Release: 6.0.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-08-06 20:01:55 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
JBoss_BPM_Suite_Business_central.png
none
Fixed ordering screenshot. none

Description Toshiya Kobayashi 2014-01-06 09:41:32 UTC 
Description of problem:

Logs in "Instance Log" field in "Instance Details" panel are ordered by date. But if those logs (NodeInstanceLog) have the same timestamp, they are displayed in random order. It could be solved by 'ORDER BY log.date DESC, log.id DESC'.

Version-Release number of selected component (if applicable):

6.0.0 ER7

Steps to Reproduce:

1. Create simple bpmn process(StartNode-->ScriptTask-->EndNode)
2. Build and deploy package.
3. Go to "Process Management"-->"Process Definitions" and start process instance
4. Check the "Instance Log" in "Instance Details" panel.

Actual results:

The same timestamp logs are displayed in random order.

Expected results:

The same timestamp logs are ordered by id (DESC).
Comment 1 Toshiya Kobayashi 2014-01-06 09:42:50 UTC 
Created attachment 846001 [details]
JBoss_BPM_Suite_Business_central.png

Screenshot of the issue
Comment 2 Toshiya Kobayashi 2014-01-08 12:52:30 UTC 
Sent a pull request:

https://github.com/droolsjbpm/jbpm/pull/187
Comment 3 Mauricio Salatino 2014-02-20 09:35:47 UTC 
Fixed in 6.0.x : http://github.com/droolsjbpm/jbpm/compare/20883cf...b16a827
Comment 4 Marek Baluch 2014-03-05 20:48:16 UTC 
Verified on 6.0.1.ER2.
Comment 5 Marek Baluch 2014-03-05 20:48:41 UTC 
Created attachment 871152 [details]
Fixed ordering screenshot.