nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12c - increasing number of automatic restarts for OBIS service

PiotrN

Hi All,

OBIS service in my installation of OBIEE 12c sometime fails and automatically tries to start up but only 2 times. From time to time it manages to go up at first or second attempt but unfortunately most of the time it is not enough. Is is possible to increase the number of auto-restart attempts?

The only thing i could find is

AUTOMATIC_RESTART = YES;

in NQSConfig.INI.

Regards,

Piotr

Find more posts tagged with

Accepted answers

All comments

Joel Acha

My suggestion would be to actually identify the root cause behind the obis crashes.Have you looked at what may be causing these crashes?

[Deleted User]

+1 to Joel. What's the root cause?

What do the log files say?

Are there core dumps?

etc. etc. etc.

PiotrN

That is the plan, but in the meantime I need to get the environment available and semi-stable at least.

The cause of the crashes seems to be this:

------------- log ----------------

[2019-08-05T23:55:19.529+02:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: 005ZqMkfYBk1vXaj9L6iKD0004U4004j2f,0] [sik: ssi] [tid: eb37700] [55005] The cache polling delete statement failed for table .....

[2019-08-05T23:55:19.529+02:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: 005ZqMkfYBk1vXaj9L6iKD0004U4004j2f,0] [sik: ssi] [tid: eb37700] [55005] The cache polling delete statement failed for table

FTisiot

Can you then try deactivate cache polling or understand why the statement is failing?

This gives you info about removing cache with polling table

[Deleted User]

In order for us to be able to help you, please post that in your initial question next time. We can't see your system or read your log files

PiotrN

Hi Christian,

But going back to my initial question - is there a way to increase number of automatic restarts for OBIS?

Regards,

Piotr

[Deleted User]

That's pretty much attacking the problem from the wrong end. Beating a dead horse 5 times instead of 2 won't make it magically well again.

I have systems which are running without a single restart. It isn't supposed to fail at all

What is going wrong and why. That's important. If you want you can always schedule a graceful shutdown and startup nightly with a cronjob and the stop/start commands.

[Deleted User]

Did you give up on this topic or are you still working on it?

For the benefit of the community it would help if - once concluded - you marked the corresponding answers as correct and helpful.

Thanks