on 01-14-2010 10:25 PM
Hi all
I check SAPMMC work process list everying is look green, JAVA + Java + dispatcher + Messages everying ok but, when I try to connect SAP GUI, I got an error:
ABAB Runtime Error Error Code (nothing is there), and buttom line of window this messages:
SQL error in the database when accessing a table.
I tried client 000 SAP* nothing happend same messages
What should I do ?
I am not sure is that basis job or Oracle, but error look like Oracle
Your response will be appriciated
Angeline
Edited by: AngelinePurnama on Jan 15, 2010 12:19 AM
Angeline,
Logon to the database at the oslevel.
Using BRTOOLS check whether any tablespace is filled up completly(99% or above)
extend the identified tablespaces using brtools and then try logging in.
Gerard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi there,
Thank for reply, I am sure thats Table space problem, I look at it in System Log from SAPMMC
stop and restart instance and I got these messages keep repaiting...
Database: Database error 1552 at DEL access to table USR41
Database: Database error 1552 at INS access to table PATCHHIST
Database: Database error 1552 at UPD access to table TSPSVI
Spool / print: DB_RTAB_ERROR at Table TSPSVI, Error 1 rspogdio 2
Database: Database error 1552 at UPD access to table BTCCTL
SAP-Basis System: Run-time error "DBIF_RSQL_SQL_ERROR occurred
Database: Database error 1552 at EXE
SAP-Basis System: Run-time error "DBIF_DSQL2_SQL_ERROR occurred
Database: Database error 1552 at UPD access to table USR02
Database: > tablespace 'PSAPSR3'
My question is how to increase table space from BRtools;
could you please tell me the step by step procedure... I do find out BRtool.exe file and run it
select option 2: space management
sleect option 1: extend tablespace
now I got some options:
1 - BRSPACE profile (profile) ...........[initQAS.sap]
2 - database user/password (user) .......[/] Do I have to put user and password?
3 ~ Tablespace name (tablespace).........[]
4 - confirmation mode (confirm)..........[yes]
5 - Scrolling line count (scroll)........[20]
6 - message language (language)..........[E]
7 - BRSPACE command line (command).......[-p initQAS.sap -s 20 -l E -f tsextend]
Now I have continue sign... can I continue for that for define table space name ???
please advise
> Database: Database error 1552 at DEL access to table USR41
> Database: Database error 1552 at INS access to table PATCHHIST
> Database: Database error 1552 at UPD access to table TSPSVI
Ok, you get a ORA-1552 error.
So why don't just check what the h**ck it means?
ORA-01552:cannot use system rollback segment for non-system tablespace 'string'
> My question is how to increase table space from BRtools;
Why on earth would you want to do this to solve your problem?
For some reason your user cannot use the PSAPUNDO as undo/rollback tablespace.
I'd bet my two pence on that it is OFFLINE or non-existing.
Check your PSAPUNDO!
regards,
Lars
I tried SAP Notes: but that doesn't help me at all... i don't know why...
Here is current status
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace
'PSAPSR3'
This is my current status
SQL>select segment_name, tablespace_name, status from dba_rollback_segs;
EGMENT_NAME TABLESPACE_NAME STATUS
-
YSTEM SYSTEM ONLINE
SYSSMU17$ PSAPUNDO OFFLINE
SYSSMU16$ PSAPUNDO OFFLINE
SYSSMU15$ PSAPUNDO OFFLINE
SYSSMU14$ PSAPUNDO OFFLINE
SYSSMU13$ PSAPUNDO OFFLINE
SYSSMU12$ PSAPUNDO OFFLINE
SYSSMU11$ PSAPUNDO OFFLINE
SYSSMU10$ PSAPUNDO NEEDS RECOVERY
SYSSMU9$ PSAPUNDO NEEDS RECOVERY
SYSSMU8$ PSAPUNDO NEEDS RECOVERY
EGMENT_NAME TABLESPACE_NAME STATUS
-
SYSSMU7$ PSAPUNDO NEEDS RECOVERY
SYSSMU6$ PSAPUNDO NEEDS RECOVERY
SYSSMU5$ PSAPUNDO NEEDS RECOVERY
SYSSMU4$ PSAPUNDO NEEDS RECOVERY
SYSSMU3$ PSAPUNDO NEEDS RECOVERY
SYSSMU2$ PSAPUNDO NEEDS RECOVERY
SYSSMU1$ PSAPUNDO NEEDS RECOVERY
8 rows selected.
what all steps i should do to solve this issue
plz help me it is very critical
Angeline
Hi Angeline
Several of the UNDO segments are possibly corrupted. The UNDO segments are marked NEEDS RECOVERY when they are unable to rollback uncomitted transactions contained in this particular undo segment on startup.
This may have happened because:
1) A data file is offline and therefore the rollback of the uncomitted transaction cannot occur.
2) A datafile is corrupted and this prevents the rollback from working
3) The undo datafile is corrupt.
Can you check if all the data files are online?
If all the datafiles are online, then you will need drop the corrupted UNDO tablespace and recreate a new one. The steps for removing the corrupted undo segments are well documented, search for undo "needs recovery".
Are you able to do a full database recovery? This would be the best option, even if you fix the undo tablespace your database maybe logically corrupted as several uncomitted transactions have not been rollbacked.
Good luck.
Doug
Such problems with sql databases you can solve out with the help of [repair mdf|http://mdfrecoverytool.com]. It works under any computer requirements. The tool displays the results of working with lost or corrupted mdf files. It doesn't modify source data during recovering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have some kind of error on your database.
check in SAPMMC to get an idea:
SAP systems
- [Your SID]
- [Your server]
- SYSLOG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.