Reg: Sql error in the database when accessing a table

[Former Member]

Hi All,

I have a problem when executing SE80. "It says SQL error in the database when accessing a table".

Please find the attached screen short for reference. It was working fine previously not sure what this causing.

Remaining Tcodes are just working fine.

Please help in this regard.

Thanks,

Sandy.

[Former Member]

what input you are passing in SE80?

[RaymondGiuseppi]

Is there any message in SM21, if you find the table name check transactions like DB02 (Alerts, Database Check) or SE14.

Regards,

Raymond

[sandeep_katoch]

hi Sandeep,

Please check where this error is coming from.

For this before executing the tocde put /h and then enter the tcode.

Once you enter into debugging put a breakpoint on statement message.

It will stop at the message and you will come to know where exactly this is coming.

One more thing you can do is to ask fellow colleagues whether they are also having this problem or not.

I am not sure but what I suspect is someone has done something either in exits or Badi's or enhancements in standard.

Rgds,

Sandeep katoch

[Former Member]

Hi Raymond/Sandeep/Vipin.

First all thanks guys for such quick response.

Raymond - Even i get the same error if i'm accessing sm21.

Sandeep - Will try in that way.

Vipin - I'm not sure what your asking about.

Thanks

Sandy

[RaymondGiuseppi]

SM21 was not intent to solve problem but to help diagnose, often there is a clearer error message in SM21, like an ORA-0060 for Oracle or the like.

When you get your error message, call sm21 on another mode and read the system log. You can also ask the DB maintenance guys for any log in database server.

Regards,

Raymond

[srivijay_dinnimath]

Hi Sandeep,

For your information,  http://scn.sap.com/thread/3178917

Regards,

Srivijay

[Azeemquadri]

Usually these errors are right after upgrades.

Ask the basis people if all the tables were properly transported.

The problem could be that the database tables are missing.

[Former Member]

Thanks For all the replies I have told basis people about this.