cancel
Showing results for 
Search instead for 
Did you mean: 

ST04 - SQL execute

Former Member
0 Kudos

Hi all,

I am executing some select SQL statements in ST04.
However, upon executing, nothing happen. No output/result

Can someone advise? Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI Castro,

Do you receive any errors or sm21 entries at the same time when you execute this?

Johan

Former Member
0 Kudos

hi johan, didn't have any pop-up error and syslog is clear.    

Former Member
0 Kudos

What is you sap basis SAPKB version?

Also right after executing this try su53 for your user might be auth related issue.

Johan

Answers (5)

Answers (5)

Former Member
0 Kudos

Thanks Johan, indeed after executing the SQL, i checked in SU53, and found myself lack some authorizations.

Weird thing, usually when I was lack in authorization, it would pop up an error.

magexposito
Active Participant
0 Kudos

Hi Castro,

Not always you get a pop-up or error message showing you lack authorization to do something in the ABAP system. Also, please note that sometimes the authorization objects and values shown on transaction SU53 are not correct. In those cases you can do an authorization trace on transaction ST01 for an user.

Best regards.

former_member184473
Active Contributor
0 Kudos

Hello,

As Miguel mentioned, you could use ST01 and perform a authorization test.

If you logon as DDIC (or any superuse), do you observe this issue? If not, perform an authorization test for this user and compare with the affected user.

Regards,

Eduardo Rezende

former_member206552
Active Contributor
0 Kudos

Hi Castro

Do you have all the required access ?

Can you see the database in DB02 ?

Best Regards

Marius

Former Member
0 Kudos

Can you provide screenshots with SQL query and results?

Former Member
0 Kudos

Hi Castro,

Also check Note 1028624 - Overview of DBA Cockpit for Oracle

Also what is your version of Basis SAPKB ?

Many corrections depending on basis release.

Johan

AtulKumarJain
Active Contributor
0 Kudos

Hi Eliza,

Please check the sm21 log for your user and paste the output here.

BR

Atul

Former Member
0 Kudos

hi atul,


i've checked again the system logs after i try to execute the sql in ST04, but it's empty.
thanks.