success_flag not updating correctly in usage tracking

Question

Hi All

success_flag is not updating correctly in usage tracking

we see only 0 for success

and 3 for all the failures

no single column have 1 or 2 for the failure reports.

i checked support blog couldnt find anything, our version OBIEE 11.1.1.7.140715

any known issue work around any body aware of ... Thank you for the help and for the Reply's on Advance.

Thomas Dodds · Answer

Test for it ... "I am sure some..." is a conclusion based on what?

920799 · Answer

Thank you for the reply

Yes We have Time out and row limitation setup..I am sure some queries were failed with error row limit or time out.

but we have never seen any entry in usage tracking table with success_flg  code 1 and 2 .

Thomas Dodds · Answer

It's working as designed ... unless you know 100% that you've timed out a query OR that you've blown through a row limitation ... ALL other failures get lumped to #3

SuccessSUCCESS_FLGThe completion status of the query:

0 - The query completed successfully with no errors.

1 - The query timed out.

2 - The query failed because row limits were exceeded.

3 - The query failed due to some other reason.