cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Error in database when accessing a table

Former Member
0 Kudos

i get sql error when try to log into the sap system, it says sql error in the database when accessing a table

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

thanks for all of you, my problem solved by recover undo table space.

Former Member
0 Kudos

good that your problem has already been solved, grateful to help me: the error is:

"SQL 50,000: SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off the part of the security configuration for this server. The ad system "

markus_doehr2
Active Contributor
0 Kudos

Well - what do you think is our next question?

A SAP system has more than 50.000 tables, there are thousands of possible errors and issues. If you want help, please tell us

- the exact error message you get

- was it working before?

- what did you do?

Markus

Former Member
0 Kudos

first thank you for your reply.

the system was working but suddenly i found an error from the operating system says that there is an error in writing duo to hardware faliure, and sap work process was giving error, after i checked i found that there is about 3 data files need to be recoverd so i did that and the work process worked and i can open the sap logon but when i enter username and password it gives that error: sql error in the data base when accessing a table,

find below developer trace file dev_w0:

-


trc file: "dev_w0", trc level: 1, release: "700"

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, MJ

*

A ABAP ShmAdm attached (addr=000007FF562BE000 leng=20955136 end=000007FF576BA000)

A >> Shm MMADM area (addr=000007FF56766FE0 leng=247168 end=000007FF567A3560)

A >> Shm MMDAT area (addr=000007FF567A4000 leng=15818752 end=000007FF576BA000)

A RFC Destination> destination unierpdev02_ED2_11 host unierpdev02 system ED2 systnr 11 (unierpdev02_ED2_11)

A RFC Options> H=unierpdev02,S=11,d=2,

A RFC FRFC> fallback activ but this is not a central instance.

A

A RFC rfc/signon_error_log = -1

A RFC rfc/dump_connection_info = 0

A RFC rfc/dump_client_info = 0

A RFC rfc/cp_convert/ignore_error = 1

A RFC rfc/cp_convert/conversion_char = 23

A RFC rfc/wan_compress/threshold = 251

A RFC rfc/recorder_pcs not set, use defaule value: 2

A RFC rfc/delta_trc_level not set, use default value: 0

A RFC rfc/no_uuid_check not set, use default value: 0

A RFC rfc/bc_ignore_thcmaccp_retcode not set, use default value: 0

A RFC Method> initialize RemObjDriver for ABAP Objects

M ThrCreateShObjects allocated 49900 bytes at 0000000030330050

N SsfSapSecin: putenv(SECUDIR=C:\usr\sap\ED2\DVEBMGS11\sec): ok

N

N =================================================

N === SSF INITIALIZATION:

N ===...SSF Security Toolkit name SAPSECULIB .

N ===...SSF trace level is 0 .

N ===...SSF library is C:\usr\sap\ED2\DVEBMGS11\exe\sapsecu.dll .

N ===...SSF hash algorithm is SHA1 .

N ===...SSF symmetric encryption algorithm is DES-CBC .

N ===...completed with return code 5.

N =================================================

N

N Thu Apr 16 18:02:42 2009

N MskiInitLogonTicketCacheHandle: Logon Ticket cache pointer retrieved from shared memory.

N MskiInitLogonTicketCacheHandle: Workprocess runs with Logon Ticket cache.

M JrfcVmcRegisterNativesDriver o.k.

W =================================================

W === ipl_Init() called

B dbtran INFO (init_connection '<DEFAULT>' [ORACLE:700.08]):

B max_blocking_factor = 5, max_in_blocking_factor = 5,

B min_blocking_factor = 5, min_in_blocking_factor = 5,

B prefer_union_all = 0, prefer_join = 0,

B prefer_fix_blocking = 0, prefer_in_itab_opt = 1,

B convert AVG = 0, alias table FUPD = 0,

B escape_as_literal = 1, opt GE LE to BETWEEN = 0,

B select * =0x0f, character encoding = STD / <none>:-,

B use_hints = abap->1, dbif->0x1, upto->2147483647, rule_in->0,

B rule_fae->0, concat_fae->0, concat_fae_or->0

W ITS Plugin: Path dw_gui

W ITS Plugin: Description ITS Plugin - ITS rendering DLL

W ITS Plugin: sizeof(SAP_UC) 2

W ITS Plugin: Release: 700, [7000.0.179.20050900]

W ITS Plugin: Int.version, [33]

W ITS Plugin: Feature set: [17]

