Kbase P116686: A negative value of a decimal field in an audited table is stored without the sign in the audit tabl
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/7/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
SYMPTOM(s):
OpenEdge 10.1A01
A negative value of a decimal field in an audited table is stored without the sign in the _aud-audit-data system table
The auditing is enabled for a user table that contains audited decimal fields
CAUSE:
This is a known issue being investigated by Development
CAUSE:
This issue occurs when using OpenEdge 10.1A and OpenEdge 10.1A01.
When auditing and recording decimal field values, negative values will be recorded as positive values.
This is an example that illustrates the improper behavior:
Table ?Customer? has the field ?CreditLimit?.
Auditing is enabled for the field ?CreditLimit?.
If a user changes the field ?CreditLimit? to -100 (negative) the audit information show the value of the change in the audit table as 100 (positive). The negative signal is being incorrectly ignored.
Searching for the audit record, the information recorded on the field _aud-audit-data._Event-detail will show as 100.
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.