04-01-2013 10:58 AM
Hi All ,
Recently we upgraded our system into EHP6.Since then some SAP queries are not working , throwing runtime error .
Can somebody guide me what to do to make those queries run?
04-23-2013 10:46 AM
I have faced a similar issue and managed to solve the problem by following the steps below:
1. use SE93 to get the generated program name ('AQ...');
2. use SE37 to run FM 'RSAQ_DECODE_REPORT_NAME' to get USERGROUP and QUERY using the program name from step 1;
3. use SE38 to run program 'SAP_QUERY_CALL' with user group and query from step 2.
For more information please refer to Note 393160 - SAP Query: Using queries
04-02-2013 12:26 PM
Did you try to execute the queries in SQ01 or only in transaction with generated program name.?
In the second case, consider converting the transactions :
Create a transaction with parameters, call START_REPORT transaction and pass the information to execute a query with followinng parameters
D_SREPOVARI-REPORTTYPE = 'AQ'
D_SREPOVARI-REPORT = user group (add a trailing 'G' for global area)
D_SREPOVARI-EXTDREPORT = query name
Calling those transactions should recreate the queries. (Once during first execution.)
If you don't want to clean your system, you may be required to force the system to generate those program "old fashionned" - check Note 723577 - SAP Query: Release upgrade and new generation.
For oldest versions there are also programs that may correct some problems whose names start with RSAQ_REPAIR. (and good old RSAQUM40.)
Also you could read Note 550764 - FAQ SAP Query which contains much information and links.
Regards,
Raymond
04-23-2013 10:46 AM
I have faced a similar issue and managed to solve the problem by following the steps below:
1. use SE93 to get the generated program name ('AQ...');
2. use SE37 to run FM 'RSAQ_DECODE_REPORT_NAME' to get USERGROUP and QUERY using the program name from step 1;
3. use SE38 to run program 'SAP_QUERY_CALL' with user group and query from step 2.
For more information please refer to Note 393160 - SAP Query: Using queries