W ===... Calling itsp_Init in external dll ===>

W === ipl_Init() returns 0, ITSPE_OK: OK

W =================================================

N VSI: WP init in ABAP VM completed with rc=0

E Replication is disabled

E EnqCcInitialize: local lock table initialization o.k.

E EnqId_SuppressIpc: local EnqId initialization o.k.

E EnqCcInitialize: local enqueue client init o.k.

C OCI-call failed with -1=OCI_ERROR

C SQL error 1552: 'ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3700''

C *** ERROR => Error 1552 in stmt_execute() from oci_execute_stmt(), orpc=0

[dbsloci.c 12650]

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

[dbsloci.c 12652]

C sc_p=000000000802CFC0,no=6,idc_p=00000000119001E0,con=0,act=1,slen=123,smax=256,#vars=5,stmt=00000000119FA590,table=DYNPLOAD

C UPDATE "DYNPLOAD" SET "DATA" = :A0 WHERE "PROGNAME" = :A1 AND "DYNPNUMBER" = :A2 AND "TYPE" = :A3 RE\

C TURNING "DATA" INTO :A4;

C sc_p=000000000802CFC0,no=6,idc_p=00000000119001E0,con=0,act=1,slen=123,smax=256,#vars=5,stmt=00000000119FA590,table=DYNPLOAD

C prep=0,lit=0,nsql=0,lobret=1,#exec=1,dbcnt=0,upsh_p=000000000802D058,ocistmth_p=0000000011CB40E8

C IN : cols=4,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=-1,rsize=90,vmax=32,bound=1,iobuf_p=0000000007F99190,vda_p=0000000008791490

C lobs=1,lmax=4,lpcnt=0,larr=0000000007F910C0,lcurr_p=0000000000000000,rret=0

C OUT: cols=1,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=0,rsize=0,vmax=32,bound=0,iobuf_p=0000000000000000,vda_p=0000000008791C20

C lobs=1,lmax=4,lpcnt=0,larr=0000000007F911C0,lcurr_p=0000000000000000,rret=0

C UPDATE "DYNPLOAD" SET "DATA" = :A0 WHERE "PROGNAME" = :A1 AND "DYNPNUMBER" = :A2 AND "TYPE" = :A3 RE\

C TURNING "DATA" INTO :A4;

