Kbase P117017: Sorting problem on _aud-audit-data._Audit-date-time passing UTC midnight
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/7/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
SYMPTOM(s):
Sorting problem on _aud-audit-data._Audit-date-time passing UTC midnight
When applying sorting on an audit enable database which had some actions taken place around UTC midnight, the output can be like the following:
...
2006-06-14T02:02:05.078+02:00
2006-06-14T02:02:06.096+02:00
2006-06-14T02:02:07.114+02:00
2006-06-14T01:58:02.928+02:00
2006-06-14T01:58:04.244+02:00
2006-06-14T01:58:05.278+02:00
...
2006-06-14T01:59:57.400+02:00
2006-06-14T01:59:58.418+02:00
2006-06-14T01:59:59.436+02:00
The entries from 2 AM and later appear before the entries from 1:58 and 1:59.
CAUSE:
This is a known issue being investigated by Development
FIX:
A T-Fix has been created for 10.1A02 which addresses this problem. Later versions will incorporate the fix into the shipped product.
Contact Progress Software Technical Support to request the T-Fix.