Run time Error DBIF_RSQL_SQL_ERROR while logging and executing some tcodes

[Former Member]

Hi all,

Hi all,

When i try to login into my system (ECC 6.0 with Oracle DB), i have been directed to dump -->

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Short text

SQL error in the database when accessing a table.

Missing RAISING Clause in Interface

Program SAPFSDS1

Include FSDS1E01

Row 365

Module type (FORM)

Module Name TRANSFORM_NEW_OLD

Trigger Location of Exception

Program SAPFSDS1

Include FSDS1E01

Row 380

Module type (FORM)

Module Name TRANSFORM_NEW_OLD

In the source code the the cause for the error is shown in the below line"

SELECT SINGLE * FROM TDCLD

WHERE DOKCLASS EQ DOKCLASS.

"How to correct the error"

Database error text........: "ORA-32255: Message 32255 not found;

product=RDBMS; facility=ORA#"

Internal call code.........: "RSQL/READ/TDCLD "

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

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

find an interim solution in an SAP Note.

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

keywords:

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"SAPFSDS1" or "FSDS1E01"

"TRANSFORM_NEW_OLD"

When i tried to look for the error ORA-32255, i am unable to get any information regarding this?

Could you please suggest me..

I have made the following changes trying to solve the error:

shared_pool_size = 401832601 and

i have executed sql command --> alter system set "_object_statistics"=false scope=spfile;

Message from Alert Log file:

Incremental checkpoint up to RBA [0x1076.10c61.0], current log tail at RBA [0x1076.10e4d.0]

Message from dev_w0 file:

OCI-call failed with -1=OCI_ERROR

C SQL error 32255: 'ORA-32255: Message 32255 not found; product=RDBMS; facility=ORA

C '

C *** ERROR => Error 32255 in stmt_fetch() from oci_execute_stmt(), orpc=0

[dbsloci.c 12720]

C *** ERROR => ORA-32255 occurred when executing SQL stmt (parse error offset=0)

[dbsloci.c 12739]

C sc_p&H05B11F10,no&H110,idc_p&H00000000,con=0,act=1,sle n&H103,smax&H256,#vars=2,stmt

8718D8,table=ATAB

C SELECT "TABNAME" , "VARKEY" , "DATALN" , "VARDATA" FROM "ATAB" WHERE "TABNAME" = :A0 AND "VARKEY" = \

C :A1;

C sc_p&H05B11F10,no&H110,idc_p&H00000000,con=0,act=1,sle n&H103,smax&H256,#vars=2,stmt

8718D8,table=ATAB

C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p &H00000000,ocistmth_p

872784

C IN : cols=2,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rs ize&H28,vmax&H32,bound=1,iobuf_p&H05BF4F28,vda_p

873CA8

C lobs=0,lmax=0,lpcnt=0,larr&H00000000,lcurr_p&H0000000 0,rret=0

C OUT: cols=4,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=-1,rs ize&H124,vmax&H32,bound=1,iobuf_p&H05BEBAF8,vda_p

874118

C lobs=0,lmax=0,lpcnt=0,larr&H00000000,lcurr_p&H0000000 0,rret=0

C SELECT "TABNAME" , "VARKEY" , "DATALN" , "VARDATA" FROM "ATAB" WHERE "TABNAME" = :A0 AND "VARKEY" = \

C :A1;

