cancel
Showing results for 
Search instead for 
Did you mean: 

SQL-Error 904 when doing SQL Explain in RSRT

Former Member
0 Kudos

Hi all

I am trying to do a SQL explain in a query in RSRT to analyse why it is running so slow, but I keep getting an error message:

"An SQL-Error is occurred: 904".

I have tried using the "Display Run Schedule" option in RSRT. I have also tried "Display SQL/BIA Query" in RSRT and then hitting "Display of SQL Access Plan" but I get the same error message. I also get the same message when I try a SQL explain in ST05.

Does anyone have any ideas? System is a 701 SP5 and the DB is Oracle 10.2.0.4.0.

Regards

Chami

Accepted Solutions (1)

Accepted Solutions (1)

former_member225306
Active Contributor
0 Kudos

Hi,

Check note

731 - Sammelhinweis: ORA-00904

specifically points 9 and 10 and make sure that your database is up

to the current patchset and SAP bundle patch and that the parameters

are setup correctly.

See notes

1175996 - Automated Oracle 10g/11g patches check

1171650 - Automated Oracle DB parameter check

Thanks,

Venkat

Former Member
0 Kudos

Thanks Venkat, that seems quite promising. I will get Basis to look at it.

Chami

Answers (1)

Answers (1)

former_member210615
Contributor
0 Kudos