problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

[Former Member]

Sir,

            one z program in finance module ( zadvice :- payment for vendors).

            program code was unchanged from last 8 months, and while executing it i am getting dbif_rsql_sql_error and cx_sy_open_sql_db error.

            any suggestions please.

Regards.

[hendrik_brandes]

Hello Satish,

can you please specify the error detailed? The error can result through some changes in the database structure. For example: If you use an internal table with less fields than the db-table, you can get this error.

Kind regards,

Hendrik

[Former Member]

sir pls check this statements which was used in the program.

types : begin of it_bseg,

bukrs  TYPE  bukrs,                               "Company Code
           belnr  TYPE  belnr_d,                             "Accounting Document Number
           gjahr  TYPE  gjahr,                               "Fiscal Year
           buzei  TYPE  buzei,                               "Number of Line Item Within Accounting Document
           augdt  TYPE  augdt,                               "Clearing Date
           wrbtr  TYPE  wrbtr,                               "Amount in document currency
           hkont  TYPE  hkont,                               "General Ledger Account
           sgtxt  TYPE  sgtxt,                               "Item Text
           lifnr  TYPE  lifnr,                               "Account Number of Vendor or Creditor
           bschl  TYPE  bschl,                               "Posting Key
           koart  TYPE  koart,                               "Account Type
           umskz  TYPE  umskz,                               "Special G/L Indicator
           augbl  TYPE  augbl,                               "Document Number of the Clearing Document
           shkzg  TYPE  shkzg,                               "Debit/Credit Indicator
           dmbtr  TYPE  dmbtr,                               "Amount in Local Currency
           rebzg  TYPE  rebzg,                               "Number of the Invoice the Transaction Belongs to
           qbshb  TYPE  qbshb,                               "Withholding Tax Amount (in Document Currency)
           ebeln  TYPE  ebeln,                               "Purchasing Document Number
           nebtr  TYPE  nebtr,                               "Net Payment Amount
         END OF ty_bseg.

data : it_bseg type table of ty_bseg,

         wa_bseg     type      ty_bseg.

IF sy-subrc = 0.
       SELECT bukrs                                                  "Company Code
              belnr                                                  "Accounting Document Number
              gjahr                                                  "Fiscal Year
              buzei                                                  "Number of Line Item Within Accounting Document
              augdt                                                  "Clearing Date
              wrbtr                                                  "Amount in document currency
              hkont                                                  "General Ledger Account
              sgtxt                                                  "Item Text
              lifnr                                                  "Account Number of Vendor or Creditor
              bschl                                                  "Posting Key
              koart                                                  "Account Type
              umskz                                                  "Special G/L Indicator
              augbl                                                  "Document Number of the Clearing Document
              shkzg                                                  "Debit/Credit Indicator
              dmbtr                                                  "Amount in Local Currency
              rebzg                                                  "Number of the Invoice the Transaction Belongs to
              qbshb                                                  "Withholding Tax Amount (in Document Currency)
              ebeln                                                  "Purchasing Document Number
              nebtr                                                  "Net Payment Amount
              FROM bseg
              INTO TABLE it_bseg
              WHERE bukrs = wa_bkpf-bukrs
                AND augbl = wa_bkpf-belnr
                AND augdt = wa_bkpf-budat
                AND gjahr = wa_bkpf-gjahr.
       IF sy-subrc = 0.
         DELETE it_bseg WHERE belnr = pr_belnr.
       ENDIF.
     ENDIF.
   ENDIF.

IN the point IF SY-SUBRC = 0.

the program was terminating.

[RaymondGiuseppi]

Did you check dump information via ST22 and system log via SM21 to get the actual DB error ?

Regards,

Raymond

[Abhijit74]

Hello,

Please check this thread http://scn.sap.com/thread/3306657.

Thanks,

Abhijit

[Former Member]

sir,

      when i am passing values to bseg, in se16n transaction. the values .

after giving these values the run time error occured

can u please explain what is cause of this and any ways to correct it.

because it is effecting many reports.

Regards.

[Former Member]

Try

Into corresponding fields of it_bseg

in the select statement.

Also, post the next part of the Dump!

[former_member189845]

Hi Sathish,

Please check out this links this might be helpful for u.

http://benxbrain.com/en(bD1lbiZjPTAwMQ==)/index.do?onInputProcessing=brai_thread&001_thread_id=17795...

http://www.stechno.net/sap-notes.html?view=sapnote&id=1280623

http://www.benx.de/de(bD1lbiZjPTAwMQ==)/index.do?onInputProcessing=brai_thread&001_thread_id=2099089...

[RaymondGiuseppi]

So you get an Oracle problem : ORA-25153 "Temporary Tablespace is Empty", ask database manager to check for temp dataspace PSAPTEMP. (Was a recovery executed)

Also you could read Note 600513 - ORA-25153 after recovery due to missing tempfiles or Note 659946 - FAQ: Temporary tablespaces.

Regards,

Raymond