garecanbp

Commodore
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-07-30
01:05
494 views
Duration from Execution Plan different from query DB?
Hello,
At Execution Plan Run, it is showed testing duration.
I checked at db from View TM_V_ExecDefRuns, the Duration is different from Duration that showed at SC.
At SC Execution Plan, it show Duration 0h 39m 0s
From the View with the same Execution Plan id, the Duration I convert from ms (2340971) to 16 minutes and 11 seconds
Am I wrong to convert the Duration?
3 Replies
Hubert Inreiter

Micro Focus Expert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-07-30
03:58
Hi garecanbp,
Do you report on manual or automated tests?
Is this question about an execution plan or testing cycle?
Regards,
Hubert
Do you report on manual or automated tests?
Is this question about an execution plan or testing cycle?
Regards,
Hubert
garecanbp

Commodore
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-07-30
04:03
Hello,
This is for Automated Test.
I created custom report to show result test from execution plan
This is for Automated Test.
I created custom report to show result test from execution plan
Hubert Inreiter

Micro Focus Expert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2018-07-31
09:46
Hi garecanbp,
The duration in milliseconds is converted this way to a readable form:
2340971 ms / 1000
= 234 sec
234 sec / 60
= 39 min
That's consistent with what you see in SC.
Regards,
Hubert