Query generated program not imported to Quality server

[rekha_manjunath2]

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

[hiriyappa_myageri]

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

[rekha_manjunath2]

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

[rekha_manjunath2]

Hi Hiri,

Attaching the screen shot of the Transport request objects.

[hiriyappa_myageri]

AQZZYSTP_USRGP==ZQUERY_WYT3===

please check ur tr this program is not present.

[rekha_manjunath2]

Hi,

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

[hiriyappa_myageri]

Hi,

gothrough this post u will get idea of transporting query report

[Former Member]

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

[rekha_manjunath2]

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

[Former Member]

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

[RaymondGiuseppi]

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

[rekha_manjunath2]

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

[RaymondGiuseppi]

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

[Former Member]

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.

[rekha_manjunath2]

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

[rekha_manjunath2]

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

[rekha_manjunath2]

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

[Former Member]

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?

[rekha_manjunath2]

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

[Former Member]

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.. ^^)

[RaymondGiuseppi]

User groups too can be transported like querie and infosets.

Regards,

Raymond

[rekha_manjunath2]

Hi Cristophe,

Yes the user groups is copied and pasted in the transaction. Attaching the screen shots for your reference.

I have assigned all the users in user group. Attaching that screen shot as well.

@Raymond - could you please let me know how to transport. I have tried the truck icon in user group and infoset i have tried to transport but i dont get any transport request. Please let  me know how to solve this.

Am i assigning the users correct? let me know please.

Regards,

Rekha

[Former Member]

You can transport the things you need by using program RSAQR3TR. (be carefull, you need to export from dev system to a TR, then once transported, export from TR to your quality system with the same program)

You're saying some people can't use your transaction, but is it working for you?

[rekha_manjunath2]

Hi Christophe,

Yes i am able to use it but when the functional is trying to test he is not able to run the transaction.

He gets the error "user group not created". I have assigned all the users in user group. Still this error in DEV system

Does it have any authorization issue?

Regards,

Rekha

[Former Member]

Can you also paste the Query screen shot? Also what is the exact msg that comes for this user, can you share the same with message no and ID?

I tried it in my system and it is working. I am assuming you are still working in dev system and not quality.

[Former Member]

su53 should give you a hint about that

[rekha_manjunath2]

Hi Abhijit,

Yes i am still working on DEV server. The functional is internally moving the request from SCC1 and he gets the below error

I transported (using the truck icon or the program name RSAQR3TR ) the user group and infoset in the DEV server and i got return code 0.

The screen shot of Query

Regards,

Rekha

[rekha_manjunath2]

Hi Christophe,

i checked the SU53 screen shot and got missing authorization for authorization object S_QUERY for change mode in the internal system which is a testing system.

But does the authorization matter as the query is executing in the DEV.

Regards,

Rekha

[rekha_manjunath2]

Hi All,

The issue was solved.!! Transported the query using the export option by unchecking the Test Run.

Even if the transport request is imported to Quality system, the query needs to be generated in every system. Authorization to generate in the quality system and Production system was taken and executed.

Thanks all for the guidance provided.

Regards,

Rekha

[Vincent82]

Hello,

can you please tell me how to generate a query in a system after transport please ?