topic Re: Query generated program not imported to Quality server in Application Development and Automation Discussions

Query generated program not imported to Quality server

rekha_manjunath2 — Fri, 05 Sep 2014 06:50:53 GMT

Hi All,

I am working on a query. It is an existing query which has been converted to an ABAP program in Z.

The requirement was to make some minor changes in the existing report, like change in the selection screen and include an extra column in the output.

report.

when I checked the transaction it had a Z program, when i went into it, it was a SAP generated program with the report name starting in Z.

It was not possible to make the changes in the existing program.

So i created a new Infoset YSTP_INFOSET with the requested changes and a new user group YSTP_USRGP assigned to the infoset in SQ02 and SQ03 respectively.

Query area is a global area.

I created a new query in SQ01 and when i executed gave me correct result.

i went to SE38 there it displayed the program name AQZZYSTP_USRGP==ZQUERY_WYT3===

this name i assigned to the transaction in SE93.

It was working fine till it was moved to the quality system. In the next system when i tried to test i got a short dumb telling that the report was not found.

The Infoset and the User group are present in the quality system. but the program is not moved.

Please tell me how to move this? its an urgent issue and it needs to be solved today.

Points will be awarded .

Please help.

Regards,

Rekha

Re: Query generated program not imported to Quality server

hiriyappa_myageri — Fri, 05 Sep 2014 07:04:39 GMT

Hi,

Please check ur TR weather report present or not.

if its there means double click that object and save that object in same request.

Regards,

Hiriyappa

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Fri, 05 Sep 2014 07:17:09 GMT

Hi Hiri,

Attaching the screen shot of the Transport request objects.

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Fri, 05 Sep 2014 07:19:09 GMT

Hi Hiri,

The program name AQZZYSTP_USRGP==ZQUERY_WYT3=== is not moved to quality system.

when i checked in SE38 i got a message AQZZYSTP_USRGP==ZQUERY_WYT3=== not found

Regards,

Rekha

Re: Query generated program not imported to Quality server

hiriyappa_myageri — Fri, 05 Sep 2014 07:27:04 GMT

AQZZYSTP_USRGP==ZQUERY_WYT3===

please check ur tr this program is not present.

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Fri, 05 Sep 2014 08:07:30 GMT

Hi,

It has the program in the TR . here is the screen shot

Re: Query generated program not imported to Quality server

hiriyappa_myageri — Fri, 05 Sep 2014 08:51:58 GMT

Hi,

gothrough this post u will get idea of transporting query report

Re: Query generated program not imported to Quality server

Former Member — Fri, 05 Sep 2014 08:52:19 GMT

Are you able to see both the user group YSTP_USRGP and the Info set ZQUERY_WYT3 in quality system? If yes can you try and regenerate the program

SQ01-> select the query then Query->More Functions->Generate program.

regards

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Fri, 05 Sep 2014 09:28:54 GMT

Hi Abhjit,

Yes both the infoset YSTP_INFOSET and the user group YSTP_USRGP are available in the quality system.

My Query name is ZQUERY_WYT3.

i have generated the query in the same below format

SQ01-> select the query then Query->More Functions->Generate program.

I have included that program name again the transaction SE93.

Will this be transported?

Regards,

Rekha

Re: Query generated program not imported to Quality server

Former Member — Fri, 05 Sep 2014 09:42:01 GMT

Just a question, if you have generated the program then can you not transport it to production just like any other program?

Re: Query generated program not imported to Quality server

RaymondGiuseppi — Fri, 05 Sep 2014 09:55:16 GMT

Don't transport program but transport query, and don't use generated program in your transaction but create a transaction with parameters calling transaction START_REPORT, skip first screen, and parameters as follow:

D_SREPOVARI-REPORTTYPE= AQ "parameter indicating Abap Query
D_SREPOVARI-REPORT= 'ZGRP' "Query User group
D_SREPOVARI-EXTDREPORT= 'ZNAME' "Query name

So if any change arise the transaction will regenerate the report (first execution, after modification of query or infoset, upgrade of system, etc.)

Regards,

Raymond

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Fri, 05 Sep 2014 09:59:18 GMT

Hi Raymond,

But the transaction is already created for this by someone earlier.

I had to modify the report by adding selection screen and the output report.

@Abhijit - there is the place i am getting stuck. I am not able to transport that program.

Regards,

Rekha

Re: Query generated program not imported to Quality server

RaymondGiuseppi — Fri, 05 Sep 2014 10:09:11 GMT

So delete and recreate transaction or change its transaction type.

NB: If you want to call the query in a report, then use one of the solutions of note 393160 - SAP Query: Using queries (FM: RSAQ_SUBMIT_QUERY_REPORT, RSAQ_QUERY_CALL, or IQAPI_QCALL)

Regards,

Raymond

Re: Query generated program not imported to Quality server

Former Member — Fri, 05 Sep 2014 10:32:01 GMT

I would agree to the option provided by Raymond, but since you are saying you need to change the program to accommodate additional selection screen and output, I would suggest you copy the query program AQ into Z and then modify and transport as a regular program.

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Fri, 05 Sep 2014 14:07:34 GMT

Hi,

As Raymond suggested, i have deleted the transaction and recreated it with the transaction type as in the screen shot. and given the values. This is a standard area where i have created the Infoset and User Group.

The functional need to transport the request to the quality server now. Keeping my fingers crossed.

Hope it does not go for a short dump.

Regards,

Rekha

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Fri, 05 Sep 2014 14:29:01 GMT

Hi,

When the functional is testing in the DEV server they are getting the error as User group not created.

How do we assign all the users to this?

Regards,

Rekha

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Tue, 09 Sep 2014 07:38:57 GMT

Hi All,

I am still facing the issue. The functional is getting the message "user group not created"

i have assigned all the users to the user group in SQ03.

Could any of u plz help. Its a bit urgent.

Regards,

Rekha

Re: Query generated program not imported to Quality server

Former Member — Tue, 09 Sep 2014 08:10:21 GMT

Is this error in quality or development server? Did you transfer the user group to Quality system? Have you copied your AQ program as Z program and moved to quality with transaction code assigned?

Re: Query generated program not imported to Quality server

rekha_manjunath2 — Tue, 09 Sep 2014 12:11:24 GMT

Hi Abhijit,

Its in the DEV server itself. no i have not created the AQ program as Z instead i have assigned the parameters in the transaction( user group and query name)

Please help what i need to do.

Regards,

Rekha

Re: Query generated program not imported to Quality server

Former Member — Tue, 09 Sep 2014 12:30:50 GMT

Is the user_group correctly named in your transaction according to the user group related to your query? (I prefer asking, people usually recopy what they are told to.. ^^)