cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_RSQL_SQL_ERROR CX_SY_OPEN_SQL_DB

Former Member
0 Kudos

Dear Experts,

Recently I had finished System copy from Old dev (OS 2003 DB- oracle 10g) to new Dev server (OS 2012  DB - Oracle 11g) through swpm, All post activities has been finished but when I execute ME22N & ME23N system give me below error

DBIF_RSQL_SQL_ERROR

CX_SY_OPEN_SQL_DB

Short text

    SQL error in the database when accessing a table.

How to correct the error

    Database error text........: "ORA-01722: invalid number"

    Internal call code.........: "[RSQL/FTCH/EKBE ]"

    Please check the entries in the system log (Transaction SM21).

    If the error occures in a non-modified SAP program, you may be able to

    find an interim solution in an SAP Note.

    If you have access to SAP Notes, carry out a search with the following

    keywords:

    "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

    "SAPLME07" or "LME07U02"

    "MMPUR_EKBE_READ_EBELN_EBELP"

Kind Regards,

N S Rathore

Accepted Solutions (1)

Accepted Solutions (1)

former_member207186
Contributor
0 Kudos

Hi,

Regarding this issue, you can refer to SAP Note 591600 - "Error due to inappropriate column values".

Regards,

Bíborka

Former Member
0 Kudos

Dear Greta,

Thanks for your prompt reply , I am getting error on Ora - 1722 - Invalid number, please give me solution accordingly, I am a BASIS person not much idea about coding.

you may check trace and sys logs

Kind Regards,

N S Rathore

Former Member
0 Kudos

Table EKBE showing inconsistent

See attached error.

Regards,

N S Rathore

manumohandas82
Active Contributor
0 Kudos

Activate the object in SE11 .

Restart the database and check once again or clear the table buffers (/$TAB )

Thanks ,

Manu

Former Member
0 Kudos

Dear Sir,

I have already restart the database, How to clear table buffers (/$TAB ) ?

Can you explain me please.

Kind Regards,

N S Rathore

Answers (3)

Answers (3)

Former Member
0 Kudos

Dear All,

My Issue has been resolved  " How"

Login in to DDIC (000)  - Execute SE14  Table - EKBE - Utilities - Database Object - Check

Save and activate Table and indexes.


Login again in my 600 client and check it's working fine. Now my database and DDIC consistent mode


Thanks to you all for your valuable suggestion.


Kind Regards,


N S Rathore

JamesZ
Advisor
Advisor
0 Kudos

Hi ,

This is not a database error, please share the short dump and also upload the SAP work process trace which is for the dump.

The short dump writes which sap application server and which sap work process is responsible for the dump, so you can locate the dev_w** trace.

Best regards,
James

Former Member
0 Kudos

Dear James ,

Uploaded trace files , Please check .

Thanks ,

N S Rathore

former_member204746
Active Contributor
0 Kudos

you did not upload interesting traces.

please upload dev_w0.

JamesZ
Advisor
Advisor
0 Kudos

Hi Rathore,

As Eric mentioned, please provide the right traces.

how to find right trace:

The short dump writes which sap application server and which sap work process is responsible for the dump, so you can locate the dev_w** trace.

Best regards,

James

Former Member
0 Kudos

Dear Sir,

When I download trace file given me same error. now showing error on execute maximum tcode.

Attached trace file for your kind reference...!!

Kind Regards,

N S Rathore

Former Member
0 Kudos

Dear Sir,

When I download trace file given me same error. now showing error on execute maximum tcode.

Attached trace file for your kind reference...!!

Kind Regards,

N S Rathore

former_member182657
Active Contributor
0 Kudos

Hi,

Could you share System logs from SM21 ?

Thanks,

Former Member
0 Kudos

Dear Sir,

Attached SM21 / Trace logs , Please check

Regards

N S Rathore