Skip to Content
author's profile photo Former Member
Former Member

An SQL Error occured when accessing the table .

Hi Experts,

I have an issue in my IDES server. When I try logging in I face the following error "An SQL Error occured when accessing the table".

Even I have checked my tablespaces using brtools.

List of database tablespaces:

Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.

Total[KB] Used[%] Free[KB] ExtSize[KB] FreeExt. Largest[KB]

1 - PSAPIDS DATA ONLINE LOCAL AUTO NO 37/37

87783424 94.63 4712384 96593920 15 9185280+:8069120

+:8069120+:8069120+:8048640+

2 - PSAPIDS640 DATA ONLINE LOCAL AUTO NO 20/20

48222208 98.50 721280 96604160 24 8990720+:7905280

+:7884800+:7864320+:7761920+

3 - PSAPIDSUSR DATA ONLINE LOCAL AUTO NO 1/1

51200 68.00 16384 10188800 1 10188800+:16384:0

:0:0

4 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 1/1

2048000 71.10 591872 8192000 1 8192000+:591872:

0:0:0

5 - PSAPUND1 UNDO ONLINE LOCAL MANUAL NO 1/1

10485760 0.01 10484352 23068656 3 23068656+:4063232

:4061888:2359232:0

6 - SYSTEM DATA ONLINE LOCAL MANUAL NO 1/1

870400 67.10 286336 9369600 2 9369600+:285632:

Please help me with the solution.

Thanks in Advance,

Satheesh E

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Jan 02, 2014 at 05:17 AM

    Hi Satheesh,

    Are you able to login and execute any transaction, do you see any dumps in ST22, if so please paste the dumps and system logs errors from sm21

    regards

    kartik

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 02, 2014 at 05:13 AM

    Dear Satheesh,

    I gues you are facing this issue because of in sufficient space in table space PSAPIDS640. try to increase space.

    Regards,

    Jithin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 02, 2014 at 05:14 AM

    Hi Satheesh,

    Please check your installed microsoft loop back adapter.

    This may be corrupted.

    If yes, please reinstall loop back adpater.

    Arivazhagan S

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 02, 2014 at 05:58 AM

    Hello

    You have problems with the database.

    You need to check the alert log of the Oracle database to find out what the real reason is.

    Regards

    RB

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.