checkpoint failing when actual values are equal to accepted values

Question

Suddenly I'm getting a failure from a Database Checkpoint thats alerting me of the following:

The "SUM(P.ADJUSTED_TOTAL_STD_VOLUME)" field of row 0 contains a value (10928.6252034237) that differs from the stored one (10928.6252034237).

It does this for all 100 rows of this checkpoint, continueally telling me that my actual value does not match my expected value even though they are the exact same. Not only that, it actually lists all 100 rows twice in the Additional Info tab. Meaning it tells me the same error occured twice.

I'm using Windows Server 2008 and TestComplete 12.2

Has anyone seen this?

marsha_r · Answer

I've seen that happen with checkpoints before. &nbsp;Even though it looks like both of your values are the same type, the actual value may be coming across as something different. &nbsp;Try forcing your actual value into the same type as your accepted value using &nbsp;aqConvert inside the checkpoint and see if that helps.

tristaanogre · Answer

Could it be a rounding error? &nbsp;The actual value being returned by your SQL query could be rounded off in the report while the stored value is actually truncated at the 7.

doug_bowen · Answer

If that's the case, should I be truncating the value using SQL?If so, I can update the SQL to truncate.

tristaanogre · Answer

I'd give that a try at least. &nbsp;

doug_bowen · Answer

I'll try that, however once this test failed it gave me the option to update the checkpoint. &nbsp;After updating the checkpoint it passes. &nbsp;But when I try to store that value in our Source Control (Git), it tells me there is no difference in the checkpoint, thus not allowing me to stre the updated checkpoint.&nbsp;If that is the case, then theoretically even truncation using SQL shouldn't produce a different result. &nbsp;But I'll try it.

Forum Discussion

checkpoint failing when actual values are equal to accepted values

5 Replies

Related Content

XML checkpoint fails

Object checkpoint fails

Checkpoint

Region checkpoint fail after 1 day

XML Checkpoint

Recent Discussions

TestComplete14.72 is not recognizing WinUI-3 objects

Floating window bleep overlapping window takes longer time (~10 min) to click the button on it.

Test case randomly fails with "parent object was not found"

Does TC have a .within() method similar to Cypress.io?

SessionCreator /Timeout option not firing EventControl_OnTimeout