topic SAP Query failed... in Application Development and Automation Discussions

SAP Query failed...

Former Member — Tue, 26 Aug 2008 13:31:37 GMT

Hi all,

I am working on the SAP Query by using transaction code SQ02, SQ03 and SQ01.

I have also generated the program and copied display report name to create a transaction code for this report.

I am able to use the transaction code in the Development Environment. However, when I transported everything into Quality Environment and run the transaction code. It prompt me a shortdump with the message "Program AQZZZQTEST=ZTEST=== not found".

Anyone knows what is not right? How should I debug on this?

Thank you so much.

Re: SAP Query failed...

Former Member — Tue, 26 Aug 2008 13:40:41 GMT

hiii

you can not create sap query in developement system by just coping that program.because that progarm is automatically created by SAP when your infoset and query is created.so no need to copy it.you only need to transport abap query and system will automatically create that program.

regards

twinkal

Re: SAP Query failed...

Former Member — Tue, 26 Aug 2008 13:46:32 GMT

Hi thanks for your input. Without copy the program name, then how should I create the transaction code by using SE93.

I thought all these will be transported into Quality System. But unfortunately it is not. Or maybe I missed out some steps.

Please clarify. Thanks a lot.

Re: SAP Query failed...

naimesh_patel — Tue, 26 Aug 2008 13:50:23 GMT

Create your query in the Global Area (Cross-client) instead of the Standard Area (Client-specific). When you create a query or Infoset in the Cross Client, you have to save your work in development package. Inturn, you will save your work in transportable request.

So, if you create a tcode for this kind of query, their name will not change in the Other system and you will not get the dump.

To change the Global Area, you can select it in Tcode SQ01 or SQ02: Environment > Query Areas

Regards,

Naimesh Patel

Re: SAP Query failed...

Former Member — Tue, 26 Aug 2008 13:54:36 GMT

Hi Naimesh,

Yes, the query is created under Global Area (Cross-client).

Anybody encountered the same problem? How to solve this?

Thanks.

Re: SAP Query failed...

naimesh_patel — Tue, 26 Aug 2008 13:56:28 GMT

Ok..

Sometimes when you transport your query to other system, it is not generated.

Go to SQ01, and try to run it once.

If it runs sucessfully, than try to run it with the Tcode.

Regards,

Naimesh Patel

Re: SAP Query failed...

Former Member — Tue, 26 Aug 2008 14:02:35 GMT

Hi Naimesh,

Actually I have tried to all the processes on SQ02, SQ03 and SQ01 at least 3 times. It is working in the Development System. Afterall transported into Quality System, the transaction code which I created earlier giving me the shortdump.

Also, when I try to search the transported changes in Quality System, it is not shown at all. Just wondering is this right or wrong?

Weird case...or there must be something I missed out.

Re: SAP Query failed...

Former Member — Tue, 26 Aug 2008 14:06:07 GMT

hii

refer following steps..i hope it helps you.

regards

twinkal

Re: SAP Query failed...

Former Member — Tue, 26 Aug 2008 14:19:13 GMT

Run your query using SQ01/02/03 in quality environment before you use the transaction first time.

hope this will work.

Regards,

Pranav

Re: SAP Query failed...

Former Member — Tue, 26 Aug 2008 14:36:02 GMT

Hi Pranav,

Nothing is showing in SQ1,SQ2 and SQ3 in my Quality System. That is why I am wondering.

Any ideas?

Re: SAP Query failed...

Former Member — Tue, 26 Aug 2008 14:49:06 GMT

r u sure that u have transported query objects to your quality env. ?

Just make sure that u transport all query objects along with your tcode.