topic Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB. in Application Development and Automation Discussions

problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

Former Member — Tue, 09 Apr 2013 07:51:12 GMT

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.

Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

hendrik_brandes — Tue, 09 Apr 2013 08:24:20 GMT

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

Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

RaymondGiuseppi — Tue, 09 Apr 2013 08:28:08 GMT

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

Regards,

Raymond

Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

Abhijit74 — Tue, 09 Apr 2013 08:31:26 GMT

Hello,

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

Thanks,

Abhijit

Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

Former Member — Tue, 09 Apr 2013 08:47:35 GMT

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.

Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

Former Member — Fri, 12 Apr 2013 05:27:54 GMT

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.

Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

former_member189845 — Fri, 12 Apr 2013 06:22:29 GMT

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=1779597%20&001_temp=R3TR%7cFUGR%7cV130%7c%7cP01

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%20&001_temp=R3TR%7cTABL%7cS120%7c%7cP01

Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

Former Member — Fri, 12 Apr 2013 06:30:21 GMT

Try

Into corresponding fields of it_bseg

in the select statement.

Also, post the next part of the Dump!

Re: problem with the run time error DBIF_RSQL_SQL_ERROR AND CX_SY_OPEN_SQL_DB.

RaymondGiuseppi — Fri, 12 Apr 2013 06:45:51 GMT

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