on 04-16-2009 4:22 PM
i get sql error when try to log into the sap system, it says sql error in the database when accessing a table
thanks for all of you, my problem solved by recover undo table space.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
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
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
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.