Skip to Content
avatar image
Former Member

Query is not getting executed


Hi All,

i have added 3 fields in existing query and created variable on calday.Moved changes to Quality and executed for testing in quality,But its not getting executed.

solution please.

Regards,

Giridharan Rajan

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

9 Answers

  • avatar image
    Former Member
    Jun 05, 2015 at 09:41 AM

    Hi,

    Have you tried whether the query working in Development ?

    If its working in Development and not working in quality try to re-import the query in overwrite mode and also check the newly created variable again.

    If possible please provide error details in detail.

    Thanks & Regards,

    Chandra Sekhar.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Raj,

      Before doing the below, try to re-generate the query in RSRT.

      This might be due to variable selections you are passing, try to limit the selection values.

      When you click on transport symbol(small truck), you will get options again, in that tick the check box against 'owerrite originals' option and also re-import option.

      Regards,

      Vengal.

  • Jun 05, 2015 at 09:52 AM

    Hi Raj,

    What do you mean by not executing, are you getting any error or getting incorrect results. Can you share the error details if any.

    Try to re-generate the query in RSRT first and then execute it.

    Regards,

    Vengal.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 05, 2015 at 10:41 AM

    Hi Rajan,

    Can you please check the filter restriction in the query both in development and test system.

    Goto Query Designer using dev and quality system and check the characteristics restriction if you have the same filter restrictions for the query in both systems.

    It might be possible that you might not have same filter restrictions in quality due to which it might be processing huge data consuming huge memory and dumping.

    Also you can try to regenerate the query in RSRT using the "Generate Report" button.

    Please also again activate the infocube quality system on which query in created.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 05, 2015 at 10:54 AM

    Hi,

    it is working fine in DEV and have run the RSRT or bex anlayzer.

    if not working DEV don't transport to quality system.

    after correcting the issue in DEV then collect it into new TR move to quality system.

    run the report in RSRT.

    Thanks,

    phani.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 05, 2015 at 10:55 AM

    Hi Giridharan,

    The problem might be caused due to performance issues.

    Can you please go to transaction RSRT of the relevant BW Backend system -> go to transaction RSRT -> enter the Techincal Name of the relevant Query -> Go to Properties tab on the top of the page -> Please set READ Mode to 'H'.

    Then, please regenerate the query in RSRT using the 'Generate Report' button and check whether it helps you.

    Also, please refer the following SAP KBA Note:

    2141196 - Common performance issues occurring while executing Queries and Web Templates in Java Web

    Thanks & Regards,

    Sapna


    Add comment
    10|10000 characters needed characters exceeded

  • Jun 05, 2015 at 11:14 AM

    Hi Raj,

    Try to Generate query in RSRT and limit the selections to as much detail as possible.

    This error may be occuring due to lots of data getting slected for given selection criteria.

    Please check how many records do you have in underlying info-provider that belong to the selection criteria that you have entered.

    Apart from that you can go through below link and check for any erros.

    http://scn.sap.com/community/business-explorer/blog/2015/05/14/when-your-bex-report-execution-turns-into-error-general-steps-to-follow

    Hope this helps.

    -Swati.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 06, 2015 at 08:07 AM

    HI,

    Try to re-generate the query through RSRT.

    Try to provide the selection in such way that query can be executed very fast or run for small set of data.Please check that is there huge amount of data available in quality.

    It might be the case that if you have added a variable for calday and by mistake it will run the report for all data without any filter.

    Please check through t - code SM50 or SM66 after execute through RSRT. It will give the idea where exectly it is going to stuck.

    Hope this helps.

    Thanks,

    Chandresh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I think you will be getting a ST22 dump for the memory storage error which you are getting when running query.

      Please check the dump file , there you will find the code where it is failing.

      This might be helpful.

      Also please goto infocube on which query is created and check how much data it contains.

      You can compress the data in cube if its too much.

      You can use safety belt parameters as per below note to restrict data processing as per value defined in safety belt parameter.

      1127156 - Safety belt: Result set is too large

      Regards,

      Amit

  • Jun 12, 2015 at 11:12 AM

    Hi,

    Did you check by applying filter on Calendar Day under Characteristic Restrictions to restrict it for 1 day?

    Regards,

    Shalaka

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 12, 2015 at 11:15 AM

    Hi,
    I noticed the following error message here:
    "No more storage space available for extending ....."

    The memory errors means that more memory was requested because the program needed
    to expand an internal table, but not available.


    When Extended Memory is used up, the process will go into "PRIV" mode as
    it starts using Heap Memory (or vise-versa). No other user will be able to use this Work Process while it is in PRIV mode. If there is enough heap for it to finish, the memory errors will not be seen.

    Please try increasing free memory available,
    parameter em/initial_size_MB
    Please refer the following SAP Note regarding this:
    835474 - More than 32 GB extended memory

    Also please check the parameter ztta/roll_extension
    Please refer the following SAP Note regarding this:
    146289 - Parameter Recommendations for 64-Bit SAP Kernel


    Try increasing the parameter, abap/heap_area_dia from Transaction RZ11.

    Also check the following SAP Notes:
    649327 - Analysis of memory consumption
    425207 - SAP memory management, current parameter ranges

    369726 - TSV_TNEW_PAGE_ALLOC_FAILED

    185185 - Investigating memory bottlenecks w/o the Memory Inspector

    If you are using Release 7.3x, please refer the following SAP Note:
    1711881 - Subsequent correction to SAP Note 1708934

    Thanks & Regards,

    Sapna

    Add comment
    10|10000 characters needed characters exceeded