How to customize OBIEE Error Message

Question

Hi,

We have a requirement to customize one of the Error message in OBIEE 12c.

If any of the report is running more than 10 minutes we are killing that particular query from Database (with a trigger). As soon as the query get killed in OBIEE front end we are able to see below error message -

message: ORA-00028: your session has been killed ORA-00028: your session has been killed

I want to customize this message to "Query has been killed as time limit has been exhausted"

Is it possible to do? Which XML file contain below message, so that I can modify that XML.

Thanks

Anirban

Anirban1 · Answer

Hi Joel,

Thanks for your reply, we will definitely look into the problem, but meanwhile do not want database resource should be consume for those queries which is taking more than 10 minutes, that is while we will kill those queries from back end and further look into it.

Thanks

Anirban

Joel Acha · Answer

I might be missing something here but in my very humble opinion, shouldn't you be looking at the underlying issue of the query performance in your database? A query taking over 10 minutes doesn't sound right.

[Deleted User] · Answer

Sorry if this isn't what you wanted to hear, but that's it.Does that conclude the issue for you?