Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

success_flag not updating correctly in usage tracking

Received Response
21
Views
3
Comments
920799
920799 Rank 4 - Community Specialist
edited Aug 13, 2024 5:40PM in Oracle Analytics Forum

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.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    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_FLG

    The 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.

  • 920799
    920799 Rank 4 - Community Specialist

    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
    Thomas Dodds Rank 8 - Analytics & AI Strategist

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