B ***LOG BY4=> sql error 1552 performing MOD on table DYNPLOAD [dbdynpdb#? @ 510] [dbdynpdb0510 ]

B ***LOG BY0=> ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3700' [dbdynpdb#? @ 510] [dbdynpdb0510 ]

B *** ERROR => Input values: Table = DYNPLOAD, prog = SAPMSSY0 , dynpnr = 0121, langu =

[dbdynpdb2.c 510]

Y *** WARNING => Async update of dynproload SAPMSSY0 0121 failed: DBrc = 1 [dyrdypdb.c 188]

Y *** WARNING => ===> requesting WP: 7 [dyrdypdb.c 189]

C

C Thu Apr 16 18:02:46 2009

C OCI-call failed with -1=OCI_ERROR

C SQL error 1552: 'ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3700''

C *** ERROR => Error 1552 in stmt_execute() from oci_execute_stmt(), orpc=0

[dbsloci.c 12650]

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

[dbsloci.c 12652]

C sc_p=000000000802CFC0,no=6,idc_p=00000000119001E0,con=0,act=1,slen=123,smax=256,#vars=5,stmt=00000000119FA590,table=DYNPLOAD

C UPDATE "DYNPLOAD" SET "DATA" = :A0 WHERE "PROGNAME" = :A1 AND "DYNPNUMBER" = :A2 AND "TYPE" = :A3 RE\

C TURNING "DATA" INTO :A4;

C sc_p=000000000802CFC0,no=6,idc_p=00000000119001E0,con=0,act=1,slen=123,smax=256,#vars=5,stmt=00000000119FA590,table=DYNPLOAD

C prep=0,lit=0,nsql=0,lobret=1,#exec=1,dbcnt=0,upsh_p=000000000802D058,ocistmth_p=0000000011CB40E8

C IN : cols=4,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=-1,rsize=90,vmax=32,bound=1,iobuf_p=0000000007F99190,vda_p=0000000008791490

C lobs=1,lmax=4,lpcnt=0,larr=0000000007F910C0,lcurr_p=0000000000000000,rret=0

C OUT: cols=1,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=0,rsize=0,vmax=32,bound=0,iobuf_p=0000000000000000,vda_p=0000000008791C20

C lobs=1,lmax=4,lpcnt=0,larr=0000000007F911C0,lcurr_p=0000000000000000,rret=0

C UPDATE "DYNPLOAD" SET "DATA" = :A0 WHERE "PROGNAME" = :A1 AND "DYNPNUMBER" = :A2 AND "TYPE" = :A3 RE\

C TURNING "DATA" INTO :A4;

B ***LOG BY4=> sql error 1552 performing MOD on table DYNPLOAD [dbdynpdb#? @ 510] [dbdynpdb0510 ]

B ***LOG BY0=> ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3700' [dbdynpdb#? @ 510] [dbdynpdb0510 ]

B *** ERROR => Input values: Table = DYNPLOAD, prog = RSM13000 , dynpnr = 3000, langu =

[dbdynpdb2.c 510]

Y *** WARNING => Async update of dynproload RSM13000 3000 failed: DBrc = 1 [dyrdypdb.c 188]

Y *** WARNING => ===> requesting WP: 15 [dyrdypdb.c 189]

C

C Thu Apr 16 18:02:50 2009

C OCI-call failed with -1=OCI_ERROR

C SQL error 1552: 'ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3''

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

[dbsloci.c 12861]

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

[dbsloci.c 12880]

C sc_p=000000000802D188,no=9,idc_p=0000000000000000,con=0,act=1,slen=157,smax=256,#vars=5,stmt=00000000119FAD40,table=NRIV

C SELECT /*+ FIRST_ROWS (1) */ * FROM "NRIV" WHERE "CLIENT" = :A0 AND "OBJECT" = :A1 AND "SUBOBJECT" \

C = :A2 AND "NRRANGENR" = :A3 AND "TOYEAR" = :A4 FOR UPDATE;

C sc_p=000000000802D188,no=9,idc_p=0000000000000000,con=0,act=1,slen=157,smax=256,#vars=5,stmt=00000000119FAD40,table=NRIV

C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=0000000000000000,ocistmth_p=0000000011CBB858

C IN : cols=5,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=50,vmax=32,bound=1,iobuf_p=0000000007F99240,vda_p=00000000087932D0

C lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0

C OUT: cols=9,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=0,upto=-1,rsize=172,vmax=32,bound=1,iobuf_p=0000000007F99190,vda_p=0000000008793A60

C lobs=0,lmax=0,lpcnt=0,larr=0000000000000000,lcurr_p=0000000000000000,rret=0

C SELECT /*+ FIRST_ROWS (1) */ * FROM "NRIV" WHERE "CLIENT" = :A0 AND "OBJECT" = :A1 AND "SUBOBJECT" \

C = :A2 AND "NRRANGENR" = :A3 AND "TOYEAR" = :A4 FOR UPDATE;

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

B ***LOG BY0=> ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3' [dbtran#11 @ 7512] [dbtran 7512 ]

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

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

B FHDR: {tab='NRIV', fcode=33, mode=2, bpb=0, dbcnt=0, crsr=1,

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

B init:p=0000000000000000, init:#=0, wa:p=0X0000000007F3F5A0, wa:#=172}

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

B STMT:

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

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

B key:#=5, xfer=0, xin:#=0, row:#=0, upto=1, wa:p=0X0000000007F3F5A0}

M *** ERROR => ThINoGetInterval: db_rsql (SELECT SINGLE) failed, rc: 1 [thxxnum.c 3937]

markus_doehr2
Active Contributor
0 Kudos

It seems something went wrong during recovery.

ORA-01552 means that there are no rollback segments defined.

It's pretty difficult to help here on the forum since I don't know what you exactly recovered and how. I suggest you open an OSS call and let the support have a direct look on the system.

Markus

stefan_koehler
Active Contributor
0 Kudos

Hello Waseem,

just for your information .. please use the CODE tags.. it is nearly unreadable.

But ok.. here we go:


ERROR C SQL error 1552: 'ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3700'' 
LOG BY0=> ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3700' 
ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPSR3'

Please execute the following SQL command and post the result


shell> sqlplus "/ as sysdba"
SQL> show parameter ROLLBACK_SEGMENTS
SQL> SELECT SEGMENT_NAME, OWNER, TABLESPACE_NAME, STATUS FROM DBA_ROLLBACK_SEGS;

After this we can help you.

Regards

Stefan