topic Re: Error in Adhoc Query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/error-in-adhoc-query/m-p/7497220#M1557967 <HTML><HEAD></HEAD><BODY><P>hi experts</P><P></P><P>im having the same problem...</P><P></P><P>it is perfectly working in SAP Dev but when i transported it to SAP Prod im having this message.</P><P></P><P>please help</P></BODY></HTML> Fri, 07 Jan 2011 08:45:25 GMT Former Member 2011-01-07T08:45:25Z Error in Adhoc Query https://community.sap.com/t5/application-development-and-automation-discussions/error-in-adhoc-query/m-p/7497219#M1557966 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>In an info set , I have added two additional fields to IT0001 ,Dotted position and Dotted Position text and I have added field code for both the fields .</P><P></P><P>When I select these fields independently as output fields I am getting values expected But when I select the combination of both the fields in a Query its giving weird error like below .</P><P></P><P>As per Message procedure , I have regenerated the info set also . </P><P></P><P>If any one has faced this kind of error Please help me out and give some pointers to overcome this .</P><P></P><P>Message :</P><P></P><P>Error when generating the report (see long text)</P><P>Message no. AQ_AD_HOC221</P><P>Diagnosis</P><P>The report cannot be generated because the internal description is invalid or incomplete, or because the selection screen is too large.</P><P>Regenerate the assigned InfoSet, and read the log. If the InfoSet is OK, make sure that at least one field is given as output.</P><P>If you used the 'Refresh' icon to start the query, use the 'Output' menu option to execute the query. This gives you a full screen display of the data.</P><P>If an output was generated, the query cannot work with actual data in the construction view. In this case, always use the 'Output' function to execute the query.</P><P>Procedure</P><P>If the selection screen is too large, you need to reduce the number of your selections.</P><P>Make sure that the assigned InfoSet is correct. The name of the assigned InfoSet is stored in the menu option 'Extras -&gt; Template Information'.</P><P>Output at least one field. Otherwise you will not be able to save or generate reports.</P><P>If you do not have this problem, execute the query using the 'Output' function.</P><P>Otherwise, there is an error in the InfoSet Query.</P><P></P><P>Edited by: KAMESH G on Nov 29, 2010 9:19 AM</P></BODY></HTML> Mon, 29 Nov 2010 08:19:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-in-adhoc-query/m-p/7497219#M1557966 kamesh_g 2010-11-29T08:19:29Z Re: Error in Adhoc Query https://community.sap.com/t5/application-development-and-automation-discussions/error-in-adhoc-query/m-p/7497220#M1557967 <HTML><HEAD></HEAD><BODY><P>hi experts</P><P></P><P>im having the same problem...</P><P></P><P>it is perfectly working in SAP Dev but when i transported it to SAP Prod im having this message.</P><P></P><P>please help</P></BODY></HTML> Fri, 07 Jan 2011 08:45:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-in-adhoc-query/m-p/7497220#M1557967 Former Member 2011-01-07T08:45:25Z Re: Error in Adhoc Query https://community.sap.com/t5/application-development-and-automation-discussions/error-in-adhoc-query/m-p/7497221#M1557968 <HTML><HEAD></HEAD><BODY><P>hi </P><P></P><P>For its solved when i have done coding in one field instead of every additional field.</P><P></P><P>thanks</P></BODY></HTML> Thu, 10 Feb 2011 07:16:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/error-in-adhoc-query/m-p/7497221#M1557968 kamesh_g 2011-02-10T07:16:47Z