topic Re: Reg: Sql error in the database when accessing a table in Application Development and Automation Discussions

Reg: Sql error in the database when accessing a table

Former Member — Wed, 03 Oct 2012 06:28:27 GMT

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.

Re: Reg: Sql error in the database when accessing a table

Former Member — Wed, 03 Oct 2012 06:38:51 GMT

what input you are passing in SE80?

Re: Reg: Sql error in the database when accessing a table

RaymondGiuseppi — Wed, 03 Oct 2012 06:40:29 GMT

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

Regards,

Raymond

Re: Reg: Sql error in the database when accessing a table

sandeep_katoch — Wed, 03 Oct 2012 06:44:42 GMT

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

Re: Reg: Sql error in the database when accessing a table

Former Member — Wed, 03 Oct 2012 06:50:12 GMT

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

Re: Reg: Sql error in the database when accessing a table

srivijay_dinnimath — Wed, 03 Oct 2012 06:52:12 GMT

Hi Sandeep,

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

Regards,

Srivijay

Re: Reg: Sql error in the database when accessing a table

RaymondGiuseppi — Wed, 03 Oct 2012 08:53:16 GMT

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

Re: Reg: Sql error in the database when accessing a table

Azeemquadri — Wed, 03 Oct 2012 10:49:28 GMT

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.

Re: Reg: Sql error in the database when accessing a table

Former Member — Mon, 08 Oct 2012 17:55:05 GMT

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