After upgrade to OBIEE12c : [nQSError: 46168] Operation RawFile::checkSoftLimit failed, it'll exceed

Gaétan Francoeur

Hi,

We get the following error in a dashboard after having upgraded from 11g to 12c.

We haven't changed anything in config file like instanceconfig.xml, NQSconfig, ...

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

State: HY000. Code: 46168. [nQSError: 46168] Operation RawFile::checkSoftLimit failed, it'll exceed the current limitation. Current size in MB: 5120 (HY000)

Any idea what could be be the solution?

Thanks

[Deleted User]

Gaétan Francoeur wrote:Hi,We get the following error in a dashboard after having upgraded from 11g to 12c.We haven't changed anything in config file like instanceconfig.xml, NQSconfig,

Thanks

You may think that but the upgrade actually does that for you

Gaétan Francoeur

I'm trying to find out where that "Current size in MB: 5120" comes from.

I looked in the NQSconfig.ini, but I don't see it.

Gaétan Francoeur

I found that : [nQSError: 46168] Operation RawFile::checkSoftLimit failed

But we already have 100GB size limit and 5% as default parameters.

[Deleted User]

Yes but that jsut means that effectively you have 5GB - not that you're "ok" by default:

"By default the temporary file size limit is 100 GB * 5% = 5 GB. "

What *exact* OBI version are you running? "12c" doesn't mean anything because we already had 3 major releases with a total of 13 patches as you can see from MOS Doc 2070465.1

And there is even bug 22675491 (non-public) which relates to your error message mentioned in

So before starting to change that parameter maybe first check / let us know your exact version number

Gaétan Francoeur

Build: 12.2.1.2.0.BISERVER_12.2.1.2.0_LINUX.X64_170404.0308

Release Version: Oracle Business Intelligence 12.2.1.2.0

Package: 170404.0347.000

[Deleted User]

So have you investigated what causes this? Have you checked how much space there is and if you could increase the settings?

If you want a simple order instead of analysis then just do what most people would suggest in such a thread: double the space, keep the percentage.

Gaétan Francoeur

We doubled the percentage from 5% to 10% to make it work.

We'll check when the BUG will become public.

[Deleted User]

Doubling the space should go hand in hand when you double the percentage...