DBIF_RSQL_SQL_ERROR

[Former Member]

Hi There,

I am loading historical data into an ODS.

This is the error mesage in ST22.

Name of runtime error: DBIF_RSQL_SQL_ERROR

Exception: CX_SY_OPEN_SQL_DB

There is lots of space in the DB02.

Here is the ABAP code where to program fails.

The program fail on the bold line.

See below.

FORM INSERT_ODS

TABLES P_T_DATA

USING P_REQUESTID LIKE RSMONOUT-RNR

P_DATAPAKID TYPE RSDATAPID

P_PARTNO TYPE RSPARTVAL

CHANGING P_TARGET_FOUND TYPE C

P_SUBRC LIKE SY-SUBRC.

• Local data declarations

DATA: L_T_DATA LIKE /BIC/B0000119004 OCCURS 0,

L_S_DATA LIKE /BIC/B0000119004.

• Initialization

P_TARGET_FOUND = RS_C_TRUE.

CLEAR: P_SUBRC.

• Try to insert the records into the ODS table

<b>INSERT /BIC/B0000119004 FROM TABLE P_T_DATA</b>

ACCEPTING DUPLICATE KEYS.

IF SY-SUBRC NE 0.

• Roll back work and try to find the duplicates

ROLLBACK WORK.

• select * from /BIC/B0000119004

• into table l_t_data

• for all entries in p_t_data

• where request = p_t_data-request

• and datapakid = p_t_data-datapakid

• and record = p_t_data-record.

• Doesn't work because p_t_data has no structure

• Do something with the found records !

P_SUBRC = 13.

ENDIF.

ENDFORM. "INSERT_ODS

Hope anyone can help.

Thanks.

Andre.

[Former Member]

Table /BIC/B0000119004 is a PSA table. In DB02 you can search in which table space it is, i think it is PSATEMP, maybe if you delete old PSA from your system it worked

[Former Member]

True,

Need to find out and delete unwanted PSA data.

It will solve the purpose.

Regards,

Aditya

[Former Member]

Hi,

Tried deleting old PSA data, that does not help.

Maybe make PSATEMP bigger but I cannot find the table.

I am looking in DB02 space/Tablespace.

Where must I look?

Thanks.

A.

[Former Member]

In db02, detailed analisys button, put in object your table

Try to delete other PSA in your system, not only for current object, in order to free space in psatemp

Message was edited by: Oscar Romero

[Former Member]

Hi

Check up Basis ppl.

Regards,

Rohini

[Former Member]

hi,

hi,

-check the OSS Note 634458..

And also contact to ur Basis People to resolve this issue and check PSATEMP disk space

go thru thz threads may help u...

/message/1599520#1599520 [original link is broken]

Shreya

[Former Member]

Hi Shreya,

The links you gave me does not solve the problem.

I Have already spoken to my basis people and they installed patches and the problem remains.

I am looking in DB02 and the table <b>PSAPTEMP</b> and <b>PSAPTEMP16</b> is 100% used can this be the problem?

Basis poeple says these tables are system tables and making them bigger will not solve the problem.

What do you think?

Thanks.

A.

[Former Member]

hi,

let them to increase the space in PSATEMP .. it will solve ur prob..

and remove the req(mark it to Red) and start loading data

Shreya