Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Agents

Received Response
11
Views
2
Comments
OBIEEAdmin
OBIEEAdmin Rank 1 - Community Starter
edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

Hello Experts,

I have a question here. Am trying to schedule a report which has 100 rows on it and i did that it is working fine. From past 2 weeks we are having DB issues. Now the user is asking us to get the error message when report fails to his/her email ? Can we do this in OBIEE 11G or 12c ?

Please help me out here.

Regards,

Ahmed.

Answers

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Sure, you can get the error message from S_NQ_ERR_MSG. You can see which jobs have failed in S_NQ_JOB. Both table are in the RCU schema.

    You will have to create another agent that will check for errors regularly. I don't think you can have obiee send a message (out of the box) as soon as the agent fails.

  • Sagar Tippe
    Sagar Tippe Rank 4 - Community Specialist

    In addition to what Martin said, you can configure a TRIGGER at database level which will send an email whenever there is an entry to the above mentioned tables.!!

    Hope this helps..

    Sagar Tippe