SQL error in the database when accessing a table.

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[peter_dzurov · Accepted solution]

Yes, go ahead and select tablespace name, then select size of new datafile to be added...

[lbreddemann · Accepted solution]

> 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

[Former Member · Accepted solution]

Angeline,

Its very clear that its a ora-1552 issue. As Lars pointed out its looks like a PSAPUNDO issue

Read the below Notes which would help you in resolving this.

Note 3807 - Error messages regarding rollback and undo segments and

SAP note 600141 Automatic UNDO Management

Gerard

[Former Member · Accepted solution]

Hi Gerard,

Thank you soooooooooo much, I will check that SAP note on monday, If that problem fix I will let you konw....

Thank for your time...

Angeline

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Doug,

Thank you very much for explain the procedure, and you are right some sigments like undo was curripted... anyway!!! now problem has been resolved...

I just recovery psapundo now its working fine....

Thank you all

Angeline...

[Former Member · Accepted solution]

Hi Angeline,

may i know how to recovery psapundo i faced the same problem with you.

Thanks and Regards,

dinie.

[Former Member]

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.

[former_member204746]

You have some kind of error on your database.

check in SAPMMC to get an idea:

SAP systems

- [Your SID]

- [Your server]

- SYSLOG