topic Re: SQL error ? in Application Development and Automation Discussions

SQL error ?

former_member210804 — Mon, 09 Jul 2012 05:34:14 GMT

Hi Sir,

I m getting an error message

" SQL error in the database when accessing a table"

This error message is coming for all T-codes while i m trying to access them.

Pls give me guidence

Thanks & regards,

Narasimha.

Re: SQL error ?

Former Member — Mon, 09 Jul 2012 05:37:50 GMT

HI,

Can u mention the select query from which you are fetching Data.

Regards,

Ravi Singh

Re: SQL error ?

former_member210804 — Mon, 09 Jul 2012 06:15:08 GMT

Hi singh,

Please check the below code...for error

Once the cursor comes to delete statement,its showing the error message.

Thanks & regards,

Narasimha.

Re: SQL error ?

Former Member — Mon, 09 Jul 2012 08:16:08 GMT

HI,

Your query is correct.

I think :

Your query is correct. But 'SNAP' Table is a table which store temporary data in the table for a fix period around one mopnth or max 2 months temporary data.

once you execute query delete the data according to your specification mentioned in where clause.

while u access data base table u get the error.

Ask your basis guy to look into the matter.

Regards,

RAvi Singh.

Re: SQL error ?

ThomasZloch — Mon, 09 Jul 2012 09:06:05 GMT

Looks like SAP standard code for reorganization of short dumps (stored in SNAP). Did you search for related SAP notes? If not, why not?

Also, did you check ST22 for further details? If there are short dumps, what is their title and what is explained under section "error analysis"?

In general, please do your own research before posting, and if you did, mention it in your initial post.

Thomas