cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_RSQL_SQL_ERROR: CX_SY_OPEN_SQL_DB

Former Member
0 Kudos

In our BI7.0 with Oracle 10.2.0.4 this error occurs during activation and found abap runtime dumps in ST22.

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

How to correct the erroru2026

Database error text........: "ORA-12801: error signaled in parallel query

server P291#ORA-12853: insufficient memory for PX buffers: current 428176K, max needed 2386944K#ORA-04031: unable to allocate 32816 bytes of shared memory ("shared poolu201D, u201Cunknown object","sga heap(1,0)","PX msg "

Information on where terminatedu2026

Termination occurred in the ABAP program "CL_RSODSO_ACTIVATE_REQUESTS===CP" -

in "ACTIVATE_DATA_FROM_QUEUE".

The main program was "RSPROCESS ".

In the source code you have the termination point in line 198

of the (Include) program "CL_RSODSO_ACTIVATE_REQUESTS===CM00D".

The program "CL_RSODSO_ACTIVATE_REQUESTS===CP" was started as a background job.

Job Name....... "BI_PROCESS_ODSACTIVAT"

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello,

In case shared pool is set to correct value and ORA-04031 is temporary problem

you can flush shared pool by

alter system flush shared_pool;

Regards,

Reema

JPReyes
Active Contributor
0 Kudos

ORA-12853: insufficient memory

Make sure shared pool is big enough... also check that your oracle parameters according to the recommended values

Read,

SAP Note 830576 - Parameter recommendations for Oracle 10g

Regards

Juan

Former Member
0 Kudos

Do i need to change ABAP Parmeters.

PETER

Former Member
0 Kudos

Hi,

Read the note which was referred by juan and go ahead with the work around from that note...

-Srini

Former Member
0 Kudos

Cause: Insufficient SGA memory for PX buffers

Action: Reconfigure sga to include at least (max - current)bytes of additional memory

Note 617416 - Oracle9i: Dynamic SGA

Thanks

Rishi Abrol