cancel
Showing results for 
Search instead for 
Did you mean: 

Error when exporting query

former_member313879
Participant
0 Kudos

Hi Experts

What could be the reason why an error below prompts when I try exporting a query I created.

Thanks,

Janice

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

The above error due to memory problem. Limit the query result by adding condition at where clause to export.

For example, T0.docdate between [%1] and [%2]

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi ,

If your query is giving more than  thousands rows or above , you will not able to fetch the data from Query Manager it self.

Either run the same query in SQL or put the conditions in query to filter the data.

Please define a selection criteria within the current system limitation.

Thanks

TAruna

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Janice,

First minimise the Display Query Sturcture. Then try to export.

Regards

JO

former_member313879
Participant
0 Kudos

Dear all,

I solved the issue. I created new query with the same details.

Thanks a lot for all your feedbacks.



Thanks Regards,

Janice

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Could post new query that solve above problem?

Thanks & Regards,

Nagarajan

former_member313879
Participant
0 Kudos

Hi Nagarajan,

Yes, when I created new query it did not give any error. So what I did is I copied the previous query to a new file name.

Regards,

Janice

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Sorry, I don't get you. I need the query which is solved your issue.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hello Janice,

Check out this:

Export to MS Excel 2000 not working in RSRT (HT... | SCN

Regards,

Ritika Garg

Former Member
0 Kudos

Hi Jnaice,

     Please Clarify this error comes while you export the result into Excel?.

Please Check Administration-System Initialization-General Settings

and Click Path Tab. Check whether Proper Network Paths are Defined for Microsoft Excel Folder.

former_member313879
Participant
0 Kudos

Hi Jaheer,

The set up is fine also.

Former Member
0 Kudos

Hi Janice,

Is this the only query you have problem exporting or all queries?

Thanks,

Gordon

former_member313879
Participant
0 Kudos

Hi Gordon,

Yes only this one.

Former Member
0 Kudos

Have you tried on the server to run query with restricted results? Do you have the same error?

former_member313879
Participant
0 Kudos

Hi Gordon,

Yes tried it and also not working.

former_member313879
Participant
0 Kudos

Hi,

I tried putting additional parameter but still the error prompts.

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

The above error message is not because of query result. There may be some error in sap b1.

As mentioned other thread, SAP Note 1989457 - Analysing unexpected application shutdowns will solve your problem.

If not better raise ticket to SAP support.

Thanks & Regards,

Nagarajan