B ***LOG BY4=> sql error 32255 performing SEL on table ATAB [dbtran#11 @ 7512] [dbtran 7512 ]

B ***LOG BY0=> ORA-32255: Message 32255 not found; product=RDBMS; facility=ORA

[dbtran#11 @ 7512] [dbtran 7512 ]

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL'

B RSLT: {dbsl=99, tran=1}

B FHDR: {tab='ATAB', fcode&H17, mode=2, bpb=0, dbcnt=0, crsr=0,

B hold=0, keep=0, xfer=0, pkg=0, upto=0, init:b=0,

B init:p&H00000000, init:#=0, wa:p=0X031902F0, wa:#&H15000}

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'SEL'

B STMT:

B CRSR: {tab='', id=0, hold=0, prop=0x80000, max.in@0=1, fae:blk=0,

B con:id=0, con:vndr=5, val=2,

B key:#=2, xfer=0, xin:#=1, row:#=0, upto=1, wa:p=0X031902F0}

A TH VERBOSE LEVEL FULL

A ** RABAX: level LEV_RX_PXA_RELEASE_MTX entered.

A ** RABAX: level LEV_RX_PXA_RELEASE_MTX completed.

A ** RABAX: level LEV_RX_COVERAGE_ANALYSER entered.

A ** RABAX: level LEV_RX_COVERAGE_ANALYSER completed.

A ** RABAX: level LEV_RX_ROLLBACK entered.

A ** RABAX: level LEV_RX_ROLLBACK completed.

A ** RABAX: level LEV_RX_DB_ALIVE entered.

A ** RABAX: level LEV_RX_DB_ALIVE completed.

A ** RABAX: level LEV_RX_HOOKS entered.

A ** RABAX: level LEV_RX_HOOKS completed.

A ** RABAX: level LEV_RX_STANDARD entered.

A ** RABAX: level LEV_RX_STANDARD completed.

A ** RABAX: level LEV_RX_STOR_VALUES entered.

A ** RABAX: level LEV_RX_STOR_VALUES completed.

A ** RABAX: level LEV_RX_C_STACK entered.

A ** RABAX: level LEV_RX_C_STACK completed.

A ** RABAX: level LEV_RX_MEMO_CHECK entered.

A ** RABAX: level LEV_RX_MEMO_CHECK completed.

A ** RABAX: level LEV_RX_AFTER_MEMO_CHECK entered.

A ** RABAX: level LEV_RX_AFTER_MEMO_CHECK completed.

A ** RABAX: level LEV_RX_INTERFACES entered.

A ** RABAX: level LEV_RX_INTERFACES completed.

A ** RABAX: level LEV_RX_GET_MESS entered.

A ** RABAX: level LEV_RX_GET_MESS completed.

A ** RABAX: level LEV_RX_INIT_SNAP entered.

A ** RABAX: level LEV_RX_INIT_SNAP completed.

A ** RABAX: level LEV_RX_WRITE_SYSLOG entered.

A ** RABAX: level LEV_RX_WRITE_SYSLOG completed.

A ** RABAX: level LEV_RX_WRITE_SNAP entered.

A ** RABAX: level LEV_SN_END completed.

A ** RABAX: level LEV_RX_SET_ALERT entered.

A ** RABAX: level LEV_RX_SET_ALERT completed.

A ** RABAX: level LEV_RX_COMMIT entered.

A ** RABAX: level LEV_RX_COMMIT completed.

A ** RABAX: level LEV_RX_SNAP_SYSLOG entered.

A ** RABAX: level LEV_RX_SNAP_SYSLOG completed.

A ** RABAX: level LEV_RX_RESET_PROGS entered.

A ** RABAX: level LEV_RX_RESET_PROGS completed.

A ** RABAX: level LEV_RX_STDERR entered.

A Sun Apr 05 22:38:04 2009

A

A ABAP Program SAPFSDS1 .

A Source FSDS1E01 Line 380.

A Error Code DBIF_RSQL_SQL_ERROR.

A Module $Id: //bas/700_REL/src/krn/runt/absapsql.c#9 $ SAP.

A Function HandleRsqlErrors Line 778.

A ** RABAX: level LEV_RX_STDERR completed.

A ** RABAX: level LEV_RX_RFC_ERROR entered.

A ** RABAX: level LEV_RX_RFC_ERROR completed.

A ** RABAX: level LEV_RX_RFC_CLOSE entered.

A ** RABAX: level LEV_RX_RFC_CLOSE completed.

A ** RABAX: level LEV_RX_IMC_ERROR entered.

A ** RABAX: level LEV_RX_IMC_ERROR completed.

A ** RABAX: level LEV_RX_DATASET_CLOSE entered.

A ** RABAX: level LEV_RX_DATASET_CLOSE completed.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS entered.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS completed.

A ** RABAX: level LEV_RX_ERROR_SAVE entered.

A ** RABAX: level LEV_RX_ERROR_SAVE completed.

A ** RABAX: level LEV_RX_ERROR_TPDA entered.

A ** RABAX: level LEV_RX_ERROR_TPDA completed.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.

A ** RABAX: level LEV_RX_END entered.

A ** RABAX: level LEV_RX_END completed.

A ** RABAX: end no http/smtp

A ** RABAX: end RX_BTCHLOG|RX_VBLOG

A SQL error in the database when accessing a table..

A

I have started the local client copy and have stopped it in the middle. i have logged off and tried to login again, this is the start of the dump.

I am unable to resolve it. PLEASE give a solution

Thanks & Regards,

Subbu.

[Former Member]

Hi Subbu,

How were you able to resolve this problem. Please, explain as I have run into the same problem.

Regards,

Azhar.

[Former Member]

Hi Subbu,

We were in touch when you previously posted this, but somehow I got an error when I tried to access the thread. I remember that your DB was still 10.2.0.1 and that this may have caused a corruption. The only explanation for ORA-32255 that looks remotely interesting is that it may occur with the OCI (Oracle Call Interface) accessing a NULL LOB (and ATAB does contain a LOB field). Do you have any chance of upgrading the database where you have the problem to 10.2.0.4?

I don't know whether we'll learn anything useful from this (you might just get an ORA-32255 again) but could you execute the following statement in SQLPLUS:

select count(*) from <sapuser>.ATAB where VARDATA IS NULL;

(replace <sapuser> with the name of the SAP schema owner)

Regards,

Mark

[Former Member]

Dear Experts,

I am sorry , I dont find a solution here. Could you please give some solution . Thanks.

regards

Vagesan

[Former Member]

check for the space in database,is there enough space?

Rohit

[Former Member]

Hi Rohit,

There is enough space in the HD.

As mentioned i am receiving this error when i aborted a clinet copy.

Even i tried as per Note: 686357 , which is relevant but when I try to follow as per the note i.e. SE11 -> Display Table -> Utilities -> Database Object -> Check. But i m directed to dump again when i clieck on Check.

Please suggest.

Thanks & Regards,

Subbu.

[former_member185031]

Rohit is not telling for HDD space, He is telling you to check the Table Space in Database. If you are not ablt to check via DB02 then check with BRTOOLS.

Regards,

Subhash

[Former Member]

Hi Subash,

I have checked both he tablespace info. and HD info., both are having space...

From SAP MMC --> SYSLOG i have seen the following info. "Database: Database error 32255 at SEL access to table ATAB"

For the Error 32255 no info. even when i googled it and i have reorganised the ATAB table using BRSPACE, but my issue is not solved???

will this info. help to solve??

Thanks,

Subbu