topic Re: Reload task error in QlikView

Reload task error

master_student — Wed, 07 Sep 2016 16:50:39 GMT

Hi,

One of my QlikView dashbords does not load successfully.

Here's the error :

07/09/2016 16:56:25: 0444 SQL SELECT *

07/09/2016 16:56:25: 0445 FROM "QTP"

07/09/2016 16:56:30: Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","SELECT *

07/09/2016 16:56:30: FROM "QTP"

07/09/2016 16:56:30: General Script Error

07/09/2016 16:56:30: Execution Failed

07/09/2016 16:56:30: Execution finished.

Could you kindly advise.

Re: Reload task error

pradeep_s — Thu, 08 Sep 2016 05:34:34 GMT

Wiem,

You need more shared memory than allocated.

This error is related to DB.

The Oracle documentation has these notes on the ORA-04031 error:

ORA-04031: unable to allocate nn bytes of shared memory

Cause: More shared memory is needed than was allocated in the shared pool.

Action: If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".

The ORA-04031 error also happens when you are using automatic memory management (sga_max_size), and the memory specific is too small.

Re: Reload task error

master_student — Fri, 09 Sep 2016 09:49:29 GMT

Thanks Pradeep. You are right. The Database administrators of my company fixed that.